/// <summary>
/// ALO122頁面取消回來
/// </summary>
/// <param name="dis_no">配本序號</param>
/// <param name="item">品號</param>
/// <param name="period">期別</param>
/// <param name="chan_no">通路</param>
/// <param name="DIS_TOT_OQTY">通路合計配量</param>
/// <param name="N_DIS_TOT_QTY">路線合計配量</param>
/// <param name="N_MAX_ROUTE">路線起</param>
/// <param name="N_MIN_ROUTE">路線迄</param>
//private void Query_Data(string dis_no, string item, string period, string chan_no, string DIS_TOT_OQTY, string N_DIS_TOT_QTY, string N_MAX_ROUTE, string N_MIN_ROUTE)
private void Query_Data(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 SessionIDName1 = "ALO121_dt1" + PageTimeStamp.Value;
//DataTable Dt = (DataTable)Session[SessionIDName1];
//DataRow[] Dr = Dt.Select("ITEM='" + Request.QueryString["pItem"] + "' and PERIOD='" + Request.QueryString["pPeriod"] + "'");
//Fill_Field(Request.QueryString["pItem"], Request.QueryString["pPeriod"], Request.QueryString["pPeriod"], Dr[0]["N_PER_QTY"].ToString(), Dr[0]["ID"].ToString(), Dr[0]["N_ROWNUM"].ToString(), Dr[0]["Root_No"].ToString());
//重新查詢出配本商品
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);
//SLP_CHAN_NO1.Text = Request.QueryString["pChanNo"];
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 = (Request.QueryString["pItem"] != null) ? Request.QueryString["pItem"] : SLP_ITEM.Text;
hidPERIOD.Value = (Request.QueryString["pPeriod"] != null) ? Request.QueryString["pPeriod"] : SLP_PERIOD.Text;
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);
}
}
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>
/// <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; }
}
private void UC_RecPre()
{
try
{
if (txtDIS_NO.Text.Trim().Length > 0)
{
ArrayList ParameterList = new ArrayList();//20091113
ParameterList.Clear();
ParameterList.Add(txtDIS_NO.Text.Trim()); //配本序號
DataTable dt = new DataTable();
BCO.MaintainDisRecord bco = new BCO.MaintainDisRecord(ConnectionDB);
dt = bco.QueryDisMainFor121(ParameterList, '3');
if (dt.Rows.Count > 0)
{
Clear_Fields();
txtDIS_NO.Text = dt.Rows[0]["DIS_NO"].ToString();
btnQuery1_Click(null, null);
}
else
ScriptManager.RegisterStartupScript(this, this.GetType(), "NoData", "alert('已無上一筆資料');", true);
}
else
ScriptManager.RegisterStartupScript(this, this.GetType(), "NoData", "alert('請先輸入配本序號');", true);
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
}
protected void btnQuery1_Click(object sender, EventArgs e)
{
//Session裏的dt變數:
//dt -> 配本主檔
//dt1 -> 配本商品
//dt2 -> 營業所
//dt3 -> 配本通路
//dt4 -> 合計欄位：通路店數、通路合計配量
//dt5 -> 配本門市
try
{
string SessionIDName = "ALO121_dt1" + PageTimeStamp.Value;
DataTable Sdt = (DataTable)Session[SessionIDName];
if (Sdt != null) { Sdt.Clear(); Sdt.Dispose(); }
SessionIDName = "ALO121_dt2" + PageTimeStamp.Value;
Sdt = (DataTable)Session[SessionIDName];
if (Sdt != null) { Sdt.Clear(); Sdt.Dispose(); }
SessionIDName = "ALO121_dt3" + PageTimeStamp.Value;
Sdt = (DataTable)Session[SessionIDName];
if (Sdt != null) { Sdt.Clear(); Sdt.Dispose(); }
SessionIDName = "ALO121_dt4" + PageTimeStamp.Value;
Sdt = (DataTable)Session[SessionIDName];
if (Sdt != null) { Sdt.Clear(); Sdt.Dispose(); }
SessionIDName = "ALO121_dt5" + PageTimeStamp.Value;
Sdt = (DataTable)Session[SessionIDName];
if (Sdt != null) { Sdt.Clear(); Sdt.Dispose(); }
SessionIDName = "";
ArrayList ParameterList = new ArrayList();//20091113
ParameterList.Clear();
ParameterList.Add(txtDIS_NO.Text.Trim()); //配本序號
if (SLP_DIS_DATE.Text.Length == 0) ParameterList.Add(System.DBNull.Value); else ParameterList.Add(SLP_DIS_DATE.Text); //配本日期
if (SLP_ST_ACCEPT_DATE.Text.Length == 0) ParameterList.Add(System.DBNull.Value); else ParameterList.Add(SLP_ST_ACCEPT_DATE.Text); //門市進貨日
if (SLP_APPROVE_DATE.Text.Length == 0) ParameterList.Add(System.DBNull.Value); else ParameterList.Add(SLP_APPROVE_DATE.Text); //確認日期
//查詢配本主檔
DataTable dt = new DataTable();
BCO.MaintainDisRecord bco = new BCO.MaintainDisRecord(ConnectionDB);
dt = bco.QueryDisMainFor121(ParameterList, '0');
if (dt.Rows.Count > 0)
{
Clear_Fields();
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);
string item, period;
//查詢配本商品
getDis_Item(dt.Rows[0]["DIS_NO"].ToString(), SLP_APPROVE_DATE.Text, out item, out period);
if (item == "") { lblErrorQ1.Text = "無商品資料"; lblErrorQ1.Visible = true; EnableButton(false); DisableQueryFields(false); return; }
if (period == "") { lblErrorQ1.Text = "無期別資料"; lblErrorQ1.Visible = true; EnableButton(false); DisableQueryFields(false); return; }
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"; //合計
//本邏輯判斷要放在getDis_Chan函式之前，因getDis_Chan另外判斷若查無資料則通路1、通路2不可查詢
if (SLP_APPROVE_DATE.Text == "")
EnableButton(true);
else //已確認，可查詢，不可修改 2011/1/29 by Tony
{
//品號查詢
btnPrev2.Enabled = true;
btnNext2.Enabled = true;
btnQuery2.Enabled = true;
btnConditionQuery.Enabled = true;
//通路1查詢
btnPrev3.Enabled = true;
btnNext3.Enabled = true;
btnQuery3.Enabled = true;
//通路2查詢
btnQuery4.Enabled = true;
}
//查詢營業所
get_ZO(dt.Rows[0]["DIS_NO"].ToString());
//查詢配本通路
getDis_Chan(dt.Rows[0]["DIS_NO"].ToString(), item, period);
//查詢合計欄位：通路店數、通路合計配量
getTotal_Chan(dt.Rows[0]["DIS_NO"].ToString(), dt.Rows[0]["ST_ACCEPT_DATE"].ToString().Length == 0 ? "" : Convert.ToDateTime(dt.Rows[0]["ST_ACCEPT_DATE"].ToString()).ToString("yyyyMMdd"), item, period, "", "", "", '0');
//建立配本門市暫存、查詢配本門市
getStore(dt.Rows[0]["DIS_NO"].ToString(), item, period);
GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.FindExport, true, "", btnExport1, WUI_GMToolbarV.ClickAction.ButtonClick);
}
else
{
lblErrorQ1.Text = "查無資料";
lblErrorQ1.Visible = true;
GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.FindExport, false, "", btnExport1, WUI_GMToolbarV.ClickAction.ButtonClick);
}
}
catch (Exception ex) { this.lblErrorQ1.Text = ex.Message; lblErrorQ1.Visible = true; }
}
private void UC_RecLast()
{
try
{
ArrayList ParameterList = new ArrayList();//20091113
ParameterList.Clear();
DataTable dt = new DataTable();
BCO.MaintainDisRecord bco = new BCO.MaintainDisRecord(ConnectionDB);
dt = bco.QueryDisMainFor121(ParameterList, '4');
if (dt.Rows.Count > 0)
{
Clear_Fields();
txtDIS_NO.Text = dt.Rows[0]["DIS_NO"].ToString();
btnQuery1_Click(null, null);
}
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
}
