protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //提取数据 int mainId = 0; string whereOther = ""; if (Request.QueryString["mainId"] != null && Request.QueryString["mainId"].Trim() != "" && Request.QueryString["mainId"].Trim() != "null") { mainId = Convert.ToInt32(Request.QueryString["mainId"].Trim()); } YnBaseDal.YnPage ynPage = new YnBaseDal.YnPage(); ynPage.SetPageSize(500); //pageRows; ynPage.SetCurrentPage(1); //pageNumber; List <AscmWmsBackInvoiceDetail> listAscmWmsBackInvoiceDetail = AscmWmsBackInvoiceDetailService.GetInstance().GetList(ynPage, "", "", mainId, "", whereOther); AscmWmsBackInvoiceMain ascmWmsBackInvoiceMain = AscmWmsBackInvoiceMainService.GetInstance().Get(mainId); if (ascmWmsBackInvoiceMain != null) { ascmWmsBackInvoiceMain.ascmSupplier = AscmSupplierService.GetInstance().Get(ascmWmsBackInvoiceMain.supplierId); } ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local; ReportViewer1.LocalReport.ReportPath = Server.MapPath("WmsBackInvoiceDetailReport.rdlc"); ReportDataSource rds1 = new ReportDataSource(); rds1.Name = "DataSet1"; rds1.Value = listAscmWmsBackInvoiceDetail; ReportViewer1.LocalReport.DataSources.Clear();//好像不clear也可以 ReportViewer1.LocalReport.DataSources.Add(rds1); string companpyTitle = "美的中央空调"; string title = companpyTitle + "供应商退货明细"; ReportParameter[] reportParameters = new ReportParameter[] { new ReportParameter("ReportParameter_Title", title), new ReportParameter("ReportParameter_ReportTime", "打印时间:" + DateTime.Now.ToString("yyyy-MM-dd")), new ReportParameter("ReportParameter_DocNumber", "单据号:" + ascmWmsBackInvoiceMain.docNumber), new ReportParameter("ReportParameter_ManualDocNumber", "手工单号:" + ascmWmsBackInvoiceMain.manualDocNumber), new ReportParameter("ReportParameter_ResponsiblePerson", "责任人:" + ascmWmsBackInvoiceMain.responsiblePerson), new ReportParameter("ReportParameter_WarehouseId", "默认仓库:" + ascmWmsBackInvoiceMain.warehouseId), new ReportParameter("ReportParameter_StatusCn", "状态:" + ascmWmsBackInvoiceMain.statusCn), new ReportParameter("ReportParameter_ReasonName", "退货原因:" + ascmWmsBackInvoiceMain.reasonName), new ReportParameter("ReportParameter_SupplierDocNumber", "供方编码:" + ascmWmsBackInvoiceMain.supplierDocNumber), new ReportParameter("ReportParameter_SupplierName", "供方名称:" + ascmWmsBackInvoiceMain.supplierName), new ReportParameter("ReportParameter_Memo", "备注:" + ascmWmsBackInvoiceMain.memo), }; ReportViewer1.LocalReport.SetParameters(reportParameters); ReportViewer1.LocalReport.Refresh(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //提取数据 int mainId = 0; if (Request.QueryString["mainId"] != null && Request.QueryString["mainId"].Trim() != "" && Request.QueryString["mainId"].Trim() != "null") { mainId = Convert.ToInt32(Request.QueryString["mainId"].Trim()); } YnBaseDal.YnPage ynPage = new YnBaseDal.YnPage(); ynPage.SetPageSize(500); //pageRows; ynPage.SetCurrentPage(1); //pageNumber; List <AscmWmsIncManAccDetail> listAscmWmsIncManAccDetail = AscmWmsIncManAccDetailService.GetInstance().GetList(mainId); AscmWmsIncManAccMain ascmWmsIncManAccMain = AscmWmsIncManAccMainService.GetInstance().Get(mainId); if (ascmWmsIncManAccMain != null) { ascmWmsIncManAccMain.ascmSupplier = AscmSupplierService.GetInstance().Get(ascmWmsIncManAccMain.supplierId); ascmWmsIncManAccMain.ascmSupplierAddress = AscmSupplierAddressService.GetInstance().Get(ascmWmsIncManAccMain.supplierAddressId); } ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local; ReportViewer1.LocalReport.ReportPath = Server.MapPath("WmsIncManAccDetailReport.rdlc"); ReportDataSource rds1 = new ReportDataSource(); rds1.Name = "DataSet1"; rds1.Value = listAscmWmsIncManAccDetail; ReportViewer1.LocalReport.DataSources.Clear();//好像不clear也可以 ReportViewer1.LocalReport.DataSources.Add(rds1); string companpyTitle = "美的中央空调"; string title = companpyTitle + "送货单明细"; ReportParameter[] reportParameters = new ReportParameter[] { new ReportParameter("ReportParameter_Title", title), new ReportParameter("ReportParameter_ReportTime", "打印时间:" + DateTime.Now.ToString("yyyy-MM-dd")), new ReportParameter("ReportParameter_DocNumber", "送货单号:" + ascmWmsIncManAccMain.docNumber), new ReportParameter("ReportParameter_ResponsiblePerson", "责任人:" + ascmWmsIncManAccMain.responsiblePerson), new ReportParameter("ReportParameter_CreateTimeShow", "生成时间:" + ascmWmsIncManAccMain.createTimeShow), new ReportParameter("ReportParameter_SupplierDocNumber", "供方编码:" + ascmWmsIncManAccMain.supplierDocNumber), new ReportParameter("ReportParameter_SupplierName", "供方名称:" + ascmWmsIncManAccMain.supplierName), new ReportParameter("ReportParameter_WarehouseId", "收货仓库:" + ascmWmsIncManAccMain.warehouseId), new ReportParameter("ReportParameter_SupperWarehouse", "供应子库:" + ascmWmsIncManAccMain.supperWarehouse), new ReportParameter("ReportParameter_SupperPlateNumber", "运输车牌:" + ascmWmsIncManAccMain.supperPlateNumber), new ReportParameter("ReportParameter_SupperTelephone", "联系电话:" + ascmWmsIncManAccMain.supperTelephone), new ReportParameter("ReportParameter_Memo", "备注:" + ascmWmsIncManAccMain.memo), }; ReportViewer1.LocalReport.SetParameters(reportParameters); ReportViewer1.LocalReport.Refresh(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //提取数据 string queryWord = ""; if (Request.QueryString["queryWord"] != null && Request.QueryString["queryWord"].Trim() != "" && Request.QueryString["queryWord"].Trim() != "null") { queryWord = Request.QueryString["queryWord"].Trim(); } YnBaseDal.YnPage ynPage = new YnBaseDal.YnPage(); ynPage.SetPageSize(500); //pageRows; ynPage.SetCurrentPage(1); //pageNumber; List <AscmSupplier> listAscmSupplier = AscmSupplierService.GetInstance().GetList(ynPage, "", "", queryWord, null); ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local; ReportViewer1.LocalReport.ReportPath = Server.MapPath("SupplierReport.rdlc"); ReportDataSource rds1 = new ReportDataSource(); rds1.Name = "DataSet1"; rds1.Value = listAscmSupplier; ReportViewer1.LocalReport.DataSources.Clear();//好像不clear也可以 ReportViewer1.LocalReport.DataSources.Add(rds1); string companpyTitle = "美的中央空调"; string title = companpyTitle + "供应商"; ReportParameter[] reportParameters = new ReportParameter[] { new ReportParameter("ReportParameter_Title", title), new ReportParameter("ReportParameter_ReportTime", "打印时间:" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss")) }; ReportViewer1.LocalReport.SetParameters(reportParameters); ReportViewer1.LocalReport.Refresh(); } }