private void btnSave_Click(object sender, EventArgs e) { if (rds.RmPo.Rows.Count <= 0) { return; } if (!PDAFunction.IsCanCon()) { MessageBox.Show(@"无法连接到服务器", @"Warning"); return; } for (var i = 0; i <= rds.RmPo.Rows.Count - 1; i++) { var cmd = new SQLiteCommand { CommandText = "insert into RmPo(cOrderNumber,FitemID,FEntryID,cInvCode,cInvName,cUnit,iQuantity,iScanQuantity,cVendor,cMemo) values(@cOrderNumber,@FitemID,@FEntryID,@cInvCode,@cInvName,@cUnit,@iQuantity,0,@cVendor,@cMemo)" }; cmd.Parameters.AddWithValue("@cOrderNumber", rds.RmPo.Rows[i]["cOrderNumber"]); cmd.Parameters.AddWithValue("@FitemID", rds.RmPo.Rows[i]["FItemID"]); cmd.Parameters.AddWithValue("@FEntryID", rds.RmPo.Rows[i]["FEntryID"]); cmd.Parameters.AddWithValue("@cInvCode", rds.RmPo.Rows[i]["cInvCode"]); cmd.Parameters.AddWithValue("@cInvName", rds.RmPo.Rows[i]["cInvName"]); cmd.Parameters.AddWithValue("@cUnit", "1"); cmd.Parameters.AddWithValue("@iQuantity", rds.RmPo.Rows[i]["iQuantity"]); cmd.Parameters.AddWithValue("@cVendor", rds.RmPo.Rows[i]["cVendor"]); cmd.Parameters.AddWithValue("@cMemo", rds.RmPo.Rows[i]["cMemo"]); PDAFunction.ExecSqLite(cmd); } //写下载日志 var logCmd = new SqlCommand("AddLogAction"); logCmd.CommandType = CommandType.StoredProcedure; logCmd.Parameters.AddWithValue("@cFunction", "采购订单下载"); logCmd.Parameters.AddWithValue("@cDescription", frmLogin.lUser + "下载采购订单:" + rds.RmPo.Rows[0]["cOrderNumber"]); var ucon = new SqlConnection(frmLogin.WmsCon); PDAFunction.ExecSqL(ucon, logCmd); MessageBox.Show(@"成功保存", @"Success"); rds.RmPo.Rows.Clear(); lblSum.Text = ""; txtBarCode.Text = ""; }
private void btnSave_Click(object sender, EventArgs e) { if (prods.ProDelivery.Rows.Count <= 0) { return; } if (!PDAFunction.IsCanCon()) { MessageBox.Show(@"无法连接到服务器", @"Warning"); return; } for (var i = 0; i <= prods.ProDelivery.Rows.Count - 1; i++) { var cmd = new SQLiteCommand { CommandText = "insert into ProDelivery(AutoID,cCode,cCusCode,cCusName,cMaker,dMaketime,cDepCode,cDepName,cMemo,cVerifyState,dVeriDate) values(@AutoID,@cCode,@cCusCode,@cCusName,@cMaker,@dMaketime,@cDepCode,@cDepName,@cMemo,@cVerifyState,@dVeriDate)" }; cmd.Parameters.AddWithValue("@AutoID", prods.ProDelivery.Rows[i]["AutoID"]); cmd.Parameters.AddWithValue("@cCode", prods.ProDelivery.Rows[i]["cCode"]); cmd.Parameters.AddWithValue("@cCusCode", prods.ProDelivery.Rows[i]["cCusCode"]); cmd.Parameters.AddWithValue("@cCusName", prods.ProDelivery.Rows[i]["cCusName"]); cmd.Parameters.AddWithValue("@cMaker", prods.ProDelivery.Rows[i]["cMaker"]); cmd.Parameters.AddWithValue("@dMaketime", prods.ProDelivery.Rows[i]["dMaketime"]); cmd.Parameters.AddWithValue("@cDepCode", prods.ProDelivery.Rows[i]["cDepCode"]); cmd.Parameters.AddWithValue("@cDepName", prods.ProDelivery.Rows[i]["cDepName"]); cmd.Parameters.AddWithValue("@cMemo", prods.ProDelivery.Rows[i]["cMemo"]); cmd.Parameters.AddWithValue("@cVerifyState", prods.ProDelivery.Rows[i]["cVerifyState"]); cmd.Parameters.AddWithValue("@dVeriDate", prods.ProDelivery.Rows[i]["dVeriDate"]); PDAFunction.ExecSqLite(cmd); } var ucmd = new SqlCommand("update ProDelivery set cVerifyState='拣货下载' where cCode=@cCode"); ucmd.Parameters.AddWithValue("@cCode", prods.ProDelivery.Rows[0]["cCode"]); var ucon = new SqlConnection(frmLogin.WmsCon); PDAFunction.ExecSqL(ucon, ucmd); MessageBox.Show(@"成功保存", @"Success"); prods.ProDelivery.Rows.Clear(); lblSum.Text = ""; }