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 = "";
}
