/// <summary> /// ALO122頁面取消回來 /// </summary> /// <param name="dis_no">配本序號</param> /// <param name="item">品號</param> /// <param name="period">期別</param> /// <param name="chan_no">通路</param> /// <param name="DIS_TOT_OQTY">通路合計配量</param> /// <param name="N_DIS_TOT_QTY">路線合計配量</param> /// <param name="N_MAX_ROUTE">路線起</param> /// <param name="N_MIN_ROUTE">路線迄</param> //private void Query_Data(string dis_no, string item, string period, string chan_no, string DIS_TOT_OQTY, string N_DIS_TOT_QTY, string N_MAX_ROUTE, string N_MIN_ROUTE) private void Query_Data(string dis_no) { //Session裏的dt變數: //dt -> 配本主檔 //dt1 -> 配本商品 //dt2 -> 營業所 //dt3 -> 配本通路 //dt4 -> 合計欄位:通路店數、通路合計配量 //dt5 -> 配本門市 try { string SessionIDName = ""; ArrayList ParameterList = new ArrayList();//20091113 ParameterList.Clear(); ParameterList.Add(dis_no); //配本序號 ParameterList.Add(System.DBNull.Value); //配本日期 ParameterList.Add(System.DBNull.Value); //門市進貨日 ParameterList.Add(System.DBNull.Value); //確認日期 //查詢配本主檔 DataTable dt = new DataTable(); BCO.MaintainDisRecord bco = new BCO.MaintainDisRecord(ConnectionDB); dt = bco.QueryDisMainFor121(ParameterList, '0'); //btnCancel1_Click(null, null); if (dt.Rows.Count > 0) { btnExport1.Enabled = true; txtDIS_NO.Text = dt.Rows[0]["DIS_NO"].ToString(); SLP_DIS_DATE.Text = dt.Rows[0]["DIS_DATE"].ToString(); SLP_ST_ACCEPT_DATE.Text = dt.Rows[0]["ST_ACCEPT_DATE"].ToString(); SLP_APPROVE_DATE.Text = dt.Rows[0]["APPROVE_DATE"].ToString(); DisableQueryFields(true); if (SLP_APPROVE_DATE.Text == "") EnableButton(true); txtZO_A.Text = "0"; //台北 txtZO_B.Text = "0"; //新竹 txtZO_D.Text = "0"; //台中 txtZO_E.Text = "0"; //嘉義 txtZO_H.Text = "0"; //高雄 txtZO_C.Text = "0"; //總部 txtZO_Sum.Text = "0"; //合計 //查詢配本商品 //string SessionIDName1 = "ALO121_dt1" + PageTimeStamp.Value; //DataTable Dt = (DataTable)Session[SessionIDName1]; //DataRow[] Dr = Dt.Select("ITEM='" + Request.QueryString["pItem"] + "' and PERIOD='" + Request.QueryString["pPeriod"] + "'"); //Fill_Field(Request.QueryString["pItem"], Request.QueryString["pPeriod"], Request.QueryString["pPeriod"], Dr[0]["N_PER_QTY"].ToString(), Dr[0]["ID"].ToString(), Dr[0]["N_ROWNUM"].ToString(), Dr[0]["Root_No"].ToString()); //重新查詢出配本商品 string item, period; getDis_Item(dt.Rows[0]["DIS_NO"].ToString(), SLP_APPROVE_DATE.Text, out item, out period); if (Request.QueryString["pItem"] != null) SLP_ITEM.Text = Request.QueryString["pItem"]; else SLP_ITEM.Text = item; if (Request.QueryString["pPeriod"] != null) SLP_PERIOD.Text = Request.QueryString["pPeriod"]; else SLP_PERIOD.Text = period; //帶出其它畫面回來的品號、期別 btnQuery2_Click(null, null); //查詢營業所 get_ZO(dt.Rows[0]["DIS_NO"].ToString()); //查詢配本通路 //getDis_Chan(dt.Rows[0]["DIS_NO"].ToString(), Request.QueryString["pItem"], Request.QueryString["pPeriod"]); getDis_Chan(dt.Rows[0]["DIS_NO"].ToString(), SLP_ITEM.Text, SLP_PERIOD.Text); //SLP_CHAN_NO1.Text = Request.QueryString["pChanNo"]; btnQuery3_Click(SLP_CHAN_NO1.Text); //查詢合計欄位:路線店數、路線合計配量 getTotal_Chan(txtDIS_NO.Text, SLP_ST_ACCEPT_DATE.Text.Length == 0 ? "" : Convert.ToDateTime(SLP_ST_ACCEPT_DATE.Text).ToString("yyyyMMdd"), hidITEM.Value, hidPERIOD.Value, hidChan_No2.Value, SLP_N_MAX_ROUTE.Text, SLP_N_MIN_ROUTE.Text, '2'); //建立配本門市暫存、查詢配本門市 hidITEM.Value = (Request.QueryString["pItem"] != null) ? Request.QueryString["pItem"] : SLP_ITEM.Text; hidPERIOD.Value = (Request.QueryString["pPeriod"] != null) ? Request.QueryString["pPeriod"] : SLP_PERIOD.Text; if (hidChan_No2.Value == "") getStore(dt.Rows[0]["DIS_NO"].ToString(), SLP_ITEM.Text, SLP_PERIOD.Text); //getStore(dt.Rows[0]["DIS_NO"].ToString(), Request.QueryString["pItem"], Request.QueryString["pPeriod"]); else QueryChan('1'); GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.FindExport, true, "", btnExport1, WUI_GMToolbarV.ClickAction.ButtonClick); } else { lblErrorQ1.Text = "查無資料"; lblErrorQ1.Visible = true; //ScriptManager.RegisterStartupScript(this, this.GetType(), "NoData", "alert('查無資料');", true); GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.FindExport, false, "", btnExport1, WUI_GMToolbarV.ClickAction.ButtonClick); } } catch (Exception ex) { this.lblErrorQ1.Text = ex.Message; lblErrorQ1.Visible = true; } }
/// <summary> /// POP_StoreSet頁面回來 /// </summary> /// <param name="dis_no">配本序號</param> /// <param name="item">品號</param> /// <param name="period">期別</param> /// <param name="chan_no">通路</param> private void Query_Data_POP(string dis_no) { //Session裏的dt變數: //dt -> 配本主檔 //dt1 -> 配本商品 //dt2 -> 營業所 //dt3 -> 配本通路 //dt4 -> 合計欄位:通路店數、通路合計配量 //dt5 -> 配本門市 try { string SessionIDName = ""; ArrayList ParameterList = new ArrayList();//20091113 ParameterList.Clear(); ParameterList.Add(dis_no); //配本序號 ParameterList.Add(System.DBNull.Value); //配本日期 ParameterList.Add(System.DBNull.Value); //門市進貨日 ParameterList.Add(System.DBNull.Value); //確認日期 //查詢配本主檔 DataTable dt = new DataTable(); BCO.MaintainDisRecord bco = new BCO.MaintainDisRecord(ConnectionDB); dt = bco.QueryDisMainFor121(ParameterList, '0'); //btnCancel1_Click(null, null); if (dt.Rows.Count > 0) { btnExport1.Enabled = true; txtDIS_NO.Text = dt.Rows[0]["DIS_NO"].ToString(); SLP_DIS_DATE.Text = dt.Rows[0]["DIS_DATE"].ToString(); SLP_ST_ACCEPT_DATE.Text = dt.Rows[0]["ST_ACCEPT_DATE"].ToString(); SLP_APPROVE_DATE.Text = dt.Rows[0]["APPROVE_DATE"].ToString(); DisableQueryFields(true); if (SLP_APPROVE_DATE.Text == "") EnableButton(true); txtZO_A.Text = "0"; //台北 txtZO_B.Text = "0"; //新竹 txtZO_D.Text = "0"; //台中 txtZO_E.Text = "0"; //嘉義 txtZO_H.Text = "0"; //高雄 txtZO_C.Text = "0"; //總部 txtZO_Sum.Text = "0"; //合計 //重新查詢出配本商品 //string item, period; //getDis_Item(dt.Rows[0]["DIS_NO"].ToString(), SLP_APPROVE_DATE.Text, out item, out period); //if (Request.QueryString["pItem"] != null) // SLP_ITEM.Text = Request.QueryString["pItem"]; //else // SLP_ITEM.Text = item; //if (Request.QueryString["pPeriod"] != null) // SLP_PERIOD.Text = Request.QueryString["pPeriod"]; //else // SLP_PERIOD.Text = period; ////帶出其它畫面回來的品號、期別 //btnQuery2_Click(null, null); //查詢營業所 get_ZO(dt.Rows[0]["DIS_NO"].ToString()); //查詢配本通路 //getDis_Chan(dt.Rows[0]["DIS_NO"].ToString(), Request.QueryString["pItem"], Request.QueryString["pPeriod"]); getDis_Chan(dt.Rows[0]["DIS_NO"].ToString(), SLP_ITEM.Text, SLP_PERIOD.Text); btnQuery3_Click(SLP_CHAN_NO1.Text); //查詢合計欄位:路線店數、路線合計配量 getTotal_Chan(txtDIS_NO.Text, SLP_ST_ACCEPT_DATE.Text.Length == 0 ? "" : Convert.ToDateTime(SLP_ST_ACCEPT_DATE.Text).ToString("yyyyMMdd"), hidITEM.Value, hidPERIOD.Value, hidChan_No2.Value, SLP_N_MAX_ROUTE.Text, SLP_N_MIN_ROUTE.Text, '2'); //建立配本門市暫存、查詢配本門市 hidITEM.Value = SLP_ITEM.Text; hidPERIOD.Value = SLP_PERIOD.Text; #region 查詢門市 ParameterList.Clear(); ParameterList.Add(txtDIS_NO.Text); //配本序號 ParameterList.Add(SLP_ITEM.Text); //配本商品品號 ParameterList.Add(SLP_PERIOD.Text); //配本商品期別 ParameterList.Add(PageTimeStamp.Value + Session["UID"].ToString()); ParameterList.Add("ALO121"); //工作頁面 //DataTable dt = new DataTable(); BCO.MaintainDisRecord bco1 = new BCO.MaintainDisRecord(ConnectionDB); dt = bco1.QueryPageDisStore(ParameterList); txtQueryTotRec.Text = dt.Rows.Count.ToString(); ComputeTotQty(dt); //計算查詢總配量 SessionIDName = "ALO121_dt5" + PageTimeStamp.Value; Session[SessionIDName] = dt; if (dt.Rows.Count > 0) { btnPOP_DisStoreSet.Enabled = (SLP_APPROVE_DATE.Text == string.Empty); GridView2.DataSource = CopyTable(dt);//產生Rx_ITEM及Rx_PERIOD都不為空值的DataTable; GridView2.DataBind(); Resize_Div(GridView2.Rows.Count); UpdatePanel1.Update(); } else { btnPOP_DisStoreSet.Enabled = false; GridView2.DataSource = null; GridView2.DataBind(); Resize_Div(GridView2.Rows.Count); UpdatePanel1.Update(); } #endregion //if (hidChan_No2.Value == "") // getStore(dt.Rows[0]["DIS_NO"].ToString(), SLP_ITEM.Text, SLP_PERIOD.Text); //getStore(dt.Rows[0]["DIS_NO"].ToString(), Request.QueryString["pItem"], Request.QueryString["pPeriod"]); //else // QueryChan('1'); GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.FindExport, true, "", btnExport1, WUI_GMToolbarV.ClickAction.ButtonClick); } else { lblErrorQ1.Text = "查無資料"; lblErrorQ1.Visible = true; //ScriptManager.RegisterStartupScript(this, this.GetType(), "NoData", "alert('查無資料');", true); GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.FindExport, false, "", btnExport1, WUI_GMToolbarV.ClickAction.ButtonClick); } dt.Dispose(); } catch (Exception ex) { this.lblErrorQ1.Text = ex.Message; lblErrorQ1.Visible = true; } }
private void UC_RecPre() { try { if (txtDIS_NO.Text.Trim().Length > 0) { ArrayList ParameterList = new ArrayList();//20091113 ParameterList.Clear(); ParameterList.Add(txtDIS_NO.Text.Trim()); //配本序號 DataTable dt = new DataTable(); BCO.MaintainDisRecord bco = new BCO.MaintainDisRecord(ConnectionDB); dt = bco.QueryDisMainFor121(ParameterList, '3'); if (dt.Rows.Count > 0) { Clear_Fields(); txtDIS_NO.Text = dt.Rows[0]["DIS_NO"].ToString(); btnQuery1_Click(null, null); } else ScriptManager.RegisterStartupScript(this, this.GetType(), "NoData", "alert('已無上一筆資料');", true); } else ScriptManager.RegisterStartupScript(this, this.GetType(), "NoData", "alert('請先輸入配本序號');", true); } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } }
protected void btnQuery1_Click(object sender, EventArgs e) { //Session裏的dt變數: //dt -> 配本主檔 //dt1 -> 配本商品 //dt2 -> 營業所 //dt3 -> 配本通路 //dt4 -> 合計欄位:通路店數、通路合計配量 //dt5 -> 配本門市 try { string SessionIDName = "ALO121_dt1" + PageTimeStamp.Value; DataTable Sdt = (DataTable)Session[SessionIDName]; if (Sdt != null) { Sdt.Clear(); Sdt.Dispose(); } SessionIDName = "ALO121_dt2" + PageTimeStamp.Value; Sdt = (DataTable)Session[SessionIDName]; if (Sdt != null) { Sdt.Clear(); Sdt.Dispose(); } SessionIDName = "ALO121_dt3" + PageTimeStamp.Value; Sdt = (DataTable)Session[SessionIDName]; if (Sdt != null) { Sdt.Clear(); Sdt.Dispose(); } SessionIDName = "ALO121_dt4" + PageTimeStamp.Value; Sdt = (DataTable)Session[SessionIDName]; if (Sdt != null) { Sdt.Clear(); Sdt.Dispose(); } SessionIDName = "ALO121_dt5" + PageTimeStamp.Value; Sdt = (DataTable)Session[SessionIDName]; if (Sdt != null) { Sdt.Clear(); Sdt.Dispose(); } SessionIDName = ""; ArrayList ParameterList = new ArrayList();//20091113 ParameterList.Clear(); ParameterList.Add(txtDIS_NO.Text.Trim()); //配本序號 if (SLP_DIS_DATE.Text.Length == 0) ParameterList.Add(System.DBNull.Value); else ParameterList.Add(SLP_DIS_DATE.Text); //配本日期 if (SLP_ST_ACCEPT_DATE.Text.Length == 0) ParameterList.Add(System.DBNull.Value); else ParameterList.Add(SLP_ST_ACCEPT_DATE.Text); //門市進貨日 if (SLP_APPROVE_DATE.Text.Length == 0) ParameterList.Add(System.DBNull.Value); else ParameterList.Add(SLP_APPROVE_DATE.Text); //確認日期 //查詢配本主檔 DataTable dt = new DataTable(); BCO.MaintainDisRecord bco = new BCO.MaintainDisRecord(ConnectionDB); dt = bco.QueryDisMainFor121(ParameterList, '0'); if (dt.Rows.Count > 0) { Clear_Fields(); btnExport1.Enabled = true; txtDIS_NO.Text = dt.Rows[0]["DIS_NO"].ToString(); SLP_DIS_DATE.Text = dt.Rows[0]["DIS_DATE"].ToString(); SLP_ST_ACCEPT_DATE.Text = dt.Rows[0]["ST_ACCEPT_DATE"].ToString(); SLP_APPROVE_DATE.Text = dt.Rows[0]["APPROVE_DATE"].ToString(); DisableQueryFields(true); string item, period; //查詢配本商品 getDis_Item(dt.Rows[0]["DIS_NO"].ToString(), SLP_APPROVE_DATE.Text, out item, out period); if (item == "") { lblErrorQ1.Text = "無商品資料"; lblErrorQ1.Visible = true; EnableButton(false); DisableQueryFields(false); return; } if (period == "") { lblErrorQ1.Text = "無期別資料"; lblErrorQ1.Visible = true; EnableButton(false); DisableQueryFields(false); return; } txtZO_A.Text = "0"; //台北 txtZO_B.Text = "0"; //新竹 txtZO_D.Text = "0"; //台中 txtZO_E.Text = "0"; //嘉義 txtZO_H.Text = "0"; //高雄 txtZO_C.Text = "0"; //總部 txtZO_Sum.Text = "0"; //合計 //本邏輯判斷要放在getDis_Chan函式之前,因getDis_Chan另外判斷若查無資料則通路1、通路2不可查詢 if (SLP_APPROVE_DATE.Text == "") EnableButton(true); else //已確認,可查詢,不可修改 2011/1/29 by Tony { //品號查詢 btnPrev2.Enabled = true; btnNext2.Enabled = true; btnQuery2.Enabled = true; btnConditionQuery.Enabled = true; //通路1查詢 btnPrev3.Enabled = true; btnNext3.Enabled = true; btnQuery3.Enabled = true; //通路2查詢 btnQuery4.Enabled = true; } //查詢營業所 get_ZO(dt.Rows[0]["DIS_NO"].ToString()); //查詢配本通路 getDis_Chan(dt.Rows[0]["DIS_NO"].ToString(), item, period); //查詢合計欄位:通路店數、通路合計配量 getTotal_Chan(dt.Rows[0]["DIS_NO"].ToString(), dt.Rows[0]["ST_ACCEPT_DATE"].ToString().Length == 0 ? "" : Convert.ToDateTime(dt.Rows[0]["ST_ACCEPT_DATE"].ToString()).ToString("yyyyMMdd"), item, period, "", "", "", '0'); //建立配本門市暫存、查詢配本門市 getStore(dt.Rows[0]["DIS_NO"].ToString(), item, period); GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.FindExport, true, "", btnExport1, WUI_GMToolbarV.ClickAction.ButtonClick); } else { lblErrorQ1.Text = "查無資料"; lblErrorQ1.Visible = true; GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.FindExport, false, "", btnExport1, WUI_GMToolbarV.ClickAction.ButtonClick); } } catch (Exception ex) { this.lblErrorQ1.Text = ex.Message; lblErrorQ1.Visible = true; } }
private void UC_RecLast() { try { ArrayList ParameterList = new ArrayList();//20091113 ParameterList.Clear(); DataTable dt = new DataTable(); BCO.MaintainDisRecord bco = new BCO.MaintainDisRecord(ConnectionDB); dt = bco.QueryDisMainFor121(ParameterList, '4'); if (dt.Rows.Count > 0) { Clear_Fields(); txtDIS_NO.Text = dt.Rows[0]["DIS_NO"].ToString(); btnQuery1_Click(null, null); } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } }