/// <summary>
/// 產生VAM09第三張報表_對帳單明細
/// </summary>
/// <param name="ParameterList">變數清單</param>
/// <returns>回傳查詢結果</returns>
public DataTable VAM09_3(ArrayList ParameterList)
{
VAMModel.VAM09_BCO BCO = new VAMModel.VAM09_BCO(ConntionDB);
DataTable Dt = BCO.QueryVendorCheckSheetDetl(ParameterList);
if (Dt.Rows.Count > 0)
{
return Dt;
}
else
{
throw new Exception("查無資料!!");
}
}
/// <summary>
/// 產生VAM09第四張報表_對帳單單品
/// </summary>
/// <param name="ParameterList">變數清單</param>
/// <returns>回傳查詢結果</returns>
public DataSet VAM09_4(ArrayList ParameterList)
{
VAMModel.VAM09_BCO BCO = new VAMModel.VAM09_BCO(ConntionDB);
DataTable Dt1 = BCO.QueryVendorSKUCheckSheet(ParameterList);
DataTable Dt2 = BCO.QueryVendorSKUReturnCheckSheet(ParameterList);
#region 重組DATATABLE
DataTable dt_rpt1 = this.MakeDTForRptD();
if (Dt1.Rows.Count > 0)
{
for (int i = 0; i < Dt1.Rows.Count; i++)
{
DataRow drA = dt_rpt1.NewRow();
drA[0] = Dt1.Rows[i][0].ToString();
drA[1] = Dt1.Rows[i][1].ToString();
drA[2] = Dt1.Rows[i][2].ToString();
drA[3] = Dt1.Rows[i][3].ToString();
drA[4] = "";//RPT_TYPE
drA[5] = Dt1.Rows[i][4].ToString();
drA[6] = Dt1.Rows[i][5].ToString();
drA[7] = Dt1.Rows[i][6].ToString();
drA[8] = Convert.ToDecimal(Dt1.Rows[i][7].ToString());
drA[9] = Convert.ToDecimal(Dt1.Rows[i][8].ToString());
drA[10] = "進貨數";//ACCEPT_FIELD
drA[11] = Dt1.Rows[i][9].ToString();
drA[12] = "退貨數";//RETURN_FIELD
drA[13] = Dt1.Rows[i][10].ToString();
drA[14] = "銷售量";//SALE_FIELD
drA[15] = Convert.ToDecimal(Dt1.Rows[i][11].ToString());
drA[16] = Convert.ToDecimal(Dt1.Rows[i][12].ToString());
drA[17] = Convert.ToDecimal(Dt1.Rows[i][13].ToString());
drA[18] = Convert.ToDecimal(Dt1.Rows[i][14].ToString());
drA[19] = Convert.ToDecimal(Dt1.Rows[i][15].ToString());
dt_rpt1.Rows.Add(drA);
}
}
if (Dt2.Rows.Count > 0)
{
for (int i = 0; i < Dt2.Rows.Count; i++)
{
DataRow drA = dt_rpt1.NewRow();
drA[0] = Dt2.Rows[i][0].ToString();
drA[1] = Dt2.Rows[i][1].ToString();
drA[2] = Dt2.Rows[i][2].ToString();
drA[3] = Dt2.Rows[i][3].ToString();
drA[4] = "廠退日大於期別結束日";//RPT_TYPE
drA[5] = Dt2.Rows[i]["ITEM"].ToString();
drA[6] = Dt2.Rows[i]["ITEM_NAME"].ToString();
drA[7] = Dt2.Rows[i]["PERIOD"].ToString();
drA[8] = Convert.ToDecimal(Dt2.Rows[i]["PRICE"].ToString());
drA[9] = Convert.ToDecimal(Dt2.Rows[i]["COST"].ToString());
drA[10] = "退貨日期";//ACCEPT_FIELD
drA[11] = Convert.ToDateTime(Dt2.Rows[i]["RETURN_DATE"].ToString()).ToShortDateString();
drA[12] = "退貨單號";//RETURN_FIELD
drA[13] = Dt2.Rows[i]["RETURN_NO"].ToString();
drA[14] = "退貨數量";//SALE_FIELD
drA[15] = Convert.ToDecimal(Dt2.Rows[i]["RETURN_QTY"].ToString());
drA[16] = Convert.ToDecimal(Dt2.Rows[i]["ONHD_QTY"].ToString());
drA[17] = Convert.ToDecimal(Dt2.Rows[i][13].ToString());
drA[18] = Convert.ToDecimal(Dt2.Rows[i][14].ToString());
drA[19] = Convert.ToDecimal(Dt2.Rows[i][15].ToString());
dt_rpt1.Rows.Add(drA);
}
}
#endregion
if (dt_rpt1.Rows.Count > 0)
{
DataTable Dt3 = BCO.QueryVAM094SetIsMark(ParameterList);
DataTable dt_rpt2 = dt_rpt1.Clone();
if (Dt3.Rows.Count > 0)
{
for (int i = 0; i < Dt3.Rows.Count; i++)
{
DataRow drA = dt_rpt2.NewRow();
drA[0] = Dt3.Rows[i][0].ToString();
drA[1] = Dt3.Rows[i][1].ToString();
drA[2] = Dt3.Rows[i][2].ToString();
drA[3] = Dt3.Rows[i][3].ToString();
drA[4] = "已結帳資料,僅供參考";//RPT_TYPE
drA[5] = Dt3.Rows[i]["ITEM"].ToString();
drA[6] = Dt3.Rows[i]["ITEM_NAME"].ToString();
drA[7] = Dt3.Rows[i]["PERIOD"].ToString();
drA[8] = Convert.ToDecimal(Dt3.Rows[i]["PRICE"].ToString());
drA[9] = Convert.ToDecimal(Dt3.Rows[i]["COST"].ToString());
drA[10] = "進貨數";//ACCEPT_FIELD
drA[11] = Dt3.Rows[i]["ACCEPT_QTY"].ToString();
drA[12] = "退貨數";//RETURN_FIELD
drA[13] = Dt3.Rows[i]["RETURN_QTY"].ToString();
drA[14] = "銷售量";//SALE_FIELD
drA[15] = Convert.ToDecimal(Dt3.Rows[i]["SALES_QTY"].ToString());
drA[16] = Convert.ToDecimal(Dt3.Rows[i]["IS_MARK"].ToString());
drA[17] = 0;
drA[18] = 0;
drA[19] = 0;
dt_rpt2.Rows.Add(drA);
}
}
DataSet ds_Return = new DataSet();
dt_rpt1.TableName = "VAM094_R1";
dt_rpt2.TableName = "VAM094_R2";
ds_Return.Tables.Add(dt_rpt1.Copy());
ds_Return.Tables.Add(dt_rpt2.Copy());
dt_rpt1.Dispose();
dt_rpt2.Dispose();
return ds_Return;
}
else
{
throw new Exception("查無資料!!");
}
}
/// <summary>
/// 產生VAM09第六張報表_【實銷結-結清】
/// </summary>
/// <param name="ParameterList">變數清單</param>
/// <returns>回傳查詢結果</returns>
public DataTable VAM09_6(ArrayList ParameterList)
{
VAMModel.VAM09_BCO BCO = new VAMModel.VAM09_BCO(ConntionDB);
DataTable Dt = BCO.QueryVdsVamSalesClear(ParameterList);
if (Dt.Rows.Count > 0)
{
return Dt;
}
else
{
throw new Exception("查無資料!!");
}
}
