/// <summary>
/// CGR05報表
/// </summary>
/// <param name="ParameterList">變數清單</param>
/// <returns>回傳查詢結果</returns>
public DataTable VGR06_1(ArrayList ParameterList,
string ReportOutputFormat,
ref ReportList.ExcelOtherType EOT
)
{
VGRModel.VDS_VGR06_BCO bco = new VGRModel.VDS_VGR06_BCO(ConntionDB);
DataTable dtData = bco.GetRptData(ParameterList);
if (dtData.Rows.Count == 0)
{
throw new Exception("查無資料");
}
else
{
DataTable dtResult = dtData.Copy();
DataView dv = dtData.DefaultView;
dv.Sort = "Return_No asc,Item asc,Period asc";
dtData = dv.ToTable();
//取得筆數資料，筆數未滿10的倍數，塞假資料補成10的倍數(因為套表是10筆1張)
int iSeqNo = 0;
for (int j = 0; j < dtData.Rows.Count; j++)
{
if (j > 0)
{
if (dtData.Rows[j]["Return_No"].ToString().Trim() != dtData.Rows[j - 1]["Return_No"].ToString().Trim())
{
if (iSeqNo < 10)
{
for (int i = 0; i < (10 - iSeqNo); i++)
{
DataRow drNew = dtResult.NewRow();
drNew["Return_Date"] = dtData.Rows[j - 1]["Return_Date"].ToString();
drNew["Vendor_Name"] = dtData.Rows[j - 1]["Vendor_Name"].ToString();
drNew["Vendor"] = dtData.Rows[j - 1]["Vendor"].ToString();
drNew["Business_Contact"] = dtData.Rows[j - 1]["Business_Contact"].ToString();
drNew["Business_Fax"] = dtData.Rows[j - 1]["Business_Fax"].ToString();
drNew["Return_No"] = dtData.Rows[j - 1]["Return_No"].ToString();
drNew["Tax_Total_Amt"] = decimal.Parse(dtData.Rows[j - 1]["Tax_Total_Amt"].ToString());
drNew["UnTax_Total_Amt"] = decimal.Parse(dtData.Rows[j - 1]["UnTax_Total_Amt"].ToString());
drNew["Tax_Amt"] = decimal.Parse(dtData.Rows[j - 1]["Tax_Amt"].ToString());
drNew["Item"] = "XXXXXXXXXX"; //只要ITEM是XXXXXXXXXX就抑制顯示
drNew["Item_Name"] = "";
drNew["Period"] = "";
drNew["Return_Qty"] = 0;
drNew["Price"] = 0;
drNew["Cost"] = 0;
dtResult.Rows.Add(drNew);
}
}
iSeqNo = 0;
}
}
iSeqNo++;
}
if (iSeqNo < 10) //判斷最後一筆是否為第10筆
{
for (int i = 0; i < (10 - iSeqNo); i++)
{
DataRow drNew = dtResult.NewRow();
drNew["Return_Date"] = dtData.Rows[dtData.Rows.Count - 1]["Return_Date"].ToString();
drNew["Vendor_Name"] = dtData.Rows[dtData.Rows.Count - 1]["Vendor_Name"].ToString();
drNew["Vendor"] = dtData.Rows[dtData.Rows.Count - 1]["Vendor"].ToString();
drNew["Business_Contact"] = dtData.Rows[dtData.Rows.Count - 1]["Business_Contact"].ToString();
drNew["Business_Fax"] = dtData.Rows[dtData.Rows.Count - 1]["Business_Fax"].ToString();
drNew["Return_No"] = dtData.Rows[dtData.Rows.Count - 1]["Return_No"].ToString();
drNew["Tax_Total_Amt"] = decimal.Parse(dtData.Rows[dtData.Rows.Count - 1]["Tax_Total_Amt"].ToString());
drNew["UnTax_Total_Amt"] = decimal.Parse(dtData.Rows[dtData.Rows.Count - 1]["UnTax_Total_Amt"].ToString());
drNew["Tax_Amt"] = decimal.Parse(dtData.Rows[dtData.Rows.Count - 1]["Tax_Amt"].ToString());
drNew["Item"] = "XXXXXXXXXX"; //只要ITEM是XXXXXXXXXX就抑制顯示
drNew["Item_Name"] = "";
drNew["Period"] = "";
drNew["Return_Qty"] = 0;
drNew["Price"] = 0;
drNew["Cost"] = 0;
dtResult.Rows.Add(drNew);
}
}
dv = dtResult.DefaultView;
dv.Sort = "Return_No asc,Item asc,Period asc";
dtResult = dv.ToTable();
return dtResult;
}
}
