/// <summary>
/// COM07報表
/// </summary>
/// <param name="ParameterList">變數清單</param>
/// <returns>回傳查詢結果</returns>
public DataTable COM15_1(ArrayList ParameterList,
string ReportOutputFormat,
ref ReportList.ExcelOtherType EOT
)
{
COMModel.COM15_BCO bco = new COMModel.COM15_BCO(ConntionDB);
DataTable Dt = bco.QuerySalesReport(ParameterList);
if (Dt.Rows.Count == 0)
{
throw new Exception("查無資料");
}
else
{
return Dt;
}
}
private DataTable QuerySum_Accept_Qty()
{
BCO.COM15_BCO bco = new BCO.COM15_BCO(ConntionDB);
#region 前置檢查與參數過濾
string strSLP_StoreChain = this.SLP_StoreChain.Text;
string strSLP_SKU = this.SLP_SKU.Text;
string strSLP_ItemPeriod = this.SLP_ItemPeriod.Text;
#endregion
#region 組合查詢條件至ArrayList
ParameterList.Clear();
ParameterList.Add(GetValueSetParameter(strSLP_StoreChain, "string"));
ParameterList.Add(GetValueSetParameter(strSLP_SKU, "string"));
ParameterList.Add(GetValueSetParameter(strSLP_ItemPeriod, "string"));
#endregion
DataTable dt = bco.QuerySum_Accept_Qty(ParameterList);
return dt;
}
private DataTable QueryZ_O()
{
BCO.COM15_BCO bco = new BCO.COM15_BCO(ConntionDB);
DataTable dt = bco.QueryZ_O();
return dt;
}
