/// <summary> /// 查詢配本門市 /// </summary> /// <param name="dis_no">配本序號</param> /// <param name="item">配本商品品號</param> /// <param name="period">配本商品期別</param> /// <param name="from">0:原查詢,1:從其它程式回來的查詢</param> private void getStore(string dis_no, string item, string period) { 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(Session["UID"].ToString()); //登入者 DataTable dt = new DataTable(); BCO.MaintainDisRecord bco = new BCO.MaintainDisRecord(ConnectionDB); if (Request.QueryString["PageTimeStamp"] != null)//由其它頁面返回 { if (!(item == Request.QueryString["pItem"] && period == Request.QueryString["pPeriod"])) { dt = bco.CreateAndQueryDisStoreFor121(ParameterList); if (ViewState["isChanged"] != null) if (ViewState["isChanged"].ToString() == "0") ViewState["isChanged"] = "1"; } else { //ViewState["isChanged"] = 0:未查詢過其它品號、期別資料,使用QueryDisStoreFor121查詢門市資料 //1:表已查過其它品號、期別資料,原資料已被刪除,使用CreateAndQueryDisStoreFor121查詢門市資料 //null:表不是從ALO123回來的情況,使用CreateAndQueryDisStoreFor121查詢門市資料 if (ViewState["isChanged"] != null) if (ViewState["isChanged"].ToString() == "0") { if (Request.QueryString["pChanNo"] != null)//曾傳通路至其它頁面 if (Request.QueryString["pChanNo"] != "") { QueryChan('1'); return; } else //由其它頁面返回,未傳通路2資料至其它頁面,查詢全通路資料 dt = bco.QueryDisStoreFor121(ParameterList); else dt = bco.QueryDisStoreFor121(ParameterList); } else dt = bco.CreateAndQueryDisStoreFor121(ParameterList); else dt = bco.CreateAndQueryDisStoreFor121(ParameterList); } } else dt = bco.CreateAndQueryDisStoreFor121(ParameterList); txtQueryTotRec.Text = dt.Rows.Count.ToString(); ComputeTotQty(dt); //計算查詢總配量 string 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(); } } catch (Exception ex) { this.lblErrorQ1.Text = ex.Message; lblErrorQ1.Visible = true; } }