16,555
社区成员
发帖
与我相关
我的任务
分享
Private Sub CmdSave()
On Error GoTo ErrHan
Dim rs As Recordset
Dim rsTemp As Recordset
Dim sql As String
Dim i As Integer
Dim cn As New ADODB.Connection
cn.begintrans()
sql = "select * from 合同库 where 1=2"
rs.Open(sql, cn) '修改打开
rs.AddNew()
rs("合同编号").Value = TextBox1.Text
rs("单位名称").Value = TextBox2.Text
rs.Update()
sql = "select * from 订货库 where 合同编号='" & TextBox1.Text & "'"
rs.Open(sql, cn) '修改打开
For i = 1 To ListView1.Items.Count
rs.AddNew()
rs("合同编号").Value = TextBox1.Text
rs("序号").Value = i
rs("产品编号").Value = ListView1.Items(i).Text
rs("订货数量").Value = ListView1.Items(i).SubItems(1)
rs.Update()
sql = "select * from 库存表 where 产品编号='" & ListView1.Items(i).Text & "'"
rsTemp.open(sql, cn) '修改打开
rsTemp("订货数").Value = rsTemp("订货数").Value + Val(ListView1.Items(i).SubItems(1))
rsTemp.update()
Next i
cn.committrans()
Exit Sub
ErrHan:
cn.rollbacktrans()
End Sub