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();
            }
        }
Example #2
0
        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();
            }
        }
Example #3
0
        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();
            }
        }