private void HY_PurchasingdetailsReport_Load(object sender, EventArgs e) { HY_Invoicing.HY_Purchasingstatus hypur;//实例化传值窗体 hypur = (HY_Invoicing.HY_Purchasingstatus)this.Owner; string aa = hypur.GetMainvalue;//单号传值 string sup = hypur.HYSupplier;//供应商传值 string model = hypur.ModelID;//模号 HY_BLL.HY_StorageBLL hystorfobll = new HY_StorageBLL(); string sql = "select * from HY_ProcurementInfo where c_DID='" + aa + "' and c_Supplier='"+sup+"'"; DataSet ds = hystorfobll.ExecuteQueryDataSet(sql); this.reportViewer1.LocalReport.ReportEmbeddedResource = "LL.Main.HY_Report.HY_ProcurementInfoReport.rdlc"; this.reportViewer1.LocalReport.DataSources.Clear(); this.reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("HY_ProcurementInfo", ds.Tables[0])); //设置打印布局模式,显示物理页面大小 this.reportViewer1.SetDisplayMode(Microsoft.Reporting.WinForms.DisplayMode.PrintLayout); //缩放模式为百分比,以100%方式显示 this.reportViewer1.ZoomMode = Microsoft.Reporting.WinForms.ZoomMode.Percent; this.reportViewer1.ZoomPercent = 100; ReportParameter rp = new ReportParameter("content", sup); this.reportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp }); ReportParameter rp1 = new ReportParameter("cgID", aa); this.reportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp1 }); ReportParameter mod = new ReportParameter("modelID", model); this.reportViewer1.LocalReport.SetParameters(new ReportParameter[] { mod }); // TODO: 这行代码将数据加载到表“hYMISDataSet.HY_ProcurementInfo”中。您可以根据需要移动或移除它。 //this.HY_ProcurementInfoTableAdapter.Fill(this.DataSet1.HY_ProcurementInfo, aa); this.reportViewer1.RefreshReport(); }
private void HY_BomlistDB2_Load(object sender, EventArgs e) { LL.Main.HY_Production.HY_BomAudit hybomaud;//实例化传值窗体 hybomaud = (LL.Main.HY_Production.HY_BomAudit)this.Owner; string aa = hybomaud.B_SKID; string cid = hybomaud.B_CNID; string customer = hybomaud.B_CustomerID; string no = hybomaud.B_No; string material = hybomaud.B_Material; string bomSize = hybomaud.B_BomSize; string height = hybomaud.B_Height; string tonnage = hybomaud.B_Tonnage; string mname = hybomaud.B_Name; string notes = hybomaud.B_Notes; HY_BLL.HY_StorageBLL hystorfobll = new HY_StorageBLL(); string sql = "select * from HY_BomDetails where d_SKID='" + aa + "' order by d_ID desc"; DataSet ds = hystorfobll.ExecuteQueryDataSet(sql); this.reportViewer1.LocalReport.ReportEmbeddedResource = "LL.Main.HY_Report.HY_BomlistReport.rdlc"; this.reportViewer1.LocalReport.DataSources.Clear(); ReportParameter bid = new ReportParameter("BID", aa); this.reportViewer1.LocalReport.SetParameters(new ReportParameter[] { bid }); ReportParameter cnid = new ReportParameter("CNID", cid); this.reportViewer1.LocalReport.SetParameters(new ReportParameter[] {cnid}); ReportParameter cust = new ReportParameter("CustomerID", customer); this.reportViewer1.LocalReport.SetParameters(new ReportParameter[] { cust }); ReportParameter gcs = new ReportParameter("GCS", no); this.reportViewer1.LocalReport.SetParameters(new ReportParameter[] { gcs }); ReportParameter cz = new ReportParameter("CZ", material); this.reportViewer1.LocalReport.SetParameters(new ReportParameter[] { cz }); ReportParameter boms = new ReportParameter("YLZC", bomSize); this.reportViewer1.LocalReport.SetParameters(new ReportParameter[] { boms }); ReportParameter bhgd = new ReportParameter("BHGD", height); this.reportViewer1.LocalReport.SetParameters(new ReportParameter[] { bhgd }); ReportParameter ccd = new ReportParameter("CCDW", tonnage); this.reportViewer1.LocalReport.SetParameters(new ReportParameter[] { ccd }); ReportParameter mjmc = new ReportParameter("MJMC", mname); this.reportViewer1.LocalReport.SetParameters(new ReportParameter[] { mjmc }); ReportParameter gznr = new ReportParameter("GZNR", notes); this.reportViewer1.LocalReport.SetParameters(new ReportParameter[] { gznr }); this.reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("HY_BomDetails", ds.Tables[0])); //设置打印布局模式,显示物理页面大小 this.reportViewer1.SetDisplayMode(Microsoft.Reporting.WinForms.DisplayMode.PrintLayout); //缩放模式为百分比,以100%方式显示 this.reportViewer1.ZoomMode = Microsoft.Reporting.WinForms.ZoomMode.Percent; this.reportViewer1.ZoomPercent = 100; this.reportViewer1.RefreshReport(); }
private void HY_StorageDB_Load(object sender, EventArgs e) { HY_BLL.HY_StorageBLL hystorfobll = new HY_StorageBLL(); string sql = "select * from HY_Storage order by s_ID desc"; DataSet ds = hystorfobll.ExecuteQueryDataSet(sql); this.reportViewer1.LocalReport.ReportEmbeddedResource = "LL.Main.HY_Report.HY_StrageReport.rdlc"; this.reportViewer1.LocalReport.DataSources.Clear(); this.reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("myds", ds.Tables[0].DefaultView)); // TODO: 这行代码将数据加载到表“DataSet1.HY_Storage”中。您可以根据需要移动或移除它。 //this.HY_StorageTableAdapter.Fill(this.DataSet1.HY_Storage); //设置打印布局模式,显示物理页面大小 this.reportViewer1.SetDisplayMode(Microsoft.Reporting.WinForms.DisplayMode.PrintLayout); //缩放模式为百分比,以100%方式显示 this.reportViewer1.ZoomMode = Microsoft.Reporting.WinForms.ZoomMode.Percent; this.reportViewer1.ZoomPercent = 100; this.reportViewer1.RefreshReport(); }
private void HY_BomlistDB_Load(object sender, EventArgs e) { LL.Main.HY_Production.HY_BOMListInventory hybomlist;//实例化传值窗体 hybomlist = (LL.Main.HY_Production.HY_BOMListInventory)this.Owner; string aa = hybomlist.GetBomvalue;//传值 HY_BLL.HY_StorageBLL hystorfobll = new HY_StorageBLL(); string sql = "select * from HY_BomDetails where d_SKID='" + aa + "' order by d_ID desc"; DataSet ds = hystorfobll.ExecuteQueryDataSet(sql); this.reportViewer1.LocalReport.ReportEmbeddedResource = "LL.Main.HY_Report.HY_BomlistReport.rdlc"; this.reportViewer1.LocalReport.DataSources.Clear(); this.reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("HY_BomDetails", ds.Tables[0])); // TODO: 这行代码将数据加载到表“DataSet1.HY_Storage”中。您可以根据需要移动或移除它。 //this.HY_StorageTableAdapter.Fill(this.DataSet1.HY_Storage); //设置打印布局模式,显示物理页面大小 this.reportViewer1.SetDisplayMode(Microsoft.Reporting.WinForms.DisplayMode.PrintLayout); //缩放模式为百分比,以100%方式显示 this.reportViewer1.ZoomMode = Microsoft.Reporting.WinForms.ZoomMode.Percent; this.reportViewer1.ZoomPercent = 100; this.reportViewer1.RefreshReport(); }