/// <summary> /// 儲存鈕 /// </summary> protected void btnAddDetail_Click(object sender, EventArgs e) { if (txtNB_LOCATE_SUM.Text == "") txtNB_LOCATE_SUM.Text = "0"; if (txtNB_ITEM_COUNT.Text == "") txtNB_ITEM_COUNT.Text = "0"; if (Convert.ToInt32(txtNB_ITEM_COUNT.Text) != Convert.ToInt32(txtNB_LOCATE_SUM.Text)) { ErrorMsgLabel.Text = "開站儲位與理貨商品的品項數不符"; //ScriptManager.RegisterClientScriptBlock(Page, this.GetType(), "A", "alert(' 開站儲位與理貨商品的品項數不符 ');", true); return; } string SessionIDName = "CGD032_" + 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(), "CGD032.aspx", "alert(' 目前無資料異動 ');", true); return; } if (DT_Add == null && DT_Mod == null && DT_Del == null) { ErrorMsgLabel.Text = "目前無資料異動"; //ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD032.aspx", "alert(' 目前無資料異動 ');", true); return; } CGDModel.CGDCommon BCOCommon = new CGDModel.CGDCommon(); System.Data.Common.DbTransaction DBT = BCOCommon.OpenAndGetConnection(ConnectionDB).BeginTransaction(); CGDModel.MaintainPickLocate BCO = new CGDModel.MaintainPickLocate(ConntionDB); try { if (userMode == "Edit") { //修改---------------------------------------------------------------------------------------------------------- foreach (DataRow dRow in Dt.Rows) { ParameterList.Clear(); ParameterList.Add(dRow["STATION_OPEN", DataRowVersion.Current].ToString()); ParameterList.Add(Convert.ToInt32(dRow["LOCATE_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(Convert.ToDateTime(dRow["ST_ACCEPT_DATE", DataRowVersion.Original].ToString())); ParameterList.Add(dRow["PICK_BATCH", DataRowVersion.Original].ToString()); ParameterList.Add(dRow["DPS_CODE", DataRowVersion.Original].ToString()); ParameterList.Add(dRow["STATION_NO", DataRowVersion.Original].ToString()); ParameterList.Add(Convert.ToInt32(dRow["LOCATE_CNT", DataRowVersion.Original].ToString())); ParameterList.Add(dRow["STATION_OPEN", DataRowVersion.Original].ToString()); //---新增時所需資料 ParameterList.Add(Session["UID"]); ParameterList.Add(Session["UID"]); ParameterList.Add(1); ParameterList.Add(Convert.ToDateTime(this.hidSLPDate1.Text.Trim())); ParameterList.Add(this.hidtxtPickBatch.Text.Trim()); ParameterList.Add(this.ddlDPS_CODE.SelectedItem.Text.Trim()); ParameterList.Add(dRow["STATION_NO"]); ParameterList.Add(dRow["LOCATE_CNT"]); ParameterList.Add(dRow["STATION_OPEN"]); string MSG = BCO.Update_VDS_CGD_PICK_STATION(ParameterList, DBT); if (MSG == "NODATA") { throw new Exception("DB_NODATA"); } } } //新增---------------------------------------------------------------------------------------------------------- if (userMode == "Insert") { foreach (DataRow dRow in Dt.Rows) { ParameterList.Clear(); ParameterList.Add(Session["UID"]); ParameterList.Add(Session["UID"]); ParameterList.Add(1); ParameterList.Add(Convert.ToDateTime(this.hidSLPDate1.Text.Trim())); ParameterList.Add(this.hidtxtPickBatch.Text.Trim()); ParameterList.Add(this.ddlDPS_CODE.SelectedItem.Text.Trim()); ParameterList.Add(dRow["STATION_NO"]); ParameterList.Add(dRow["LOCATE_CNT"]); ParameterList.Add(dRow["STATION_OPEN"]); BCO.Insert_VDS_CGD_PICK_STATION(ParameterList, DBT); } } DBT.Commit();//交易成功 //從DB讀取最新資料 Dt = null; ParameterList.Clear(); ParameterList.Add(this.ddlDPS_CODE.SelectedItem.Text.Trim()); ParameterList.Add(this.hidSLPDate1.Text.Trim()); ParameterList.Add(this.hidtxtPickBatch.Text.Trim()); Dt = BCO.QuerySwitch(CGDModel.CGDCommon.QueryType.QueryPickStation, ParameterList); Session[SessionIDName] = Dt; userMode = "Edit"; ErrorMsgLabel.Text = "儲存完畢"; //ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD032.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 { } //Response.Redirect(string.Format("CGD031.aspx?Code=CGD03&StAcceptDate={0}&PickBatch={1}&ChanNo={2}&AreaPercent={3}", hidStAcceptDate.Text, hidPickBatch.Text, hidChanNo.Text, hidAreaPercent.Text), false); }
/// <summary> /// databind 繫結查詢資料到GridView /// </summary> private void databind() { //抓取本頁初次登記的時間 string SessionIDName = "CGD032_" + PageTimeStamp.Value; CGDModel.MaintainPickLocate BCO = new CGDModel.MaintainPickLocate(ConntionDB); DataTable Dt; ParameterList.Clear(); ParameterList.Add(this.ddlDPS_CODE.SelectedItem.Text.Trim()); ParameterList.Add(this.hidSLPDate1.Text.Trim()); ParameterList.Add(this.hidtxtPickBatch.Text.Trim()); Dt = BCO.QuerySwitch(CGDModel.CGDCommon.QueryType.QueryPickStation, ParameterList); if (Dt.Rows.Count == 0) { userMode = "Insert"; ParameterList.Clear(); Dt = BCO.QuerySwitch(CGDModel.CGDCommon.QueryType.QueryDefaultStation, ParameterList); } else { userMode = "Edit"; } #region 計算開始儲位累計 int tempNB_LOCATE_SUM = 0; for (int i = 0; i <= Dt.Rows.Count - 1; i++) { tempNB_LOCATE_SUM += (Dt.Rows[i]["LOCATE_CNT"].ToString() == "") ? Convert.ToInt32("0") : Convert.ToInt32(Dt.Rows[i]["LOCATE_CNT"].ToString()); } txtNB_LOCATE_SUM.Text = Convert.ToString(tempNB_LOCATE_SUM); #endregion Session[SessionIDName] = Dt; DataView DV1 = Dt.DefaultView; DV1.RowFilter = "rownum <= " + TextBoxRowCountLimit.Text.Trim(); GridView1.DataSource = DV1; GridView1.Visible = true; //設定分頁大小 GridView1.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text); GridView1.PageIndex = 0; GridView1.DataBind(); }
/// <summary> /// 儲存鈕 /// </summary> protected void btnSave_Click(object sender, EventArgs e) { if (txtChanNo.Text == "") { ErrorMsgLabel.Text = "請先執行[商品擷取]"; //ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD031.aspx", "alert(' 請先執行[商品擷取] ');", true); return; } string checkResult = CheckPickLocateSum(); if (checkResult != txtChanNo.Text) { ErrorMsgLabel.Text = "開站儲位與理貨商品的品項數不符"; //ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD031.aspx", "alert(' 開站儲位與理貨商品的品項數不符 ');", true); return; } string SessionIDName = "CGD031_" + PageTimeStamp.Value; DataTable Dt = (DataTable)Session[SessionIDName]; CGDModel.CGDCommon BCOCommon = new CGDModel.CGDCommon(); System.Data.Common.DbTransaction DBT = BCOCommon.OpenAndGetConnection(ConnectionDB).BeginTransaction(); try { //刪除 ParameterList.Clear(); //ParameterList.Add(hidSLPDate.Text); //ParameterList.Add(hidPickBatch.Text); ParameterList.Add(SLP_StAcceptDate.Text); ParameterList.Add(txtPickBatch.Text); CGDModel.MaintainPickLocate BCO = new CGDModel.MaintainPickLocate(ConntionDB); BCO.DeletePickLocate(ParameterList, DBT); //新增 for (int i = 0; i <= Dt.Rows.Count - 1; i++) { ParameterList.Clear(); ParameterList.Add(Dt.Rows[i]["NAME"]); ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(Dt.Rows[i]["STATUS"]); if (Dt.Rows[i]["ST_ACCEPT_DATE"].ToString() == "") { ParameterList.Add(SLP_StAcceptDate.Text); } else { ParameterList.Add(Dt.Rows[i]["ST_ACCEPT_DATE"]); } if (Dt.Rows[i]["PICK_BATCH"].ToString() == "") { ParameterList.Add(txtPickBatch.Text); } else { ParameterList.Add(Dt.Rows[i]["PICK_BATCH"]); } ParameterList.Add(Dt.Rows[i]["NUM"]); if (Dt.Rows[i]["STATION_NO"].ToString() == "") { DBT.Rollback();//交易失敗 ErrorMsgLabel.Text = "請先執行儲位設定"; //ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD031.aspx", "alert(' 請先執行[儲位設定] ');", true); return; } else { ParameterList.Add(Dt.Rows[i]["STATION_NO"]); } if (Dt.Rows[i]["LOCATE_NO"].ToString() == "") { DBT.Rollback();//交易失敗 ErrorMsgLabel.Text = "請先執行儲位設定"; //ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD031.aspx", "alert(' 請先執行[儲位設定] ');", true); return; } else { ParameterList.Add(Dt.Rows[i]["LOCATE_NO"]); } ParameterList.Add(Dt.Rows[i]["ITEM"]); ParameterList.Add(Dt.Rows[i]["PERIOD"]); ParameterList.Add(Dt.Rows[i]["ITEM_NAME"]); ParameterList.Add(Dt.Rows[i]["VIRTUAL_CODE"]); ParameterList.Add(Dt.Rows[i]["VIRTUAL_NAME"]); ParameterList.Add(Dt.Rows[i]["BARCODE"]); ParameterList.Add(Dt.Rows[i]["PERIOD_BARCODE"]); ParameterList.Add(Dt.Rows[i]["S_LENGTH"]); ParameterList.Add(Dt.Rows[i]["S_WIDTH"]); ParameterList.Add(Dt.Rows[i]["S_HEIGHT"]); ParameterList.Add(Dt.Rows[i]["S_WEIGHT"]); ParameterList.Add(Dt.Rows[i]["P_LENGTH"]); ParameterList.Add(Dt.Rows[i]["P_WIDTH"]); ParameterList.Add(Dt.Rows[i]["P_HEIGHT"]); ParameterList.Add(Dt.Rows[i]["P_WEIGHT"]); ParameterList.Add(Dt.Rows[i]["PMA"]); ParameterList.Add(Dt.Rows[i]["DPS_STATUS"]); ParameterList.Add(Dt.Rows[i]["DPS_UP_TIME"]); ParameterList.Add(Dt.Rows[i]["PICK_QTY"]); BCO.Insert_VDS_CGD_PICK_LOCATE(ParameterList, DBT); } DBT.Commit();//交易成功 ErrorMsgLabel.Text = "儲存完畢"; //ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD031.aspx", "alert(' 儲存完畢 ');", true); } catch (Exception ex) { DBT.Rollback();//交易失敗 ErrorMsgLabel.Text = ex.Message; } finally { } }
/// <summary> /// 檢查商品資料是否已截取 /// </summary> private string CheckPickData() { CGDModel.MaintainPickLocate BCO = new CGDModel.MaintainPickLocate(ConntionDB); ParameterList.Clear(); ParameterList.Add(hidSLPDate1.Text.Trim()); ParameterList.Add(hidtxtPickBatch.Text.Trim()); return BCO.CheckPickData(ParameterList); }
/// <summary> /// 擷取1對多的工作站代號 /// </summary> private void GetMultiStationNo() { CGDModel.MaintainPickLocate BCO = new CGDModel.MaintainPickLocate(ConntionDB); DataTable Dt; ParameterList.Clear(); ParameterList.Add(this.SLP_StAcceptDate.Text.Trim()); ParameterList.Add(this.txtPickBatch.Text.Trim()); Dt = BCO.QuerySwitch(CGDModel.CGDCommon.QueryType.GetMultiStationNo, ParameterList); if (Dt.Rows.Count != 0) { MultiStationNo.InnerHtml = Dt.DataSet.GetXml(); } else { MultiStationNo.InnerHtml = ""; } }
/// <summary> /// 判斷1對多工作站的儲格商品是否有單店的數量大於等於100 /// </summary> private DataTable CheckMultiStationItem(string StAcceptDate, string PickBatch, string Item, string Period, string VirtualCode) { CGDModel.MaintainPickLocate BCO = new CGDModel.MaintainPickLocate(ConntionDB); ParameterList.Clear(); ParameterList.Add(StAcceptDate); ParameterList.Add(PickBatch); ParameterList.Add(Item); ParameterList.Add(Period); ParameterList.Add(VirtualCode); return BCO.QuerySwitch(CGDModel.CGDCommon.QueryType.CheckMultiStationItem, ParameterList); }
/// <summary> /// 商品擷取 /// </summary> private void GetPickItem() { if (Verify_GetPickItem() == true) { //----執行 Procedure VDS_CGD_CGD03-------------------------------------------------------------------------------- CGDModel.MaintainPickLocate BCO = new CGDModel.MaintainPickLocate(ConntionDB); Int32 ITEM_CNT = 0; string rtnMsg = ""; DataTable Dt = null; ParameterList.Clear(); ParameterList.Add(this.SLP_StAcceptDate.Text.Trim()); ParameterList.Add(this.txtPickBatch.Text.Trim()); ParameterList.Add(Convert.ToDouble(this.txtAreaPercent.Text.ToString())); ParameterList.Add(100 - Convert.ToDouble(this.txtAreaPercent.Text.ToString())); ParameterList.Add(Session["UID"].ToString().Trim()); Dt = BCO.GetPickItem(ParameterList, ref ITEM_CNT); string CheckResult = BCO.Procedure_VDS_CGD_CGD03(ParameterList, ref rtnMsg); if (rtnMsg != "") ErrorMsgLabel.Text = rtnMsg; if (CheckResult == "1") { //----GetPickItem------------(理貨儲位分派資料)---------------------------------------------------------------- //抓取本頁初次登記的時間 string SessionIDName = "CGD031_" + PageTimeStamp.Value; ParameterList.Clear(); ParameterList.Add(this.SLP_StAcceptDate.Text.Trim()); ParameterList.Add(this.txtPickBatch.Text.Trim()); ParameterList.Add(Session["UID"].ToString().Trim()); Dt = BCO.GetPickItem(ParameterList, ref ITEM_CNT); txtChanNo.Text = Convert.ToString(ITEM_CNT); if (Dt.Rows.Count == 0) { ErrorMsgLabel.Text = "查無理貨儲位分派資料"; //ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD031.aspx", "alert(' 查無理貨儲位分派資料 ');", true); } Dt = setRowNum(Dt); Session[SessionIDName] = Dt; DataView DV1 = Dt.DefaultView; DV1.RowFilter = "ID <= " + Convert.ToString(Convert.ToInt32(TextBoxRowCountLimit.Text.Trim()) - 1); GridView1.DataSource = DV1; GridView1.Visible = true; //設定分頁大小 GridView1.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text); GridView1.PageIndex = 0; GridView1.DataBind(); //----GetPickOutItem------------(非理貨商品門市資料)-------------------------------------------------------------- //抓取本頁初次登記的時間 string SessionIDName2 = "CGD031_2_" + PageTimeStamp.Value; DataTable Dt2; ParameterList.Clear(); ParameterList.Add(this.SLP_StAcceptDate.Text.Trim()); ParameterList.Add(this.txtPickBatch.Text.Trim()); Dt2 = BCO.QuerySwitch(CGDModel.CGDCommon.QueryType.GetPickOutItem, ParameterList); if (Dt.Rows.Count == 0) { ErrorMsgLabel.Text = "查無非理貨商品門市資料"; //ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD031.aspx", "alert(' 查無非理貨商品門市資料 ');", true); } Session[SessionIDName2] = Dt2; DataView DV2 = Dt2.DefaultView; DV2.RowFilter = "rownum <= " + TextBoxRowCountLimit.Text.Trim(); GridView2.DataSource = DV2; GridView2.Visible = true; //設定分頁大小 GridView2.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text); GridView2.PageIndex = 0; GridView2.DataBind(); btnSetStation.Enabled = true; btnSetLocate.Enabled = true; } else { ErrorMsgLabel.Text = "[Procedure VDS_CGD_CGD03]執行失敗"; //ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD031.aspx", "alert(' [Procedure VDS_CGD_CGD03]執行失敗 ');", true); return; } } }
/// <summary> /// 工作站比重檢核 /// </summary> private string CheckPickLocateWeight(string StAcceptDate, string PickBatch, string STATION_NO, Int32 WeightPercent) { CGDModel.MaintainPickLocate BCO = new CGDModel.MaintainPickLocate(ConntionDB); ParameterList.Clear(); ParameterList.Add(StAcceptDate); ParameterList.Add(PickBatch); ParameterList.Add(STATION_NO); ParameterList.Add(WeightPercent); return BCO.CheckPickLocateWeight(ParameterList); }
/// <summary> /// databind 繫結查詢資料到GridView /// </summary> private void databind() { //抓取本頁初次登記的時間 string SessionIDName = "CGD031_" + PageTimeStamp.Value; CGDModel.MaintainPickLocate BCO = new CGDModel.MaintainPickLocate(ConntionDB); DataTable Dt; ParameterList.Clear(); ParameterList.Add(this.SLP_StAcceptDate.Text.Trim()); ParameterList.Add(this.txtPickBatch.Text.Trim()); Dt = BCO.QuerySwitch(CGDModel.CGDCommon.QueryType.QueryPickLocate, ParameterList); if (Dt.Rows.Count == 0) { ErrorMsgLabel.Text = "查無資料"; //ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD031.aspx", "alert(' 查無資料 ');", true); GridView1.Visible = false; return; } #region 品項數 Int32 ITEM_CNT = 0; DataTable Dt2 = null; ParameterList.Clear(); ParameterList.Add(this.SLP_StAcceptDate.Text.Trim()); ParameterList.Add(this.txtPickBatch.Text.Trim()); ParameterList.Add(Session["UID"].ToString().Trim()); BCO.GetQueryPickItem(ParameterList, ref ITEM_CNT); txtChanNo.Text = Convert.ToString(ITEM_CNT); #endregion Session[SessionIDName] = Dt; DataView DV1 = Dt.DefaultView; DV1.RowFilter = "rownum <= " + Convert.ToString(Convert.ToInt32(TextBoxRowCountLimit.Text.Trim()) - 1); GridView1.DataSource = DV1; GridView1.Visible = true; //設定分頁大小 GridView1.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text); GridView1.PageIndex = 0; GridView1.DataBind(); }
/// <summary> /// 判斷工作站開站的儲位數是否等於品項數 /// </summary> private string CheckPickLocateSum() { //抓取本頁初次登記的時間 string SessionIDName = "CGD031_" + PageTimeStamp.Value; CGDModel.MaintainPickLocate BCO = new CGDModel.MaintainPickLocate(ConntionDB); ParameterList.Clear(); ParameterList.Add(this.SLP_StAcceptDate.Text.Trim()); ParameterList.Add(this.txtPickBatch.Text.Trim()); return BCO.GetPickLocateSum(ParameterList); }
/// <summary> /// 列印鈕 /// </summary> protected void btnPrintReport_Click(object sender, EventArgs e) { //if (VerifyFormData() == true) //{ try { ErrorMsgLabel.Text = ""; this.hid_PageStatus.Value = "PRINT"; //抓取本頁初次登記的時間 string SessionIDName = "CGD031_" + PageTimeStamp.Value; CGDModel.MaintainPickLocate BCO = new CGDModel.MaintainPickLocate(ConntionDB); DataTable Dt; ParameterList.Clear(); ParameterList.Add(this.SLP_StAcceptDate.Text.Trim()); ParameterList.Add(this.txtPickBatch.Text.Trim()); Dt = BCO.QuerySwitch(CGDModel.CGDCommon.QueryType.REPORT, ParameterList); if (Dt.Rows.Count == 0) { this.hid_PageStatus.Value = "QUERY"; ErrorMsgLabel.Text = "查無資料"; //ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD031.aspx", "alert(' 查無資料 ');", true); CrystalReportViewer1.Visible = false; return; } else { #region 顯示報表 string s_FileName = ""; //設定輸出檔名 string s_rptFilePath = ""; //設定報表路徑 s_rptFilePath = Server.MapPath("./REPORT/CGD031.rpt"); s_FileName = HttpUtility.UrlEncode("理貨商品儲位分派處理.PDF", System.Text.Encoding.UTF8); LoadCrystalReport(s_FileName, s_rptFilePath, Dt, "PDF"); #endregion } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } finally { } //} }
/// <summary> /// 整批刪除鈕 /// </summary> protected void btnPatchDelete_Click(object sender, EventArgs e) { try { CGDModel.MaintainPickLocate BCO = new CGDModel.MaintainPickLocate(ConntionDB); DataTable Dt; ParameterList.Clear(); ParameterList.Add(this.SLP_StAcceptDate.Text.Trim()); ParameterList.Add(this.txtPickBatch.Text.Trim()); ParameterList.Add(Session["UID"].ToString()); BCO.DeleteBatch(ParameterList, null); GridView1.Visible = false; ErrorMsgLabel.Text = "刪除完畢"; //ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD031.aspx", "alert(' 刪除完畢 ');", true); } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } finally { } }
/// <summary> /// 匯出鈕 /// </summary> protected void btnExport_Click(object sender, EventArgs e) { try { //---讀取資料 CGDModel.MaintainPickLocate BCO = new CGDModel.MaintainPickLocate(ConntionDB); DataTable Dt; ParameterList.Clear(); ParameterList.Add(this.SLP_StAcceptDate.Text.Trim()); ParameterList.Add(this.txtPickBatch.Text.Trim()); Dt = BCO.QuerySwitch(CGDModel.CGDCommon.QueryType.Label, ParameterList); if (Dt.Rows.Count == 0) { ErrorMsgLabel.Text = "查無資料"; //ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD031.aspx", "alert(' 查無資料 ');", true); return; } //---輸出至文字檔 System.Text.StringBuilder sb_Out_String = new System.Text.StringBuilder(); Response.Clear(); Response.Buffer = true; Response.Charset = "BIG5"; string StAcceptDay = SLP_StAcceptDate.Text.Substring(5, 2); Response.AppendHeader("Content-Disposition", "attachment;filename=" + Server.UrlEncode("EAHT" + StAcceptDay + txtPickBatch.Text + "x.txt")); Response.ContentEncoding = System.Text.Encoding.GetEncoding("BIG5"); Response.ContentType = "application/ms-txt"; this.EnableViewState = false; System.IO.StringWriter oStringWriter = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter oHtmlTextWriter = new HtmlTextWriter(oStringWriter); foreach (DataRow dRow in Dt.Rows) { sb_Out_String.Remove(0, sb_Out_String.Length); sb_Out_String.Append(dRow["DATA"].ToString()); Response.Write(sb_Out_String.ToString()); Response.Write(oHtmlTextWriter.NewLine); } Response.End(); ErrorMsgLabel.Text = "匯出完畢"; //ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD031.aspx", "alert(' 匯出完畢 ');", true); } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } finally { } }
/// <summary> /// 1對多儲位商品數量檢核鈕 /// </summary> protected void btnCheckCount_Click(object sender, EventArgs e) { ErrorMsgLabel.Text = ""; string SessionIDName = "CGD031_" + PageTimeStamp.Value; string SessionIDName3 = "CGD031_3_" + PageTimeStamp.Value; string checkResult = ""; DataTable Dt = (DataTable)Session[SessionIDName]; CGDModel.MaintainPickLocate BCO = new CGDModel.MaintainPickLocate(ConntionDB); ParameterList.Clear(); ParameterList.Add(this.SLP_StAcceptDate.Text.Trim()); ParameterList.Add(this.txtPickBatch.Text.Trim()); DataTable Dt2 = BCO.QuerySwitch(CGDModel.CGDCommon.QueryType.GetMultiStationNo, ParameterList); DataTable Dt3 = null; DataTable Dt4 = null; hidSLPDate.Text = SLP_StAcceptDate.Text; hidPickBatch.Text = txtPickBatch.Text; try { for (int i = 0; i <= Dt.Rows.Count - 1; i++) { string STATION_NO = Dt.Rows[i]["STATION_NO"].ToString(); string ITEM = Dt.Rows[i]["ITEM"].ToString(); string PERIOD = Dt.Rows[i]["PERIOD"].ToString(); string VIRTUAL_CODE = Dt.Rows[i]["VIRTUAL_CODE"].ToString(); for (int k = 0; k <= Dt2.Rows.Count - 1; k++) { if (STATION_NO == Dt2.Rows[k]["STATION_NO"].ToString().Trim()) { Dt3 = CheckMultiStationItem(hidSLPDate.Text.Trim(), hidPickBatch.Text.Trim(), ITEM, PERIOD, VIRTUAL_CODE); if (Dt3.Rows.Count != 0) { if (Dt4 == null) { Dt4 = Dt3.Copy(); } else { Dt4.Merge(Dt3); } } } } } if (Dt4 != null) { Session[SessionIDName3] = Dt4; DataView DV1 = Dt4.DefaultView; DV1.RowFilter = "rownum <= " + Convert.ToString(Convert.ToInt32(TextBoxRowCountLimit.Text.Trim()) - 1); GridView3.DataSource = DV1; GridView3.Visible = true; //設定分頁大小 GridView3.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text); GridView3.PageIndex = 0; GridView3.DataBind(); } else { GridView3.Visible = false; ErrorMsgLabel.Text = "查無儲格商品單店數量大於等於100之資料"; //ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD031.aspx", "alert(' 查無儲格商品單店數量大於等於100之資料 ');", true); } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } finally { } }
/// <summary> /// 儲位設定鈕 /// </summary> protected void btnSetLocate_Click(object sender, EventArgs e) { if (txtChanNo.Text == "") { ErrorMsgLabel.Text = "請先執行[商品擷取]"; //ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD031.aspx", "alert(' 請先執行[商品擷取] ');", true); return; } try { ErrorMsgLabel.Text = ""; string checkResult = CheckPickLocateSum(); if (checkResult != txtChanNo.Text) { ErrorMsgLabel.Text = "開站儲位與理貨商品的品項數不符"; //ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD031.aspx", "alert(' 開站儲位與理貨商品的品項數不符 ');", true); return; } else { //讀取儲位設定資料 CGDModel.MaintainPickLocate BCO = new CGDModel.MaintainPickLocate(ConntionDB); DataTable Dt; ParameterList.Clear(); ParameterList.Add(this.SLP_StAcceptDate.Text.Trim()); ParameterList.Add(this.txtPickBatch.Text.Trim()); Dt = BCO.QuerySwitch(CGDModel.CGDCommon.QueryType.SetPickLocateNo, ParameterList); //將儲位設定資料合併入存在Session中的商品擷取資料 string SessionIDName = "CGD031_" + PageTimeStamp.Value; DataTable Dt2 = (DataTable)Session[SessionIDName]; for (int i = 0; i <= Dt2.Rows.Count - 1; i++) { Dt2.Rows[i]["NUM"] = Dt.Rows[i]["NUM"]; Dt2.Rows[i]["STATION_NO"] = Dt.Rows[i]["STATION_NO"]; Dt2.Rows[i]["LOCATE_NO"] = Dt.Rows[i]["LOCATE_NO"]; } Dt2 = setRowNum(Dt2); Session[SessionIDName] = Dt2; DataView DV1 = Dt2.DefaultView; DV1.RowFilter = "ID <= " + Convert.ToString(Convert.ToInt32(TextBoxRowCountLimit.Text.Trim()) - 1); GridView1.DataSource = DV1; GridView1.Visible = true; //設定分頁大小 GridView1.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text); GridView1.PageIndex = 0; GridView1.DataBind(); } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } finally { } }