//private void LoadReport() //{ // try // { // this.rptView.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Local; // this.rptView.LocalReport.DataSources.Clear(); // LocalReport reportEngine = new LocalReport(); // using (ProxyBE p = new ProxyBE()) // { // this.rptView.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Local; // this.rptView.LocalReport.DataSources.Clear(); // DataSet ds = new DataSet("dsPackageLabel"); // DataTable tb = reportData.Tables[0].Copy(); // tb.Columns.Add(new DataColumn("Remarks", typeof(string))); // tb.Columns.Add(new DataColumn("PackageDesc", typeof(string))); // tb.Columns.Add(new DataColumn("Qty", typeof(int))); // tb.Columns.Add(new DataColumn("Barcode", typeof(byte[]))); // tb.Columns.Add(new DataColumn("Logo", typeof(byte[]))); // tb.Columns.Add(new DataColumn("PrintDate", typeof(string))); // //重置报表数据列 // foreach (DataRow row in tb.Rows) // { // SearchPackageDetailArgs subArgs = new SearchPackageDetailArgs(); // subArgs.OrderID = (Guid)row["OrderID"]; // subArgs.PackageID = (Guid)row["PackageID"]; // SearchResult subResult = p.Client.SearchPackageDetail(null, subArgs); // int totalQty = 0; // //string CabinetNum = ""; // string remarks = ""; // string strColor = ""; // int rowscount = 1; // var query = from g in subResult.DataSet.Tables[0].AsEnumerable() // group g by new // { // Size = g.Field<string>("Size"), // PackageNum = g.Field<int>("PackageNum"), // PackageBarcode = g.Field<string>("PackageBarcode"), // MaterialType = g.Field<string>("MaterialType"), // ItemName = g.Field<string>("ItemName"), // MadeLength = g.Field<decimal>("MadeLength"), // MadeWidth = g.Field<decimal>("MadeWidth"), // MadeHeight = g.Field<decimal>("MadeHeight") // } into lists_Package // select new // { // ItemName = lists_Package.Key.ItemName, // MaterialType = lists_Package.Key.MaterialType, // Size = lists_Package.Key.Size, // PackageBarcode = lists_Package.Key.PackageBarcode, // PackageNum = lists_Package.Key.PackageNum, // MadeWidth = lists_Package.Key.MadeWidth, // MadeLength = lists_Package.Key.MadeLength, // MadeHeight = lists_Package.Key.MadeHeight, // Qty = lists_Package.Sum(n => n.Field<int>("Qty")) // }; // if (query.ToList().Count > 0) // { // var lists = query.ToList(); // foreach (var item in lists) // { // if (rowscount > 11) // { // break; // } // totalQty += item.Qty; // string itemName = item.ItemName; // if ("A,B,C,D,E,F".Contains(itemName.Substring(0, 1))) // { // itemName = itemName.Substring(1); // } // int index = item.ItemName.LastIndexOf("mm"); // if (index >= 0) // { // itemName = itemName.Substring(index + 2, itemName.Length - (index + 2)); // } // if (item.ItemName.Length > 4) // { // remarks += string.Format("{0}:{1}*{2}*{3}={4}\r\n", itemName.Substring(0, 4), item.MadeLength.ToString("#"), item.MadeWidth.ToString("#"), item.MadeHeight.ToString("#"), item.Qty); // } // else // { // remarks += string.Format("{0}:{1}*{2}*{3}={4}\r\n", itemName, item.MadeLength.ToString("#"), item.MadeWidth.ToString("#"), item.MadeHeight.ToString("#"), item.Qty); // } // strColor = item.MaterialType; // rowscount++; // }; // } // row["Qty"] = totalQty; // row["Remarks"] = remarks; // row["Address"] = row["Province"].ToString() + row["City"].ToString() + row["Address"].ToString(); // row["Barcode"] = CommonView.getQRcode(row["PackageBarcode"].ToString()); // row["PackageDesc"] = string.Format("第 {0} 包", int.Parse(row["PackageNum"].ToString()).ToString("00")); // row["Logo"] = CommonView.getLogoFile(this.LogoFile); // row["PrintDate"] = DateTime.Now.ToString("yyyy-MM-dd"); // } // ds.Tables.Add(tb); // ReportDataSource rptDataSource = new ReportDataSource(); // rptDataSource.Name = "dsPackageLabel"; // rptDataSource.Value = ds.Tables[0]; // LocalReport report = new LocalReport(); // report.DataSources.Clear(); // //设置需要打印的报表的文件名称。 // report.ReportEmbeddedResource = "Mes.Package.Report.rptPackageLabel.rdlc"; // report.DataSources.Add(rptDataSource); // //刷新报表中的需要呈现的数据 // report.Refresh(); // this.rptView.LocalReport.DataSources.Add(rptDataSource); // this.rptView.RefreshReport(); // } // } // catch (Exception ex) // { // MessageBox.Show(ex.Message, "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Error); // } //} /// <summary> /// 打印预览 /// </summary> public void PreviewReport() { CrptDataSource rptds = new CrptDataSource(); DataSet ds = rptds.GetItemLabelDataSource(this.reportData.Tables[0], this.LogoFile); ReportDataSource rptDataSource = new ReportDataSource(); rptDataSource.Name = "tbPackageDataTable"; rptDataSource.Value = ds.Tables[0]; this.rptView.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Local; this.rptView.LocalReport.DataSources.Clear(); this.rptView.LocalReport.ReportEmbeddedResource = "Mes.Package.Report.Report1.rdlc"; this.rptView.LocalReport.DataSources.Add(rptDataSource); this.rptView.RefreshReport(); }
public void PreviewCommonReport(Guid CabinetID, string CategoryName) { CrptDataSource rptds = new CrptDataSource(); DataSet ds = rptds.GetCommonLabelDataSource(CabinetID, CategoryName, this.LogoFile); ReportDataSource rptDataSource = new ReportDataSource(); rptDataSource.Name = "tbPackageDataTable"; rptDataSource.Value = ds.Tables[0]; this.rptView.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Local; this.rptView.LocalReport.DataSources.Clear(); this.rptView.LocalReport.ReportEmbeddedResource = "Mes.Package.Report.rptCommonLabel.rdlc"; this.rptView.LocalReport.DataSources.Add(rptDataSource); this.rptView.RefreshReport(); }
public void PrintCommonLabel(Guid CabinetID, string CategoryName) { CrptDataSource rptdata = new CrptDataSource(); DataSet ds = rptdata.GetCommonLabelDataSource(CabinetID, CategoryName, this.LogoFile); ReportDataSource rptDataSource = new ReportDataSource(); rptDataSource.Name = "tbPackageDataTable"; rptDataSource.Value = ds.Tables[0]; LocalReport report = new LocalReport(); report.DataSources.Clear(); //设置需要打印的报表的文件名称。 report.ReportEmbeddedResource = "Mes.Package.Report.rptDoorLabel.rdlc"; report.DataSources.Add(rptDataSource); //刷新报表中的需要呈现的数据 report.Refresh(); PrintStream(report); }