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