表A中.列名:"荒料编号"数据有如下:TF15-03K0001TF16-03K2500
TF17-03K1105
需要其返回对应的"流水编号"列的数据,
Dim a1 As String = e.Form.Controls("荒料编号").value
If a1 > "" Then
Dim sa As String = a1.Split("-")(1) '以"03K为条件查询-----------------------
sa = sa.SubString(0,3)
Dim cmc As WinForm.ComboBox = e.form.Controls("流水编号")
cmc.ComboList = DataTables("表A").GetComboListString("流水编号","荒料编号 like '" & sa & "%'" And "[打包] = '" & False & "'")
End If
我用以上代码,不知道是哪里不对,无法返回正确的数据.请求帮助!!!
[此贴子已经被作者于2015/10/18 11:24:44编辑过]