private DataTable Get_Query_Data()
{
#region 處理查詢
string s_Count = (this.TextBoxRowCountLimit.Text == string.Empty) ? "9999" : this.TextBoxRowCountLimit.Text;
DropDownList drop_ST_ACCEPT_QTY = (DropDownList)((ASP.wui_slp_slp_slpnumber_ascx)slp_ST_ACCEPT_QTY).FindControl("D1");
TextBox txt_ST_ACCEPT_QTY = (TextBox)((ASP.wui_slp_slp_slpnumber_ascx)slp_ST_ACCEPT_QTY).FindControl("TextBoxCode");
//(TextBox)this.slp_ST_ACCEPT_QTY.FindControl("TextBoxCode");
ArrayList ParameterList = new ArrayList();//20091117
ParameterList.Clear();
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(GetValueSetParameter(this.slp_BUSDATE.Text, "date", false));//訂單日期
ParameterList.Add(GetValueSetParameter(this.slp_CHAN_NO.Text, "string", CheckBoxLikeSearch.Checked));//通路
ParameterList.Add(GetValueSetParameter(this.slp_STORE.Text, "string", CheckBoxLikeSearch.Checked));//門市
ParameterList.Add(GetValueSetParameter(this.txt_PO_SOURCE_NO.Text, "string", CheckBoxLikeSearch.Checked));//PO單號
ParameterList.Add(GetValueSetParameter(this.slp_Z_O.Text, "string", CheckBoxLikeSearch.Checked));//營業所
ParameterList.Add(GetValueSetParameter(this.slp_SAL_ID.Text, "string", CheckBoxLikeSearch.Checked));//營業專員
ParameterList.Add(GetValueSetParameter(this.txt_BARCODE.Text, "string", CheckBoxLikeSearch.Checked));//一段碼
ParameterList.Add(GetValueSetParameter(this.txt_PERIOD_BARCODE.Text, "string", CheckBoxLikeSearch.Checked));//二段碼
try
{
int.Parse(txt_ST_ACCEPT_QTY.Text.Trim());
ParameterList.Add(GetValueSetParameter(drop_ST_ACCEPT_QTY.SelectedItem.Text, "string", false));//運算子
ParameterList.Add(GetValueSetParameter(txt_ST_ACCEPT_QTY.Text, "int", false));//出貨量
}
catch
{
ParameterList.Add(GetValueSetParameter(string.Empty, "string", false));//運算子
ParameterList.Add(GetValueSetParameter(txt_ST_ACCEPT_QTY.Text, "int", false));//出貨量
}
ParameterList.Add(GetValueSetParameter(this.slp_ITEM.Text, "string", CheckBoxLikeSearch.Checked));//品號/品名
ParameterList.Add(GetValueSetParameter(this.slp_PERIOD.Text, "string", CheckBoxLikeSearch.Checked));//期別
ParameterList.Add(GetValueSetParameter(this.drop_ORDER_TYPE.SelectedValue, "int", false));//訂單來源
ParameterList.Add(GetValueSetParameter(this.drop_PROC_DESC.SelectedValue, "int", false));//處理記錄
ParameterList.Add(GetValueSetParameter(this.drop_STATUS.SelectedValue, "int", false));//結案狀態
ParameterList.Add(GetValueSetParameter(this.slp_ST_ACCEPT_DATE.Text, "date", false));//進貨單日
ParameterList.Add(GetValueSetParameter(s_Count, "int", false));//筆數
DataTable dt_Return = new DataTable();
CRMModel.RecordCRMOrder CRMBCO = new CRMModel.RecordCRMOrder(ConnectionDB);
dt_Return = CRMBCO.QueryCRM22(ParameterList);
#endregion
return dt_Return;
}
