private void btnDelete_Click(object sender, EventArgs e) { if (dGridMain.CurrentRowIndex < 0) { return; } if (MessageBox.Show(@"确定删除当前下载的生产订单?", @"确定删除?", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question, MessageBoxDefaultButton.Button3) != DialogResult.Yes) { return; } var cmd = new SQLiteCommand("select * from RmProduceDetail where cCode=@cCode"); cmd.Parameters.AddWithValue("@cCode", rds.RmProduce.Rows[dGridMain.CurrentRowIndex]["cCode"]); if (PDAFunction.ExistSqlite(frmLogin.SqliteCon, cmd)) { MessageBox.Show(@"当前班次制令单已经进行过领料,不允许删除!", @"Warning"); return; } //if (!PDAFunction.IsCanCon()) //{ // MessageBox.Show(@"无法连接到服务器", @"Warning"); // return; //} var dCmd = new SQLiteCommand("Delete from RmProduce where cCode=@cCode"); dCmd.Parameters.AddWithValue("@cCode", rds.RmProduce.Rows[dGridMain.CurrentRowIndex]["cCode"]); PDAFunction.ExecSqLite(dCmd); MessageBox.Show(@"删除成功", @"Success"); LoaRmProduce(); }
/// <summary> /// 保存出库扫描,并重新进入出库单号的扫描获取 /// </summary> private void SaveOutWareHouse(string cSerialNumber, string cInvCode, string cInvName, decimal iQuantity, string cLotNo, string FItemID) { var sqLiteCmd = new SQLiteCommand("insert into RmProduceDetail(cBarCode,cCode,cLotNo,cInvCode,cInvName,iQuantity,cUser,FItemID,FSPNumber,AutoID) " + "values(@cBarCode,@cCode,@cLotNo,@cInvCode,@cInvName,@iQuantity,@cUser,@FItemID,@FSPNumber,@AutoID)"); sqLiteCmd.Parameters.AddWithValue("@cBarCode", cSerialNumber); sqLiteCmd.Parameters.AddWithValue("@cCode", lblOrderNumber.Text); sqLiteCmd.Parameters.AddWithValue("@cLotNo", cLotNo); sqLiteCmd.Parameters.AddWithValue("@cInvCode", cInvCode); sqLiteCmd.Parameters.AddWithValue("@cInvName", cInvName); sqLiteCmd.Parameters.AddWithValue("@iQuantity", iQuantity); sqLiteCmd.Parameters.AddWithValue("@cUser", frmLogin.lUser); sqLiteCmd.Parameters.AddWithValue("@FItemID", FItemID); sqLiteCmd.Parameters.AddWithValue("@FSPNumber", lblStockPlaceID.Text); sqLiteCmd.Parameters.AddWithValue("@AutoID", ShiftID); PDAFunction.ExecSqLite(sqLiteCmd); var PlusCmd = new SQLiteCommand("update RmProduce set iScanQuantity=ifnull(iScanQuantity,0)+@iQuantity where cCode=@cCode and FItemID=@FItemID "); PlusCmd.Parameters.AddWithValue("@cCode", lblOrderNumber.Text); PlusCmd.Parameters.AddWithValue("@iQuantity", iQuantity); PlusCmd.Parameters.AddWithValue("@FItemID", FItemID); PDAFunction.ExecSqLite(PlusCmd); txtBarCode.Text = ""; txtBarCode.Focus(); RefreshGrid(); }
/// <summary> /// 保存出库扫描,并重新进入出库单号的扫描获取 /// </summary> private void SaveOutWareHouse(string cBarCode, string cInvCode, string cInvName, decimal iQuantity, string cLotNo, int FitemID) { var sqLiteCmd = new SQLiteCommand("insert into ProDeliveryDetail(AutoID,cCode,cBarCode,cLotNo,FItemID,cInvCode,cInvName,iQuantity,cUser,cBoxNumber,FSPNumber) " + "values(@AutoID,@cCode,@cBarCode,@cLotNo,@FItemID,@cInvCode,@cInvName,@iQuantity,@cUser,@cBoxNumber,@FSPNumber)"); sqLiteCmd.Parameters.AddWithValue("@AutoID", _AutoID); sqLiteCmd.Parameters.AddWithValue("@cCode", lblOrderNumber.Text); sqLiteCmd.Parameters.AddWithValue("@cBarCode", cBarCode); sqLiteCmd.Parameters.AddWithValue("@cLotNo", cLotNo); sqLiteCmd.Parameters.AddWithValue("@FitemID", FitemID); sqLiteCmd.Parameters.AddWithValue("@cInvCode", cInvCode); sqLiteCmd.Parameters.AddWithValue("@cInvName", cInvName); sqLiteCmd.Parameters.AddWithValue("@iQuantity", iQuantity); sqLiteCmd.Parameters.AddWithValue("@cUser", frmLogin.lUser); sqLiteCmd.Parameters.AddWithValue("@cBoxNumber", ""); sqLiteCmd.Parameters.AddWithValue("@FSPNumber", lblStockPlaceID.Text); PDAFunction.ExecSqLite(sqLiteCmd); txtBarCode.Text = ""; txtBarCode.Focus(); RefreshGrid(); }
private void dGridMain_DoubleClick(object sender, EventArgs e) { if (dGridMain.CurrentRowIndex <= -1) { return; } //if (!PDAFunction.IsCanCon()) //{ // MessageBox.Show("无法连接到服务器"); //} if (MessageBox.Show(@"确定删除当前行?", @"确定删除?", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question, MessageBoxDefaultButton.Button3) != DialogResult.Yes) { return; } var sqLiteCmd = new SQLiteCommand("Delete From RmStoreDetail where id=@id"); sqLiteCmd.Parameters.AddWithValue("@id", rds.RmStoreDetail.Rows[dGridMain.CurrentRowIndex]["id"]); //执行删除 PDAFunction.ExecSqLite(sqLiteCmd); var MinusCmd = new SQLiteCommand("update RmPo set iScanQuantity=iScanQuantity-@iQuantity where FEntryID=@FEntryID"); MinusCmd.Parameters.AddWithValue("@cInvCode", rds.RmStoreDetail.Rows[dGridMain.CurrentRowIndex]["FEntryID"]); MinusCmd.Parameters.AddWithValue("@iQuantity", rds.RmStoreDetail.Rows[dGridMain.CurrentRowIndex]["iQuantity"]); PDAFunction.ExecSqLite(MinusCmd); rds.RmStoreDetail.Rows.RemoveAt(dGridMain.CurrentRowIndex); RefreshGrid(); if (rds.RmStoreDetail.Rows.Count > 0) { dGridMain.CurrentRowIndex = 0; } }
private void btnComplete_Click(object sender, EventArgs e) { _sumException = 0; if (!PDAFunction.IsCanCon()) { MessageBox.Show(@"无法连接到SQL服务器,无法上传", @"Warning"); return; } if (rds.RmStoreDetail.Rows.Count <= 0) { MessageBox.Show(@"无任何数据!", @"Warning"); return; } if (lblOutAll.Text.Equals("未完成")) { if (MessageBox.Show("采购未完成,是否确定要上传", "是否", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) != DialogResult.Yes) { return; } } btnComplete.Enabled = false; var cGuid = Guid.NewGuid().ToString(); if (!UpLoaRmStoreDetail(cGuid)) { MessageBox.Show(@"无法连接到SQL服务器,请重试!", @"Warning"); RefreshGrid(); btnComplete.Enabled = true; return; //成功后,删除离线出库通知单数据 } if (_sumException == 0) { UpLoadMain(cGuid); MessageBox.Show(@"全部上传成功!", @"Success"); var dCmd = new SQLiteCommand("Delete from RmPo where cOrderNumber=@cOrderNumber"); dCmd.Parameters.AddWithValue("@cOrderNumber", lblOrderNumber.Text); PDAFunction.ExecSqLite(dCmd); Close(); return; } else { MessageBox.Show(@"上传成功,但是有" + _sumException + @"条记录异常,请检查异常日志!", @"Success"); } RefreshGrid(); }
private bool ExecUpLoad(int i, string cGuid) { using (var con = new SqlConnection(frmLogin.WmsCon)) { using (var cmd = con.CreateCommand()) { cmd.CommandText = "Upload_RmPo"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@cOrderNumber", rds.RmPo.Rows[i]["cOrderNumber"]); cmd.Parameters.AddWithValue("@cInvCode", rds.RmPo.Rows[i]["cInvCode"]); cmd.Parameters.AddWithValue("@cInvName", rds.RmPo.Rows[i]["cInvName"]); cmd.Parameters.AddWithValue("@cUnit", rds.RmPo.Rows[i]["cUnit"]); cmd.Parameters.AddWithValue("@iQuantity", rds.RmPo.Rows[i]["iQuantity"]); cmd.Parameters.AddWithValue("@iScanQuantity", rds.RmPo.Rows[i]["iScanQuantity"]); cmd.Parameters.AddWithValue("@cVendor", rds.RmPo.Rows[i]["cVendor"]); cmd.Parameters.AddWithValue("@cMemo", rds.RmPo.Rows[i]["cMemo"]); cmd.Parameters.AddWithValue("@cUser", frmLogin.lUser); cmd.Parameters.AddWithValue("@cGuid", cGuid); cmd.Parameters.AddWithValue("@FEntryID", rds.RmPo.Rows[i]["FEntryID"]); cmd.Parameters.AddWithValue("@FItemID", rds.RmPo.Rows[i]["FItemID"]); try { con.Open(); var iTem = cmd.ExecuteNonQuery(); if (iTem == 1) { var dSqliteCmd = new SQLiteCommand("Delete from RmPo where id=@id"); //成功后,删除离线出库数据中的表 dSqliteCmd.Parameters.AddWithValue("@id", rds.RmPo.Rows[i]["id"]); PDAFunction.ExecSqLite(dSqliteCmd); return(true); } return(false); } catch (Exception ex) { MessageBox.Show(@"无法连接到SQL服务器,请重试! " + ex.Message, @"Warning"); return(false); } } } }
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 btnComplete_Click(object sender, EventArgs e) { _sumException = 0; if (!PDAFunction.IsCanCon()) { MessageBox.Show(@"无法连接到SQL服务器,无法上传", @"Warning"); return; } if (prods.ProDeliveryDetail.Rows.Count <= 0) { MessageBox.Show(@"无任何数据!", @"Warning"); return; } btnComplete.Enabled = false; var cGuid = Guid.NewGuid().ToString(); if (!UpLoadDetail(cGuid)) { MessageBox.Show(@"无法连接到SQL服务器,请重试!", @"Warning"); RefreshGrid(); btnComplete.Enabled = true; return; //成功后,删除离线出库通知单数据 } if (_sumException == 0) { MessageBox.Show(@"全部上传成功!", @"Success"); var dCmd = new SQLiteCommand("Delete from ProDelivery where cCode=@cCode"); dCmd.Parameters.AddWithValue("@cCode", lblOrderNumber.Text); PDAFunction.ExecSqLite(dCmd); Close(); return; } else { MessageBox.Show(@"上传成功,但是有" + _sumException + @"条记录异常,请检查异常日志!", @"Success"); } RefreshGrid(); }
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 = ""; }
private void dGridMain_DoubleClick(object sender, EventArgs e) { if (dGridMain.CurrentRowIndex <= -1) { return; } //if (!PDAFunction.IsCanCon()) //{ // MessageBox.Show("无法连接到服务器"); //} if (MessageBox.Show(@"确定删除当前行?", @"确定删除?", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question, MessageBoxDefaultButton.Button3) != DialogResult.Yes) { return; } var sqLiteCmd = new SQLiteCommand("Delete From ProStoreDetail where id=@id"); sqLiteCmd.Parameters.AddWithValue("@id", prods.ProStoreDetail.Rows[dGridMain.CurrentRowIndex]["id"]); //执行删除 PDAFunction.ExecSqLite(sqLiteCmd); RefreshGrid(); }
/// <summary> /// 执行导入SQL服务器操作 /// </summary> /// <param name="iRowId">把当前行行入库</param> /// <param name="cGuid">当前Guid</param> private bool UpLoadDetail(string cGuid) { using (var con = new SqlConnection(frmLogin.WmsCon)) { con.Open(); var tran = con.BeginTransaction(); using (var cmd = con.CreateCommand()) { cmd.CommandText = "Upload_RmProduceDetail"; cmd.CommandType = CommandType.StoredProcedure; cmd.Transaction = tran; for (var i = 0; i <= rds.RmProduceDetail.Rows.Count - 1; i++) { cmd.Parameters.Clear(); dGridMain.CurrentRowIndex = i; cmd.Parameters.AddWithValue("@cGuid", cGuid); cmd.Parameters.AddWithValue("@ID", rds.RmProduceDetail.Rows[i]["AutoID"]); cmd.Parameters.AddWithValue("@FItemID", rds.RmProduceDetail.Rows[i]["FItemID"]); cmd.Parameters.AddWithValue("@cBarCode", rds.RmProduceDetail.Rows[i]["cBarCode"]); cmd.Parameters.AddWithValue("@cCode", rds.RmProduceDetail.Rows[i]["cCode"]); cmd.Parameters.AddWithValue("@cLotNo", rds.RmProduceDetail.Rows[i]["cLotNo"]); cmd.Parameters.AddWithValue("@cInvCode", rds.RmProduceDetail.Rows[i]["cInvCode"]); cmd.Parameters.AddWithValue("@cInvName", rds.RmProduceDetail.Rows[i]["cInvName"]); cmd.Parameters.AddWithValue("@iQuantity", rds.RmProduceDetail.Rows[i]["iQuantity"]); cmd.Parameters.AddWithValue("@FSPNumber", rds.RmProduceDetail.Rows[i]["FSPNumber"]); cmd.Parameters.AddWithValue("@dScanTime", rds.RmProduceDetail.Rows[i]["dAddTime"]); cmd.Parameters.AddWithValue("@cBoxNumber", rds.RmProduceDetail.Rows[i]["cBoxNumber"]); cmd.Parameters.AddWithValue("@cOperator", rds.RmProduceDetail.Rows[i]["cUser"]); cmd.Parameters.AddWithValue("@cMemo", ""); try { var iTem = cmd.ExecuteNonQuery(); } catch (Exception ex) { _sumException += 1; tran.Rollback(); MessageBox.Show(@"无法连接到SQL服务器,请重试! " + ex.Message, @"Warning"); return(false); } } try { cmd.CommandText = "AddMidOrder"; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@cGuid", cGuid); cmd.Parameters.AddWithValue("@cType", "领料出库"); cmd.Parameters.AddWithValue("@cTable", "Rm_ProduceDetail"); cmd.Parameters.AddWithValue("@cOrderNumber", lblOrderNumber.Text); cmd.ExecuteNonQuery(); tran.Commit(); var dSqliteCmd = new SQLiteCommand("Delete from RmProduceDetail where cCode=@cCode"); //成功后,删除离线出库数据中的表 dSqliteCmd.Parameters.AddWithValue("@cCode", lblOrderNumber.Text); PDAFunction.ExecSqLite(dSqliteCmd); return(true); } catch (Exception ex) { MessageBox.Show(@"无法连接到SQL服务器,请重试! " + ex.Message, @"Warning"); return(false); } } } }
/// <summary> /// 保存出库扫描,并重新进入出库单号的扫描获取 /// </summary> private void SaveOutWareHouse(string cSerialNumber, string cInvCode, string cInvName, decimal iQuantity, string cLotNo, string FitemID) { var bInv = new SQLiteCommand("select iScanQuantity,iQuantity,FitemID,FEntryID from RmPo where cInvCode=@cInvCode and cOrderNumber=@cOrderNumber"); bInv.Parameters.AddWithValue("@cInvCode", cInvCode); bInv.Parameters.AddWithValue("@cOrderNumber", lblOrderNumber.Text); var dt = PDAFunction.GetSqLiteTable(bInv); if (dt == null || dt.Rows.Count < 1) { MessageBox.Show(@"获取数据出错!"); return; } //var PlusCmd = new SQLiteCommand("update RmPo set iScanQuantity=ifnull(iScanQuantity,0)+@iQuantity where cOrderNumber=@cOrderNumber and cInvCode=@cInvCode "); //PlusCmd.Parameters.AddWithValue("@cOrderNumber", lblOrderNumber.Text); //PlusCmd.Parameters.AddWithValue("@iQuantity", iQuantity); //PlusCmd.Parameters.AddWithValue("@cInvCode", cInvCode); //PDAFunction.ExecSqLite(PlusCmd); decimal iFSQty = 0, iFQty = 0; for (var i = 0; i < dt.Rows.Count; i++) { try { iFSQty = decimal.Parse(dt.Rows[i]["iScanQuantity"].ToString()); iFQty = decimal.Parse(dt.Rows[i]["iQuantity"].ToString()); } catch (Exception) { MessageBox.Show("无法取得通知单内原料批号的数量"); return; } if ((iFSQty + iQuantity) <= iFQty) { var sqLiteCmd = new SQLiteCommand("insert into RmStoreDetail(cSerialNumber,cOrderNumber,cLotNo,cInvCode,cInvName,iQuantity,cUser,FEntryID,FitemID,FSPNumber) " + "values(@cSerialNumber,@cOrderNumber,@cLotNo,@cInvCode,@cInvName,@iQuantity,@cUser,@FEntryID,@FitemID,@FSPNumber)"); sqLiteCmd.Parameters.AddWithValue("@cSerialNumber", cSerialNumber); sqLiteCmd.Parameters.AddWithValue("@cOrderNumber", lblOrderNumber.Text); sqLiteCmd.Parameters.AddWithValue("@cLotNo", cLotNo); sqLiteCmd.Parameters.AddWithValue("@cInvCode", cInvCode); sqLiteCmd.Parameters.AddWithValue("@cInvName", cInvName); sqLiteCmd.Parameters.AddWithValue("@iQuantity", iQuantity); sqLiteCmd.Parameters.AddWithValue("@cUser", frmLogin.lUser); sqLiteCmd.Parameters.AddWithValue("@FEntryID", dt.Rows[i]["FEntryID"].ToString()); sqLiteCmd.Parameters.AddWithValue("@FitemID", FitemID); sqLiteCmd.Parameters.AddWithValue("@FSPNumber", lblStockPlaceID.Text); PDAFunction.ExecSqLite(sqLiteCmd); var PlusCmd = new SQLiteCommand("update RmPo set iScanQuantity=ifnull(iScanQuantity,0)+@iQuantity where cOrderNumber=@cOrderNumber and cInvCode=@cInvCode and FEntryID=@FEntryID"); PlusCmd.Parameters.AddWithValue("@cOrderNumber", lblOrderNumber.Text); PlusCmd.Parameters.AddWithValue("@iQuantity", iQuantity); PlusCmd.Parameters.AddWithValue("@cInvCode", cInvCode); PlusCmd.Parameters.AddWithValue("@FEntryID", dt.Rows[i]["FEntryID"].ToString()); PDAFunction.ExecSqLite(PlusCmd); txtBarCode.Text = ""; txtBarCode.Focus(); RefreshGrid(); return; } else { var sqLiteCmd = new SQLiteCommand("insert into RmStoreDetail(cSerialNumber,cOrderNumber,cLotNo,cInvCode,cInvName,iQuantity,cUser,FEntryID,FitemID,FSPNumber) " + "values(@cSerialNumber,@cOrderNumber,@cLotNo,@cInvCode,@cInvName,@iQuantity,@cUser,@FEntryID,@FitemID,@FSPNumber)"); sqLiteCmd.Parameters.AddWithValue("@cSerialNumber", cSerialNumber); sqLiteCmd.Parameters.AddWithValue("@cOrderNumber", lblOrderNumber.Text); sqLiteCmd.Parameters.AddWithValue("@cLotNo", cLotNo); sqLiteCmd.Parameters.AddWithValue("@cInvCode", cInvCode); sqLiteCmd.Parameters.AddWithValue("@cInvName", cInvName); sqLiteCmd.Parameters.AddWithValue("@iQuantity", iQuantity); sqLiteCmd.Parameters.AddWithValue("@cUser", frmLogin.lUser); sqLiteCmd.Parameters.AddWithValue("@FEntryID", dt.Rows[i]["FEntryID"].ToString()); sqLiteCmd.Parameters.AddWithValue("@FitemID", FitemID); sqLiteCmd.Parameters.AddWithValue("@FSPNumber", lblStockPlaceID.Text); PDAFunction.ExecSqLite(sqLiteCmd); var PlusCmd = new SQLiteCommand("update RmPo set iScanQuantity=ifnull(iScanQuantity,0)+@iQuantity where cOrderNumber=@cOrderNumber and cInvCode=@cInvCode and FEntryID=@FEntryID"); PlusCmd.Parameters.AddWithValue("@cOrderNumber", lblOrderNumber.Text); PlusCmd.Parameters.AddWithValue("@iQuantity", iQuantity); PlusCmd.Parameters.AddWithValue("@cInvCode", cInvCode); PlusCmd.Parameters.AddWithValue("@FEntryID", dt.Rows[i]["FEntryID"].ToString()); PDAFunction.ExecSqLite(PlusCmd); iQuantity = iQuantity + iFSQty - iFQty; } } txtBarCode.Text = ""; txtBarCode.Focus(); RefreshGrid(); }