protected void btnYes_Click(object sender, EventArgs e)
{
string SessionIDName = "CGD231_" + PageTimeStamp.Value;
DataTable Dt = (DataTable)Session[SessionIDName];
DataTable Dt2 = null;
CGDModel.CGDCommon BCOCommon = new CGDModel.CGDCommon();
System.Data.Common.DbTransaction DBT = BCOCommon.OpenAndGetConnection(ConnectionDB).BeginTransaction();
CGDModel.ProcessPickQualityCheck BCO = new CGDModel.ProcessPickQualityCheck(ConntionDB);
try
{
if (Dt != null)
{
//存檔
foreach (DataRow dr in Dt.Rows)
{
ParameterList.Clear();
ParameterList.Add(dr["PICK_NO"].ToString());
ParameterList.Add(dr["ITEM"].ToString());
ParameterList.Add(dr["PERIOD"].ToString());
ParameterList.Add(dr["VIRTUAL_CODE"].ToString());
Dt2 = BCO.Get_VDS_CGD_PICK_BK_ITEM_CK(ParameterList);
if (Dt2.Rows.Count == 0)
{
ParameterList.Clear();
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(dr["PICK_NO"].ToString());
ParameterList.Add(dr["ITEM"].ToString());
ParameterList.Add(dr["VIRTUAL_CODE"].ToString());
ParameterList.Add(dr["PERIOD"].ToString());
ParameterList.Add(dr["CHECK_BATCH"].ToString());
ParameterList.Add(dr["CHECK_QTY"].ToString());
ParameterList.Add(dr["MODIFY_QTY"].ToString());
BCO.Insert_VDS_CGD_PICK_BK_ITEM_CK(ParameterList, DBT);
}
else
{
ParameterList.Clear();
ParameterList.Add(dr["PICK_NO"].ToString());
ParameterList.Add(dr["ITEM"].ToString());
ParameterList.Add(dr["PERIOD"].ToString());
ParameterList.Add(dr["VIRTUAL_CODE"].ToString());
ParameterList.Add(dr["CHECK_QTY"].ToString());
ParameterList.Add(dr["MODIFY_QTY"].ToString());
ParameterList.Add(Session["UID"].ToString());
BCO.UPDATE_VDS_CGD_PICK_BK_ITEM_CK(ParameterList, DBT);
}
}
DBT.Commit();
}
ErrorMsgLabel.Text = "儲存完畢";
//ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD023.aspx", "alert(' 儲存完畢 ');", true);
}
catch (Exception ex)
{
DBT.Rollback();//交易失敗
ErrorMsgLabel.Text = ex.Message;
}
finally { }
txtCheckQty.Enabled = true;
txtModifyQty.ReadOnly = true;
txtModifyQty.BackColor = System.Drawing.Color.LightGray;
btnCancel.Visible = false;
btnYes.Visible = false;
btnEndCheck.Visible = true;
btnEndBox.Visible = true;
btnEndCheck.Enabled = true;
btnEndBox.Enabled = false;
txtRCItemBarcode.Text = "";
ViewState["RCCheckState"] = "N";
ViewState["RCBoxEndState"] = "N";
Response.Redirect("CGD231.aspx?Code=CGD23", false);
}
