/// <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();
}
}
