sql 两个文本框求积?解决办法
sql 两个文本框求积?
现在想把金额小计的值变成单价乘以天数的值,请问如何写,非常感谢!
------解决思路----------------------
"INSERT INTO cheliangzulin_Comment(编号,使用时间,归还时间,车牌号,单价,单位,天数,金额小计,租金出处,违章记录,是否处理,使用人,本次行驶里程,行驶里程,保养,费用,用车事由及地点,保养维修单据上传,操作员,TabIndex) VALUES ('" & Me.Textbox1.Text & "','" & Me.PiShiText1.Text & "','" & Me.PiShiText2.Text & "','" & Me.PiShiText3.Text & "','" & Me.PiShiText4.Text & "','" & Me.PiShiText5.Text & "','" & Me.PiShiText6.Text & "','" & Me.PiShiText7.Text & "','" & Me.PiShiText8.Text & "','" & Me.PiShiText9.Text & "','" & Me.PiShiText10.Text & "','" & Me.PiShiText11.Text & "','" & Me.PiShiText12.Text & "','" & Me.PiShiText13.Text & "','" & Me.PiShiText14.Text & "','" & Me.PiShiText15.Text & "','" & Me.PiShiText16.Text & "','" & Me.PiShiText17.Text & "','" & UserName & "','" & GetTabIndex & "')"
现在想把金额小计的值变成单价乘以天数的值,请问如何写,非常感谢!
------解决思路----------------------
"INSERT INTO cheliangzulin_Comment(编号,使用时间,归还时间,车牌号,单价,单位,天数,金额小计,租金出处,违章记录,是否处理,使用人,本次行驶里程,行驶里程,保养,费用,用车事由及地点,保养维修单据上传,操作员,TabIndex) VALUES ('" & Me.Textbox1.Text & "','" & Me.PiShiText1.Text & "','" & Me.PiShiText2.Text & "','" & Me.PiShiText3.Text & "','" & Me.PiShiText4.Text & "','" & Me.PiShiText5.Text & "','" & Me.PiShiText6.Text & "','" & (Int.Parse(Me.PiShiText4.Text) * Int.Parse(Me.PiShiText7.Text)) & "','" & Me.PiShiText8.Text & "','" & Me.PiShiText9.Text & "','" & Me.PiShiText10.Text & "','" & Me.PiShiText11.Text & "','" & Me.PiShiText12.Text & "','" & Me.PiShiText13.Text & "','" & Me.PiShiText14.Text & "','" & Me.PiShiText15.Text & "','" & Me.PiShiText16.Text & "','" & Me.PiShiText17.Text & "','" & UserName & "','" & GetTabIndex & "')"应该是这样