English
+
资源名称：ERPSYS.zip [点击查看]
上传用户：zhpu1995
上传日期：2013-09-06
资源大小：61151k
文件大小：87k
源码类别：
企业管理
开发平台：
Visual Basic
- VERSION 5.00
- Object = "{BEEECC20-4D5F-4F8B-BFDC-5D9B6FBDE09D}#1.0#0"; "vsflex8.ocx"
- Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "mscomctl.ocx"
- Begin VB.Form JC_FrmQcyelr
- BackColor = &H00C0C0C0&
- BorderStyle = 1 'Fixed Single
- Caption = "期初余额录入_总帐"
- ClientHeight = 8310
- ClientLeft = 675
- ClientTop = 720
- ClientWidth = 11850
- Icon = "基础设置_期初余额录入.frx":0000
- KeyPreview = -1 'True
- LinkTopic = "Form4"
- MaxButton = 0 'False
- MinButton = 0 'False
- ScaleHeight = 8310
- ScaleWidth = 11850
- StartUpPosition = 1 '所有者中心
- Begin VB.PictureBox Pic_Title
- Height = 765
- Left = 0
- Picture = "基础设置_期初余额录入.frx":1042
- ScaleHeight = 705
- ScaleWidth = 11715
- TabIndex = 7
- Top = 600
- Width = 11775
- Begin VB.Label Lab_Lrztxs
- Appearance = 0 'Flat
- BackColor = &H80000005&
- BorderStyle = 1 'Fixed Single
- Caption = "初始完成浏览只读"
- ForeColor = &H000000C0&
- Height = 405
- Left = 10800
- TabIndex = 13
- Top = 180
- Width = 765
- End
- Begin VB.Label Label1
- Appearance = 0 'Flat
- BackColor = &H80000005&
- BackStyle = 0 'Transparent
- Caption = "辅助核算科目"
- ForeColor = &H80000008&
- Height = 195
- Index = 0
- Left = 9510
- TabIndex = 12
- Top = 420
- Width = 1305
- End
- Begin VB.Label Lab_Color
- Appearance = 0 'Flat
- BackColor = &H00FFFF80&
- BorderStyle = 1 'Fixed Single
- ForeColor = &H80000008&
- Height = 195
- Index = 1
- Left = 9270
- TabIndex = 11
- Top = 420
- Width = 195
- End
- Begin VB.Label tsLabel
- BackColor = &H80000018&
- BackStyle = 0 'Transparent
- Caption = "期初余额录入"
- BeginProperty Font
- Name = "宋体"
- Size = 14.25
- Charset = 134
- Weight = 700
- Underline = 0 'False
- Italic = 0 'False
- Strikethrough = 0 'False
- EndProperty
- ForeColor = &H00000000&
- Height = 375
- Index = 4
- Left = 630
- TabIndex = 10
- Top = 180
- Width = 1905
- End
- Begin VB.Label Lab_Color
- Appearance = 0 'Flat
- BackColor = &H00C0E0FF&
- BorderStyle = 1 'Fixed Single
- ForeColor = &H80000008&
- Height = 195
- Index = 0
- Left = 9270
- TabIndex = 9
- Top = 150
- Width = 195
- End
- Begin VB.Label Label1
- Appearance = 0 'Flat
- BackColor = &H80000005&
- BackStyle = 0 'Transparent
- Caption = "非末级科目"
- ForeColor = &H80000008&
- Height = 195
- Index = 2
- Left = 9510
- TabIndex = 8
- Top = 150
- Width = 1035
- End
- End
- Begin VB.TextBox Ydtext
- BackColor = &H00C0FFFF&
- BorderStyle = 0 'None
- Height = 300
- Left = 8760
- MultiLine = -1 'True
- TabIndex = 0
- Top = 2760
- Visible = 0 'False
- Width = 1185
- End
- Begin VB.ComboBox YdCombo
- Height = 300
- Left = 8700
- Style = 2 'Dropdown List
- TabIndex = 3
- Top = 3210
- Visible = 0 'False
- Width = 1155
- End
- Begin VB.Timer Timer1
- Interval = 1
- Left = 8970
- Top = 1620
- End
- Begin VB.CommandButton Ydcommand
- Height = 300
- Left = 10050
- Picture = "基础设置_期初余额录入.frx":35106
- Style = 1 'Graphical
- TabIndex = 1
- Top = 2010
- Visible = 0 'False
- Width = 300
- End
- Begin VSFlex8Ctl.VSFlexGrid WglrGrid
- Height = 6915
- Left = 30
- TabIndex = 4
- Top = 1380
- Width = 11775
- _cx = 5080
- _cy = 5080
- Appearance = 1
- BorderStyle = 1
- Enabled = -1 'True
- BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
- Name = "宋体"
- Size = 9
- Charset = 134
- Weight = 400
- Underline = 0 'False
- Italic = 0 'False
- Strikethrough = 0 'False
- EndProperty
- MousePointer = 0
- BackColor = 16777215
- ForeColor = -2147483640
- BackColorFixed = 12632256
- ForeColorFixed = -2147483630
- BackColorSel = -2147483635
- ForeColorSel = -2147483634
- BackColorBkg = -2147483636
- BackColorAlternate= 16777215
- GridColor = -2147483633
- GridColorFixed = -2147483632
- TreeColor = -2147483632
- FloodColor = 192
- SheetBorder = -2147483642
- FocusRect = 1
- HighLight = 1
- AllowSelection = -1 'True
- AllowBigSelection= -1 'True
- AllowUserResizing= 0
- SelectionMode = 0
- GridLines = 1
- GridLinesFixed = 2
- GridLineWidth = 1
- Rows = 50
- Cols = 10
- FixedRows = 1
- FixedCols = 1
- RowHeightMin = 0
- RowHeightMax = 0
- ColWidthMin = 0
- ColWidthMax = 0
- ExtendLastCol = 0 'False
- FormatString = ""
- ScrollTrack = 0 'False
- ScrollBars = 3
- ScrollTips = 0 'False
- MergeCells = 0
- MergeCompare = 0
- AutoResize = -1 'True
- AutoSizeMode = 0
- AutoSearch = 0
- AutoSearchDelay = 2
- MultiTotals = -1 'True
- SubtotalPosition= 1
- OutlineBar = 0
- OutlineCol = 0
- Ellipsis = 0
- ExplorerBar = 0
- PicturesOver = 0 'False
- FillStyle = 0
- RightToLeft = 0 'False
- PictureType = 0
- TabBehavior = 0
- OwnerDraw = 0
- Editable = 0
- ShowComboButton = 1
- WordWrap = 0 'False
- TextStyle = 0
- TextStyleFixed = 0
- OleDragMode = 0
- OleDropMode = 0
- DataMode = 0
- VirtualData = -1 'True
- DataMember = ""
- ComboSearch = 3
- AutoSizeMouse = -1 'True
- FrozenRows = 0
- FrozenCols = 0
- AllowUserFreezing= 0
- BackColorFrozen = 0
- ForeColorFrozen = 0
- WallPaperAlignment= 9
- AccessibleName = ""
- AccessibleDescription= ""
- AccessibleValue = ""
- AccessibleRole = 24
- Begin MSComctlLib.ImageList ImageList1
- Left = 9120
- Top = 780
- _ExtentX = 1005
- _ExtentY = 1005
- BackColor = -2147483643
- ImageWidth = 16
- ImageHeight = 16
- MaskColor = 12632256
- _Version = 393216
- BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628}
- NumListImages = 29
- BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "基础设置_期初余额录入.frx":35490
- Key = "sz"
- EndProperty
- BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "基础设置_期初余额录入.frx":3582A
- Key = "dy"
- EndProperty
- BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "基础设置_期初余额录入.frx":35BC4
- Key = "yl"
- EndProperty
- BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "基础设置_期初余额录入.frx":35F5E
- Key = "xg"
- EndProperty
- BeginProperty ListImage5 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "基础设置_期初余额录入.frx":362F8
- Key = "zh"
- EndProperty
- BeginProperty ListImage6 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "基础设置_期初余额录入.frx":36692
- Key = "sh"
- EndProperty
- BeginProperty ListImage7 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "基础设置_期初余额录入.frx":36A2C
- Key = "bc"
- EndProperty
- BeginProperty ListImage8 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "基础设置_期初余额录入.frx":36DC6
- Key = "fq"
- EndProperty
- BeginProperty ListImage9 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "基础设置_期初余额录入.frx":37160
- Key = "bz"
- EndProperty
- BeginProperty ListImage10 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "基础设置_期初余额录入.frx":374FA
- Key = "tc"
- EndProperty
- BeginProperty ListImage11 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "基础设置_期初余额录入.frx":37894
- Key = "bcgs"
- EndProperty
- BeginProperty ListImage12 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "基础设置_期初余额录入.frx":37C2E
- Key = "mrlk"
- EndProperty
- BeginProperty ListImage13 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "基础设置_期初余额录入.frx":37FC8
- Key = "xsxm"
- EndProperty
- BeginProperty ListImage14 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "基础设置_期初余额录入.frx":38362
- Key = "first"
- EndProperty
- BeginProperty ListImage15 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "基础设置_期初余额录入.frx":386FC
- Key = "prev"
- EndProperty
- BeginProperty ListImage16 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "基础设置_期初余额录入.frx":38A96
- Key = "next"
- EndProperty
- BeginProperty ListImage17 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "基础设置_期初余额录入.frx":38E30
- Key = "last"
- EndProperty
- BeginProperty ListImage18 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "基础设置_期初余额录入.frx":391CA
- Key = "xx"
- EndProperty
- BeginProperty ListImage19 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "基础设置_期初余额录入.frx":39564
- Key = "define"
- EndProperty
- BeginProperty ListImage20 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "基础设置_期初余额录入.frx":398FE
- Key = "exec"
- EndProperty
- BeginProperty ListImage21 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "基础设置_期初余额录入.frx":39C98
- Key = "xz"
- EndProperty
- BeginProperty ListImage22 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "基础设置_期初余额录入.frx":3A032
- Key = "sc"
- EndProperty
- BeginProperty ListImage23 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "基础设置_期初余额录入.frx":3A3CC
- Key = "sx"
- EndProperty
- BeginProperty ListImage24 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "基础设置_期初余额录入.frx":3A766
- Key = "cx"
- EndProperty
- BeginProperty ListImage25 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "基础设置_期初余额录入.frx":3AB00
- Key = "zd"
- EndProperty
- BeginProperty ListImage26 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "基础设置_期初余额录入.frx":3AE9A
- Key = "dz"
- EndProperty
- BeginProperty ListImage27 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "基础设置_期初余额录入.frx":3B234
- Key = "ph"
- EndProperty
- BeginProperty ListImage28 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "基础设置_期初余额录入.frx":3B5CE
- Key = "fz"
- EndProperty
- BeginProperty ListImage29 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "基础设置_期初余额录入.frx":3B968
- Key = "dw"
- EndProperty
- EndProperty
- End
- End
- Begin MSComctlLib.Toolbar Tlb_Action
- Align = 1 'Align Top
- Height = 555
- Left = 0
- TabIndex = 2
- Top = 0
- Width = 11850
- _ExtentX = 20902
- _ExtentY = 979
- ButtonWidth = 820
- ButtonHeight = 926
- AllowCustomize = 0 'False
- Wrappable = 0 'False
- Appearance = 1
- Style = 1
- ImageList = "ImageList1"
- _Version = 393216
- BeginProperty Buttons {66833FE8-8583-11D1-B16A-00C0F0283628}
- NumButtons = 12
- BeginProperty Button1 {66833FEA-8583-11D1-B16A-00C0F0283628}
- Caption = "设置"
- Key = "ymsz"
- Object.ToolTipText = "打印页面设置"
- ImageKey = "sz"
- EndProperty
- BeginProperty Button2 {66833FEA-8583-11D1-B16A-00C0F0283628}
- Caption = "打印"
- Key = "dy"
- Object.ToolTipText = "打印当前单据或Ctrl+P"
- ImageKey = "dy"
- EndProperty
- BeginProperty Button3 {66833FEA-8583-11D1-B16A-00C0F0283628}
- Caption = "预览"
- Key = "yl"
- ImageKey = "yl"
- EndProperty
- BeginProperty Button4 {66833FEA-8583-11D1-B16A-00C0F0283628}
- Style = 3
- EndProperty
- BeginProperty Button5 {66833FEA-8583-11D1-B16A-00C0F0283628}
- Caption = "辅助"
- Key = "fz"
- ImageKey = "fz"
- EndProperty
- BeginProperty Button6 {66833FEA-8583-11D1-B16A-00C0F0283628}
- Style = 3
- EndProperty
- BeginProperty Button7 {66833FEA-8583-11D1-B16A-00C0F0283628}
- Caption = "平衡"
- Key = "ph"
- ImageKey = "ph"
- EndProperty
- BeginProperty Button8 {66833FEA-8583-11D1-B16A-00C0F0283628}
- Caption = "对帐"
- Key = "dz"
- ImageKey = "dz"
- EndProperty
- BeginProperty Button9 {66833FEA-8583-11D1-B16A-00C0F0283628}
- Style = 3
- EndProperty
- BeginProperty Button10 {66833FEA-8583-11D1-B16A-00C0F0283628}
- Caption = "定位"
- Key = "dw"
- ImageKey = "dw"
- EndProperty
- BeginProperty Button11 {66833FEA-8583-11D1-B16A-00C0F0283628}
- Caption = "帮助"
- Key = "bz"
- ImageKey = "bz"
- EndProperty
- BeginProperty Button12 {66833FEA-8583-11D1-B16A-00C0F0283628}
- Caption = "退出"
- Key = "fh"
- ImageKey = "tc"
- EndProperty
- EndProperty
- BorderStyle = 1
- Begin VB.CommandButton Cmd_Qclrwc
- Caption = "期初录入完成"
- Height = 375
- Left = 8700
- TabIndex = 14
- Top = 90
- Width = 1245
- End
- Begin MSComctlLib.Toolbar GsToolbar
- Height = 525
- Left = 10170
- TabIndex = 6
- Top = 0
- Width = 1665
- _ExtentX = 2937
- _ExtentY = 926
- ButtonWidth = 1455
- ButtonHeight = 926
- AllowCustomize = 0 'False
- Appearance = 1
- Style = 1
- ImageList = "ImageList1"
- _Version = 393216
- BeginProperty Buttons {66833FE8-8583-11D1-B16A-00C0F0283628}
- NumButtons = 2
- BeginProperty Button1 {66833FEA-8583-11D1-B16A-00C0F0283628}
- Caption = "保存格式"
- Key = "bcgs"
- ImageKey = "bcgs"
- EndProperty
- BeginProperty Button2 {66833FEA-8583-11D1-B16A-00C0F0283628}
- Caption = "默认列宽"
- Key = "hfmrgs"
- ImageKey = "mrlk"
- EndProperty
- EndProperty
- End
- End
- Begin VB.Label Lab_OperStatus
- BackColor = &H000080FF&
- Caption = "1"
- Height = 345
- Left = 9240
- TabIndex = 5
- Top = 840
- Visible = 0 'False
- Width = 345
- End
- End
- Attribute VB_Name = "JC_FrmQcyelr"
- Attribute VB_GlobalNameSpace = False
- Attribute VB_Creatable = False
- Attribute VB_PredeclaredId = True
- Attribute VB_Exposed = False
- '*********************************************************************************************
- '* 模 块 名 称 :科目期初余额录入
- '* 功 能 描 述 :
- '* 程序员姓名 :张建忠
- '* 最后修改人 :张建忠
- '* 最后修改时间:2001/11/26
- '* 备 注:程序中所有依实际情况自定义部分均用[>> <<]括起
- '*
- '* 1.每次调入外部功能窗体，均要加锁ChangeLock=True,窗体关闭后解锁ChangeLock=false
- '*
- '* 2.网格列存储内容注解
- '*
- '* 0-末级科目标识 1-数量核算标识 2-外币核算标识
- '*
- '* 3.Lab_OperStatus 用此标签来标识单据录入状态(默认值为1) 1-浏览 2-修改
- '*
- '*********************************************************************************************
- '以下为自定义变量
- Dim Int_CodeScheme() As Integer '会计科目编码方案
- Dim Int_CodeLev As Integer '会计科目编码级数
- Dim Int_OriYear As Integer '期初录入年度
- '以下为固定使用变量(网格)
- Dim Cxnrrec As New ADODB.Recordset '显示查询内容动态集
- Dim Dyymctbl As New DY_Dyymsz '打印页面窗体变量
- Dim GridCode As String '显示网格网格代码
- Dim GridInf() As Variant '整个网格设置信息
- Dim ReportTitle As String '报表主标题
- Dim Tsxx As String '系统提示信息
- Dim Pmbcsjhs As Long '屏幕网格保持数据行数(大于等于1)
- Dim Fzxwghs As Integer '辅助项网格行数(包括合计行)
- Dim Sfxshjwg As Boolean '是否显示合计网格
- Dim Qslz As Long '网格隐藏(非操作显示)列数
- Dim Sjhgd As Double '网格数据行高度
- Dim GridBoolean() As Boolean '网格列信息(布尔型)
- Dim GridStr() As String '网格列信息(字符型)
- Dim GridInt() As Integer '网格列信息(整型)
- Dim Sfblbzkd As Boolean '是否保留帮助宽度(字段提供帮助时,是否为按钮保留空间)
- Dim Dqlrwgh As Long '当前录入数据网格行
- Dim Dqlrwgl As Long '当前录入数据网格列
- Dim Dqlkwgh As Long '刚刚离开网格行(不一定为录入行)
- Dim Dqlkwgl As Long '刚刚离开网格列
- Dim Dqtoprow As Long '当前录入状态时最上端可视行
- Dim Dqleftcol As Long '当前录入状态时最左端可视列
- Dim Zdlrqnr As String '字段录入修改前内容(用来判断内容是否修改)
- Dim Wbkbhlock As Boolean '文本框改变值锁
- Dim changelock As Boolean '网格行列改变控制锁(用来区别用户改变.程序改变)
- Dim Gdtlock As Boolean '滚动条滚动控制(用来区别用户改变.程序改变)
- Dim Yxxpdlock As Boolean '字段有效性判断锁(内容不修改不需进行字段有效性判断)
- Dim Hyxxpdlock As Boolean '行有效性判断锁(字段内容不修改不需进行行有效性判断)
- Dim Valilock As Boolean '文本框失去焦点是否进行有效性控制(TRUE 为锁定*限用网格录入)
- Dim Shsfts As Boolean '删除记录行是否提示
- Dim Szzls As Integer '网格信息数组最大下标值(网格列数-1)
- Private Sub Form_KeyPress(KeyAscii As Integer) '控制焦点转移和限制录入字符"'"
- Select Case KeyAscii
- Case 39 '屏蔽字符"'"
- KeyAscii = 0
- End Select
- End Sub
- Private Sub Form_Load() '窗 体 装 入
- '判断期初录入状态
- Call Sub_AllowQclr
- '初始化各种锁值
- changelock = False '网格行列改变控制锁
- Gdtlock = False '滚动条滚动控制
- Yxxpdlock = True '字段有效性判断锁
- Hyxxpdlock = True '行有效性判断锁
- Wbkbhlock = False '文本框内容改变锁
- '报表主标题及报表编码
- ReportTitle = "期初余额录入"
- XtReportCode = "Cwzz_qcyelr"
- Load Dyymctbl
- '调 入 网 格
- GridCode = "Cwzz_qcyelr" '网格属性编码
- Call BzWgcsh(WglrGrid, GridCode, GridInf(), GridBoolean(), GridInt(), GridStr())
- Qslz = GridInf(1)
- Sjhgd = GridInf(2)
- Pmbcsjhs = GridInf(3)
- Fzxwghs = GridInf(4)
- Sfblbzkd = GridInf(5)
- Shsfts = GridInf(6)
- Sfxshjwg = GridInf(7)
- Szzls = WglrGrid.Cols - 1
- '生成查询结果
- WglrGrid.Redraw = False
- Call Sub_Query
- WglrGrid.Redraw = True
- '读入科目编码方案
- Call Sub_CodeScheme("Cwzz_kmcode", Int_CodeLev, Int_CodeScheme())
- '调整标题位置
- SetTitlePos tsLabel(4)
- End Sub
- Private Sub Form_Unload(Cancel As Integer) '窗体卸载
- '调入其它窗体或功能产生的有效性判断(包括数据回写)
- If Not Fun_Drfrmyxxpd Then
- Cancel = True
- End If
- '卸载打印页面窗体
- Unload Dyymctbl
- End Sub
- Private Sub Sub_Query() '生成查询结果
- Dim Sqlstr As String '查询字符串
- Dim RecTemp As New ADODB.Recordset '临时使用动态集
- Dim Jsqte As Long '临时计数器
- Sqlstr = " SELECT Cwzz_AccCode.Ccode, Cwzz_AccCode.CodeLevel,Cwzz_AccCode.Cname,Cwzz_AccCode.BalanceOri,Cwzz_AccCode.EndFlag,Cwzz_AccCode.ForeignFlag,Cwzz_AccCode.QuantityFlag," & _
- " Cwzz_AccCode.PersonFlag,Cwzz_AccCode.CusFlag,Cwzz_AccCode.SupplierFlag,Cwzz_AccCode.DeptFlag,Cwzz_AccCode.ItemFlag," & _
- " Cwzz_AccCode.Measure,Gy_ForeignCurrency.ForeignCurrName,Cwzz_AccSum.Ycye, Cwzz_AccSum.Mjje," & _
- " Cwzz_AccSum.Qcye, Cwzz_AccSum.Mdje, Cwzz_AccSum.Byjfljje,Cwzz_AccSum.Bydfljje, Cwzz_AccSum.Qmye, Cwzz_AccSum.Ycsl," & _
- " Cwzz_AccSum.Qcsl, Cwzz_AccSum.Mjsl, Cwzz_AccSum.Mdsl,Cwzz_AccSum.Byjfljsl, Cwzz_AccSum.Bydfljsl, Cwzz_AccSum.Qmsl," & _
- " Cwzz_AccSum.Ycwb, Cwzz_AccSum.Mjwb, Cwzz_AccSum.Qcwb,Cwzz_AccSum.Mdwb, Cwzz_AccSum.Byjfljwb, Cwzz_AccSum.Bydfljwb," & _
- " Cwzz_AccSum.Qmwb" & _
- " FROM Cwzz_AccCode LEFT OUTER JOIN Cwzz_AccSum ON Cwzz_AccCode.Ccode = Cwzz_AccSum.Ccode And Cwzz_AccSum.Year = " & Int_OriYear & " And Cwzz_AccSum.Period = 1" & _
- " LEFT OUTER JOIN Gy_ForeignCurrency ON Cwzz_AccCode.ForeignCurrCode =Gy_ForeignCurrency.ForeignCurrCode" & _
- " Order By Cwzz_AccCode.Ccode"
- Set RecTemp = Cw_DataEnvi.DataConnect.Execute(Sqlstr)
- With RecTemp
- WglrGrid.Clear 1
- WglrGrid.Rows = .RecordCount + WglrGrid.FixedRows
- Jsqte = WglrGrid.FixedRows
- Do While Not .EOF
- If Jsqte >= WglrGrid.Rows Then
- WglrGrid.AddItem ""
- End If
- '[>>显示查询内容
- If .Fields("PersonFlag") Then '个人往来核算
- WglrGrid.TextMatrix(Jsqte, 3) = "1"
- WglrGrid.Cell(flexcpBackColor, Jsqte, 0, , WglrGrid.Cols - 1) = Lab_Color(1).BackColor
- Else
- WglrGrid.TextMatrix(Jsqte, 3) = "0"
- End If
- If .Fields("CusFlag") Then '客户往来核算
- WglrGrid.TextMatrix(Jsqte, 4) = "1"
- WglrGrid.Cell(flexcpBackColor, Jsqte, 0, , WglrGrid.Cols - 1) = Lab_Color(1).BackColor
- Else
- WglrGrid.TextMatrix(Jsqte, 4) = "0"
- End If
- If .Fields("SupplierFlag") Then '供应商往来核算
- WglrGrid.TextMatrix(Jsqte, 5) = "1"
- WglrGrid.Cell(flexcpBackColor, Jsqte, 0, , WglrGrid.Cols - 1) = Lab_Color(1).BackColor
- Else
- WglrGrid.TextMatrix(Jsqte, 5) = "0"
- End If
- If .Fields("DeptFlag") Then '客户往来核算
- WglrGrid.TextMatrix(Jsqte, 6) = "1"
- WglrGrid.Cell(flexcpBackColor, Jsqte, 0, , WglrGrid.Cols - 1) = Lab_Color(1).BackColor
- Else
- WglrGrid.TextMatrix(Jsqte, 6) = "0"
- End If
- If .Fields("ItemFlag") Then '项目核算
- WglrGrid.TextMatrix(Jsqte, 7) = "1"
- WglrGrid.Cell(flexcpBackColor, Jsqte, 0, , WglrGrid.Cols - 1) = Lab_Color(1).BackColor
- Else
- WglrGrid.TextMatrix(Jsqte, 7) = "0"
- End If
- If Not .Fields("EndFlag") Then '是否末级科目,非末级科目变色显示
- WglrGrid.TextMatrix(Jsqte, 0) = "0"
- WglrGrid.Cell(flexcpBackColor, Jsqte, 0, , WglrGrid.Cols - 1) = Lab_Color(0).BackColor
- Else
- WglrGrid.TextMatrix(Jsqte, 0) = "1"
- End If
- WglrGrid.TextMatrix(Jsqte, Sydz("001", GridStr(), Szzls)) = Trim(.Fields("Ccode") & "") '科目编码
- WglrGrid.TextMatrix(Jsqte, Sydz("002", GridStr(), Szzls)) = Space(2 * (.Fields("CodeLevel") - 1)) & Trim(.Fields("Cname") & "") '科目名称
- WglrGrid.TextMatrix(Jsqte, Sydz("005", GridStr(), Szzls)) = Trim(.Fields("BalanceOri") & "") '科目余额方向
- '1.金额
- If Val(.Fields("Ycye") & "") <> 0 Then '年初余额
- If WglrGrid.TextMatrix(Jsqte, Sydz("005", GridStr(), Szzls)) = "借" Then
- WglrGrid.TextMatrix(Jsqte, Sydz("006", GridStr(), Szzls)) = Val(.Fields("Ycye") & "")
- Else
- WglrGrid.TextMatrix(Jsqte, Sydz("006", GridStr(), Szzls)) = -Val(.Fields("Ycye") & "")
- End If
- End If
- If Val(.Fields("Byjfljje") & "") <> 0 Then
- WglrGrid.TextMatrix(Jsqte, Sydz("007", GridStr(), Szzls)) = Val(.Fields("Byjfljje") & "") '本年借方累计本币金额
- End If
- If Val(.Fields("Bydfljje") & "") <> 0 Then
- WglrGrid.TextMatrix(Jsqte, Sydz("008", GridStr(), Szzls)) = Val(.Fields("Bydfljje") & "") '本年贷方累计本币金额
- End If
- If Val(.Fields("Qmye") & "") <> 0 Then
- If WglrGrid.TextMatrix(Jsqte, Sydz("005", GridStr(), Szzls)) = "借" Then
- WglrGrid.TextMatrix(Jsqte, Sydz("009", GridStr(), Szzls)) = Val(.Fields("Qmye") & "")
- Else
- WglrGrid.TextMatrix(Jsqte, Sydz("009", GridStr(), Szzls)) = -Val(.Fields("Qmye") & "")
- End If
- End If
- '如果科目为末级科目且进行数量核算
- If .Fields("QuantityFlag") And .Fields("EndFlag") Then
- WglrGrid.TextMatrix(Jsqte, 1) = "1" '数量核算标识
- WglrGrid.TextMatrix(Jsqte, Sydz("004", GridStr(), Szzls)) = Trim(.Fields("Measure") & "") '计量单位
- WglrGrid.TextMatrix(Jsqte, Sydz("005", GridStr(), Szzls)) = Trim(.Fields("BalanceOri") & "") '科目余额方向
- If Val(.Fields("Ycsl") & "") <> 0 Then '年初数量
- If WglrGrid.TextMatrix(Jsqte, Sydz("005", GridStr(), Szzls)) = "借" Then
- WglrGrid.TextMatrix(Jsqte, Sydz("010", GridStr(), Szzls)) = Val(.Fields("Ycsl") & "")
- Else
- WglrGrid.TextMatrix(Jsqte, Sydz("010", GridStr(), Szzls)) = -Val(.Fields("Ycsl") & "")
- End If
- End If
- If Val(.Fields("Byjfljsl") & "") <> 0 Then
- WglrGrid.TextMatrix(Jsqte, Sydz("011", GridStr(), Szzls)) = Val(.Fields("Byjfljsl") & "") '本年借方累计原币金额
- End If
- If Val(.Fields("Bydfljsl") & "") <> 0 Then
- WglrGrid.TextMatrix(Jsqte, Sydz("012", GridStr(), Szzls)) = Val(.Fields("Bydfljsl") & "") '本年贷方累计原币金额
- End If
- If Val(.Fields("Qmsl") & "") <> 0 Then '期末数量
- If WglrGrid.TextMatrix(Jsqte, Sydz("005", GridStr(), Szzls)) = "借" Then
- WglrGrid.TextMatrix(Jsqte, Sydz("013", GridStr(), Szzls)) = Val(.Fields("Qmsl") & "")
- Else
- WglrGrid.TextMatrix(Jsqte, Sydz("013", GridStr(), Szzls)) = -Val(.Fields("Qmsl") & "")
- End If
- End If
- Else
- WglrGrid.TextMatrix(Jsqte, 1) = "0"
- End If
- If .Fields("ForeignFlag") And .Fields("EndFlag") Then
- WglrGrid.TextMatrix(Jsqte, 2) = "1" '外币核算标识
- WglrGrid.TextMatrix(Jsqte, Sydz("003", GridStr(), Szzls)) = Trim(.Fields("ForeignCurrName") & "") '外币名称
- WglrGrid.TextMatrix(Jsqte, Sydz("005", GridStr(), Szzls)) = Trim(.Fields("BalanceOri") & "") '科目余额方向
- If Val(.Fields("Ycwb") & "") <> 0 Then '年初外币
- If WglrGrid.TextMatrix(Jsqte, Sydz("005", GridStr(), Szzls)) = "借" Then
- WglrGrid.TextMatrix(Jsqte, Sydz("014", GridStr(), Szzls)) = Val(.Fields("Ycwb") & "")
- Else
- WglrGrid.TextMatrix(Jsqte, Sydz("014", GridStr(), Szzls)) = -Val(.Fields("Ycwb") & "")
- End If
- End If
- If Val(.Fields("Byjfljwb") & "") <> 0 Then
- WglrGrid.TextMatrix(Jsqte, Sydz("015", GridStr(), Szzls)) = Val(.Fields("Byjfljwb") & "") '本年借方累计原币金额
- End If
- If Val(.Fields("Bydfljwb") & "") <> 0 Then
- WglrGrid.TextMatrix(Jsqte, Sydz("016", GridStr(), Szzls)) = Val(.Fields("Bydfljwb") & "") '本年贷方累计原币金额
- End If
- If Val(.Fields("Qmwb") & "") <> 0 Then '期初外币
- If WglrGrid.TextMatrix(Jsqte, Sydz("005", GridStr(), Szzls)) = "借" Then
- WglrGrid.TextMatrix(Jsqte, Sydz("017", GridStr(), Szzls)) = Val(.Fields("Qmwb") & "")
- Else
- WglrGrid.TextMatrix(Jsqte, Sydz("017", GridStr(), Szzls)) = -Val(.Fields("Qmwb") & "")
- End If
- End If
- Else
- WglrGrid.TextMatrix(Jsqte, 2) = "0"
- End If
- '<<]
- WglrGrid.RowHeight(Jsqte) = Sjhgd
- .MoveNext
- Jsqte = Jsqte + 1
- Loop
- End With
- End Sub
- Private Sub Tlb_Action_ButtonClick(ByVal Button As MSComctlLib.Button) '用户点击工具条
- '屏蔽文本框,下拉组合框有效性判断
- Valilock = True
- '屏蔽网格失去焦点产生的有效性判断
- changelock = True
- Select Case Button.Key
- Case "ymsz" '页面设置
- Dyymctbl.Show 1
- Case "yl" '预 览
- If Fun_Drfrmyxxpd Then
- Call bbyl(True)
- End If
- Case "dy" '打 印
- If Fun_Drfrmyxxpd Then
- Call bbyl(False)
- End If
- Case "ph" '试算平衡
- If Fun_Drfrmyxxpd Then
- Xtcdcs = Str(Int_OriYear)
- JC_FrmQcyessph.HelpContextID = Me.HelpContextID
- JC_FrmQcyessph.Show 1
- End If
- Case "dz" '对帐
- If Fun_Drfrmyxxpd Then
- Xtcdcs = Str(Int_OriYear) '对帐年度
- Xtcdcsfz = "1" '对帐会计期间
- JC_FrmQcyeDz.HelpContextID = Me.HelpContextID
- JC_FrmQcyeDz.Show 1
- End If
- Case "dw" '定位
- If Fun_Drfrmyxxpd Then
- JC_FrmKmdw.Show 1
- If Xtfhcs <> "" Then
- With WglrGrid
- For Jsqte = .FixedRows To .Rows - 1
- If Mid(.TextMatrix(Jsqte, Sydz("001", GridStr(), Szzls)), 1, Len(Xtfhcs)) = Xtfhcs Then
- .Select Jsqte, Sydz("001", GridStr(), Szzls)
- .TopRow = Jsqte
- Exit For
- End If
- Next Jsqte
- End With
- End If
- End If
- Case "fz" '辅助核算期初录入
- If Fun_Drfrmyxxpd Then
- With WglrGrid
- If .TextMatrix(.Row, 3) = "1" Or .TextMatrix(.Row, 4) = "1" Or .TextMatrix(.Row, 5) = "1" Or .TextMatrix(.Row, 6) = "1" Or .TextMatrix(.Row, 7) = "1" Then '辅助核算
- Xtcdcs = .TextMatrix(.Row, Sydz("001", GridStr(), Szzls))
- JC_FrmQcAss0.HelpContextID = Me.HelpContextID
- JC_FrmQcAss0.Show 1
- End If
- End With
- End If
- Case "bz" '帮 助
- Call F1bz
- Case "fh" '退 出
- Unload Me
- End Select
- '解 锁
- Valilock = False
- changelock = False
- End Sub
- Private Sub Form_KeyUp(KeyCode As Integer, Shift As Integer) '支持热键操作
- If Shift = 2 Then
- Select Case UCase(Chr(KeyCode))
- Case "P" 'Ctrl+P 打印
- If Tlb_Action.Buttons("dy").Enabled Then
- Call bbyl(False)
- End If
- End Select
- End If
- End Sub
- Private Sub Wbkcl() '文本框录入之前处理(根据实际情况)
- Dim xswbrr As String
- With WglrGrid
- Zdlrqnr = Trim(.Text)
- xswbrr = Trim(.Text)
- If GridBoolean(.Col, 3) Then '列表框录入
- '填充列表框程序
- Call FillCombo(YdCombo, GridStr(.Col, 5), xswbrr, 0)
- Else
- Wbkbhlock = True
- '====以下为用户自定义
- Ydtext.Text = xswbrr
- '====以上为用户自定义
- Wbkbhlock = False
- Ydtext.SelStart = Len(Ydtext.Text)
- End If
- End With
- End Sub
- Private Function sjzdyxxpd(Dqpdwgh As Long, Dqpdwgl As Long) '录入数据字段有效性判断,同时进行字段录入事后处理
- Dim Str_JudgeText As String '临时有效性判断字段内容
- Dim Coljsq As Long '临时列计数器
- Dim RecTemp As New ADODB.Recordset '临时使用动态集
- Dim Dbl_Qcye As Double '临时期初余额
- With WglrGrid
- '非录入状态有效性为合法
- If Yxxpdlock Or .Row < .FixedRows Then
- sjzdyxxpd = True
- Exit Function
- End If
- Str_JudgeText = Trim(.TextMatrix(Dqpdwgh, Dqpdwgl))
- Select Case GridStr(Dqpdwgl, 1)
- '以下为自定义部分[
- '1.放置字段有效性判断程序
- Case "006", "007", "008" '年初余额,累计借方,累计贷方(本币金额)
- If .TextMatrix(Dqpdwgh, Sydz("005", GridStr(), Szzls)) = "借" Then
- Dbl_Qcye = Val(.TextMatrix(Dqpdwgh, Sydz("006", GridStr(), Szzls))) + Val(.TextMatrix(Dqpdwgh, Sydz("007", GridStr(), Szzls))) - Val(.TextMatrix(Dqpdwgh, Sydz("008", GridStr(), Szzls)))
- Else
- Dbl_Qcye = Val(.TextMatrix(Dqpdwgh, Sydz("006", GridStr(), Szzls))) - Val(.TextMatrix(Dqpdwgh, Sydz("007", GridStr(), Szzls))) + Val(.TextMatrix(Dqpdwgh, Sydz("008", GridStr(), Szzls)))
- End If
- If Dbl_Qcye = 0 Then
- .TextMatrix(Dqpdwgh, Sydz("009", GridStr(), Szzls)) = ""
- Else
- .TextMatrix(Dqpdwgh, Sydz("009", GridStr(), Szzls)) = Dbl_Qcye
- End If
- Case "010", "011", "012" '年初余额,累计借方,累计贷方(数量)
- If .TextMatrix(Dqpdwgh, Sydz("005", GridStr(), Szzls)) = "借" Then
- Dbl_Qcye = Val(.TextMatrix(Dqpdwgh, Sydz("010", GridStr(), Szzls))) + Val(.TextMatrix(Dqpdwgh, Sydz("011", GridStr(), Szzls))) - Val(.TextMatrix(Dqpdwgh, Sydz("012", GridStr(), Szzls)))
- Else
- Dbl_Qcye = Val(.TextMatrix(Dqpdwgh, Sydz("010", GridStr(), Szzls))) - Val(.TextMatrix(Dqpdwgh, Sydz("011", GridStr(), Szzls))) + Val(.TextMatrix(Dqpdwgh, Sydz("012", GridStr(), Szzls)))
- End If
- If Dbl_Qcye = 0 Then
- .TextMatrix(Dqpdwgh, Sydz("013", GridStr(), Szzls)) = ""
- Else
- .TextMatrix(Dqpdwgh, Sydz("013", GridStr(), Szzls)) = Dbl_Qcye
- End If
- Case "014", "015", "016" '年初余额,累计借方,累计贷方(外币金额)
- If .TextMatrix(Dqpdwgh, Sydz("005", GridStr(), Szzls)) = "借" Then
- Dbl_Qcye = Val(.TextMatrix(Dqpdwgh, Sydz("014", GridStr(), Szzls))) + Val(.TextMatrix(Dqpdwgh, Sydz("015", GridStr(), Szzls))) - Val(.TextMatrix(Dqpdwgh, Sydz("016", GridStr(), Szzls)))
- Else
- Dbl_Qcye = Val(.TextMatrix(Dqpdwgh, Sydz("014", GridStr(), Szzls))) - Val(.TextMatrix(Dqpdwgh, Sydz("015", GridStr(), Szzls))) + Val(.TextMatrix(Dqpdwgh, Sydz("016", GridStr(), Szzls)))
- End If
- If Dbl_Qcye = 0 Then
- .TextMatrix(Dqpdwgh, Sydz("017", GridStr(), Szzls)) = ""
- Else
- .TextMatrix(Dqpdwgh, Sydz("017", GridStr(), Szzls)) = Dbl_Qcye
- End If
- '2.放置字段事后处理程序
- '以上为自定义部分]
- End Select
- '字段录入正确后为零字段清空
- Call Qkwlzd(Dqpdwgh, Dqpdwgl)
- sjzdyxxpd = True
- Yxxpdlock = True
- Exit Function
- End With
- Lrcwcl: '录入错误处理
- With WglrGrid
- Call Xtxxts(Tsxx, 0, 1)
- changelock = True
- .Select Dqpdwgh, Dqpdwgl
- changelock = False
- Call xswbk
- sjzdyxxpd = False
- Exit Function
- End With
- End Function
- Private Function Sjhzyxxpd(ByVal Yxxpdh As Long) As Boolean '录入数据行有效性判断,同时进行行处理
- Dim Lrywlz As Long '录入错误列值
- Dim RecTemp As New ADODB.Recordset '临时使用动态集
- Dim Sqlstr As String '临时查询字符串
- Dim Dbl_Ori(1 To 12) As Double '科目记录原数据
- Dim Dbl_Now(1 To 12) As Double '科目记录现数据
- Dim Str_Ccode As String '操作科目
- Dim Rec_AccSum As New ADODB.Recordset '科目总帐动态集
- Dim Bln_Foreign As Boolean '外币核算
- Dim Lng_GridRow As Long '定位科目所在网格行
- With WglrGrid
- '行没有发生变化则不进行有效性判断
- If Hyxxpdlock Then
- Sjhzyxxpd = True
- Exit Function
- End If
- '以下为自定义部分[
- '1.放置行有效性判断程序
- '首先进行为空判断(固定不变)
- For Jsqte = Qslz To .Cols - 1
- '字段不能为空
- If GridInt(Jsqte, 5) = 1 Then
- If Len(Trim(.TextMatrix(Yxxpdh, Jsqte))) = 0 Then
- Tsxx = GridStr(Jsqte, 2)
- Lrywlz = Jsqte
- GoTo Lrcwcl
- Exit For
- End If
- End If
- '字段不能为零
- If GridInt(Jsqte, 5) = 2 Then
- If Val(Trim(.TextMatrix(Yxxpdh, Jsqte))) = 0 Then
- Tsxx = GridStr(Jsqte, 2)
- Lrywlz = Jsqte
- GoTo Lrcwcl
- Exit For
- End If
- End If
- Next Jsqte
- '2.放置行处理程序
- '[>>当用户录入数据完毕后自动进行本科目及上级科目数据回写
- Str_Ccode = Trim(WglrGrid.TextMatrix(Yxxpdh, Sydz("001", GridStr(), Szzls)))
- If WglrGrid.TextMatrix(Yxxpdh, 2) = "1" Then
- Bln_Foreign = True
- Else
- Bln_Foreign = False
- End If
- Sqlstr = "SELECT * FROM Cwzz_AccSum Where Ccode='" & Str_Ccode & "' And Year=" & Int_OriYear & " And Period=1"
- Set RecTemp = Cw_DataEnvi.DataConnect.Execute(Sqlstr)
- If Not RecTemp.EOF Then
- Dbl_Ori(1) = RecTemp.Fields("Ycye") '年初余额
- Dbl_Ori(2) = RecTemp.Fields("Byjfljje") '本年借方累计金额
- Dbl_Ori(3) = RecTemp.Fields("Bydfljje") '本年贷方累计金额
- Dbl_Ori(4) = RecTemp.Fields("Qmye") '期末余额
- Dbl_Ori(5) = RecTemp.Fields("Ycsl") '年初数量
- Dbl_Ori(6) = RecTemp.Fields("Byjfljsl") '本年借方累计数量
- Dbl_Ori(7) = RecTemp.Fields("Bydfljsl") '本年贷方累计金额
- Dbl_Ori(8) = RecTemp.Fields("Qmsl") '期末数量
- Dbl_Ori(9) = RecTemp.Fields("Ycwb") '年初外币
- Dbl_Ori(10) = RecTemp.Fields("Byjfljwb") '本年借方累计外币
- Dbl_Ori(11) = RecTemp.Fields("Bydfljwb") '本年贷方累计外币
- Dbl_Ori(12) = RecTemp.Fields("Qmwb") '期末外币
- End If
- If WglrGrid.TextMatrix(Yxxpdh, Sydz("005", GridStr(), Szzls)) = "借" Then
- Dbl_Now(1) = Val(.TextMatrix(Yxxpdh, Sydz("006", GridStr(), Szzls))) '年初余额
- Dbl_Now(2) = Val(.TextMatrix(Yxxpdh, Sydz("007", GridStr(), Szzls))) '本年借方累计金额
- Dbl_Now(3) = Val(.TextMatrix(Yxxpdh, Sydz("008", GridStr(), Szzls))) '本年贷方累计金额
- Dbl_Now(4) = Val(.TextMatrix(Yxxpdh, Sydz("009", GridStr(), Szzls))) '期末余额
- Dbl_Now(5) = Val(.TextMatrix(Yxxpdh, Sydz("010", GridStr(), Szzls))) '年初数量
- Dbl_Now(6) = Val(.TextMatrix(Yxxpdh, Sydz("011", GridStr(), Szzls))) '本年借方累计数量
- Dbl_Now(7) = Val(.TextMatrix(Yxxpdh, Sydz("012", GridStr(), Szzls))) '本年贷方累计金额
- Dbl_Now(8) = Val(.TextMatrix(Yxxpdh, Sydz("013", GridStr(), Szzls))) '期末数量
- Dbl_Now(9) = Val(.TextMatrix(Yxxpdh, Sydz("014", GridStr(), Szzls))) '年初外币
- Dbl_Now(10) = Val(.TextMatrix(Yxxpdh, Sydz("015", GridStr(), Szzls))) '本年借方累计外币
- Dbl_Now(11) = Val(.TextMatrix(Yxxpdh, Sydz("016", GridStr(), Szzls))) '本年贷方累计外币
- Dbl_Now(12) = Val(.TextMatrix(Yxxpdh, Sydz("017", GridStr(), Szzls))) '期末余额
- Else
- Dbl_Now(1) = -Val(.TextMatrix(Yxxpdh, Sydz("006", GridStr(), Szzls))) '年初余额
- Dbl_Now(2) = Val(.TextMatrix(Yxxpdh, Sydz("007", GridStr(), Szzls))) '本年借方累计金额
- Dbl_Now(3) = Val(.TextMatrix(Yxxpdh, Sydz("008", GridStr(), Szzls))) '本年贷方累计金额
- Dbl_Now(4) = -Val(.TextMatrix(Yxxpdh, Sydz("009", GridStr(), Szzls))) '期末余额
- Dbl_Now(5) = -Val(.TextMatrix(Yxxpdh, Sydz("010", GridStr(), Szzls))) '年初数量
- Dbl_Now(6) = Val(.TextMatrix(Yxxpdh, Sydz("011", GridStr(), Szzls))) '本年借方累计数量
- Dbl_Now(7) = Val(.TextMatrix(Yxxpdh, Sydz("012", GridStr(), Szzls))) '本年贷方累计金额
- Dbl_Now(8) = -Val(.TextMatrix(Yxxpdh, Sydz("013", GridStr(), Szzls))) '期末数量
- Dbl_Now(9) = -Val(.TextMatrix(Yxxpdh, Sydz("014", GridStr(), Szzls))) '年初外币
- Dbl_Now(10) = Val(.TextMatrix(Yxxpdh, Sydz("015", GridStr(), Szzls))) '本年借方累计外币
- Dbl_Now(11) = Val(.TextMatrix(Yxxpdh, Sydz("016", GridStr(), Szzls))) '本年贷方累计外币
- Dbl_Now(12) = -Val(.TextMatrix(Yxxpdh, Sydz("017", GridStr(), Szzls))) '期末余额
- End If
- End With
- On Error GoTo Swcwcl
- Cw_DataEnvi.DataConnect.BeginTrans
- '1.登记总帐(注意需要对其上级科目记帐)
- Int_LevTe = 1
- Do While True
- Str_Parent = Trim(Mid(Str_Ccode, 1, Int_CodeScheme(Int_LevTe)))
- With Rec_AccSum
- If .State = 1 Then .Close
- .Open "SELECT Cwzz_AccSum.* From Cwzz_AccSum WHERE Ccode='" & Str_Parent & "' And Year =" & Int_OriYear & " AND Period = 1", Cw_DataEnvi.DataConnect, adOpenDynamic, adLockOptimistic
- '判断记帐科目是否存在,如存在则替换原有数据,否则插入新记录
- If Not Rec_AccSum.EOF Then
- '判断是否为末级科目,如是则替换原有数据,否则先减去原有数据再增加现录数据
- If Str_Parent = Str_Ccode Then
- .Fields("Ycye") = Dbl_Now(1) '年初余额
- .Fields("Qcye") = Dbl_Now(1) '期初余额
- .Fields("Mjje") = Dbl_Now(2) '本月借方金额合计
- .Fields("Mdje") = Dbl_Now(3) '本月贷方金额合计
- .Fields("Byjfljje") = Dbl_Now(2) '本月借方金额合计
- .Fields("Bydfljje") = Dbl_Now(3) '本月贷方金额合计
- .Fields("Qmye") = Dbl_Now(4) '期末余额
- .Fields("Ycsl") = Dbl_Now(5) '年初数量
- .Fields("Qcsl") = Dbl_Now(5) '期初数量
- .Fields("Mjsl") = Dbl_Now(6) '本月借方数量合计
- .Fields("Mdsl") = Dbl_Now(7) '本月贷方数量合计
- .Fields("Byjfljsl") = Dbl_Now(6) '本月借方数量合计
- .Fields("Bydfljsl") = Dbl_Now(7) '本月贷方数量合计
- .Fields("Qmsl") = Dbl_Now(8) '期末数量
- '如为外币核算则用外币录入金额替换,否则填入本位币金额
- If Bln_Foreign Then
- .Fields("Ycwb") = Dbl_Now(9) '年初原币
- .Fields("Qcwb") = Dbl_Now(9) '期初原币
- .Fields("Mjwb") = Dbl_Now(10) '本月借方原币合计
- .Fields("Mdwb") = Dbl_Now(11) '本月贷方原币合计
- .Fields("Byjfljwb") = Dbl_Now(10) '本月借方原币合计
- .Fields("Bydfljwb") = Dbl_Now(11) '本月贷方原币合计
- .Fields("Qmwb") = Dbl_Now(12) '期末原币
- Else
- .Fields("Ycwb") = Dbl_Now(1) '年初原币
- .Fields("Qcwb") = Dbl_Now(1) '期初原币
- .Fields("Mjwb") = Dbl_Now(2) '本月借方原币合计
- .Fields("Mdwb") = Dbl_Now(3) '本月贷方原币合计
- .Fields("Byjfljwb") = Dbl_Now(2) '本月借方原币合计
- .Fields("Bydfljwb") = Dbl_Now(3) '本月贷方原币合计
- .Fields("Qmwb") = Dbl_Now(4) '期末原币
- End If
- Else
- .Fields("Ycye") = .Fields("Ycye") + Dbl_Now(1) - Dbl_Ori(1) '年初余额
- .Fields("Qcye") = .Fields("Ycye") '期初余额
- .Fields("Byjfljje") = .Fields("Byjfljje") + Dbl_Now(2) - Dbl_Ori(2) '本年借方金额累计
- .Fields("Bydfljje") = .Fields("Bydfljje") + Dbl_Now(3) - Dbl_Ori(3) '本年贷方金额累计
- .Fields("Mjje") = .Fields("Byjfljje") '本月借方金额合计
- .Fields("Mdje") = .Fields("Bydfljje") '本月贷方金额合计
- .Fields("Qmye") = .Fields("Qmye") + Dbl_Now(4) - Dbl_Ori(4) '期末余额
- End If
- .Update
- '更新其他各会计期间数据
- Sqlstr = "Update Cwzz_AccSum Set Ycye=" & .Fields("Ycye") & ",Qcye=" & .Fields("Qmye") & ",Byjfljje=" & .Fields("Byjfljje") & ",Bydfljje=" & .Fields("Bydfljje") & ",Qmye=" & .Fields("Qmye") & _
- ",Ycsl=" & .Fields("Ycsl") & ",Qcsl=" & .Fields("Qmsl") + 0 & ",Byjfljsl=" & .Fields("Byjfljsl") + 0 & ",Bydfljsl=" & .Fields("Bydfljsl") + 0 & ",Qmsl=" & .Fields("Qmsl") + 0 & _
- ",Ycwb=" & .Fields("Ycwb") & ",Qcwb=" & .Fields("Qmwb") + 0 & ",Byjfljwb=" & .Fields("Byjfljwb") + 0 & ",Bydfljwb=" & .Fields("Bydfljwb") + 0 & ",Qmwb=" & .Fields("Qmwb") + 0 & _
- " Where Ccode='" & Str_Parent & "' And Year=" & Int_OriYear & " And Period >1"
- Cw_DataEnvi.DataConnect.Execute (Sqlstr)
- Else
- .AddNew
- .Fields("Ccode") = Str_Parent '科目编码
- .Fields("Year") = Int_OriYear '会计年度
- .Fields("Period") = 1 '会计期间
- .Fields("Ycye") = Dbl_Now(1) '年初余额
- .Fields("Qcye") = Dbl_Now(1) '期初余额
- .Fields("Mjje") = Dbl_Now(2) '本月借方金额合计
- .Fields("Mdje") = Dbl_Now(3) '本月贷方金额合计
- .Fields("Byjfljje") = Dbl_Now(2) '本月借方金额合计
- .Fields("Bydfljje") = Dbl_Now(3) '本月贷方金额合计
- .Fields("Qmye") = Dbl_Now(4) '期末余额
- If Str_Parent = Str_Ccode Then
- .Fields("Ycsl") = Dbl_Now(5) '年初数量
- .Fields("Qcsl") = Dbl_Now(5) '期初数量
- .Fields("Mjsl") = Dbl_Now(6) '本月借方数量合计
- .Fields("Mdsl") = Dbl_Now(7) '本月贷方数量合计
- .Fields("Byjfljsl") = Dbl_Now(6) '本月借方数量合计
- .Fields("Bydfljsl") = Dbl_Now(7) '本月贷方数量合计
- .Fields("Qmsl") = Dbl_Now(8) '期末数量
- If Bln_Foreign Then
- .Fields("Ycwb") = Dbl_Now(9) '年初原币
- .Fields("Qcwb") = Dbl_Now(9) '期初原币
- .Fields("Mjwb") = Dbl_Now(10) '本月借方原币合计
- .Fields("Mdwb") = Dbl_Now(11) '本月贷方原币合计
- .Fields("Byjfljwb") = Dbl_Now(10) '本月借方原币合计
- .Fields("Bydfljwb") = Dbl_Now(11) '本月贷方原币合计
- .Fields("Qmwb") = Dbl_Now(12) '期末原币
- Else
- .Fields("Ycwb") = Dbl_Now(1) '年初原币
- .Fields("Qcwb") = Dbl_Now(1) '期初原币
- .Fields("Mjwb") = Dbl_Now(2) '本月借方原币合计
- .Fields("Mdwb") = Dbl_Now(3) '本月贷方原币合计
- .Fields("Byjfljwb") = Dbl_Now(2) '本月借方原币合计
- .Fields("Bydfljwb") = Dbl_Now(3) '本月贷方原币合计
- .Fields("Qmwb") = Dbl_Now(4) '期末原币
- End If
- End If
- .Update
- '添加并更新其他会计期间数据(按12个会计期间)
- For Int_PeriodTe = 1 To 12
- If Int_PeriodTe <> 1 Then
- Sqlstr = "Insert Into Cwzz_AccSum (Ccode,Year,Period) values ('" & Str_Parent & "'," & Int_OriYear & "," & Int_PeriodTe & ")"
- Cw_DataEnvi.DataConnect.Execute (Sqlstr)
- End If
- Next Int_PeriodTe
- Sqlstr = "Update Cwzz_AccSum Set Ycye=" & .Fields("Ycye") & ",Qcye=" & .Fields("Qmye") & ",Byjfljje=" & .Fields("Byjfljje") & ",Bydfljje=" & .Fields("Bydfljje") & ",Qmye=" & .Fields("Qmye") & _
- ",Ycsl=" & .Fields("Ycsl") & ",Qcsl=" & .Fields("Qmsl") + 0 & ",Byjfljsl=" & .Fields("Byjfljsl") + 0 & ",Bydfljsl=" & .Fields("Bydfljsl") + 0 & ",Qmsl=" & .Fields("Qmsl") + 0 & _
- ",Ycwb=" & .Fields("Ycwb") & ",Qcwb=" & .Fields("Qmwb") + 0 & ",Byjfljwb=" & .Fields("Byjfljwb") + 0 & ",Bydfljwb=" & .Fields("Bydfljwb") + 0 & ",Qmwb=" & .Fields("Qmwb") + 0 & _
- " Where Ccode='" & Str_Parent & "' And Year=" & Int_OriYear & " And Period >1"
- Cw_DataEnvi.DataConnect.Execute (Sqlstr)
- End If
- End With
- If Str_Parent = Str_Ccode Then
- Exit Do
- End If
- Int_LevTe = Int_LevTe + 1
- Loop
- Cw_DataEnvi.DataConnect.CommitTrans
- '刷新相应网格数据
- Int_LevTe = 1
- Do While True
- Str_Parent = Trim(Mid(Str_Ccode, 1, Int_CodeScheme(Int_LevTe)))
- If Str_Parent = Str_Ccode Then
- Exit Do
- End If
- With RecTemp
- Sqlstr = "SELECT Cwzz_AccSum.* From Cwzz_AccSum WHERE Ccode='" & Str_Parent & "' And Year =" & Int_OriYear & " AND Period = 1"
- Set RecTemp = Cw_DataEnvi.DataConnect.Execute(Sqlstr)
- If Not RecTemp.EOF Then
- Lng_GridRow = WglrGrid.FindRow(Str_Parent, , Sydz("001", GridStr(), Szzls))
- If Lng_GridRow <> -1 Then
- If RecTemp.Fields("Ycye") <> 0 Then '年初余额
- If WglrGrid.TextMatrix(Lng_GridRow, Sydz("005", GridStr(), Szzls)) = "借" Then
- WglrGrid.TextMatrix(Lng_GridRow, Sydz("006", GridStr(), Szzls)) = RecTemp.Fields("Ycye")
- Else
- WglrGrid.TextMatrix(Lng_GridRow, Sydz("006", GridStr(), Szzls)) = -RecTemp.Fields("Ycye")
- End If
- Else
- WglrGrid.TextMatrix(Lng_GridRow, Sydz("006", GridStr(), Szzls)) = ""
- End If
- If RecTemp.Fields("Byjfljje") <> 0 Then
- WglrGrid.TextMatrix(Lng_GridRow, Sydz("007", GridStr(), Szzls)) = RecTemp.Fields("Byjfljje") '本年借方累计本币金额
- Else
- WglrGrid.TextMatrix(Lng_GridRow, Sydz("007", GridStr(), Szzls)) = ""
- End If
- If RecTemp.Fields("Bydfljje") <> 0 Then
- WglrGrid.TextMatrix(Lng_GridRow, Sydz("008", GridStr(), Szzls)) = RecTemp.Fields("Bydfljje") '本年贷方累计本币金额
- Else
- WglrGrid.TextMatrix(Lng_GridRow, Sydz("008", GridStr(), Szzls)) = ""
- End If
- If RecTemp.Fields("Qmye") <> 0 Then
- If WglrGrid.TextMatrix(Lng_GridRow, Sydz("005", GridStr(), Szzls)) = "借" Then
- WglrGrid.TextMatrix(Lng_GridRow, Sydz("009", GridStr(), Szzls)) = RecTemp.Fields("Qmye")
- Else
- WglrGrid.TextMatrix(Lng_GridRow, Sydz("009", GridStr(), Szzls)) = -RecTemp.Fields("Qmye")
- End If
- Else
- WglrGrid.TextMatrix(Lng_GridRow, Sydz("009", GridStr(), Szzls)) = ""
- End If
- End If
- End If
- End With
- Int_LevTe = Int_LevTe + 1
- Loop
- '<<]
- '以上为自定义部分]
- Sjhzyxxpd = True
- Hyxxpdlock = True
- Exit Function
- Swcwcl:
- Cw_DataEnvi.DataConnect.RollbackTrans
- Tsxx = "存盘过程中出现未知错误,程序自动恢复保存前状态!"
- Call Xtxxts(Tsxx, 0, 1)
- Exit Function
- Lrcwcl: '录入错误处理
- With WglrGrid
- Call Xtxxts(Tsxx, 0, 1)
- changelock = True
- .Select Yxxpdh, Lrywlz
- changelock = False
- Call xswbk
- Sjhzyxxpd = False
- Exit Function
- End With
- End Function
- '=====================自定义过程区域====================='
- Private Sub Cmd_Qclrwc_Click() '期初录入完成
- JC_FrmQclrwc.Show 1
- Call Sub_AllowQclr
- End Sub
- Private Sub Sub_AllowQclr() '判断是否允许期初录入调整
- Int_OriYear = Xtyear
- Lab_OperStatus = "2"
- '判断用户选择会计年度是否已经结帐
- Sqlstr = "SELECT Top 1 Kjyear FROM Gy_kjrlb Where Cwzzjzbz=0 Order By Kjyear,Period"
- Set RecTemp = Cw_DataEnvi.DataConnect.Execute(Sqlstr)
- If Not RecTemp.EOF Then
- If Xtyear <> RecTemp.Fields("Kjyear") Then
- Lab_OperStatus = "1"
- End If
- Else
- Lab_OperStatus = "1"
- End If
- '判断用户是否已执行期初录入完成动作
- Sqlstr = "SELECT ItemValue FROM Gy_AccInformation Where ItemCode='Cwzz_Qclrwc'"
- Set RecTemp = Cw_DataEnvi.DataConnect.Execute(Sqlstr)
- If Not RecTemp.EOF Then
- If Trim(RecTemp.Fields("ItemValue")) = "1" Then
- Lab_OperStatus = "1"
- End If
- End If
- '设置期初录入状态
- If Lab_OperStatus = "1" Then
- Lab_Lrztxs.Visible = True
- Cmd_Qclrwc.Enabled = False
- Tlb_Action.Buttons.Item("ph").Enabled = False
- Tlb_Action.Buttons.Item("dz").Enabled = False
- Else
- Lab_Lrztxs.Visible = False
- Cmd_Qclrwc.Enabled = True
- Tlb_Action.Buttons.Item("ph").Enabled = True
- Tlb_Action.Buttons.Item("dz").Enabled = True
- End If
- End Sub
- '=====================自定义过程区域====================='
- '===================以 下 程 序 为 通 用 部 分 ,一 般 不 需 更 改======================='
- Private Sub Lrzdbz() '录入字段帮助
- If Not Ydcommand.Visible Then
- Exit Sub
- End If
- Valilock = True
- With WglrGrid
- changelock = True '调入另外窗体必须加锁
- Call Drbmhelp(GridInt(.Col, 6), GridStr(.Col, 3), Trim(Ydtext.Text))
- changelock = False
- If Len(Xtfhcs) <> 0 Then
- If GridInt(.Col, 7) = 0 Then
- Ydtext.Text = Xtfhcs
- Else
- Ydtext.Text = Xtfhcsfz
- End If
- End If
- Valilock = False
- If Ydtext.Visible Then
- Ydtext.SetFocus
- End If
- End With
- End Sub
- Private Sub Form_Resize() '窗体大小发生变化时,重新显示文本框
- Call Cxxswbk
- End Sub
- Private Function Fun_Drfrmyxxpd() As Boolean '调入其它窗体或功能产生的有效性判断(包括数据回写)
- Fun_Drfrmyxxpd = True
- With WglrGrid
- '如果当前网格处于编辑状态,则先进行数据回写再进行有效性判断
- If Ydtext.Visible Or YdCombo.Visible Then
- Call Lrsjhx
- If Not sjzdyxxpd(Dqlrwgh, Dqlrwgl) Then
- Fun_Drfrmyxxpd = False
- Exit Function
- End If
- End If
- '进行行有效性判断
- If Not Sjhzyxxpd(.Row) Then
- Fun_Drfrmyxxpd = False
- Exit Function
- End If
- End With
- End Function
- Private Sub WglrGrid_GotFocus() '网格得到焦点
- '网格得到焦点,如果当前选择行为非数据行
- '则调整当前焦点至有效数据行
- With WglrGrid
- If .Row < .FixedRows And .Rows > .FixedRows Then
- changelock = True
- .Select .FixedRows, .Col
- changelock = False
- End If
- If .Col < Qslz Then
- changelock = True
- .Select .Row, Qslz
- changelock = False
- End If
- End With
- End Sub
- Private Sub WglrGrid_LostFocus() '录入网格失去焦点
- '用以屏蔽调用其它窗体时发生网格失去焦点事件
- If changelock Then
- Exit Sub
- End If
- '引发网格RowcolChange事件
- With WglrGrid
- If Not (Ydtext.Visible Or YdCombo.Visible) Then
- .Select 0, 0
- End If
- End With
- End Sub
- Private Sub WglrGrid_AfterScroll(ByVal OldTopRow As Long, ByVal OldLeftCol As Long, ByVal NewTopRow As Long, ByVal NewLeftCol As Long) '限制用户在录入过程中滚动鼠标
- If Gdtlock Then
- Exit Sub
- End If
- With WglrGrid
- If Ydtext.Visible Or YdCombo.Visible Then
- Gdtlock = True
- .TopRow = Dqtoprow
- .LeftCol = Dqleftcol
- Gdtlock = False
- Exit Sub
- End If
- End With
- End Sub
- Private Sub WglrGrid_LeaveCell() '离开单元格
- If changelock Then
- Exit Sub
- End If
- '记录刚刚离开网格单元的行列值
- Dqlkwgh = WglrGrid.Row
- Dqlkwgl = WglrGrid.Col
- '判断是否需要录入数据回写
- If Not (Ydtext.Visible Or YdCombo.Visible) Then
- Exit Sub
- End If
- Call Lrsjhx
- End Sub
- Private Sub WglrGrid_RowColChange() '网格录入行列发生变化时,进行有效性判断
- Valilock = True '屏蔽文本框失去焦点进行有效性判断
- With WglrGrid
- If changelock Then
- Exit Sub
- End If
- If Not sjzdyxxpd(Dqlrwgh, Dqlrwgl) Then
- Exit Sub
- End If
- If .Row <> Dqlkwgh Then
- If Not Sjhzyxxpd(Dqlkwgh) Then
- Exit Sub
- End If
- End If
- End With
- Call fhyxh
- Call Xldql
- End Sub
- Private Sub WglrGrid_DblClick() '鼠标双击网格显示文本框
- With WglrGrid
- Call xswbk
- End With
- End Sub
- Private Sub Ycwbk() '隐藏文本框,帮助按钮,列表组合框
- Valilock = True
- Ydtext.Visible = False
- YdCombo.Visible = False
- Ydcommand.Visible = False
- End Sub
- Private Sub YdCombo_KeyDown(KeyCode As Integer, Shift As Integer) '列表框移动
- With WglrGrid
- Select Case KeyCode
- Case vbKeyEscape 'ESC 键放弃录入
- Valilock = True
- .SetFocus
- Call Ycwbk
- Valilock = False
- Case vbKeyReturn '回 车 键 =13
- KeyCode = 0
- .SetFocus
- Call Lrsjhx
- Rowjsq = .Row
- Coljsq = .Col + 1
- If Coljsq > .Cols - 1 Then
- If Rowjsq < .Rows - 1 Then
- Rowjsq = Rowjsq + 1
- End If
- Coljsq = Qslz
- End If
- Do While Rowjsq <= .Rows - 1
- If .ColHidden(Coljsq) Or (Not GridBoolean(Coljsq, 1)) Then
- Coljsq = Coljsq + 1
- If Coljsq > .Cols - 1 Then
- Rowjsq = Rowjsq + 1
- Coljsq = Qslz
- End If
- Else
- Exit Do
- End If
- Loop
- .Select Rowjsq, Coljsq
- Case vbKeyLeft '左 箭 头 =37
- If .Col - 1 = Qslz Then
- If .ColHidden(Qslz) Or (Not GridBoolean(Qslz, 1)) Then
- GoTo jzzx
- End If
- End If
- If .Col > Qslz Then
- KeyCode = 0
- .SetFocus
- Call Lrsjhx
- Coljsq = .Col - 1
- Do While Coljsq > Qslz
- If Coljsq - 1 = Qslz Then
- If .ColHidden(Qslz) Or (Not GridBoolean(Qslz, 1)) Then
- GoTo jzzx
- End If
- End If
- If .ColHidden(Coljsq) Or (Not GridBoolean(Coljsq, 1)) Then
- Coljsq = Coljsq - 1
- Else
- Exit Do
- End If
- Loop
- .Select .Row, Coljsq
- End If
- Case vbKeyRight '右 箭 头 =39
- KeyCode = 0
- .SetFocus
- Call Lrsjhx
- Rowjsq = .Row
- Coljsq = .Col + 1
- If Coljsq > .Cols - 1 Then
- If Rowjsq < .Rows - 1 Then
- Rowjsq = Rowjsq + 1
- End If
- Coljsq = Qslz
- End If
- Do While Rowjsq <= .Rows - 1
- If .ColHidden(Coljsq) Or (Not GridBoolean(Coljsq, 1)) Then
- Coljsq = Coljsq + 1
- If Coljsq > .Cols - 1 Then
- Rowjsq = Rowjsq + 1
- Coljsq = Qslz
- End If
- Else
- Exit Do
- End If
- Loop
- .Select Rowjsq, Coljsq
- Case Else
- End Select
- jzzx:
- End With
- End Sub
- Private Sub YdCombo_LostFocus()
- With WglrGrid '因为选中网格会先发生Rowcolchange事件置Valiock
- If Not Valilock Then '为TRUE
- Call Lrsjhx
- If Not Sjhzyxxpd(Dqlrwgh) Then
- Exit Sub
- End If
- End If
- End With
- End Sub
- Private Sub Ydcommand_MouseDown(Button As Integer, Shift As Integer, x As Single, y As Single)
- Call Lrzdbz
- End Sub
- Private Sub ydtext_KeyDown(KeyCode As Integer, Shift As Integer)
- Dim Rowjsq As Long, Coljsq As Long
- With WglrGrid
- Select Case KeyCode
- Case vbKeyF2
- Call Lrzdbz
- Case vbKeyEscape 'ESC 键放弃录入
- Valilock = True
- Call Ycwbk
- .SetFocus
- Case vbKeyReturn '回 车 键 =13
- KeyCode = 0
- .SetFocus
- Call Lrsjhx
- Rowjsq = .Row
- Coljsq = .Col + 1
- If Coljsq > .Cols - 1 Then
- If Rowjsq < .Rows - 1 Then
- Rowjsq = Rowjsq + 1
- End If
- Coljsq = Qslz
- End If
- Do While Rowjsq <= .Rows - 1
- If .ColHidden(Coljsq) Or (Not GridBoolean(Coljsq, 1)) Then
- Coljsq = Coljsq + 1
- If Coljsq > .Cols - 1 Then
- Rowjsq = Rowjsq + 1
- Coljsq = Qslz
- End If
- Else
- Exit Do
- End If
- Loop
- If Rowjsq <= .Rows - 1 Then
- .Select Rowjsq, Coljsq
- End If
- Case vbKeyUp '上 箭 头 =38
- KeyCode = 0
- .SetFocus
- Call Lrsjhx
- If .Row > .FixedRows Then
- .Row = .Row - 1
- End If
- Case vbKeyDown '下 箭 头 =40
- KeyCode = 0
- .SetFocus
- Call Lrsjhx
- If .Row < .Rows - 1 Then
- .Row = .Row + 1
- End If
- Case vbKeyLeft '左 箭 头 =37
- If .Col - 1 = Qslz Then
- If .ColHidden(Qslz) Or (Not GridBoolean(Qslz, 1)) Then
- GoTo jzzx
- End If
- End If
- If Ydtext.SelStart = 0 And .Col > Qslz Then
- KeyCode = 0
- .SetFocus
- Call Lrsjhx
- Coljsq = .Col - 1
- Do While Coljsq > Qslz
- If Coljsq - 1 = Qslz Then
- If .ColHidden(Qslz) Or (Not GridBoolean(Qslz, 1)) Then
- GoTo jzzx
- End If
- End If
- If .ColHidden(Coljsq) Or (Not GridBoolean(Coljsq, 1)) Then
- Coljsq = Coljsq - 1
- Else
- Exit Do
- End If
- Loop
- .Select .Row, Coljsq
- End If
- jzzx:
- Case vbKeyRight '右 箭 头 =39
- wblong = Len(Ydtext.Text)
- If (Ydtext.SelStart = wblong Or Ydtext.SelLength = wblong) Then
- KeyCode = 0
- .SetFocus
- Call Lrsjhx
- Rowjsq = .Row
- Coljsq = .Col + 1
- If Coljsq > .Cols - 1 Then
- If Rowjsq < .Rows - 1 Then
- Rowjsq = Rowjsq + 1
- End If
- Coljsq = Qslz
- End If
- Do While Rowjsq <= .Rows - 1
- If .ColHidden(Coljsq) Or (Not GridBoolean(Coljsq, 1)) Then
- Coljsq = Coljsq + 1
- If Coljsq > .Cols - 1 Then
- Rowjsq = Rowjsq + 1
- Coljsq = Qslz
- End If
- Else
- Exit Do
- End If
- Loop
- .Select Rowjsq, Coljsq
- End If
- Case Else
- End Select
- End With
- End Sub
- Private Sub ydtext_KeyPress(KeyAscii As Integer) '录入字符事中控制
- Call InputFieldLimit(Ydtext, GridInt(WglrGrid.Col, 1), KeyAscii)
- End Sub
- Private Sub ydtext_Change() '录入事中变化处理
- '防止程序改变但不进行处理
- If Wbkbhlock Then
- Exit Sub
- End If
- With WglrGrid
- '限制字段录入长度
- Wbkbhlock = True
- Select Case GridInt(.Col, 1)
- Case 8
- Call Sjgskz(Ydtext, Xtjezws - Xtjexsws - 1, Xtjexsws)
- Case 9
- Call Sjgskz(Ydtext, Xtslzws - Xtslxsws - 1, Xtslxsws)
- Case 10
- Call Sjgskz(Ydtext, Xtdjzws - Xtdjxsws - 1, Xtdjxsws)
- Case Else
- If GridInt(.Col, 3) <> 0 Or GridInt(.Col, 4) <> 0 Then
- Call Sjgskz(Ydtext, GridInt(.Col, 3), GridInt(.Col, 4))
- End If
- End Select
- Wbkbhlock = False
- End With
- End Sub
- Private Sub ydtext_LostFocus() '如果由于选中网格之外的控件而发生有效性判断(选中网格会先发生Rowcolchange事件置Valiock为TRUE)
- With WglrGrid
- If Not Valilock Then
- Call Lrsjhx
- If Not sjzdyxxpd(Dqlrwgh, Dqlrwgl) Then
- Exit Sub
- End If
- If Not Sjhzyxxpd(Dqlrwgh) Then
- Exit Sub
- End If
- End If
- End With
- End Sub
- Private Sub xswbk() '在当前选中单元显示文本框,列表框,帮助按钮(通用)
- Dim Wbkpy As Integer, Wbkpy1 As Integer '文本框偏移量
- '如果单据操作状态为浏览状态则不能显示录入载体
- If Trim(Lab_OperStatus.Caption) = "1" Then
- Exit Sub
- End If
- '[>>
- With WglrGrid
- '如果科目为非末级科目则不能显示录入载体
- If WglrGrid.TextMatrix(WglrGrid.Row, 0) <> 1 Then
- Exit Sub
- End If
- '如果科目不进行数量核算,则网格处于数量录入列时则不能显示录入载体
- If WglrGrid.TextMatrix(WglrGrid.Row, 1) = 0 And (.Col = Sydz("010", GridStr(), Szzls) Or .Col = Sydz("011", GridStr(), Szzls) Or .Col = Sydz("012", GridStr(), Szzls)) Then
- Exit Sub
- End If
- '如果科目不进行外币核算,则网格处于外币录入列时则不能显示录入载体
- If WglrGrid.TextMatrix(WglrGrid.Row, 2) = 0 And (.Col = Sydz("014", GridStr(), Szzls) Or .Col = Sydz("015", GridStr(), Szzls) Or .Col = Sydz("016", GridStr(), Szzls)) Then
- Exit Sub
- End If
- End With
- '>>]
- '显示文本框前返回有效行列（解决滚动条问题）
- Call Xldqh
- Call Xldql
- '隐藏文本框,帮助按钮,列表组合框
- Call Ycwbk
- With WglrGrid
- Dqlrwgh = .Row
- Dqlrwgl = .Col
- If Not GridBoolean(.Col, 1) Or .Row < .FixedRows Then
- Exit Sub
- End If
- Wbkpy = 30
- Wbkpy1 = 15
- If GridBoolean(.Col, 3) Then
- YdCombo.Left = .CellLeft + .Left + Wbkpy
- YdCombo.Top = .CellTop + .Top + Wbkpy
- YdCombo.Width = .CellWidth - Wbkpy1
- Call Wbkcl
- YdCombo.Visible = True
- YdCombo.SetFocus
- Ydcommand.Visible = False
- Ydtext.Visible = False
- Else
- If GridBoolean(.Col, 2) Then
- Ydcommand.Left = .Left + .CellLeft + .CellWidth - Ydcommand.Width + Wbkpy
- Ydcommand.Top = .Top + .CellTop + .CellHeight - Ydcommand.Height + Wbkpy
- Ydcommand.Visible = True
- Else
- Ydcommand.Visible = False
- End If
- Ydtext.Left = .CellLeft + .Left + Wbkpy
- Ydtext.Top = .CellTop + .Top + Wbkpy
- If Ydcommand.Visible Then
- If Sfblbzkd Then
- Ydtext.Width = .CellWidth - Ydcommand.Width
- Else
- Ydtext.Width = .CellWidth - Wbkpy1
- End If
- Else
- Ydtext.Width = .CellWidth - Wbkpy1
- End If
- Ydtext.Height = .CellHeight - Wbkpy1
- If GridInt(.Col, 2) <> 0 Then
- Ydtext.MaxLength = GridInt(.Col, 2)
- Else
- Ydtext.MaxLength = 3000
- End If
- Call Wbkcl
- Ydtext.Visible = True
- Ydtext.SetFocus
- End If
- Dqtoprow = .TopRow
- Dqleftcol = .LeftCol
- '重置锁值
- Valilock = False
- Wbkbhlock = False
- End With
- End Sub
- Private Sub Cxxswbk() 'Formresize中重新显示文本框,列表框,帮助按钮(通用)
- Dim Wbkpy As Integer, Wbkpy1 As Integer
- Wbkpy = 30
- Wbkpy1 = 15
- With WglrGrid
- If YdCombo.Visible Then
- YdCombo.Left = .CellLeft + .Left + Wbkpy
- YdCombo.Top = .CellTop + .Top + Wbkpy
- YdCombo.Width = .CellWidth - Wbkpy1
- End If
- If Ydcommand.Visible Then
- Ydcommand.Left = .Left + .CellLeft + .CellWidth - Ydcommand.Width + Wbkpy
- Ydcommand.Top = .Top + .CellTop + .CellHeight - Ydcommand.Height + Wbkpy
- End If
- If Ydtext.Visible Then
- If Ydcommand.Visible Then
- If Sfblbzkd Then
- Ydtext.Width = .CellWidth - Ydcommand.Width
- Else
- Ydtext.Width = .CellWidth - Wbkpy1
- End If
- Else
- Ydtext.Width = .CellWidth - Wbkpy1
- End If
- Ydtext.Left = .CellLeft + .Left + Wbkpy
- Ydtext.Top = .CellTop + .Top + Wbkpy
- Ydtext.Height = .CellHeight - Wbkpy1
- End If
- End With
- End Sub
- Private Sub Lrsjhx() '文本框录入数据回写
- With WglrGrid
- If YdCombo.Visible Then
- .Text = Trim(YdCombo.Text)
- End If
- If Ydtext.Visible Then
- .Text = Trim(Ydtext.Text)
- End If
- '(如果字段录入内容发生变化,则打开有效性判断锁)
- If Zdlrqnr <> Trim(.Text) Then
- Yxxpdlock = False
- Hyxxpdlock = False
- End If
- '隐藏文本框,帮助按钮,列表组合框
- Call Ycwbk
- End With
- End Sub
- Private Sub WglrGrid_KeyPress(KeyAscii As Integer) '网格接受键盘录入
- Dim Str_ChangeTe As String '临时交换内容
- Dim Coljsq As Long '临时列计数器
- Dim Int_SaveKey As Integer '保存KeyAscii值
- '如果单据操作状态为浏览状态则不能显示录入载体
- If Trim(Lab_OperStatus.Caption) = "1" Then
- Exit Sub
- End If
- '[>>
- With WglrGrid
- '如果科目为非末级科目则不能显示录入载体
- If WglrGrid.TextMatrix(WglrGrid.Row, 0) <> 1 Then
- Exit Sub
- End If
- '如果科目不进行数量核算,则网格处于数量录入列时则不能显示录入载体
- If WglrGrid.TextMatrix(WglrGrid.Row, 1) = 0 And (.Col = Sydz("010", GridStr(), Szzls) Or .Col = Sydz("011", GridStr(), Szzls) Or .Col = Sydz("012", GridStr(), Szzls)) Then
- Exit Sub
- End If
- '如果科目不进行外币核算,则网格处于外币录入列时则不能显示录入载体
- If WglrGrid.TextMatrix(WglrGrid.Row, 2) = 0 And (.Col = Sydz("014", GridStr(), Szzls) Or .Col = Sydz("015", GridStr(), Szzls) Or .Col = Sydz("016", GridStr(), Szzls)) Then
- Exit Sub
- End If
- End With
- '>>]
- Int_SaveKey = KeyAscii
- With WglrGrid
- '屏 蔽 回 车 键
- If KeyAscii = vbKeyReturn Then
- KeyAscii = 0
- Rowjsq = .Row
- Coljsq = .Col + 1
- If Coljsq > .Cols - 1 Then
- If Rowjsq < .Rows - 1 Then
- Rowjsq = Rowjsq + 1
- End If
- Coljsq = Qslz
- End If
- Do While Rowjsq <= .Rows - 1
- If .ColHidden(Coljsq) Or (Not GridBoolean(Coljsq, 1)) Then
- Coljsq = Coljsq + 1
- If Coljsq > .Cols - 1 Then
- Rowjsq = Rowjsq + 1
- Coljsq = Qslz
- End If
- Else
- Exit Do
- End If
- Loop
- If Rowjsq <= .Rows - 1 Then
- .Select Rowjsq, Coljsq
- End If
- Exit Sub
- End If
- '接受用户录入
- Select Case KeyAscii
- Case 0 To 32
- '显示录入载体
- Call xswbk
- Case Else
- '防止非编辑字段SendKeys()出现死循环
- If Not GridBoolean(.Col, 1) Or .Row < .FixedRows Then
- Exit Sub
- End If
- If GridBoolean(.Col, 3) Then
- '列表框录入
- Call xswbk
- Else
- Ydtext.Text = ""
- Call InputFieldLimit(Ydtext, GridInt(WglrGrid.Col, 1), KeyAscii)
- If KeyAscii = 0 Then
- Exit Sub
- End If
- '调入录入载体
- Call xswbk
- Ydtext.Text = ""
- Valilock = True
- SendKeys Chr(KeyAscii), wait
- DoEvents
- Valilock = False
- End If
- End Select
- End With
- End Sub
- Private Sub Qkwlzd(sjh As Long, Sjl As Long) '清空为零字段
- If Not GridBoolean(Sjl, 5) Then
- Exit Sub
- End If
- With WglrGrid
- If Val(Trim(.TextMatrix(sjh, Sjl))) = 0 Then
- .TextMatrix(sjh, Sjl) = ""
- End If
- End With
- End Sub
- Private Sub fhyxh() '返回录入数据有效行,同时让得到焦点网格可见
- With WglrGrid
- If .Row >= .FixedRows Then
- Call Xldqh
- End If
- End With
- End Sub
- Private Sub Xldqh() '显露当前行
- Dim Toprowte As Long
- With WglrGrid
- Toprowte = 0
- Do While .CellTop + .RowHeight(.Row) + Fzxwghs * Sjhgd > .Height And .TopRow <> Toprowte
- Toprowte = .TopRow
- .TopRow = .TopRow + 1
- Loop
- Toprowte = 0
- Do While .CellTop < .FixedRows * .RowHeight(0) And .TopRow <> Toprowte
- Toprowte = .TopRow
- .TopRow = .TopRow - 1
- Loop
- End With
- End Sub
- Private Sub Xldql() '显露当前列
- Dim Leftcolte As Long
- With WglrGrid
- If .Col >= Qslz Then
- If .LeftCol > .Col Then
- .LeftCol = .Col
- End If
- Leftcolte = 0
- Do While .CellLeft + .CellWidth > .Width And .LeftCol <> Leftcolte
- Leftcolte = .LeftCol
- .LeftCol = .LeftCol + 1
- Loop
- End If
- End With
- End Sub
- Private Sub GsToolbar_ButtonClick(ByVal Button As MSComctlLib.Button) '表格格式设置(通用)
- Select Case Button.Key
- Case "bcgs" '保存表格格式
- Call Bcwggs(WglrGrid, GridCode, GridStr())
- Case "hfmrgs" '恢复默认格式
- Call Hfmrgs(WglrGrid, GridCode, GridStr())
- Case "szxsxm" '设置显示项目
- Call Szxsxm(WglrGrid, GridCode)
- End Select
- End Sub
- Private Sub bbyl(bbylte As Boolean) '报表打印预览
- Dim Bbzbt$, Bbxbt() As String, bbxbtzzxs() As Integer, Bbxbtgs As Integer
- Dim Bbbwh() As String, Bbbwhzzxs() As Integer, Bbbwhgs As Integer
- Bbxbtgs = 1 '报 表 小 标 题 行 数
- Bbbwhgs = 0 '报 表 表 尾 行 数
- ReDim Bbxbt(1 To Bbxbtgs)
- ReDim bbxbtzzxs(1 To Bbxbtgs)
- If Bbbwhgs <> 0 Then
- ReDim Bbbwh(1 To Bbbwhgs)
- ReDim Bbbwhzzxs(1 To Bbbwhgs)
- End If
- Bbzbt = ReportTitle
- Call Scyxsjb(WglrGrid) '生成报表数据
- Call Scdybb(Dyymctbl, Bbzbt, Bbxbt(), bbxbtzzxs(), Bbxbtgs, Bbbwh(), Bbbwhzzxs(), Bbbwhgs, bbylte)
- If Not bbylte Then
- Unload DY_Tybbyldy
- End If
- End Sub
