/// <summary>
/// COM04報表
/// </summary>
/// <param name="ParameterList">變數清單</param>
/// <returns>回傳查詢結果</returns>
public DataTable COM04_1(ArrayList ParameterList,
string ReportOutputFormat,
ref ReportList.ExcelOtherType EOT
)
{
COMModel.QueryQtySumByStore bco = new COMModel.QueryQtySumByStore(ConntionDB);
DataTable Dt = bco.QueryByStore(ParameterList);
if (Dt.Rows.Count == 0)
{
throw new Exception("查無資料");
}
else
{
return Dt;
}
}
}
public DataTable searchData()
{
#region 前置檢查與參數過濾
string txt_SLP_SKU = this.SLP_SKU.Text;
string txt_SLP_ItemPeriod = this.SLP_ItemPeriod.Text;
string txt_SLP_StoreChain = this.SLP_StoreChain.Text;
string txt_SLP_Store = this.SLP_Store.Text;
string txt_SLP_Z_O = this.SLP_Z_O.Text;
string txt_SLP_User = this.SLP_User.Text;
#endregion
#region 清空靜態變數
dt_Detail = null;
#endregion
#region 處理查詢
ParameterList.Clear();
ParameterList.Add(GetValueSetParameter(txt_SLP_SKU, "string"));//[品號]
ParameterList.Add(GetValueSetParameter(txt_SLP_ItemPeriod, "string"));//[期別]
ParameterList.Add(GetValueSetParameter(txt_SLP_StoreChain, "string"));
ParameterList.Add(GetValueSetParameter(txt_SLP_Store, "string"));
ParameterList.Add(GetValueSetParameter(txt_SLP_Z_O, "string"));
ParameterList.Add(GetValueSetParameter(txt_SLP_User, "string"));
ParameterList.Add(GetValueSetParameter(this.TextBoxRowCountLimit.Text, "int"));//筆數
ParameterList.Add(SLP_BUS_DATE.StartDate); //進貨日期起
ParameterList.Add(SLP_BUS_DATE.EndDate); //進貨日期迄
BCO.QueryQtySumByStore bco = new QueryQtySumByStore(ConntionDB);
DataTable Dt = bco.QueryByStore(ParameterList);
#endregion