/// <summary> /// MKT10報表 /// </summary> /// <param name="ParameterList">變數清單</param> /// <returns>回傳查詢結果</returns> public DataSet MKT05_1(ArrayList ParameterList) { DataSet ds = new DataSet(); MKTModel.MaintainPurchaseCard bco = new MKTModel.MaintainPurchaseCard(ConntionDB); DataTable Dt1 = bco.QueryMstForPrint(ParameterList); if (Dt1.Rows.Count == 0) throw new Exception("查無資料"); DataTable Dt2 = Check_Row(bco.QueryDetlForPrint(ParameterList), ParameterList[0].ToString()); Dt1.TableName = "CRMKT05R01"; ds.Tables.Add(Dt1.Copy()); Dt2.TableName = "CRMKT05R02"; ds.Tables.Add(Dt2.Copy()); return ds; }
protected void btnPrint_Click(object sender, EventArgs e) { if (VerifyFormData() == true) { try { DataSet ds = new DataSet(); //VDS_MKT_PURCHASE_MAIN MKT.MaintainPurchaseCard BCO = new MKT.MaintainPurchaseCard(ConntionDB); ParameterList.Clear(); ParameterList.Add(hidPurcard_no.Value); DataTable Dt_M = BCO.QueryMstForPrint(ParameterList); if (Dt_M.Rows.Count == 0) { ScriptManager.RegisterStartupScript(Page, this.GetType(), "MKT052.aspx", "alert(' 查無資料 ');", true); return; } //VDS_MKT_PURCHASE_CHAIN MKT.MaintainPurchaseCard BCO_Detail = new MKT.MaintainPurchaseCard(ConntionDB); ParameterList.Clear(); ParameterList.Add(hidPurcard_no.Value); DataTable Dt_D = BCO_Detail.QueryDetlForPrint(ParameterList); DataTable Dt_D_Check = Check_Row(Dt_D); //加入報表 Dt_M.TableName = "CRMKT05R01"; ds.Tables.Add(Dt_M.Copy()); Dt_D_Check.TableName = "CRMKT05R02"; ds.Tables.Add(Dt_D_Check.Copy()); ShowReport(ds); } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; UpdatePanel_ErrMsg.Update(); } } }