/*绑定主表信息*/ protected void BindMainInfo() { /*接受参数*/ string OrderNo = Request.QueryString["no"].ToString(); /*读取数据*/ DataTable dt = AdversarySellBus.GetRepOrder(OrderNo); /*绑定RPT*/ if (dt != null) { /*加载主报表*/ rd.Load(Server.MapPath(@"~/PrinttingModel/SellManager/AdversarySell.rpt")); crViewer.LogOnInfo.Add(ReportUtil.GetTableLogOnInfo("officedba.sellmodule_report_AdversarySell")); //绑定数据 rd.SetDataSource(dt); rd.Refresh(); this.crViewer.ReportSource = rd; UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; rd.SetParameterValue("PrintName", "制表人:" + userInfo.UserName); } }
protected void LoadPrintInfo() { PrintParameterSettingModel model = new PrintParameterSettingModel(); model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; model.BillTypeFlag = int.Parse(ConstUtil.BILL_TYPEFLAG_SALE); model.PrintTypeFlag = ConstUtil.PRINTBILL_ADVERSARYSELL; AdversarySellModel modelMRP = new AdversarySellModel(); modelMRP.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; modelMRP.CustNo = this.OfferNo; /*此处需注意在模板设置表里的字段和取基本信息的字段是否一致*/ string[,] aBase = { { "对手编号", "CustNo" }, { "销售机会", "ChanceNo" }, { "竞争客户", "CustName" }, { "对手产品报价", "Price" }, { "竞争产品/方案", "Project" }, { "竞争能力", "Power" }, { "竞争优势", "Advantage" }, { "竞争劣势", "disadvantage" }, { "应对策略", "Policy" }, { "制单人", "EmployeeName" }, { "制单日期", "CreatDate" }, { "最后更新人", "ModifiedUserID" }, { "最后更新日期", "ModifiedDate" }, { "备注", "Remark" }, }; string[,] aDetail = { { "", "" } }; DataTable dbPrint = XBase.Business.Common.PrintParameterSettingBus.GetPrintParameterSettingInfo(model); DataTable dtMRP = AdversarySellBus.GetRepOrder(OfferNo); //SellOfferBus.GetRepOrder(OfferNo); string strBaseFields = ""; if (dbPrint.Rows.Count > 0) { isSeted.Value = "1"; strBaseFields = dbPrint.Rows[0]["BaseFields"].ToString(); } else { isSeted.Value = "0"; strBaseFields = "CustNo|ChanceNo|CustName|Price|Project|Power|Advantage|disadvantage|Policy|EmployeeName|CreatDate|ModifiedUserID|ModifiedDate|Remark"; } #region 主表信息 if (!string.IsNullOrEmpty(strBaseFields)) { tableBase.InnerHtml = WritePrintPageTable("销售竞争分析", strBaseFields, "", aBase, aDetail, dtMRP, null, true); } #endregion #region 明细信息 //if (!string.IsNullOrEmpty(strDetailFields)) //{ // tableDetail.InnerHtml = WritePrintPageTable("销售合同", strBaseFields, strDetailFields, aBase, aDetail, dtMRP, dtDetail, false); //} #endregion }