/// <summary> /// 複製鈕(複製視窗內的) /// </summary> protected void btnSave_Click(object sender, EventArgs e) { #region 輸入檢查 if (SLP_CopyFromDate.Text == "") { ErrorMsgLabel.Text = "舊[門市進貨日]欄位不得空白"; //ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD021.aspx", "alert(' 舊[門市進貨日]欄位不得空白 ');", true); return; } if (txtPickBatchCopyFrom.Text == "") { ErrorMsgLabel.Text = "舊[理貨批次]欄位不得空白"; //ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD021.aspx", "alert(' 舊[理貨批次]欄位不得空白 ');", true); return; } if (SLP_CopyToDate.Text == "") { ErrorMsgLabel.Text = "新[門市進貨日]欄位不得空白"; //ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD021.aspx", "alert(' 新[門市進貨日]欄位不得空白 ');", true); return; } if (Convert.ToDateTime(SLP_CopyToDate.Text) <= DateTime.Now) { ErrorMsgLabel.Text = "新[門市進貨日]欄位不得小於等於系統日"; //ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD021.aspx", "alert(' 新[門市進貨日]欄位不得小於等於系統日 ');", true); return; } if (txtPickBatchCopyTo.Text == "") { ErrorMsgLabel.Text = "新[理貨批次]欄位不得空白"; //ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD021.aspx", "alert(' 新[理貨批次]欄位不得空白 ');", true); return; } #endregion System.IO.TextReader tr; CGDModel.CGDCommon BCOCommon = new CGDModel.CGDCommon(); System.Data.Common.DbTransaction DBT = BCOCommon.OpenAndGetConnection(ConnectionDB).BeginTransaction(); try { CGDModel.MaintainSetRouteOrder BCO = new CGDModel.MaintainSetRouteOrder(ConntionDB); string strWhere = ""; // 檢查新日期是否有資料----------------------------------------------------------------------------------------- #region checking DataTable DtCheckNew; ParameterList.Clear(); ParameterList.Add(this.SLP_CopyToDate.Text.Trim()); ParameterList.Add(this.txtPickBatchCopyTo.Text.Trim()); DtCheckNew = BCO.QuerySwitch(CGDModel.CGDCommon.QueryType.QueryRouteOrder, ParameterList); if (DtCheckNew.Rows.Count > 0) { ErrorMsgLabel.Text = "輸入的新門市進貨日已有資料"; //ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD011.aspx", "alert(' 輸入的新門市進貨日已有資料 ');", true); return; } #endregion // 檢查舊日期是否有資料 , 如有資料則進行複製-------------------------------------------------------------------- #region checking DataTable DtCheckOld; ParameterList.Clear(); ParameterList.Add(this.SLP_CopyFromDate.Text.Trim()); ParameterList.Add(this.txtPickBatchCopyFrom.Text.Trim()); DtCheckOld = BCO.QuerySwitch(CGDModel.CGDCommon.QueryType.QueryRouteOrder, ParameterList); if (DtCheckOld.Rows.Count == 0) { ErrorMsgLabel.Text = "輸入的舊門市進貨日沒有資料可以複製"; //ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD011.aspx", "alert(' 輸入的舊門市進貨日沒有資料可以複製 ');", true); return; } else { for (int i = 0; i <= DtCheckOld.Rows.Count - 1; i++) { ParameterList.Clear(); ParameterListDel.Clear(); ParameterList.Add(DtCheckOld.Rows[i]["NAME"]); ParameterList.Add(DtCheckOld.Rows[i]["CREATEDATE"]); ParameterList.Add(DtCheckOld.Rows[i]["CREATEUID"]); ParameterList.Add(System.DateTime.Now); ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(DtCheckOld.Rows[i]["STATUS"]); ParameterList.Add(DtCheckOld.Rows[i]["ENABLE"]); ParameterList.Add(DtCheckOld.Rows[i]["DPS_CODE"]); ParameterList.Add(Convert.ToDateTime(this.SLP_CopyToDate.Text.Trim())); ParameterList.Add(this.txtPickBatchCopyTo.Text.Trim()); ParameterList.Add(DtCheckOld.Rows[i]["LINE"]); ParameterList.Add(DtCheckOld.Rows[i]["PICK_ORDER"]); ParameterList.Add(DtCheckOld.Rows[i]["ROUTE"]); ParameterList.Add(DtCheckOld.Rows[i]["STORE_CNT"]); BCO.InsertRouteOrder(ParameterList, DBT); } DBT.Commit();//交易成功 } #endregion ErrorMsgLabel.Text = "複製完畢"; //ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD011.aspx", "alert(' 複製完畢 ');", true); } catch (Exception ex) { DBT.Rollback();//交易失敗 ErrorMsgLabel.Text = ex.Message; } btnCloseCopy_Click(null, null); }
/// <summary> /// 儲存鈕 /// </summary> protected void btnSave_Click1(object sender, EventArgs e) { string SessionIDName = "CGD011_" + PageTimeStamp.Value; DataTable Dt = null; DataTable DT_Add = null; DataTable DT_Mod = null; DataTable DT_Del = null; if (Session[SessionIDName] != null) { Dt = (DataTable)Session[SessionIDName]; DT_Add = Dt.GetChanges(DataRowState.Added); DT_Mod = Dt.GetChanges(DataRowState.Modified); DT_Del = Dt.GetChanges(DataRowState.Deleted); } else { ErrorMsgLabel.Text = "目前無資料異動"; //ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD011.aspx", "alert(' 目前無資料異動 ');", true); return; } if (DT_Add == null && DT_Mod == null && DT_Del == null) { ErrorMsgLabel.Text = "目前無資料異動"; //ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD011.aspx", "alert(' 目前無資料異動 ');", true); return; } CGDModel.CGDCommon BCOCommon = new CGDModel.CGDCommon(); System.Data.Common.DbTransaction DBT = BCOCommon.OpenAndGetConnection(ConnectionDB).BeginTransaction(); CGDModel.MaintainSetRouteOrder BCO = new CGDModel.MaintainSetRouteOrder(ConntionDB); try { //刪除---------------------------------------------------------------------------------------------------------- if (DT_Del != null) { foreach (DataRow dRow in DT_Del.Rows) { ParameterList.Clear(); ParameterList.Add(dRow["PICK_BATCH", DataRowVersion.Original].ToString()); ParameterList.Add(Convert.ToDateTime(dRow["ST_ACCEPT_DATE", DataRowVersion.Original].ToString()).ToShortDateString()); ParameterList.Add(dRow["ROUTE", DataRowVersion.Original].ToString()); ParameterList.Add(Convert.ToDateTime(dRow["UPDATEDATE", DataRowVersion.Original].ToString())); ParameterList.Add(dRow["UPDATEUID", DataRowVersion.Original].ToString()); string MSG = BCO.DeleteRouteOrder(ParameterList, DBT); if (MSG == "NODATA") { throw new Exception("DB_NODATA"); } } } //新增---------------------------------------------------------------------------------------------------------- if (DT_Add != null) { foreach (DataRow dRow in DT_Add.Rows) { ParameterList.Clear(); if (DT_Add.Columns.Contains("NAME").ToString() == "True") { ParameterList.Add(dRow["NAME"]); } else { ParameterList.Add(dRow["LINE"].ToString() + "-" + dRow["ROUTE"].ToString()); } ParameterList.Add(dRow["CREATEDATE"]); ParameterList.Add(dRow["CREATEUID"]); ParameterList.Add(dRow["UPDATEDATE"]); ParameterList.Add(dRow["UPDATEUID"]); if (DT_Add.Columns.Contains("STATUS").ToString() == "True") { ParameterList.Add(dRow["STATUS"]); } else { ParameterList.Add(0); } ParameterList.Add(dRow["ENABLE"]); ParameterList.Add(dRow["DPS_CODE"]); ParameterList.Add(Convert.ToDateTime(dRow["ST_ACCEPT_DATE"]).ToShortDateString()); ParameterList.Add(dRow["PICK_BATCH"]); ParameterList.Add(dRow["LINE"]); ParameterList.Add(dRow["PICK_ORDER"]); ParameterList.Add(dRow["ROUTE"]); ParameterList.Add(dRow["STORE_CNT"]); BCO.InsertRouteOrder(ParameterList, DBT); } } //修改---------------------------------------------------------------------------------------------------------- if (DT_Mod != null) { foreach (DataRow dRow in DT_Mod.Rows) { ParameterList.Clear(); ParameterList.Add(dRow["UPDATEUID", DataRowVersion.Current].ToString()); ParameterList.Add(dRow["NAME", DataRowVersion.Current].ToString()); ParameterList.Add(dRow["DPS_CODE", DataRowVersion.Current].ToString()); ParameterList.Add(dRow["ST_ACCEPT_DATE", DataRowVersion.Current]); ParameterList.Add(dRow["PICK_BATCH", DataRowVersion.Current].ToString()); ParameterList.Add(dRow["LINE", DataRowVersion.Current].ToString()); ParameterList.Add(dRow["PICK_ORDER", DataRowVersion.Current].ToString()); ParameterList.Add(dRow["ROUTE", DataRowVersion.Current].ToString()); ParameterList.Add(Convert.ToInt32(dRow["STORE_CNT", DataRowVersion.Current].ToString())); ParameterList.Add(Convert.ToDateTime(dRow["CREATEDATE", DataRowVersion.Original].ToString())); ParameterList.Add(dRow["CREATEUID", DataRowVersion.Original].ToString()); ParameterList.Add(Convert.ToDateTime(dRow["UPDATEDATE", DataRowVersion.Original].ToString())); ParameterList.Add(dRow["UPDATEUID", DataRowVersion.Original].ToString()); ParameterList.Add(Convert.ToInt16(dRow["STATUS", DataRowVersion.Original].ToString())); ParameterList.Add(Convert.ToInt16(dRow["ENABLE", DataRowVersion.Original].ToString())); ParameterList.Add(dRow["NAME", DataRowVersion.Original].ToString()); ParameterList.Add(dRow["DPS_CODE", DataRowVersion.Original].ToString()); ParameterList.Add(dRow["ST_ACCEPT_DATE", DataRowVersion.Original].ToString()); ParameterList.Add(dRow["PICK_BATCH", DataRowVersion.Original].ToString()); ParameterList.Add(dRow["LINE", DataRowVersion.Original].ToString()); ParameterList.Add(dRow["PICK_ORDER", DataRowVersion.Original].ToString()); ParameterList.Add(dRow["ROUTE", DataRowVersion.Original].ToString()); ParameterList.Add(Convert.ToInt32(dRow["STORE_CNT", DataRowVersion.Original].ToString())); string MSG = BCO.UpdateRouteOrder(ParameterList, DBT); if (MSG == "NODATA") { throw new Exception("DB_NODATA"); } } } DBT.Commit();//交易成功 btnQuery_Click(null, null); ErrorMsgLabel.Text = "儲存完畢"; //ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD011.aspx", "alert(' 儲存完畢 ');", true); } catch (Exception ex) { DBT.Rollback();//交易失敗 if (ex.Message.IndexOf("違反必須為唯一的限制條件") > 0) { ErrorMsgLabel.Text = "新增之站所已重複"; //ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD281.aspx", "alert(' 新增之站所已重複 ');", true); return; } if (ex.Message.IndexOf("NODATA") > 0) { ErrorMsgLabel.Text = "原資料已異動過,請重新查詢資料後再作處理"; //ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD281.aspx", "alert(' 原資料已異動過,請重新查詢資料後再作處理 ');", true); return; } ErrorMsgLabel.Text = ex.Message; } finally { } }