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();
}