/// <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("查無資料!!"); } }