/// <summary>
/// 產生STM28第二張報表_門市商品牌價清單
/// </summary>
/// <param name="ParameterList">變數清單</param>
/// <returns>回傳查詢結果</returns>
public DataTable STM28_2(ArrayList ParameterList)
{
DataTable Dt;
STMModel.QuerySTM28 BCO = new STMModel.QuerySTM28(ConntionDB);
if (ParameterList[2].ToString().Trim() == "")
{
Dt = BCO.GETSTM28R02DATA01(ParameterList);
DataTable Dt1 = BCO.GETSTM28R02DATA02(ParameterList);
if (Dt1.Rows.Count > 0)
{
foreach (DataRow dr1 in Dt1.Rows)
{
DataRow Dr = Dt.NewRow();
for (int j = 0; j < Dt1.Columns.Count; j++)
Dr[j] = dr1[j];
Dt.Rows.Add(Dr);
}
}
}
else
{
Dt = BCO.GETSTM28R02DATA02(ParameterList);
}
if (Dt.Rows.Count > 0)
{
return Dt;
}
else
{
throw new Exception("查無資料!!");
}
}
/// <summary>
/// 產生STM28第一張報表_門市商品牌價清單
/// </summary>
/// <param name="ParameterList">變數清單</param>
/// <returns>回傳查詢結果</returns>
public DataTable STM28_1(ArrayList ParameterList)
{
STMModel.QuerySTM28 BCO = new STMModel.QuerySTM28(ConntionDB);
DataTable Dt = BCO.GETSTM28R01DATA01(ParameterList);
if (Dt.Rows.Count > 0)
{
return Dt;
}
else
{
throw new Exception("查無資料!!");
}
}
