/// <summary>
/// IVM22_2報表(列印鈕)
/// </summary>
/// <param name="ParameterList">變數清單</param>
/// <returns>回傳查詢結果</returns>
public DataTable IVM22_2(ArrayList ParameterList)
{
#region
IVMModel.PrintStockDetl BCO = new IVMModel.PrintStockDetl(ConntionDB);
DataTable Dt = BCO.PrintRpt02(ParameterList);
if (Dt.Rows.Count == 0)
{
throw new Exception("查無資料");
}
else
{
return Dt;
}
#endregion
}
public DataTable queryData()
{
ResultMsgLabel.Text = "";
BCO.PrintStockDetl bco = new BCO.PrintStockDetl(ConntionDB);
DataTable Dt = null;
ArrayList aList = this.getParameterList();
switch (rdoRpt.SelectedValue)
{
case "0":
Dt = bco.PrintRpt01(aList);
break;
case "1":
Dt = bco.PrintRpt02(aList);
break;
default:
break;
}
return Dt;
}
/// <summary>
/// IVM22_4報表(匯出鈕)-依廠商排序
/// </summary>
/// <param name="ParameterList">變數清單</param>
/// <param name="ReportOutputFormat">報表格式(PDF,EXCEL)</param>
/// <param name="EOT">匯出Excel方式</param>
/// <returns>回傳查詢結果</returns>
public DataTable IVM22_4(ArrayList ParameterList,
string ReportOutputFormat,
ref ReportList.ExcelOtherType EOT
)
{
#region
IVMModel.PrintStockDetl BCO = new IVMModel.PrintStockDetl(ConntionDB);
DataTable Dt = BCO.PrintRpt02(ParameterList);
if (Dt.Rows.Count == 0)
{
throw new Exception("查無資料");
}
//設定使用第三方元件匯出EXCEL
if (ReportOutputFormat == "EXCEL")
{
#region 表頭
#endregion
EOT = ReportList.ExcelOtherType.None;
}
return Dt;
#endregion
}