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();
}
