资源名称:ERPSYS.zip [点击查看]
上传用户:zhpu1995
上传日期:2013-09-06
资源大小:61151k
文件大小:38k
源码类别:
企业管理
开发平台:
Visual Basic
- VERSION 5.00
- Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCTL.OCX"
- Begin VB.MDIForm XT_Main
- BackColor = &H00808000&
- Caption = "百利/ERP5.0-存货核算"
- ClientHeight = 6510
- ClientLeft = 1380
- ClientTop = 1440
- ClientWidth = 11835
- Icon = "系统_主界面.frx":0000
- WindowState = 2 'Maximized
- Begin VB.Timer Timer1
- Interval = 1
- Left = 3360
- Top = 1380
- End
- Begin MSComctlLib.StatusBar StatusBar1
- Align = 2 'Align Bottom
- Height = 375
- Left = 0
- TabIndex = 0
- Top = 6135
- Width = 11835
- _ExtentX = 20876
- _ExtentY = 661
- _Version = 393216
- BeginProperty Panels {8E3867A5-8586-11D1-B16A-00C0F0283628}
- NumPanels = 6
- BeginProperty Panel1 {8E3867AB-8586-11D1-B16A-00C0F0283628}
- AutoSize = 2
- Object.Width = 5292
- MinWidth = 5292
- Key = "OperStatus"
- EndProperty
- BeginProperty Panel2 {8E3867AB-8586-11D1-B16A-00C0F0283628}
- Object.Width = 5292
- MinWidth = 5292
- Key = "zt"
- EndProperty
- BeginProperty Panel3 {8E3867AB-8586-11D1-B16A-00C0F0283628}
- AutoSize = 2
- Object.Width = 2117
- MinWidth = 2117
- Key = "czy"
- EndProperty
- BeginProperty Panel4 {8E3867AB-8586-11D1-B16A-00C0F0283628}
- AutoSize = 2
- Object.Width = 3519
- MinWidth = 3528
- Key = "rq"
- EndProperty
- BeginProperty Panel5 {8E3867AB-8586-11D1-B16A-00C0F0283628}
- Style = 5
- Object.Width = 1411
- MinWidth = 1411
- TextSave = "17:39"
- Key = "sj"
- EndProperty
- BeginProperty Panel6 {8E3867AB-8586-11D1-B16A-00C0F0283628}
- AutoSize = 2
- Object.Width = 3519
- MinWidth = 3528
- Key = "rjbb"
- EndProperty
- EndProperty
- End
- Begin MSComctlLib.ImageList ImageList1
- Left = 11070
- Top = 510
- _ExtentX = 1005
- _ExtentY = 1005
- BackColor = -2147483643
- ImageWidth = 16
- ImageHeight = 16
- MaskColor = 12632256
- _Version = 393216
- BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628}
- NumListImages = 8
- BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "系统_主界面.frx":1042
- Key = "stb"
- EndProperty
- BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "系统_主界面.frx":1496
- Key = "xttb"
- EndProperty
- BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "系统_主界面.frx":18EE
- Key = "qx"
- EndProperty
- BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "系统_主界面.frx":1D4E
- Key = "kplr"
- EndProperty
- BeginProperty ListImage5 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "系统_主界面.frx":21A2
- Key = "kpgl"
- EndProperty
- BeginProperty ListImage6 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "系统_主界面.frx":2602
- Key = "tcxt"
- EndProperty
- BeginProperty ListImage7 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "系统_主界面.frx":291E
- Key = "szk"
- EndProperty
- BeginProperty ListImage8 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "系统_主界面.frx":2D76
- Key = "gnqx"
- EndProperty
- EndProperty
- End
- Begin VB.Menu Chhs_File
- Caption = "文件(&F)"
- Index = 101
- Begin VB.Menu Chhs_Register
- Caption = "重新注册(&R)"
- End
- Begin VB.Menu v5
- Caption = "-"
- End
- Begin VB.Menu Chhs_quit
- Caption = "退出系统(&Q)"
- End
- End
- Begin VB.Menu Chhs_jcsz
- Caption = "基础设置(&J)"
- Begin VB.Menu Chhs_Ywfw
- Caption = "业务范围设置(&Y)"
- End
- Begin VB.Menu fg0
- Caption = "-"
- End
- Begin VB.Menu Chhs_Macc
- Caption = "存货科目设置(&C)"
- End
- Begin VB.Menu Chhs_Dfacc
- Caption = "对方科目设置(&D)"
- End
- Begin VB.Menu fg3
- Caption = "-"
- End
- Begin VB.Menu Chhs_Eval
- Caption = "暂估条件设置(&Z)"
- End
- End
- Begin VB.Menu Chhs_Bill
- Caption = "单据管理(&B)"
- Begin VB.Menu Chhs_Startbill
- Caption = "期初单据(&F)"
- End
- Begin VB.Menu fg5
- Caption = "-"
- End
- Begin VB.Menu Chhs_Matebill
- Caption = "材料入库单(&M)"
- End
- Begin VB.Menu Chhs_Prodinbill
- Caption = "产品入库单(&P)"
- End
- Begin VB.Menu Chhs_Otherinbill
- Caption = "其它入库单(&O)"
- End
- Begin VB.Menu fg1
- Caption = "-"
- End
- Begin VB.Menu Chhs_Mateoutbill
- Caption = "材料出库单(&L)"
- End
- Begin VB.Menu Chhs_Selloutbill
- Caption = "销售出库单(&S)"
- End
- Begin VB.Menu Chhs_Otheroutbill
- Caption = "其它出库单(&T)"
- End
- Begin VB.Menu fg2
- Caption = "-"
- End
- Begin VB.Menu Chhs_Adjustinbill
- Caption = "入库调整单(&A)"
- End
- Begin VB.Menu Chhs_Adjustoutbill
- Caption = "出库调整单(&U)"
- End
- Begin VB.Menu Chhs_Adjustplanbill
- Caption = "计划价调整单(&R)"
- End
- End
- Begin VB.Menu Chhs_List
- Caption = "单据列表(&L)"
- Begin VB.Menu Chhs_Startbilllist
- Caption = "期初单据列表(&F)"
- End
- Begin VB.Menu fg7
- Caption = "-"
- End
- Begin VB.Menu Chhs_Mateinbilllist
- Caption = "材料入库单列表(&M)"
- End
- Begin VB.Menu Chhs_Prodinbilllist
- Caption = "产品入库单列表(&P)"
- End
- Begin VB.Menu Chhs_Otherinbilllist
- Caption = "其它入库单列表(&O)"
- End
- Begin VB.Menu fg8
- Caption = "-"
- End
- Begin VB.Menu Chhs_Mateoutbilllist
- Caption = "材料出库单列表(&L)"
- End
- Begin VB.Menu Chhs_Seloutbilllist
- Caption = "销售出库单列表(&S)"
- End
- Begin VB.Menu Chhs_Otheroutbilllist
- Caption = "其它出库单列表(&T)"
- End
- Begin VB.Menu fg14
- Caption = "-"
- End
- Begin VB.Menu Chhs_AdjustInlist
- Caption = "入库单调整列表(&A)"
- End
- Begin VB.Menu Chhs_AdjustOutList
- Caption = "出库单调整列表(&U)"
- End
- End
- Begin VB.Menu Chhs_Cl
- Caption = "处理(&S)"
- Begin VB.Menu Chhs_Qcjz
- Caption = "期初记帐(&Q)"
- End
- Begin VB.Menu Chhs_Djjz
- Caption = "单据记帐(&D)"
- End
- Begin VB.Menu fg10
- Caption = "-"
- End
- Begin VB.Menu Chhs_Cyl
- Caption = "差异率计算(&C)"
- End
- Begin VB.Menu Chhs_Avgprice
- Caption = "平均单价计算(&P)"
- End
- Begin VB.Menu Chhs_EvalPrice
- Caption = "存货估价处理(&E)"
- End
- Begin VB.Menu Chhs_ProdPrice
- Caption = "产品成本调整(&A)"
- End
- Begin VB.Menu fg11
- Caption = "-"
- End
- Begin VB.Menu Chhs_Qmcl
- Caption = "期末处理(&M)"
- End
- Begin VB.Menu Chhs_Ccpz
- Caption = "生成凭证(&Z)"
- End
- Begin VB.Menu Chhs_Qmjz
- Caption = "期末结帐(&J)"
- End
- End
- Begin VB.Menu c_yhdz
- Caption = "帐簿分析(&C)"
- Begin VB.Menu Chhs_Mxz
- Caption = "明细帐(&M)"
- End
- Begin VB.Menu Chhs_Zz
- Caption = "总帐(&Z)"
- End
- Begin VB.Menu Chhs_lsz
- Caption = "出入库流水帐(&L)"
- End
- End
- Begin VB.Menu Chhs_Tjfx
- Caption = "统计报表(&X)"
- Begin VB.Menu Chhs_Insum
- Caption = "入库单汇总表(&I)"
- End
- Begin VB.Menu Chhs_Outsum
- Caption = "出库单汇总表(&O)"
- End
- Begin VB.Menu Chhs_Sfchz
- Caption = "收发存汇总表(&S)"
- End
- Begin VB.Menu Chhs_Inoutclasssum
- Caption = "收发类别汇总表(&C)"
- End
- Begin VB.Menu fg12
- Caption = "-"
- End
- Begin VB.Menu Chhs_Diffft
- Caption = "差异分摊表(&D)"
- End
- Begin VB.Menu Chhs_Abcfl
- Caption = "存货ABC分类表(&H)"
- End
- Begin VB.Menu fg13
- Caption = "-"
- End
- Begin VB.Menu Chhs_Evalfx
- Caption = "暂估成本分析(&E)"
- End
- Begin VB.Menu Chhs_Incbfx
- Caption = "入库成本分析(&F)"
- End
- End
- Begin VB.Menu Chhs_gnbm
- Caption = "工具(&T)"
- Begin VB.Menu Chhs_gnbmjsq
- Caption = "计算器(&S)"
- End
- Begin VB.Menu Chhs_gnbmkmrl
- Caption = "会计日历(&C)"
- End
- End
- Begin VB.Menu mnuwindows
- Caption = "窗口(&W)"
- WindowList = -1 'True
- Begin VB.Menu mnuWindowCascade
- Caption = "层叠(&C)"
- End
- Begin VB.Menu mnuWindowTileHorizontal
- Caption = "横向平铺(&H)"
- End
- Begin VB.Menu mnuWindowTileVertical
- Caption = "纵向平铺(&V)"
- End
- Begin VB.Menu mnuWindowArrangeIcons
- Caption = "排列图标(&A)"
- End
- End
- Begin VB.Menu Chhs_bz
- Caption = "帮助(&H)"
- Begin VB.Menu Chhs_xtbz
- Caption = "系统帮助(&S)"
- End
- Begin VB.Menu Chhs_gy
- Caption = "关于(&A)"
- End
- End
- End
- Attribute VB_Name = "XT_Main"
- Attribute VB_GlobalNameSpace = False
- Attribute VB_Creatable = False
- Attribute VB_PredeclaredId = True
- Attribute VB_Exposed = False
- '**************************************
- '* 模 块 名 称 :存货核算系统主窗体
- '* 功 能 描 述 :作为系统主界面
- '* 程序员姓名 : 白凤英
- '* 最后修改人 : 白凤英
- '* 最后修改时间:2000/11/21
- '**************************************
- Dim Tsxx As String '系统提示信息
- Private Sub Chhs_Abcfl_Click() 'Abc分类
- '判断用户是否有此功能执行权限,如有则写上机日志(进入)
- If Not Security_Log("Chhs_Abcfl", Xtczybm, 1) Then
- Exit Sub
- End If
- Tjfx_AbcFx.Show
- Tjfx_AbcFxCond.Show 1
- Security_Log "Chhs_Abcfl", Xtczybm, 2, False '用户退出时写上机日志
- End Sub
- Private Sub Chhs_Adjustinbill_Click() '入库单调整
- '判断用户是否有此功能执行权限,如有则写上机日志(进入)
- If Not Security_Log("Chhs_AdjustInEdit", Xtczybm, 1) Then
- Exit Sub
- End If
- If Xtyear <> PGKjYear Then
- Tsxx = "操作日期不在当前会计年度(" + Trim(Str(PGKjYear)) + ")之内,请重新登录!"
- Call Xtxxts(Tsxx, 0, 1)
- Else
- If Xtmm <> PGNowmon Then
- Tsxx = "操作日期不在当前会计期间(" + Trim(Str(Xtyear)) + "." + Trim(Str(PGNowmon)) + ")之内,请重新登录!"
- Call Xtxxts(Tsxx, 0, 1)
- Else
- Xtcdcs = "1"
- DJ_AdjustInbill.Show 1
- Security_Log "Chhs_AdjustInEdit", Xtczybm, 2, False '用户退出时写上机日志
- End If
- End If
- End Sub
- Private Sub Chhs_AdjustInlist_Click() '入库单调整列表
- '判断用户是否有此功能执行权限,如有则写上机日志(进入)
- If Not Security_Log("Chhs_AdjustInList", Xtczybm, 1) Then
- Exit Sub
- End If
- LB_AdjustInBillList.Show
- LB_AdjustInBillCond.Show 1
- Security_Log "Chhs_AdjustInList", Xtczybm, 2, False '用户退出时写上机日志
- End Sub
- Private Sub Chhs_Adjustoutbill_Click() '出库单调整
- '判断用户是否有此功能执行权限,如有则写上机日志(进入)
- If Not Security_Log("Chhs_AdjustInEdit", Xtczybm, 1) Then
- Exit Sub
- End If
- If Xtyear <> PGKjYear Then
- Tsxx = "操作日期不在当前会计年度(" + Trim(Str(PGKjYear)) + ")之内,请重新登录!"
- Call Xtxxts(Tsxx, 0, 1)
- Else
- If Xtmm <> PGNowmon Then
- Tsxx = "操作日期不在当前会计期间(" + Trim(Str(Xtyear)) + "." + Trim(Str(PGNowmon)) + ")之内,请重新登录!"
- Call Xtxxts(Tsxx, 0, 1)
- Else
- Xtcdcs = "1"
- DJ_AdjustOutBill.Show 1
- Security_Log "Chhs_AdjustInEdit", Xtczybm, 2, False '用户退出时写上机日志
- End If
- End If
- End Sub
- Private Sub Chhs_AdjustOutList_Click() '出库单调整列表
- '判断用户是否有此功能执行权限,如有则写上机日志(进入)
- If Not Security_Log("Chhs_AdjustOutList", Xtczybm, 1) Then
- Exit Sub
- End If
- LB_AdjustOutBillList.Show
- LB_AdjustOutBillCond.Show 1
- Security_Log "Chhs_AdjustOutList", Xtczybm, 2, False '用户退出时写上机日志
- End Sub
- Private Sub Chhs_Adjustplanbill_Click() '计划价调整
- Xtcdcs = "1"
- DJ_AdjustPlan.Show 1
- End Sub
- Private Sub Chhs_Avgprice_Click() '平均单价列表
- '判断用户是否有此功能执行权限,如有则写上机日志(进入)
- If Not Security_Log("Chhs_AvgPrice", Xtczybm, 1) Then
- Exit Sub
- End If
- CL_AveragePrice.Show
- CL_AveragePriceFind.Show 1
- Security_Log "Chhs_AvgPrice", Xtczybm, 2, False '用户退出时写上机日志
- End Sub
- Private Sub Chhs_Ccpz_Click() '生成凭证
- '判断用户是否有此功能执行权限,如有则写上机日志(进入)
- If Not Security_Log("Chhs_Scpz", Xtczybm, 1) Then
- Exit Sub
- End If
- If Xtyear <> PGKjYear Then
- Tsxx = "操作日期不在当前会计年度(" + Trim(Str(PGKjYear)) + ")之内,请重新登录!"
- Call Xtxxts(Tsxx, 0, 1)
- Else
- If Xtmm <> PGNowmon Then
- Tsxx = "操作日期不在当前会计期间(" + Trim(Str(Xtyear)) + "." + Trim(Str(PGNowmon)) + ")之内,请重新登录!"
- Call Xtxxts(Tsxx, 0, 1)
- Else
- CL_MakeVoucher.Show
- CL_MakeVoucherFind.Show 1
- Security_Log "Chhs_Scpz", Xtczybm, 2, False '用户退出时写上机日志
- End If
- End If
- End Sub
- Private Sub Chhs_Cyl_Click() '差异率列表
- '判断用户是否有此功能执行权限,如有则写上机日志(进入)
- If Not Security_Log("Chhs_Cyl", Xtczybm, 1) Then
- Exit Sub
- End If
- If Qmclcy Then
- CL_Discrepancy.Show
- CL_DiscrepancyFind.Show 1
- Security_Log "Chhs_Cyl", Xtczybm, 2, False '用户退出时写上机日志
- Else
- Tsxx = "系统期末不处理差异!"
- Call Xtxxts(Tsxx, 0, 4)
- End If
- End Sub
- Private Sub Chhs_Dfacc_Click() '对方科目
- Jcsz_Dfacc.Show 1
- End Sub
- Private Sub Chhs_Diffft_Click() '差异分摊
- '判断用户是否有此功能执行权限,如有则写上机日志(进入)
- If Not Security_Log("Chhs_Cyft", Xtczybm, 1) Then
- Exit Sub
- End If
- If Qmclcy Then
- Tjfx_Diff.Show
- Tjfx_DiffCond.Show 1
- Security_Log "Chhs_Cyft", Xtczybm, 2, False '用户退出时写上机日志
- Else
- Tsxx = "系统期末不处理差异!"
- Call Xtxxts(Tsxx, 0, 4)
- End If
- End Sub
- Private Sub Chhs_Djjz_Click() '单据记帐
- Dim Rectemp As Recordset
- '判断用户是否有此功能执行权限,如有则写上机日志(进入)
- If Not Security_Log("Chhs_Djjz", Xtczybm, 1) Then
- Exit Sub
- End If
- If Xtyear <> PGKjYear Then
- Tsxx = "操作日期不在当前会计年度(" + Trim(Str(PGKjYear)) + ")之内,请重新登录!"
- Call Xtxxts(Tsxx, 0, 1)
- Else
- If Xtmm <> PGNowmon Then
- Tsxx = "操作日期不在当前会计期间(" + Trim(Str(Xtyear)) + "." + Trim(Str(PGNowmon)) + ")之内,请重新登录!"
- Call Xtxxts(Tsxx, 0, 1)
- Else
- Set Rectemp = Cw_DataEnvi.DataConnect.Execute("select Gy_WareHouse.whcode from Gy_WareHouse left outer join Gy_Whlimit on Gy_WareHouse.whcode=Gy_Whlimit.whcode where Gy_Whlimit.czybm='" & Xtczybm & "' ")
- If Rectemp.EOF Then
- Tsxx = "没有进行仓库设置!"
- Call Xtxxts(Tsxx, 0, 4)
- Exit Sub
- Else
- Set Rectemp = Cw_DataEnvi.DataConnect.Execute("select Gy_WareHouse.whcode from Gy_WareHouse left outer join Gy_Whlimit on Gy_WareHouse.whcode=Gy_Whlimit.whcode where Gy_Whlimit.czybm='" & Xtczybm & "' and Gy_WareHouse.EndDealFlagChhs=0")
- If Rectemp.EOF Then
- Tsxx = "仓库已全部期末处理,不允许进行记帐或恢复记帐操作!"
- Call Xtxxts(Tsxx, 0, 4)
- Exit Sub
- End If
- End If
- Set Rectemp = Nothing
- CL_BillChalkitup.Show
- CL_BillChalkitupCond.Show 1
- Security_Log "Chhs_Djjz", Xtczybm, 2, False '用户退出时写上机日志
- End If
- End If
- Set Rectemp = Nothing
- End Sub
- Private Sub Chhs_Eval_Click() '暂估存货设置
- If Xtclzg Then
- Jcsz_InterimMaterial.Show 1
- Else
- Tsxx = "系统不处理暂估!"
- Call Xtxxts(Tsxx, 0, 4)
- End If
- End Sub
- Private Sub Chhs_Evalfx_Click() '暂估成本分析
- '判断用户是否有此功能执行权限,如有则写上机日志(进入)
- If Not Security_Log("Chhs_EvalFx", Xtczybm, 1) Then
- Exit Sub
- End If
- If Xtclzg Then
- Tjfx_EvalFx.Show
- Tjfx_EvalFxCond.Show 1
- Security_Log "Chhs_EvalFx", Xtczybm, 2, False '用户退出时写上机日志
- Else
- Tsxx = "系统不处理暂估!"
- Call Xtxxts(Tsxx, 0, 4)
- End If
- End Sub
- Private Sub Chhs_EvalPrice_Click() '暂估单价处理
- '判断用户是否有此功能执行权限,如有则写上机日志(进入)
- If Not Security_Log("Chhs_EvalPrice", Xtczybm, 1) Then
- Exit Sub
- End If
- CL_InterimMaterialPrice.Show
- CL_InterimMaterialFind.Show 1
- Security_Log "Chhs_EvalPrice", Xtczybm, 2, False '用户退出时写上机日志
- End Sub
- Private Sub Chhs_gnbmjsq_Click() '计算器
- Shell App.Path & "calc.exe", vbNormalFocus
- End Sub
- Private Sub Chhs_gnbmkmrl_Click() '日历表
- XT_kjrlFrm.Show 1
- End Sub
- Private Sub Chhs_gy_Click() '关于
- XT_frmAbout.Show
- End Sub
- Private Sub Chhs_Incbfx_Click() '入库成本分析
- '判断用户是否有此功能执行权限,如有则写上机日志(进入)
- If Not Security_Log("Chhs_InCbfx", Xtczybm, 1) Then
- Exit Sub
- End If
- Tjfx_IncbFx.Show
- Tjfx_IncbFxCond.Show 1
- Security_Log "Chhs_InCbfx", Xtczybm, 2, False '用户退出时写上机日志
- End Sub
- Private Sub Chhs_Inoutclasssum_Click() '收发类别汇总表
- '判断用户是否有此功能执行权限,如有则写上机日志(进入)
- If Not Security_Log("Chhs_InOutClassSum", Xtczybm, 1) Then
- Exit Sub
- End If
- Tjfx_InOutClassSum.Show
- Tjfx_InOutClassSumCond.Show 1
- Security_Log "Chhs_InOutClassSum", Xtczybm, 2, False '用户退出时写上机日志
- End Sub
- Private Sub Chhs_Insum_Click() '入库单汇总表
- '判断用户是否有此功能执行权限,如有则写上机日志(进入)
- If Not Security_Log("Chhs_InbillSum", Xtczybm, 1) Then
- Exit Sub
- End If
- Tjfx_InBillSum.Show
- Tjfx_InBillSumCond.Show 1
- Security_Log "Chhs_InbillSum", Xtczybm, 2, False '用户退出时写上机日志
- End Sub
- Private Sub Chhs_lsz_Click() '流水帐
- '判断用户是否有此功能执行权限,如有则写上机日志(进入)
- If Not Security_Log("Chhs_Lsz", Xtczybm, 1) Then
- Exit Sub
- End If
- Zbfx_InOut.Show
- Zbfx_InOutCond.Show 1
- Security_Log "Chhs_Lsz", Xtczybm, 2, False '用户退出时写上机日志
- End Sub
- Private Sub Chhs_Macc_Click() '存货科目
- Jcsz_Macc.Show 1
- End Sub
- Private Sub Chhs_Matebill_Click() '材料入库单
- '判断用户是否有此功能执行权限,如有则写上机日志(进入)
- If Not Security_Log("Chhs_MateInEdit", Xtczybm, 1) Then
- Exit Sub
- End If
- If ClrkdKfsc Then
- If Not Sub_Records(Xtrq, "Chhs_V_MateInBill") Then
- Tsxx = CStr(Format(Xtrq, "yyyy-mm-dd")) + " 无单据!"
- Call Xtxxts(Tsxx, 0, 4)
- Else
- Xtcdcs = "1"
- DJ_MateInBill.Show 1
- Security_Log "Chhs_MateInEdit", Xtczybm, 2, False '用户退出时写上机日志
- End If
- Else
- Xtcdcs = "1"
- DJ_MateInBill.Show 1
- Security_Log "Chhs_MateInEdit", Xtczybm, 2, False '用户退出时写上机日志
- End If
- End Sub
- Private Sub Chhs_Mateinbilllist_Click() '材料入库单列表
- '判断用户是否有此功能执行权限,如有则写上机日志(进入)
- If Not Security_Log("Chhs_MateInBillList", Xtczybm, 1) Then
- Exit Sub
- End If
- LB_MateInBillList.Show
- LBCX_MateInBillListFind.Show 1
- Security_Log "Chhs_MateInBillList", Xtczybm, 2, False '用户退出时写上机日志
- End Sub
- Private Sub Chhs_Mateoutbill_Click() '材料出库单
- '判断用户是否有此功能执行权限,如有则写上机日志(进入)
- If Not Security_Log("Chhs_MateOutEdit", Xtczybm, 1) Then
- Exit Sub
- End If
- If Xt_XtJc Then
- If Not Sub_Records(Xtrq, "Chhs_V_MateOutBill") Then
- Tsxx = CStr(Format(Xtrq, "yyyy-mm-dd")) + " 无单据!"
- Call Xtxxts(Tsxx, 0, 4)
- Else
- Xtcdcs = "1"
- DJ_MateOutBill.Show 1
- Security_Log "Chhs_MateOutEdit", Xtczybm, 2, False '用户退出时写上机日志
- End If
- Else
- Xtcdcs = "1"
- DJ_MateOutBill.Show 1
- Security_Log "Chhs_MateOutEdit", Xtczybm, 2, False '用户退出时写上机日志
- End If
- End Sub
- Private Sub Chhs_Mateoutbilllist_Click() '材料出库单列表
- '判断用户是否有此功能执行权限,如有则写上机日志(进入)
- If Not Security_Log("Chhs_MateOutBillList", Xtczybm, 1) Then
- Exit Sub
- End If
- LB_MateOutBillList.Show
- LBCX_MateOutBillListFind.Show 1
- Security_Log "Chhs_MateOutBillList", Xtczybm, 2, False '用户退出时写上机日志
- End Sub
- Private Sub Chhs_Mxz_Click() '明细帐
- '判断用户是否有此功能执行权限,如有则写上机日志(进入)
- If Not Security_Log("Chhs_Mxz", Xtczybm, 1) Then
- Exit Sub
- End If
- Zbfx_List.Show
- Zbfx_ListCond.Show 1
- Security_Log "Chhs_Mxz", Xtczybm, 2, False '用户退出时写上机日志
- End Sub
- Private Sub Chhs_Otherinbill_Click() '其它入库单
- '判断用户是否有此功能执行权限,如有则写上机日志(进入)
- If Not Security_Log("Chhs_OtherInEdit", Xtczybm, 1) Then
- Exit Sub
- End If
- If Xt_XtJc Then
- If Not Sub_Records(Xtrq, "Chhs_V_OtherInBill") Then
- Tsxx = CStr(Format(Xtrq, "yyyy-mm-dd")) + " 无单据!"
- Call Xtxxts(Tsxx, 0, 4)
- Else
- Xtcdcs = "1"
- DJ_OtherInBill.Show 1
- Security_Log "Chhs_OtherInEdit", Xtczybm, 2, False '用户退出时写上机日志
- End If
- Else
- Xtcdcs = "1"
- DJ_OtherInBill.Show 1
- Security_Log "Chhs_OtherInEdit", Xtczybm, 2, False '用户退出时写上机日志
- End If
- End Sub
- Private Sub Chhs_Otherinbilllist_Click() '其它入库单列表
- '判断用户是否有此功能执行权限,如有则写上机日志(进入)
- If Not Security_Log("Chhs_OtherInBillList", Xtczybm, 1) Then
- Exit Sub
- End If
- LB_OtherInBillList.Show
- LBCX_OtherInBillListFind.Show 1
- Security_Log "Chhs_OtherInBillList", Xtczybm, 2, False '用户退出时写上机日志
- End Sub
- Private Sub Chhs_Otheroutbill_Click() '其它出库单
- '判断用户是否有此功能执行权限,如有则写上机日志(进入)
- If Not Security_Log("Chhs_OtherOutEdit", Xtczybm, 1) Then
- Exit Sub
- End If
- If Xt_XtJc Then
- If Not Sub_Records(Xtrq, "Chhs_V_OtherOutBill") Then
- Tsxx = CStr(Format(Xtrq, "yyyy-mm-dd")) + " 无单据!"
- Call Xtxxts(Tsxx, 0, 4)
- Else
- Xtcdcs = "1"
- DJ_OtherOutBill.Show 1
- Security_Log "Chhs_OtherOutEdit", Xtczybm, 2, False '用户退出时写上机日志
- End If
- Else
- Xtcdcs = "1"
- DJ_OtherOutBill.Show 1
- Security_Log "Chhs_OtherOutEdit", Xtczybm, 2, False '用户退出时写上机日志
- End If
- End Sub
- Private Sub Chhs_Otheroutbilllist_Click() '其它出库单列表
- '判断用户是否有此功能执行权限,如有则写上机日志(进入)
- If Not Security_Log("Chhs_OtheOutBillList", Xtczybm, 1) Then
- Exit Sub
- End If
- LB_OtherOutBillList.Show
- LBCX_OtherOutBillListFind.Show 1
- Security_Log "Chhs_OtheOutBillList", Xtczybm, 2, False '用户退出时写上机日志
- End Sub
- Private Sub Chhs_Outsum_Click() '出库单汇总表
- '判断用户是否有此功能执行权限,如有则写上机日志(进入)
- If Not Security_Log("Chhs_OutBillSum", Xtczybm, 1) Then
- Exit Sub
- End If
- Tjfx_OutBillSum.Show
- Tjfx_OutBillSumCond.Show 1
- Security_Log "Chhs_OutBillSum", Xtczybm, 2, False '用户退出时写上机日志
- End Sub
- Private Sub Chhs_Prodinbill_Click() '产品入库单
- '判断用户是否有此功能执行权限,如有则写上机日志(进入)
- If Not Security_Log("Chhs_ProdInEdit", Xtczybm, 1) Then
- Exit Sub
- End If
- If Xt_XtJc Then
- If Not Sub_Records(Xtrq, "chhs_V_ProductInBill") Then
- Tsxx = CStr(Format(Xtrq, "yyyy-mm-dd")) + " 无单据!"
- Call Xtxxts(Tsxx, 0, 4)
- Else
- Xtcdcs = "1"
- DJ_ProdInBill.Show 1
- Security_Log "Chhs_ProdInEdit", Xtczybm, 2, False '用户退出时写上机日志
- End If
- Else
- Xtcdcs = "1"
- DJ_ProdInBill.Show 1
- Security_Log "Chhs_ProdInEdit", Xtczybm, 2, False '用户退出时写上机日志
- End If
- End Sub
- Private Sub Chhs_Prodinbilllist_Click()
- '判断用户是否有此功能执行权限,如有则写上机日志(进入)
- If Not Security_Log("Chhs_ProdInBillList", Xtczybm, 1) Then
- Exit Sub
- End If
- LB_ProdInBillList.Show
- LBCX_ProdInBillListFind.Show 1
- Security_Log "Chhs_ProdInBillList", Xtczybm, 2, False '用户退出时写上机日志
- End Sub
- Private Sub Chhs_ProdPrice_Click() '产品成本调整
- '判断用户是否有此功能执行权限,如有则写上机日志(进入)
- If Not Security_Log("Chhs_ProdPrice", Xtczybm, 1) Then
- Exit Sub
- End If
- Cl_ProdPrice.Show
- Cl_ProdPriceCond.Show 1
- Security_Log "Chhs_ProdPrice", Xtczybm, 2, False '用户退出时写上机日志
- End Sub
- Private Sub Chhs_Qcjz_Click() '期初单据记帐
- Dim Rectemp As Recordset
- '判断用户是否有此功能执行权限,如有则写上机日志(进入)
- If Not Security_Log("Chhs_Qcjz", Xtczybm, 1) Then
- Exit Sub
- End If
- If Xtyear <> PGKjYear Then
- Tsxx = "操作日期不在当前会计年度(" + Trim(Str(PGKjYear)) + "),请重新登录!"
- Call Xtxxts(Tsxx, 0, 1)
- Exit Sub
- End If
- Set Rectemp = Cw_DataEnvi.DataConnect.Execute("select * from gy_kjrlb where beginflag=1")
- If Rectemp.Fields("chhsjzbz") Then
- Tsxx = "期初月份已结帐,不允许期初记帐或恢复记帐操作!"
- Call Xtxxts(Tsxx, 0, 1)
- Exit Sub
- End If
- Set Rectemp = Cw_DataEnvi.DataConnect.Execute("select Gy_WareHouse.whcode from Gy_WareHouse left outer join Gy_Whlimit on Gy_WareHouse.whcode=Gy_Whlimit.whcode where Gy_Whlimit.czybm='" & Xtczybm & "' ")
- If Rectemp.EOF Then
- Tsxx = "没有进行仓库设置!"
- Call Xtxxts(Tsxx, 0, 4)
- Exit Sub
- Else
- Set Rectemp = Cw_DataEnvi.DataConnect.Execute("select Gy_WareHouse.whcode from Gy_WareHouse left outer join Gy_Whlimit on Gy_WareHouse.whcode=Gy_Whlimit.whcode where Gy_Whlimit.czybm='" & Xtczybm & "' and Gy_WareHouse.EndDealFlagChhs=0")
- If Rectemp.EOF Then
- Tsxx = "仓库已全部期末处理,不允许进行记帐或恢复记帐操作!"
- Call Xtxxts(Tsxx, 0, 4)
- Exit Sub
- End If
- End If
- Set Rectemp = Nothing
- Start_BillChalkitup.Show
- Start_BillChalkitupCond.Show 1
- Security_Log "Chhs_Qcjz", Xtczybm, 2, False '用户退出时写上机日志
- End Sub
- Private Sub Chhs_Qmcl_Click() '期末处理
- '判断用户是否有此功能执行权限,如有则写上机日志(进入)
- If Not Security_Log("Chhs_Qmcl", Xtczybm, 1) Then
- Exit Sub
- End If
- If Xtyear <> PGKjYear Then
- Tsxx = "操作日期不在当前会计年度(" + Trim(Str(PGKjYear)) + ")之内,请重新登录!"
- Call Xtxxts(Tsxx, 0, 1)
- Else
- CL_EndDispose.Show 1
- Security_Log "Chhs_Qmcl", Xtczybm, 2, False '用户退出时写上机日志
- End If
- End Sub
- Private Sub Chhs_Qmjz_Click() '期末结帐
- Dim Rectemp As Recordset
- '判断用户是否有此功能执行权限,如有则写上机日志(进入)
- If Not Security_Log("Chhs_Qmjz", Xtczybm, 1) Then
- Exit Sub
- End If
- If Xtyear <> PGKjYear Then
- Set Rectemp = Cw_DataEnvi.DataConnect.Execute("select * from gy_kjrlb where kjyear=" & PGKjYear - 1 & " order by period desc")
- If Not Rectemp.EOF Then
- If Xtmm = Rectemp.Fields("period") Then
- CL_EndCheckOut.Dyear = PGKjYear - 1
- CL_EndCheckOut.Dmonth = Xtmm
- CL_EndCheckOut.Timer1 = True
- CL_EndCheckOut.Opt_Qmjz.Enabled = False
- CL_EndCheckOut.Opt_Hfqmjz.Value = True
- CL_EndCheckOut.Show 1
- Security_Log "Chhs_Qmjz", Xtczybm, 2, False '用户退出时写上机日志
- Else
- Tsxx = "操作日期不在当前会计年度(" + Trim(Str(PGKjYear)) + ")之内,请重新登录!"
- Call Xtxxts(Tsxx, 0, 1)
- End If
- Else
- Tsxx = "操作日期不在当前会计年度(" + Trim(Str(PGKjYear)) + ")之内,请重新登录!"
- Call Xtxxts(Tsxx, 0, 1)
- End If
- Else
- CL_EndCheckOut.Dyear = PGKjYear
- CL_EndCheckOut.Dmonth = PGNowmon
- CL_EndCheckOut.Timer1 = True
- CL_EndCheckOut.Show 1
- Security_Log "Chhs_Qmjz", Xtczybm, 2, False '用户退出时写上机日志
- End If
- End Sub
- Private Sub Chhs_quit_Click() '退出系统
- On Error Resume Next
- Dim Jsqte As Integer
- If Not Tcxt Then
- Cancel = True
- Else
- Unload_TF = True
- For Jsqte = 0 To Forms.count - 1
- Unload Forms(Jsqte)
- Next Jsqte
- End
- End If
- End Sub
- Private Sub Chhs_Register_Click() '重新注册
- XT_login.Show 1
- End Sub
- Private Sub Chhs_Selloutbill_Click() '销售出库单
- '判断用户是否有此功能执行权限,如有则写上机日志(进入)
- If Not Security_Log("Chhs_SellOutEdit", Xtczybm, 1) Then
- Exit Sub
- End If
- If Xt_XtJc Then
- If Not Sub_Records(Xtrq, "Chhs_V_SellOutBill") Then
- Tsxx = CStr(Format(Xtrq, "yyyy-mm-dd")) + " 无单据!"
- Call Xtxxts(Tsxx, 0, 4)
- Else
- Xtcdcs = "1"
- DJ_SellOutBill.Show 1
- Security_Log "Chhs_SellOutEdit", Xtczybm, 2, False '用户退出时写上机日志
- End If
- Else
- Xtcdcs = "1"
- DJ_SellOutBill.Show 1
- Security_Log "Chhs_SellOutEdit", Xtczybm, 2, False '用户退出时写上机日志
- End If
- End Sub
- Private Sub Chhs_Seloutbilllist_Click() '销售出库单列表
- '判断用户是否有此功能执行权限,如有则写上机日志(进入)
- If Not Security_Log("Chhs_SellOutBillList", Xtczybm, 1) Then
- Exit Sub
- End If
- LB_SellOutBillList.Show
- LBCX_SellOutBillListFind.Show 1
- Security_Log "Chhs_SellOutBillList", Xtczybm, 2, False '用户退出时写上机日志
- End Sub
- Private Sub Chhs_Sfchz_Click() '收发存汇总表
- '判断用户是否有此功能执行权限,如有则写上机日志(进入)
- If Not Security_Log("Chhs_Sfchz", Xtczybm, 1) Then
- Exit Sub
- End If
- Tjfx_Sfchz.Show
- Tjfx_SfchzCond.Show 1
- Security_Log "Chhs_Sfchz", Xtczybm, 2, False '用户退出时写上机日志
- End Sub
- Private Sub Chhs_Startbill_Click() '期初单据录入
- Dim Rectemp As Recordset
- '判断用户是否有此功能执行权限,如有则写上机日志(进入)
- If Not Security_Log("Chhs_StartBillEdit", Xtczybm, 1) Then
- Exit Sub
- End If
- If Xtyear <> PGKjYear Then
- Tsxx = "操作日期不在当前会计年度(" + Trim(Str(PGKjYear)) + "),请重新登录!"
- Call Xtxxts(Tsxx, 0, 1)
- Exit Sub
- End If
- Set Rectemp = Cw_DataEnvi.DataConnect.Execute("select * from gy_kjrlb where beginflag=1")
- If Rectemp.Fields("chhsjzbz") Then
- Tsxx = "期初月份已结帐,不允许期初单据录入!"
- Call Xtxxts(Tsxx, 0, 1)
- Exit Sub
- End If
- Set Rectemp = Cw_DataEnvi.DataConnect.Execute("select Gy_WareHouse.whcode from Gy_WareHouse left outer join Gy_Whlimit on Gy_WareHouse.whcode=Gy_Whlimit.whcode where Gy_Whlimit.czybm='" & Xtczybm & "' ")
- If Rectemp.EOF Then
- Tsxx = "没有进行仓库设置!"
- Call Xtxxts(Tsxx, 0, 4)
- Exit Sub
- Else
- Set Rectemp = Cw_DataEnvi.DataConnect.Execute("select Gy_WareHouse.whcode from Gy_WareHouse left outer join Gy_Whlimit on Gy_WareHouse.whcode=Gy_Whlimit.whcode where Gy_Whlimit.czybm='" & Xtczybm & "' and Gy_WareHouse.EndDealFlagChhs=0")
- If Rectemp.EOF Then
- Tsxx = "仓库已全部期末处理,不允许期初单据录入!"
- Call Xtxxts(Tsxx, 0, 4)
- Exit Sub
- End If
- End If
- Set Rectemp = Nothing
- Xtcdcs = "1"
- Start_BillInput.Show 1
- Security_Log "Chhs_StartBillEdit", Xtczybm, 2, False '用户退出时写上机日志
- End Sub
- Private Sub Chhs_Startbilllist_Click() '期初单据列表
- '判断用户是否有此功能执行权限,如有则写上机日志(进入)
- If Not Security_Log("Chhs_StartBillList", Xtczybm, 1) Then
- Exit Sub
- End If
- Start_BillInputList.Show
- Start_BillListCond.Show 1
- Security_Log "Chhs_StartBillList", Xtczybm, 2, False '用户退出时写上机日志
- End Sub
- Private Sub Chhs_xtbz_Click() '帮助
- Call F1bz
- End Sub
- Private Sub Chhs_Ywfw_Click() '业务范围
- Jcsz_Ywfw.Show 1
- End Sub
- Private Sub Chhs_Zz_Click() '总帐
- '判断用户是否有此功能执行权限,如有则写上机日志(进入)
- If Not Security_Log("Chhs_Zz", Xtczybm, 1) Then
- Exit Sub
- End If
- Zbfx_Mate.Show
- Zbfx_MateCond.Show 1
- Security_Log "Chhs_Zz", Xtczybm, 2, False '用户退出时写上机日志
- End Sub
- Private Sub MDIForm_Activate() '主窗体击活
- Timer1.Enabled = True
- End Sub
- Private Sub MDIForm_Load()
- '调入主操作界面
- Xt_Control.Show
- End Sub
- Private Sub MDIForm_QueryUnload(Cancel As Integer, UnloadMode As Integer)
- On Error Resume Next
- Dim Jsqte As Integer
- If Not Tcxt Then
- Cancel = True
- Else
- Unload_TF = True
- For Jsqte = 0 To Forms.count - 1
- Unload Forms(Jsqte)
- Next Jsqte
- End
- End If
- End Sub
- Private Sub mnuWindowArrangeIcons_Click() '窗口排列图标
- Me.Arrange vbArrangeIcons
- End Sub
- Private Sub mnuWindowTileVertical_Click() '窗口纵向平铺
- Me.Arrange vbTileVertical
- End Sub
- Private Sub mnuWindowTileHorizontal_Click() '窗口横向平铺
- Me.Arrange vbTileHorizontal
- End Sub
- Private Sub mnuWindowCascade_Click() '窗口层叠
- Me.Arrange vbCascade
- End Sub
- '************************'以下为程序固定不变部分*********************'
- Private Function Tcxt() As Boolean '退出系统提示
- Dim Answer As Integer
- Tsxx = "请确认是否退出系统?"
- Answer = Xtxxts(Tsxx, 2, 2)
- If Answer = 1 Then
- Tcxt = True
- Else
- Tcxt = False
- End If
- End Function
- Private Sub Timer1_Timer() '在窗体激活后调入程序
- Timer1.Enabled = False
- If XT_login.QdCheck.Value = 1 Then
- Call Xtcsh
- XT_login.QdCheck.Value = 0
- End If
- End Sub
- Private Sub Xtcsh() '系统主控制台及全局变量初始化
- With XT_login
- Xtczybm = Trim(Mid(.CzyCombo.Text, 1, InStr(1, .CzyCombo.Text, "-") - 1))
- Xtczy = Trim(Mid(.CzyCombo.Text, InStr(1, .CzyCombo.Text, "-") + 1, Len(.CzyCombo.Text)))
- Xtztbm = Trim(Mid(.ZtCombo.Text, 1, InStr(1, .ZtCombo.Text, "-") - 1))
- Xtdwm = Trim(Mid(.ZtCombo.Text, InStr(1, .ZtCombo.Text, "-") + 1, Len(.ZtCombo.Text)))
- Xtkjqjgs = 12
- '业务操作日期
- Xtrq = CDate(.CzrqText.Text)
- '用户选择系统年度
- Xtyear = Val(.KjyearCombo.Text)
- '用户选择系统会计期间
- Set Xtrlrec = Cw_DataEnvi.DataConnect.Execute("Select * From Gy_kjrlb where qsrq<='" + .CzrqText.Text + "' and zzrq>='" + .CzrqText.Text + "'")
- If Not Xtrlrec.EOF Then
- Xtmm = Xtrlrec.Fields("Period")
- End If
- End With
- With XT_Main.StatusBar1
- .Panels("OperStatus") = "就绪"
- .Panels("zt").Text = Xtdwm
- .Panels("czy").Text = Xtczy
- .Panels("rq").Text = "业务日期:" + Format(Xtrq, "yyyy-mm-dd")
- .Panels("rjbb").Text = "【百利/ERP】"
- End With
- End Sub