/// <summary> /// 通路2查詢bco.QueryDisStoreForChanAndRoute /// </summary> /// <param name="from">0:原查詢,1:由其它程式返回</param> private void QueryChan(char from) { try { if (SLP_N_MAX_ROUTE.Text.Trim().Length > 0 && SLP_N_MIN_ROUTE.Text.Trim().Length > 0) if (string.Compare(SLP_N_MAX_ROUTE.Text, SLP_N_MIN_ROUTE.Text) > 0) { lblErrorQ1.Visible = true; lblErrorQ1.Text = "路線起不可大於路線迄"; return; } if (from == '0') //查詢合計欄位:通路店數、通路合計配量、路線店數、路線合計配量 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, SLP_CHAN_NO2.Text, SLP_N_MAX_ROUTE.Text, SLP_N_MIN_ROUTE.Text, '2'); ArrayList ParameterList = new ArrayList();//20091113 ParameterList.Clear(); ParameterList.Add(PageTimeStamp.Value + Session["UID"].ToString()); ParameterList.Add(txtDIS_NO.Text); //配本序號 ParameterList.Add(hidITEM.Value); //配本商品品號 ParameterList.Add(hidPERIOD.Value); //配本商品期別 ParameterList.Add(hidChan_No2.Value); //通路2 ParameterList.Add(SLP_N_MAX_ROUTE.Text); //路線起 ParameterList.Add(SLP_N_MIN_ROUTE.Text); //路線迄 ParameterList.Add(Session["UID"].ToString()); //登入者 DataTable dt = new DataTable(); BCO.MaintainDisRecord bco = new BCO.MaintainDisRecord(ConnectionDB); dt = bco.QueryDisStoreForChanAndRoute(ParameterList); txtQueryTotRec.Text = "0"; if (dt.Rows.Count > 0) { txtQueryTotRec.Text = dt.Rows.Count.ToString();//GridView2的查詢總筆數 ComputeTotQty(dt); //計算查詢總配量 } string SessionIDName = "ALO121_dt5" + PageTimeStamp.Value; Session[SessionIDName] = dt; if (dt.Rows.Count == 0) GridView2.DataSource = null; else GridView2.DataSource = CopyTable(dt); GridView2.DataBind(); Resize_Div(GridView2.Rows.Count); UpdatePanel1.Update(); } catch (Exception ex) { if (ex.Message.IndexOf("UPDATE門市121配本暫存檔時發生異常,因無資料") != -1) { lblErrorQ1.Text = "無此通路路線資料"; lblErrorQ1.Visible = true; //ScriptManager.RegisterStartupScript(this, this.GetType(), "ALO121_Alert", "alert('無此通路路線資料');", true); } else { lblErrorQ1.Text = ex.Message; lblErrorQ1.Visible = true; } } }