/// <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; } }
/// <summary> /// 由POP_StoreSet返回查詢配本門市資料 /// </summary> /// <param name="dis_no">配本序號</param> /// <param name="item">配本商品品號</param> /// <param name="period">配本商品期別</param> private void getStore_POP(string dis_no, string item, string period) { string SessionIDName = "ALO122_dt5" + PageTimeStamp.Value; DataTable dt = new DataTable(); try { ArrayList ParameterList = new ArrayList();//20091113 ParameterList.Clear(); ParameterList.Add(dis_no); //配本序號 ParameterList.Add(item); //配本商品品號 ParameterList.Add(period); //配本商品期別 ParameterList.Add(PageTimeStamp.Value + Session["UID"].ToString()); ParameterList.Add("ALO122"); //工作頁面 BCO.MaintainDisRecord bco = new BCO.MaintainDisRecord(ConnectionDB); dt = bco.QueryPageDisStore(ParameterList); if (dt.Rows.Count == 0) { btnBatchTune.Enabled = false; btnConditionQuery.Enabled = false; btnNewStoreQuery.Enabled = false; btnReturnedPerchase.Enabled = false; } } catch (Exception ex) { lblErrorQ1.Text = ex.Message; } finally { txtQueryTotRec.Text = dt.Rows.Count.ToString(); ComputeTotQty(dt); //計算查詢總配量 Session[SessionIDName] = dt; if (dt.Rows.Count == 0) GridView2.DataSource = null; else GridView2.DataSource = CopyTable(dt);//產生Rx_ITEM及Rx_PERIOD都不為空值的DataTable; GridView2.DataBind(); Resize_Div(GridView2.Rows.Count); UpdatePanel1.Update(); } }