/// <summary>
/// UP BUTTON 查詢鈕
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void but_up_Query_Click(object sender, EventArgs e)
{
System.Text.StringBuilder sb = new System.Text.StringBuilder();
try
{
if (this.hid_PageStatus.Value == "QUERY" ||
sender.ToString() == "ToolBar_RecFirst" ||
sender.ToString() == "ToolBar_RecLast" ||
sender.ToString() == "ToolBar_RecNext" ||
sender.ToString() == "ToolBar_RecPre" ||
sender.ToString() == "CRM051_TO_CRM041")
{
#region 前置檢查與參數過濾
if (this.hid_PageStatus.Value == "QUERY")
{
sb.Remove(0, sb.Length);
if (this.slp_up_CHAN_NO.Text.Trim() == string.Empty &&
this.slp_up_STORE.Text.Trim() == string.Empty &&
this.slp_up_BUSDATE.Text.Trim() == string.Empty &&
this.slp_up_BUSUID.Text.Trim() == string.Empty &&
this.txt_up_CODE.Text.Trim() == string.Empty &&
this.txt_up_CRM_NO.Text.Trim() == string.Empty)
{
sb.Append("[通路]、[門市]、[訂單日期]、[訂單維護者]、[訂單編號]、[流水編號]，六個欄位不可皆為空白，至少需輸入一項作為查詢條件。");
ScriptManager.RegisterStartupScript(this.up_Up_Button, typeof(UpdatePanel), "CRM041", "alert('" + sb.ToString() + "');", true);
return;
}
}
#endregion
#region 處理查詢
ArrayList ParameterList = new ArrayList();//20091117
if (this.hid_PageStatus.Value == "QUERY" || sender.ToString() == "CRM051_TO_CRM041")
{
#region 清空靜態變數
dtChainPOSetting = null;//異動欄位[門市] --由CRM05 連結 CRM04 =>查詢Query時先清空
dtStock = null;//異動欄位[期別]
s_PMA = string.Empty;//大分類(異動欄位[品號/品名])
s_ROOT_NO = string.Empty;//群分類(異動欄位[品號/品名])
s_SRC_LOCATE_TYPE = string.Empty;//建議儲區類別(異動欄位[訂貨量])
dt_Detail = null;
//Session["CRM041_dt_Detail" + PageTimeStamp.Value] = null;
dt_Master = null;
dt_Detail_Original = null;
#endregion
DataSet ds_Return = new DataSet();
#region 取得查詢資料
if (this.hid_PageStatus.Value == "QUERY")
{
ParameterList.Clear();
ParameterList.Add(GetValueSetParameter(this.slp_up_CHAN_NO.Text.Trim(), "string"));//通路
ParameterList.Add(GetValueSetParameter(this.slp_up_STORE.Text.Trim(), "string"));//門市
ParameterList.Add(GetValueSetParameter(this.slp_up_Z_O.Text.Trim(), "string"));//營業所
ParameterList.Add(GetValueSetParameter(this.slp_up_BUSDATE.Text.Trim(), "date"));//訂單日期
ParameterList.Add(GetValueSetParameter(this.slp_up_SALE_ID.Text.Trim(), "string"));//營業人員
ParameterList.Add(GetValueSetParameter(this.slp_up_BUSUID.Text.Trim(), "string"));//訂單維護者
ParameterList.Add(GetValueSetParameter(this.drop_up_ORDER_TYPE.Text, "int"));//訂單來源
ParameterList.Add(GetValueSetParameter(this.txt_up_PO_SOURCE_NO.Text.Trim(), "string"));//PO單號預設
ParameterList.Add(GetValueSetParameter(this.txt_up_CODE.Text.Trim(), "string"));//訂單編號
ParameterList.Add(GetValueSetParameter(this.txt_up_CRM_NO.Text.Trim(), "string"));//流水編號
ParameterList.Add(Session["UID"].ToString());
BCO.RecordCRMOrder bco = new BCO.RecordCRMOrder(ConntionDB);
ds_Return = bco.QueryCRMOrderByFind(ParameterList);
}
else if (sender.ToString() == "CRM051_TO_CRM041")
{
string s_CRM_REQUEST_NO = Request["CRM041_CRM_REQUEST_NO"].ToString();
ParameterList.Clear();
ParameterList.Add(s_CRM_REQUEST_NO);
ParameterList.Add(Session["UID"].ToString());
BCO.RecordCRMOrder bco = new BCO.RecordCRMOrder(ConntionDB);
ds_Return = bco.QueryCRMOrderBy_CRM_REQUEST_NO(ParameterList);
}
#endregion
#region 記錄查詢結果到頁面變數與Session
if (ds_Return.Tables["VDS_CRM_ORDER_MAIN"].Rows.Count == 0 ||
ds_Return.Tables["VDS_CRM_ORDER_DETL"].Rows.Count == 0)
{
ScriptManager.RegisterStartupScript(this.up_Up_Button, typeof(UpdatePanel), "CRM041", "alert('查無訂單資料');", true);
return;
}
else
{
dt_Master = ds_Return.Tables["VDS_CRM_ORDER_MAIN"].Copy();
dt_Detail = ds_Return.Tables["VDS_CRM_ORDER_DETL"].Copy();
//Session["CRM041_dt_Detail" + PageTimeStamp.Value] = dt_Detail;
dt_Detail_Original = ds_Return.Tables["VDS_CRM_ORDER_DETL"].Copy();
}
#endregion
ds_Return.Dispose();
}
else
{
DataSet ds_Return = new DataSet();
#region 取得查詢資料
ParameterList.Clear();
ParameterList.Add(this.txt_up_CODE.Text);
ParameterList.Add(Session["UID"].ToString());
BCO.RecordCRMOrder bco = new BCO.RecordCRMOrder(ConntionDB);
if (sender.ToString() == "ToolBar_RecFirst")
{ ds_Return = bco.QueryFirstCRMOrder(ParameterList); }
else if (sender.ToString() == "ToolBar_RecLast")
{ ds_Return = bco.QueryLastCRMOrder(ParameterList); }
else if (sender.ToString() == "ToolBar_RecNext")
{ ds_Return = bco.QueryNextCRMOrder(ParameterList); }
else if (sender.ToString() == "ToolBar_RecPre")
{ ds_Return = bco.QueryPriorCRMOrder(ParameterList); }
if (ds_Return == null)
{
SetPageStatus();
if (sender.ToString() == "ToolBar_RecNext")
{ ScriptManager.RegisterStartupScript(this.up_ToolBar, typeof(UpdatePanel), "CRM041", "alert('無下一筆資料');", true); }
else if (sender.ToString() == "ToolBar_RecPre")
{ ScriptManager.RegisterStartupScript(this.up_ToolBar, typeof(UpdatePanel), "CRM041", "alert('無前一筆資料');", true); }
return;
}
else
{
#region 清空靜態變數
dtChainPOSetting = null;//異動欄位[門市] --查詢清空2
dtStock = null;//異動欄位[期別]
s_PMA = string.Empty;//大分類(異動欄位[品號/品名])
s_ROOT_NO = string.Empty;//群分類(異動欄位[品號/品名])
s_SRC_LOCATE_TYPE = string.Empty;//建議儲區類別(異動欄位[訂貨量])
dt_Detail = null;
//Session["CRM041_dt_Detail" + PageTimeStamp.Value] = null;
dt_Master = null;
dt_Detail_Original = null;
#endregion
dt_Master = ds_Return.Tables["VDS_CRM_ORDER_MAIN"].Copy();
dt_Detail = ds_Return.Tables["VDS_CRM_ORDER_DETL"].Copy();
//Session["CRM041_dt_Detail" + PageTimeStamp.Value] = dt_Detail;
dt_Detail_Original = ds_Return.Tables["VDS_CRM_ORDER_DETL"].Copy();
}
#endregion
ds_Return.Dispose();
}
#endregion
#region 切換到檢視模式
this.hid_PageStatus.Value = "VIEW";
this.txt_PageStatus.Text = "VIEW";
SetPageStatus();
#endregion
#region 設定頁面控制項
#region MAIN
this.slp_up_CHAN_NO.Text = dt_Master.Rows[0]["CHAN_NO"].ToString();//通路
this.slp_up_STORE.Text = dt_Master.Rows[0]["STORE"].ToString();//門市
this.slp_up_Z_O.Text = dt_Master.Rows[0]["Z_O"].ToString();//營業所
this.slp_up_BUSDATE.Text = dt_Master.Rows[0]["BUSDATE"].ToString();//訂單日期
this.slp_up_SALE_ID.Text = dt_Master.Rows[0]["SAL_ID"].ToString();//營業人員
this.slp_up_BUSUID.Text = dt_Master.Rows[0]["BUSUID"].ToString();//訂單維護者
this.drop_up_ORDER_TYPE.Text = dt_Master.Rows[0]["ORDER_TYPE"].ToString();//訂單來源
this.txt_up_PO_SOURCE_NO.Text = dt_Master.Rows[0]["PO_SOURCE_NO"].ToString();//PO單號預設
this.txt_up_CODE.Text = dt_Master.Rows[0]["CODE"].ToString();//訂單編號
this.txt_up_CRM_NO.Text = dt_Master.Rows[0]["CRM_NO"].ToString();//流水編號
#endregion
#region DETL
this.gv_Detail.DataSource = dt_Detail;
this.gv_Detail.PageSize = 10;
this.gv_Detail.PageIndex = 0;
this.gv_Detail.DataBind();
Panel1.Height = gv_Detail.Rows.Count * 45 + 60;
#endregion
#endregion
#region 設定各欄位模式ReadOnly
this.slp_up_CHAN_NO.ReadOnly = true;
this.slp_up_STORE.ReadOnly = true;
this.slp_up_Z_O.ReadOnly = true;
this.slp_up_BUSDATE.ReadOnly = true;
this.slp_up_SALE_ID.ReadOnly = true;
this.slp_up_BUSUID.ReadOnly = true;
this.drop_up_ORDER_TYPE.ReadOnly = true;
this.txt_up_PO_SOURCE_NO.ReadOnly = true;
this.txt_up_PO_SOURCE_NO.CssClass = "readtxtbox";
this.txt_up_CODE.ReadOnly = true;
this.txt_up_CODE.CssClass = "readtxtbox";
this.txt_up_CRM_NO.ReadOnly = true;
this.txt_up_CRM_NO.CssClass = "readtxtbox";
#endregion
}
}
catch (Exception ex)
{
WaringLogProcess(ex.Message);
this.ErrorMsgLabel.Text = ex.Message;
}
finally { AuthorityControls(this); }
}
