/// <summary>
/// 查詢資料
/// </summary>
private void QueryData()
{
#region
try
{
string SessionIDName;
DataTable dt = new DataTable();
if (Session[s_SessionIDName] != null)
{
if (dtDisStore == null)
{
dt = (DataTable)Session[s_SessionIDName];
}
else
{
dt = dtDisStore;
}
}
else
{
#region 查詢設定資料
ALOModel.MaintainDisRecord BCO = new ALOModel.MaintainDisRecord(ConnectionDB);
ArrayList ParameterList = new ArrayList();
ParameterList.Clear();
ParameterList.Add(s_DIS_NO);
ParameterList.Add(s_ITEM);
ParameterList.Add(s_PERIOD);
ParameterList.Add(PageTimeStamp.Value + Session["UID"].ToString());
ParameterList.Add(Session["UID"].ToString()); //登入者
ParameterList.Add(s_WorkId);
dt = BCO.QueryDisStoreFor121(ParameterList);
#endregion
}
#region DataBind
if (dt != null && dt.Rows.Count > 0)
{
dtDisStore = dt.Copy();
GridView1.DataSource = dtDisStore;
GridView1.PageSize = 15;
if (SLP_Store1.Text.Trim() != "")
{
GridView1.PageIndex = GetPageIndexByParam(SLP_Store1.Text.Trim());
}
else
{
GridView1.PageIndex = 0;
}
GridView1.PagerStyle.HorizontalAlign = HorizontalAlign.Left;
GridView1.DataBind();
//up_GridView.Update();
dt.Dispose();
}
#endregion
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
#endregion
}
/// <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; }
}
