/// <summary> /// MKT10報表 /// </summary> /// <param name="ParameterList">變數清單</param> /// <returns>回傳查詢結果</returns> public DataSet MKT06_1(ArrayList ParameterList) { DataSet ds = new DataSet(); MKTModel.MaintainBooksPurchaseCardChain bco = new MKTModel.MaintainBooksPurchaseCardChain(ConntionDB); DataTable Dt1 = bco.QueryMstForPrint(ParameterList); if (Dt1.Rows.Count == 0) throw new Exception("查無資料"); DataTable Dt2 = Check_Row(bco.QueryDetlForPrint(ParameterList), ParameterList[0].ToString()); DataTable Dt3 = bco.QueryRefGoodsForPrint(ParameterList); Dt1.TableName = "CRMKT06R01"; ds.Tables.Add(Dt1.Copy()); Dt2.TableName = "CRMKT06R02"; ds.Tables.Add(Dt2.Copy()); Dt3.TableName = "CRMKT06R03"; ds.Tables.Add(Dt3.Copy()); return ds; }
protected void btnPrint_Click(object sender, EventArgs e) { ErrorMsgLabel.Text = ""; if (VerifyFormData() == true) { try { DataSet ds = new DataSet(); //VDS_MKT_BPURCARD_MAIN MKT.MaintainBooksPurchaseCardChain BCO = new MKT.MaintainBooksPurchaseCardChain(ConntionDB); ParameterList.Clear(); ParameterList.Add(hidBpurcard_no.Value); DataTable Dt_M = BCO.QueryMstForPrint(ParameterList); if (Dt_M.Rows.Count == 0) { ScriptManager.RegisterStartupScript(Page, this.GetType(), "MKT062.aspx", "alert(' 查無資料 ');", true); return; } //VDS_MKT_BPURCARD_CHAIN MKT.MaintainBooksPurchaseCardChain BCO_Detail = new MKT.MaintainBooksPurchaseCardChain(ConntionDB); ParameterList.Clear(); ParameterList.Add(hidBpurcard_no.Value); DataTable Dt_D = BCO_Detail.QueryDetlForPrint(ParameterList); DataTable Dt_D_Check = Check_Row(Dt_D); //VDS_MKT_BPURCARD_REFGOODS MKT.MaintainBooksPurchaseCardChain BCO_Detail2 = new MKT.MaintainBooksPurchaseCardChain(ConntionDB); ParameterList.Clear(); ParameterList.Add(hidBpurcard_no.Value); DataTable Dt_D_GOODS = BCO_Detail2.QueryRefGoodsForPrint(ParameterList); //加入報表 Dt_M.TableName = "CRMKT06R01"; ds.Tables.Add(Dt_M.Copy()); Dt_D_Check.TableName = "CRMKT06R02"; ds.Tables.Add(Dt_D_Check.Copy()); Dt_D_GOODS.TableName = "CRMKT06R03"; ds.Tables.Add(Dt_D_GOODS.Copy()); ShowReport(ds); } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } finally { } } }