/// <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 { }
}
