'窗口表头设置.表中自动生成合计
Tables("月租收费_Table1").SetHeaderRowHeight(0,25,40)
Tables("月租收费_Table1").AddNew(10)
With Tables("月租收费_Table1")
.Cols("缴费_月租_缴费月数").GrandTotal = True
.Cols("缴费_月租_缴费金额").GrandTotal = True
.GrandTotal = True
End With
'打开目录树.下拉选项'
e.Form.Controls("Table1").Table.Cols("车牌号码").DropForm = "车牌目录树"
e.Form.Controls("Table1").Table.Cols("缴费_月租_起计日期").UsetBuildInEditor = True
e.Form.Controls("Table1").Table.Cols("缴费_月租_止计日期").UsetBuildInEditor = True
e.Form.Controls("lry").text = User.name
'以这代码为准:
Dim yzdh As WinForm.TextBox = e.Form.Controls("dh")'dh是单号控件
Dim di As String = yzdh.Value 'di单号控件中的变量
Dim d As Date = Date.Today
Dim y As Integer = d.Year
Dim m As Integer = d.Month
Dim Days As Integer = Date.DaysInMonth(y,m)
Dim fd As Date = New Date(y,m,1) '获得该月的第一天
Dim ld As Date = New Date(y,m,Days) '获得该月的最后一天
Dim bh As String = "yz" & "-" & Format(d,"yyyyMM") & "-" '生成编号的前缀
Dim max As String
Dim idx As Integer
Dim flt As String
flt = "[前缀] = 'yz' And [日期] >= #" & fd & "# And [日期] <= #" & ld & "#"
max = DataTables("缴费情况").Compute("Max(单号)",flt) '取得该月的相同工程代码的最大单据编号
If max > "" Then '如果存在最大单据编号
idx = CInt(max.Substring(10,4)) + 1 '获得最大单据编号的后四位顺序号,并加1
Else
idx = 1 '否则顺序号等于1
End If
di = bh & Format(idx,"0000")
yzdh.Value = di