/// <summary>
/// COM02營業人員報表
/// </summary>
/// <param name="ParameterList">變數清單</param>
/// <returns>回傳查詢結果</returns>
public DataTable COM02_3(ArrayList ParameterList,
string ReportOutputFormat,
ref ReportList.ExcelOtherType EOT
)
{
COMModel.QuerySalesBySaleDep bco = new COMModel.QuerySalesBySaleDep(ConntionDB);
DataTable Dt = bco.QueryBySalesPerson(ParameterList);
if (Dt.Rows.Count == 0)
{
throw new Exception("查無資料");
}
else
{
Dt = computeData(Dt);
return Dt;
}
}
return dTable;
#endregion
}
public DataTable searchData()
{
#region 前置檢查與參數過濾
string txt_STAcceptDate_B = this.SLP_STAcceptDate.StartDate;
string txt_STAcceptDate_E = this.SLP_STAcceptDate.EndDate;
#endregion
#region 清空靜態變數
dt_Detail = null;
#endregion
#region 處理查詢
ParameterList.Clear();
ParameterList.Add(GetValueSetParameter(txt_STAcceptDate_B, "string"));//[進貨日期](起)]
ParameterList.Add(GetValueSetParameter(txt_STAcceptDate_E, "string"));//[進貨日期](迄)]
ParameterList.Add(GetValueSetParameter(this.TextBoxRowCountLimit.Text, "int"));//筆數
BCO.QuerySalesBySaleDep bco = new QuerySalesBySaleDep(ConntionDB);
DataTable Dt = bco.QueryBySaleDep(ParameterList);
if (Dt != null && Dt.Rows.Count > 0)
{
Dt = computeData(Dt);
public DataTable searchData()
{
#region 清空靜態變數
dt_Detail = null;
#endregion
#region 處理查詢
ParameterList.Clear();
ParameterList.Add(GetValueSetParameter(this.txt_STAcceptDate_B.Text, "string"));//[進貨日期](起)]
ParameterList.Add(GetValueSetParameter(this.txt_STAcceptDate_E.Text, "string"));//[進貨日期](迄)]
ParameterList.Add(GetValueSetParameter(this.txt_Z_O.Text, "string"));//營業所
ParameterList.Add(GetValueSetParameter(this.txt_UserID.Text, "string"));//useID
ParameterList.Add(GetValueSetParameter("999999999", "int"));//筆數
BCO.QuerySalesBySaleDep bco = new QuerySalesBySaleDep(ConntionDB);
DataTable Dt = bco.QueryBySalesPersonProfitCenter(ParameterList);
if (Dt != null)
{
Dt = computeData(Dt);
}
return Dt;
#endregion