private MemoryStream PrintVoucher(string billNo) { XtraReport rpt = new XtraReport(); rpt.LoadLayout(Server.MapPath(@"~\ReportFreightSea\repx\Account\Voucher.repx")); DataSet set = AccountFreightPrint.PrintVoucher(billNo); DevExpress.XtraReports.UI.GroupFooterBand groupFooter1 = rpt.Report.Bands["GroupFooter1"] as DevExpress.XtraReports.UI.GroupFooterBand; DevExpress.XtraReports.UI.XRSubreport subReport1 = new XRSubreport(); subReport1.Name = "groupFooter1"; groupFooter1.Controls.Add(subReport1); XtraReport rpt1 = new XtraReport(); rpt1.LoadLayout(Server.MapPath(@"~\ReportFreightSea\repx\Account\Voucher_detail.repx")); subReport1.ReportSource = rpt1; rpt1.DataSource = set; DevExpress.XtraReports.UI.GroupFooterBand groupFooter2 = rpt.Report.Bands["GroupFooter2"] as DevExpress.XtraReports.UI.GroupFooterBand; DevExpress.XtraReports.UI.XRSubreport subReport2 = new XRSubreport(); subReport2.Name = "groupFooter2"; groupFooter2.Controls.Add(subReport2); XtraReport rpt2 = new XtraReport(); rpt2.LoadLayout(Server.MapPath(@"~\ReportFreightSea\repx\Account\Voucher_detail.repx")); subReport2.ReportSource = rpt2; rpt2.DataSource = set; System.IO.MemoryStream str = new MemoryStream(); rpt.ExportToPdf(str); return(str); }
private MemoryStream PrintWh_invoice(string refN, string refType, string userId) { string user = HttpContext.Current.User.Identity.Name; XtraReport rpt = new XtraReport(); rpt.LoadLayout(Server.MapPath(@"~\ReportWarehouse\repx\invoice.repx")); string strsql = string.Format(@"exec proc_PrintInvoice_wh '{0}','{1}','{2}','{3}','{4}'", refN, "", refType, userId, ""); DataSet ds_temp = ConnectSql.GetDataSet(strsql); DataTable Mast = ds_temp.Tables[0].Copy(); Mast.TableName = "Mast"; DataTable Detail = ds_temp.Tables[1].Copy(); Detail.TableName = "Detail"; DataTable Detail2 = new DataTable(); if (ds_temp.Tables.Count > 2) { Detail2 = ds_temp.Tables[2].Copy(); Detail2.TableName = "Detail"; } if (Detail.Rows.Count > 0) { DevExpress.XtraReports.UI.GroupFooterBand groupFooter_Inv = rpt.Report.Bands["GroupFooter_Wine"] as DevExpress.XtraReports.UI.GroupFooterBand; DevExpress.XtraReports.UI.XRSubreport subReport_Inv = new XRSubreport(); subReport_Inv.Name = "GroupFooter_Wine1"; groupFooter_Inv.Controls.Add(subReport_Inv); XtraReport rpt_Inv = new XtraReport(); rpt_Inv.LoadLayout(Server.MapPath(@"~\ReportWarehouse\repx\invoice_1.repx")); subReport_Inv.ReportSource = rpt_Inv; rpt_Inv.DataSource = Detail; } if (Detail2.Rows.Count > 0) { DevExpress.XtraReports.UI.GroupFooterBand groupFooter_Inv = rpt.Report.Bands["GroupFooter_Other"] as DevExpress.XtraReports.UI.GroupFooterBand; DevExpress.XtraReports.UI.XRSubreport subReport_Inv = new XRSubreport(); subReport_Inv.Name = "GroupFooter_Other1"; groupFooter_Inv.Controls.Add(subReport_Inv); XtraReport rpt_Inv = new XtraReport(); rpt_Inv.LoadLayout(Server.MapPath(@"~\ReportWarehouse\repx\invoice_2.repx")); subReport_Inv.ReportSource = rpt_Inv; rpt_Inv.DataSource = Detail2; } rpt.DataSource = Mast; System.IO.MemoryStream str = new MemoryStream(); rpt.ExportToPdf(str); return(str); }
private MemoryStream PrintWh_doc(string refN, string refType, string userId) { System.IO.MemoryStream str = new MemoryStream(); string user = HttpContext.Current.User.Identity.Name; XtraReport rpt = new XtraReport(); string path = SafeValue.SafeString(ConnectSql.ExecuteScalar(string.Format("select path from sys_rpt where name='{0}'", refType))); if (path.Length == 0) { return(str); } //rpt.LoadLayout(Server.MapPath(@"~\ReportWarehouse\repx\po.repx")); rpt.LoadLayout(Server.MapPath(path)); string strsql = string.Format(@"exec proc_PrintWh_Po '{0}','{1}','{2}','{3}','{4}'", refN, "", refType, userId, ""); DataSet ds_temp = ConnectSql.GetDataSet(strsql); DataTable Mast = ds_temp.Tables[0].Copy(); Mast.TableName = "Mast"; DataTable Detail = ds_temp.Tables[1].Copy(); Detail.TableName = "Detail"; DataTable Detail2 = new DataTable(); if (ds_temp.Tables.Count > 2) { Detail2 = ds_temp.Tables[2].Copy(); Detail2.TableName = "Detail"; } if (Detail.Rows.Count > 0) { DevExpress.XtraReports.UI.GroupFooterBand groupFooter_Inv = rpt.Report.Bands["GroupFooter_Wine"] as DevExpress.XtraReports.UI.GroupFooterBand; DevExpress.XtraReports.UI.XRSubreport subReport_Inv = new XRSubreport(); subReport_Inv.Name = "GroupFooter_Wine1"; groupFooter_Inv.Controls.Add(subReport_Inv); XtraReport rpt_Inv = new XtraReport(); if (refType == "wh_putaway" || refType == "wh_picking") { rpt_Inv.LoadLayout(Server.MapPath(@"~\ReportWarehouse\repx\Picking_1.repx")); } else if (refType == "wh_doout") { rpt_Inv.LoadLayout(Server.MapPath(@"~\ReportWarehouse\repx\do_1.repx")); } else { rpt_Inv.LoadLayout(Server.MapPath(@"~\ReportWarehouse\repx\invoice_1.repx")); } subReport_Inv.ReportSource = rpt_Inv; rpt_Inv.DataSource = Detail; } if (Detail2.Rows.Count > 0) { DevExpress.XtraReports.UI.GroupFooterBand groupFooter_Inv = rpt.Report.Bands["GroupFooter_Other"] as DevExpress.XtraReports.UI.GroupFooterBand; DevExpress.XtraReports.UI.XRSubreport subReport_Inv = new XRSubreport(); subReport_Inv.Name = "GroupFooter_Other1"; groupFooter_Inv.Controls.Add(subReport_Inv); XtraReport rpt_Inv = new XtraReport(); if (refType == "wh_putaway" || refType == "wh_picking") { rpt_Inv.LoadLayout(Server.MapPath(@"~\ReportWarehouse\repx\Picking_2.repx")); } else if (refType == "wh_doout") { rpt_Inv.LoadLayout(Server.MapPath(@"~\ReportWarehouse\repx\do_2.repx")); } else { rpt_Inv.LoadLayout(Server.MapPath(@"~\ReportWarehouse\repx\invoice_2.repx")); } subReport_Inv.ReportSource = rpt_Inv; rpt_Inv.DataSource = Detail2; } rpt.DataSource = Mast; rpt.ExportToPdf(str); return(str); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.Detail = new DevExpress.XtraReports.UI.DetailBand(); this.xrLabel23 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel22 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel21 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel14 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel6 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel5 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel4 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLine1 = new DevExpress.XtraReports.UI.XRLine(); this.PageHeader = new DevExpress.XtraReports.UI.PageHeaderBand(); this.xrLabel13 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel11 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel3 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel2 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel1 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel12 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel10 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel9 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel8 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel7 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel19 = new DevExpress.XtraReports.UI.XRLabel(); this.PageFooter = new DevExpress.XtraReports.UI.PageFooterBand(); this.xrPageInfo1 = new DevExpress.XtraReports.UI.XRPageInfo(); this.GroupFooter1 = new DevExpress.XtraReports.UI.GroupFooterBand(); this.xrLine4 = new DevExpress.XtraReports.UI.XRLine(); this.xrLine3 = new DevExpress.XtraReports.UI.XRLine(); this.xrLine2 = new DevExpress.XtraReports.UI.XRLine(); this.xrLabel30 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel29 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel28 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel27 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel15 = new DevExpress.XtraReports.UI.XRLabel(); this.DetailReport = new DevExpress.XtraReports.UI.DetailReportBand(); this.Detail1 = new DevExpress.XtraReports.UI.DetailBand(); this.xrLabel26 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel25 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel24 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel20 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel18 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel17 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel16 = new DevExpress.XtraReports.UI.XRLabel(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // Detail // this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel23, this.xrLabel22, this.xrLabel21, this.xrLabel14, this.xrLabel6, this.xrLabel5, this.xrLabel4, this.xrLine1}); this.Detail.Height = 25; this.Detail.Name = "Detail"; // // xrLabel23 // this.xrLabel23.Location = new System.Drawing.Point(208, 0); this.xrLabel23.Name = "xrLabel23"; this.xrLabel23.Size = new System.Drawing.Size(100, 17); this.xrLabel23.Text = "STYLE"; // // xrLabel22 // this.xrLabel22.Location = new System.Drawing.Point(108, 0); this.xrLabel22.Name = "xrLabel22"; this.xrLabel22.Size = new System.Drawing.Size(100, 17); this.xrLabel22.Text = "BRAND"; // // xrLabel21 // this.xrLabel21.Location = new System.Drawing.Point(8, 0); this.xrLabel21.Name = "xrLabel21"; this.xrLabel21.Size = new System.Drawing.Size(100, 17); this.xrLabel21.Text = "ITEMCODE"; // // xrLabel14 // this.xrLabel14.Location = new System.Drawing.Point(308, 0); this.xrLabel14.Name = "xrLabel14"; this.xrLabel14.Size = new System.Drawing.Size(100, 17); this.xrLabel14.Text = "COLOR"; // // xrLabel6 // this.xrLabel6.Location = new System.Drawing.Point(592, 0); this.xrLabel6.Name = "xrLabel6"; this.xrLabel6.Size = new System.Drawing.Size(58, 17); this.xrLabel6.Text = "QTY"; // // xrLabel5 // this.xrLabel5.Location = new System.Drawing.Point(467, 0); this.xrLabel5.Name = "xrLabel5"; this.xrLabel5.Size = new System.Drawing.Size(125, 17); this.xrLabel5.Text = "DESCRIPTION"; // // xrLabel4 // this.xrLabel4.Location = new System.Drawing.Point(408, 0); this.xrLabel4.Name = "xrLabel4"; this.xrLabel4.Size = new System.Drawing.Size(59, 17); this.xrLabel4.Text = "SIZE"; // // xrLine1 // this.xrLine1.Location = new System.Drawing.Point(8, 17); this.xrLine1.Name = "xrLine1"; this.xrLine1.Size = new System.Drawing.Size(642, 8); // // PageHeader // this.PageHeader.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel13, this.xrLabel11, this.xrLabel3, this.xrLabel2, this.xrLabel1, this.xrLabel12, this.xrLabel10, this.xrLabel9, this.xrLabel8, this.xrLabel7, this.xrLabel19}); this.PageHeader.Height = 155; this.PageHeader.Name = "PageHeader"; // // xrLabel13 // this.xrLabel13.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "IBT.RequestedBy", "")}); this.xrLabel13.Location = new System.Drawing.Point(67, 125); this.xrLabel13.Name = "xrLabel13"; this.xrLabel13.Size = new System.Drawing.Size(583, 25); this.xrLabel13.Text = "xrLabel13"; // // xrLabel11 // this.xrLabel11.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "IBT.ToBranch", "")}); this.xrLabel11.Location = new System.Drawing.Point(350, 100); this.xrLabel11.Name = "xrLabel11"; this.xrLabel11.Size = new System.Drawing.Size(100, 25); this.xrLabel11.Text = "xrLabel11"; // // xrLabel3 // this.xrLabel3.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "IBT.FromBranch", "")}); this.xrLabel3.Location = new System.Drawing.Point(67, 100); this.xrLabel3.Name = "xrLabel3"; this.xrLabel3.Size = new System.Drawing.Size(100, 25); this.xrLabel3.Text = "xrLabel3"; // // xrLabel2 // this.xrLabel2.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "IBT.nIBTNo", "")}); this.xrLabel2.Location = new System.Drawing.Point(67, 42); this.xrLabel2.Name = "xrLabel2"; this.xrLabel2.Size = new System.Drawing.Size(100, 25); this.xrLabel2.Text = "xrLabel2"; // // xrLabel1 // this.xrLabel1.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "IBT.Date", "{0:dd/MM/yyyy}")}); this.xrLabel1.Location = new System.Drawing.Point(67, 67); this.xrLabel1.Name = "xrLabel1"; this.xrLabel1.Size = new System.Drawing.Size(208, 25); this.xrLabel1.Text = "xrLabel1"; // // xrLabel12 // this.xrLabel12.Location = new System.Drawing.Point(8, 42); this.xrLabel12.Name = "xrLabel12"; this.xrLabel12.Size = new System.Drawing.Size(59, 25); this.xrLabel12.Text = "No:"; // // xrLabel10 // this.xrLabel10.Location = new System.Drawing.Point(8, 67); this.xrLabel10.Name = "xrLabel10"; this.xrLabel10.Size = new System.Drawing.Size(59, 25); this.xrLabel10.Text = "Date:"; // // xrLabel9 // this.xrLabel9.Location = new System.Drawing.Point(8, 125); this.xrLabel9.Name = "xrLabel9"; this.xrLabel9.Size = new System.Drawing.Size(59, 25); this.xrLabel9.Text = "By:"; // // xrLabel8 // this.xrLabel8.Location = new System.Drawing.Point(292, 100); this.xrLabel8.Name = "xrLabel8"; this.xrLabel8.Size = new System.Drawing.Size(59, 25); this.xrLabel8.Text = "To:"; // // xrLabel7 // this.xrLabel7.Location = new System.Drawing.Point(8, 100); this.xrLabel7.Name = "xrLabel7"; this.xrLabel7.Size = new System.Drawing.Size(59, 25); this.xrLabel7.Text = "From:"; // // xrLabel19 // this.xrLabel19.Font = new System.Drawing.Font("Times New Roman", 16F, System.Drawing.FontStyle.Bold); this.xrLabel19.Location = new System.Drawing.Point(8, 8); this.xrLabel19.Name = "xrLabel19"; this.xrLabel19.ParentStyleUsing.UseFont = false; this.xrLabel19.Size = new System.Drawing.Size(317, 25); this.xrLabel19.Text = "INTER BRANCH TRANSFER"; // // PageFooter // this.PageFooter.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrPageInfo1}); this.PageFooter.Height = 30; this.PageFooter.Name = "PageFooter"; // // xrPageInfo1 // this.xrPageInfo1.Format = "Page : {0 } / {1}"; this.xrPageInfo1.Location = new System.Drawing.Point(550, 0); this.xrPageInfo1.Name = "xrPageInfo1"; this.xrPageInfo1.Size = new System.Drawing.Size(100, 25); // // GroupFooter1 // this.GroupFooter1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLine4, this.xrLine3, this.xrLine2, this.xrLabel30, this.xrLabel29, this.xrLabel28, this.xrLabel27, this.xrLabel15}); this.GroupFooter1.Height = 158; this.GroupFooter1.Name = "GroupFooter1"; // // xrLine4 // this.xrLine4.Location = new System.Drawing.Point(125, 133); this.xrLine4.Name = "xrLine4"; this.xrLine4.Size = new System.Drawing.Size(250, 25); // // xrLine3 // this.xrLine3.Location = new System.Drawing.Point(125, 92); this.xrLine3.Name = "xrLine3"; this.xrLine3.Size = new System.Drawing.Size(250, 25); // // xrLine2 // this.xrLine2.Location = new System.Drawing.Point(125, 50); this.xrLine2.Name = "xrLine2"; this.xrLine2.Size = new System.Drawing.Size(250, 25); // // xrLabel30 // this.xrLabel30.Location = new System.Drawing.Point(8, 133); this.xrLabel30.Name = "xrLabel30"; this.xrLabel30.Size = new System.Drawing.Size(117, 25); this.xrLabel30.Text = "Received By"; // // xrLabel29 // this.xrLabel29.Location = new System.Drawing.Point(8, 92); this.xrLabel29.Name = "xrLabel29"; this.xrLabel29.Size = new System.Drawing.Size(117, 25); this.xrLabel29.Text = "Delivery Personnel"; // // xrLabel28 // this.xrLabel28.Location = new System.Drawing.Point(8, 50); this.xrLabel28.Name = "xrLabel28"; this.xrLabel28.Size = new System.Drawing.Size(117, 25); this.xrLabel28.Text = "Sent By "; // // xrLabel27 // this.xrLabel27.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "IBT.Remark", "")}); this.xrLabel27.Location = new System.Drawing.Point(67, 0); this.xrLabel27.Name = "xrLabel27"; this.xrLabel27.Size = new System.Drawing.Size(583, 25); this.xrLabel27.Text = "xrLabel27"; // // xrLabel15 // this.xrLabel15.Location = new System.Drawing.Point(8, 0); this.xrLabel15.Name = "xrLabel15"; this.xrLabel15.Size = new System.Drawing.Size(59, 25); this.xrLabel15.Text = "Remark:"; // // DetailReport // this.DetailReport.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.Detail1}); this.DetailReport.DataMember = "IBTEntries"; this.DetailReport.Name = "DetailReport"; // // Detail1 // this.Detail1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel26, this.xrLabel25, this.xrLabel24, this.xrLabel20, this.xrLabel18, this.xrLabel17, this.xrLabel16}); this.Detail1.Height = 25; this.Detail1.Name = "Detail1"; // // xrLabel26 // this.xrLabel26.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "IBTEntries.Quantity", "")}); this.xrLabel26.Location = new System.Drawing.Point(600, 0); this.xrLabel26.Name = "xrLabel26"; this.xrLabel26.Size = new System.Drawing.Size(50, 25); this.xrLabel26.Text = "xrLabel26"; // // xrLabel25 // this.xrLabel25.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "IBTEntries.Description", "")}); this.xrLabel25.Location = new System.Drawing.Point(467, 0); this.xrLabel25.Name = "xrLabel25"; this.xrLabel25.Size = new System.Drawing.Size(125, 25); this.xrLabel25.Text = "xrLabel25"; // // xrLabel24 // this.xrLabel24.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "IBTEntries.Size", "")}); this.xrLabel24.Location = new System.Drawing.Point(408, 0); this.xrLabel24.Name = "xrLabel24"; this.xrLabel24.Size = new System.Drawing.Size(58, 25); this.xrLabel24.Text = "xrLabel24"; // // xrLabel20 // this.xrLabel20.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "IBTEntries.Color", "")}); this.xrLabel20.Location = new System.Drawing.Point(308, 0); this.xrLabel20.Name = "xrLabel20"; this.xrLabel20.Size = new System.Drawing.Size(100, 25); this.xrLabel20.Text = "xrLabel20"; // // xrLabel18 // this.xrLabel18.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "IBTEntries.Style", "")}); this.xrLabel18.Location = new System.Drawing.Point(208, 0); this.xrLabel18.Name = "xrLabel18"; this.xrLabel18.Size = new System.Drawing.Size(100, 25); this.xrLabel18.Text = "xrLabel18"; // // xrLabel17 // this.xrLabel17.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "IBTEntries.Brand", "")}); this.xrLabel17.Location = new System.Drawing.Point(108, 0); this.xrLabel17.Name = "xrLabel17"; this.xrLabel17.Size = new System.Drawing.Size(100, 25); this.xrLabel17.Text = "xrLabel17"; // // xrLabel16 // this.xrLabel16.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "IBTEntries.ItemCode", "")}); this.xrLabel16.Location = new System.Drawing.Point(8, 0); this.xrLabel16.Name = "xrLabel16"; this.xrLabel16.Size = new System.Drawing.Size(100, 25); this.xrLabel16.Text = "xrLabel16"; // // rptIBT // this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.Detail, this.PageHeader, this.PageFooter, this.GroupFooter1, this.DetailReport}); ((System.ComponentModel.ISupportInitialize)(this)).EndInit(); }
private void InitializeComponent() { this.components = new System.ComponentModel.Container(); DevExpress.XtraReports.UI.XRSummary xrSummary1 = new DevExpress.XtraReports.UI.XRSummary(); DevExpress.XtraCharts.SimpleDiagram simpleDiagram1 = new DevExpress.XtraCharts.SimpleDiagram(); DevExpress.XtraCharts.Series series1 = new DevExpress.XtraCharts.Series(); DevExpress.XtraCharts.RangeBarSeriesLabel rangeBarSeriesLabel1 = new DevExpress.XtraCharts.RangeBarSeriesLabel(); DevExpress.XtraCharts.OverlappedRangeBarSeriesView overlappedRangeBarSeriesView1 = new DevExpress.XtraCharts.OverlappedRangeBarSeriesView(); DevExpress.XtraCharts.Series series2 = new DevExpress.XtraCharts.Series(); DevExpress.XtraCharts.PieSeriesLabel pieSeriesLabel1 = new DevExpress.XtraCharts.PieSeriesLabel(); DevExpress.XtraCharts.PieSeriesView pieSeriesView1 = new DevExpress.XtraCharts.PieSeriesView(); DevExpress.XtraReports.UI.XRSummary xrSummary2 = new DevExpress.XtraReports.UI.XRSummary(); this.groupFooterBand1 = new DevExpress.XtraReports.UI.GroupFooterBand(); this.xrLabel7 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel4 = new DevExpress.XtraReports.UI.XRLabel(); this.ReportDetailBandStyle = new DevExpress.XtraReports.UI.XRControlStyle(); this.ReportOddStyle = new DevExpress.XtraReports.UI.XRControlStyle(); this.ReportFooterBandStyle = new DevExpress.XtraReports.UI.XRControlStyle(); this.bottomMarginBand1 = new DevExpress.XtraReports.UI.BottomMarginBand(); this.topMarginBand1 = new DevExpress.XtraReports.UI.TopMarginBand(); this.pageHeaderBand1 = new DevExpress.XtraReports.UI.PageHeaderBand(); this.xrLabel1 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel3 = new DevExpress.XtraReports.UI.XRLabel(); this.detailBand1 = new DevExpress.XtraReports.UI.DetailBand(); this.ReportGroupHeaderBandStyle = new DevExpress.XtraReports.UI.XRControlStyle(); this.ReportHeaderBandStyle = new DevExpress.XtraReports.UI.XRControlStyle(); this.groupHeaderBand1 = new DevExpress.XtraReports.UI.GroupHeaderBand(); this.ReportGroupFooterBandStyle = new DevExpress.XtraReports.UI.XRControlStyle(); this.ReportEvenStyle = new DevExpress.XtraReports.UI.XRControlStyle(); this.totalBindingSource = new System.Windows.Forms.BindingSource(this.components); this.reportFooterBand1 = new DevExpress.XtraReports.UI.ReportFooterBand(); this.xrChart1 = new DevExpress.XtraReports.UI.XRChart(); this.xrLabel10 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel6 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel2 = new DevExpress.XtraReports.UI.XRLabel(); ((System.ComponentModel.ISupportInitialize)(this.totalBindingSource)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrChart1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(simpleDiagram1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(series1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(rangeBarSeriesLabel1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(overlappedRangeBarSeriesView1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(series2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(pieSeriesLabel1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(pieSeriesView1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // groupFooterBand1 // this.groupFooterBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel7, this.xrLabel4 }); this.groupFooterBand1.Dpi = 254F; this.groupFooterBand1.HeightF = 52.22913F; this.groupFooterBand1.Name = "groupFooterBand1"; this.groupFooterBand1.StyleName = "ReportGroupFooterBandStyle"; // // xrLabel7 // this.xrLabel7.AnchorHorizontal = DevExpress.XtraReports.UI.HorizontalAnchorStyles.Left; this.xrLabel7.AnchorVertical = DevExpress.XtraReports.UI.VerticalAnchorStyles.Top; this.xrLabel7.BackColor = System.Drawing.Color.Empty; this.xrLabel7.BorderColor = System.Drawing.Color.Black; this.xrLabel7.Borders = ((DevExpress.XtraPrinting.BorderSide)((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrLabel7.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "work") }); this.xrLabel7.Dpi = 254F; this.xrLabel7.Font = new System.Drawing.Font("Times New Roman", 9.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(204))); this.xrLabel7.LocationFloat = new DevExpress.Utils.PointFloat(0.0003229777F, 0F); this.xrLabel7.Name = "xrLabel7"; this.xrLabel7.Padding = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 0, 0, 254F); this.xrLabel7.SizeF = new System.Drawing.SizeF(1243.804F, 52.22913F); this.xrLabel7.StylePriority.UseBackColor = false; this.xrLabel7.StylePriority.UseBorderColor = false; this.xrLabel7.StylePriority.UseBorders = false; this.xrLabel7.StylePriority.UseFont = false; this.xrLabel7.StylePriority.UsePadding = false; this.xrLabel7.StylePriority.UseTextAlignment = false; this.xrLabel7.Text = "xrLabel4"; this.xrLabel7.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft; // // xrLabel4 // this.xrLabel4.BackColor = System.Drawing.Color.White; this.xrLabel4.BorderColor = System.Drawing.Color.Black; this.xrLabel4.BorderDashStyle = DevExpress.XtraPrinting.BorderDashStyle.Solid; this.xrLabel4.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrLabel4.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "time_span") }); this.xrLabel4.Dpi = 254F; this.xrLabel4.Font = new System.Drawing.Font("Times New Roman", 11.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(204))); this.xrLabel4.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))); this.xrLabel4.LocationFloat = new DevExpress.Utils.PointFloat(1243.804F, 0F); this.xrLabel4.Name = "xrLabel4"; this.xrLabel4.Padding = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 0, 0, 254F); this.xrLabel4.SizeF = new System.Drawing.SizeF(527.1958F, 52.22913F); this.xrLabel4.StylePriority.UseBackColor = false; this.xrLabel4.StylePriority.UseBorderColor = false; this.xrLabel4.StylePriority.UseBorderDashStyle = false; this.xrLabel4.StylePriority.UseBorders = false; this.xrLabel4.StylePriority.UseFont = false; this.xrLabel4.StylePriority.UseForeColor = false; this.xrLabel4.StylePriority.UsePadding = false; this.xrLabel4.StylePriority.UseTextAlignment = false; xrSummary1.FormatString = "{0:}"; xrSummary1.Func = DevExpress.XtraReports.UI.SummaryFunc.Custom; xrSummary1.IgnoreNullValues = true; xrSummary1.Running = DevExpress.XtraReports.UI.SummaryRunning.Group; this.xrLabel4.Summary = xrSummary1; this.xrLabel4.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; this.xrLabel4.WordWrap = false; this.xrLabel4.SummaryGetResult += new DevExpress.XtraReports.UI.SummaryGetResultHandler(this.xrLabel4_SummaryGetResult); this.xrLabel4.SummaryReset += new System.EventHandler(this.xrLabel4_SummaryReset); this.xrLabel4.SummaryRowChanged += new System.EventHandler(this.xrLabel4_SummaryRowChanged); // // ReportDetailBandStyle // this.ReportDetailBandStyle.BackColor = System.Drawing.Color.Transparent; this.ReportDetailBandStyle.Name = "ReportDetailBandStyle"; this.ReportDetailBandStyle.Padding = new DevExpress.XtraPrinting.PaddingInfo(10, 10, 0, 0, 254F); this.ReportDetailBandStyle.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft; // // ReportOddStyle // this.ReportOddStyle.BackColor = System.Drawing.Color.Transparent; this.ReportOddStyle.Name = "ReportOddStyle"; this.ReportOddStyle.Padding = new DevExpress.XtraPrinting.PaddingInfo(10, 10, 0, 0, 254F); this.ReportOddStyle.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft; // // ReportFooterBandStyle // this.ReportFooterBandStyle.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(240)))), ((int)(((byte)(255)))), ((int)(((byte)(255))))); this.ReportFooterBandStyle.BorderColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(191)))), ((int)(((byte)(255))))); this.ReportFooterBandStyle.BorderDashStyle = DevExpress.XtraPrinting.BorderDashStyle.Solid; this.ReportFooterBandStyle.Font = new System.Drawing.Font("Times New Roman", 8.25F, System.Drawing.FontStyle.Bold); this.ReportFooterBandStyle.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))); this.ReportFooterBandStyle.Name = "ReportFooterBandStyle"; this.ReportFooterBandStyle.Padding = new DevExpress.XtraPrinting.PaddingInfo(10, 10, 0, 0, 254F); this.ReportFooterBandStyle.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft; // // bottomMarginBand1 // this.bottomMarginBand1.Dpi = 254F; this.bottomMarginBand1.HeightF = 254F; this.bottomMarginBand1.Name = "bottomMarginBand1"; // // topMarginBand1 // this.topMarginBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel2 }); this.topMarginBand1.Dpi = 254F; this.topMarginBand1.HeightF = 323F; this.topMarginBand1.Name = "topMarginBand1"; // // pageHeaderBand1 // this.pageHeaderBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel1, this.xrLabel3 }); this.pageHeaderBand1.Dpi = 254F; this.pageHeaderBand1.Font = new System.Drawing.Font("Times New Roman", 12F, System.Drawing.FontStyle.Bold); this.pageHeaderBand1.HeightF = 74.58331F; this.pageHeaderBand1.Name = "pageHeaderBand1"; this.pageHeaderBand1.StyleName = "ReportHeaderBandStyle"; this.pageHeaderBand1.StylePriority.UseFont = false; // // xrLabel1 // this.xrLabel1.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(149)))), ((int)(((byte)(218)))), ((int)(((byte)(251))))); this.xrLabel1.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrLabel1.Dpi = 254F; this.xrLabel1.Font = new System.Drawing.Font("Times New Roman", 12F, System.Drawing.FontStyle.Bold); this.xrLabel1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.xrLabel1.Name = "xrLabel1"; this.xrLabel1.Padding = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 0, 0, 254F); this.xrLabel1.SizeF = new System.Drawing.SizeF(1243.804F, 74.58331F); this.xrLabel1.StylePriority.UseBackColor = false; this.xrLabel1.StylePriority.UseBorders = false; this.xrLabel1.StylePriority.UseFont = false; this.xrLabel1.StylePriority.UsePadding = false; this.xrLabel1.StylePriority.UseTextAlignment = false; this.xrLabel1.Text = "Вид работы"; this.xrLabel1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; this.xrLabel1.WordWrap = false; // // xrLabel3 // this.xrLabel3.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(149)))), ((int)(((byte)(218)))), ((int)(((byte)(251))))); this.xrLabel3.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrLabel3.Dpi = 254F; this.xrLabel3.LocationFloat = new DevExpress.Utils.PointFloat(1243.804F, 0F); this.xrLabel3.Multiline = true; this.xrLabel3.Name = "xrLabel3"; this.xrLabel3.Padding = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 0, 0, 254F); this.xrLabel3.SizeF = new System.Drawing.SizeF(527.1958F, 74.58331F); this.xrLabel3.StylePriority.UseBackColor = false; this.xrLabel3.StylePriority.UseBorders = false; this.xrLabel3.StylePriority.UsePadding = false; this.xrLabel3.StylePriority.UseTextAlignment = false; this.xrLabel3.Text = "Время"; this.xrLabel3.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; // // detailBand1 // this.detailBand1.Dpi = 254F; this.detailBand1.EvenStyleName = "ReportEvenStyle"; this.detailBand1.HeightF = 0F; this.detailBand1.LockedInUserDesigner = true; this.detailBand1.Name = "detailBand1"; this.detailBand1.OddStyleName = "ReportOddStyle"; this.detailBand1.SortFields.AddRange(new DevExpress.XtraReports.UI.GroupField[] { new DevExpress.XtraReports.UI.GroupField("time_span", DevExpress.XtraReports.UI.XRColumnSortOrder.None) }); this.detailBand1.StyleName = "ReportDetailBandStyle"; // // ReportGroupHeaderBandStyle // this.ReportGroupHeaderBandStyle.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(206)))), ((int)(((byte)(206)))), ((int)(((byte)(206))))); this.ReportGroupHeaderBandStyle.Name = "ReportGroupHeaderBandStyle"; this.ReportGroupHeaderBandStyle.Padding = new DevExpress.XtraPrinting.PaddingInfo(10, 0, 0, 0, 254F); this.ReportGroupHeaderBandStyle.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft; // // ReportHeaderBandStyle // this.ReportHeaderBandStyle.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(206)))), ((int)(((byte)(206)))), ((int)(((byte)(206))))); this.ReportHeaderBandStyle.Name = "ReportHeaderBandStyle"; this.ReportHeaderBandStyle.Padding = new DevExpress.XtraPrinting.PaddingInfo(10, 10, 0, 0, 254F); this.ReportHeaderBandStyle.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft; // // groupHeaderBand1 // this.groupHeaderBand1.Dpi = 254F; this.groupHeaderBand1.Expanded = false; this.groupHeaderBand1.GroupFields.AddRange(new DevExpress.XtraReports.UI.GroupField[] { new DevExpress.XtraReports.UI.GroupField("work", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending) }); this.groupHeaderBand1.GroupUnion = DevExpress.XtraReports.UI.GroupUnion.WithFirstDetail; this.groupHeaderBand1.HeightF = 0F; this.groupHeaderBand1.Name = "groupHeaderBand1"; this.groupHeaderBand1.StyleName = "ReportGroupHeaderBandStyle"; // // ReportGroupFooterBandStyle // this.ReportGroupFooterBandStyle.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(240)))), ((int)(((byte)(255)))), ((int)(((byte)(255))))); this.ReportGroupFooterBandStyle.BorderColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(191)))), ((int)(((byte)(255))))); this.ReportGroupFooterBandStyle.BorderDashStyle = DevExpress.XtraPrinting.BorderDashStyle.Solid; this.ReportGroupFooterBandStyle.Font = new System.Drawing.Font("Times New Roman", 8.25F, System.Drawing.FontStyle.Bold); this.ReportGroupFooterBandStyle.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))); this.ReportGroupFooterBandStyle.Name = "ReportGroupFooterBandStyle"; this.ReportGroupFooterBandStyle.Padding = new DevExpress.XtraPrinting.PaddingInfo(10, 10, 0, 0, 254F); this.ReportGroupFooterBandStyle.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft; // // ReportEvenStyle // this.ReportEvenStyle.BackColor = System.Drawing.Color.Transparent; this.ReportEvenStyle.Name = "ReportEvenStyle"; this.ReportEvenStyle.Padding = new DevExpress.XtraPrinting.PaddingInfo(10, 10, 0, 0, 254F); this.ReportEvenStyle.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft; // // totalBindingSource // this.totalBindingSource.DataMember = "total"; // // reportFooterBand1 // this.reportFooterBand1.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(224)))), ((int)(((byte)(192))))); this.reportFooterBand1.BorderColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))); this.reportFooterBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrChart1, this.xrLabel10, this.xrLabel6 }); this.reportFooterBand1.Dpi = 254F; this.reportFooterBand1.HeightF = 1651.213F; this.reportFooterBand1.Name = "reportFooterBand1"; this.reportFooterBand1.StyleName = "ReportFooterBandStyle"; this.reportFooterBand1.StylePriority.UseBackColor = false; this.reportFooterBand1.StylePriority.UseBorderColor = false; // // xrChart1 // this.xrChart1.AnchorHorizontal = ((DevExpress.XtraReports.UI.HorizontalAnchorStyles)((DevExpress.XtraReports.UI.HorizontalAnchorStyles.Left | DevExpress.XtraReports.UI.HorizontalAnchorStyles.Right))); this.xrChart1.AnchorVertical = DevExpress.XtraReports.UI.VerticalAnchorStyles.Bottom; this.xrChart1.AppearanceNameSerializable = "Nature Colors"; this.xrChart1.AutoLayout = true; this.xrChart1.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(255)))), ((int)(((byte)(255))))); this.xrChart1.BorderColor = System.Drawing.Color.Black; this.xrChart1.BorderDashStyle = DevExpress.XtraPrinting.BorderDashStyle.Solid; this.xrChart1.Borders = DevExpress.XtraPrinting.BorderSide.None; simpleDiagram1.LabelsResolveOverlappingMinIndent = 5; this.xrChart1.Diagram = simpleDiagram1; this.xrChart1.Dpi = 254F; this.xrChart1.Legend.AlignmentHorizontal = DevExpress.XtraCharts.LegendAlignmentHorizontal.Center; this.xrChart1.Legend.AlignmentVertical = DevExpress.XtraCharts.LegendAlignmentVertical.BottomOutside; this.xrChart1.Legend.Direction = DevExpress.XtraCharts.LegendDirection.LeftToRight; this.xrChart1.Legend.Name = "Default Legend"; this.xrChart1.LocationFloat = new DevExpress.Utils.PointFloat(4.037221E-05F, 66.14697F); this.xrChart1.Name = "xrChart1"; this.xrChart1.PaletteName = "Mixed"; rangeBarSeriesLabel1.EnableAntialiasing = DevExpress.Utils.DefaultBoolean.True; series1.Label = rangeBarSeriesLabel1; series1.LabelsVisibility = DevExpress.Utils.DefaultBoolean.False; series1.LegendTextPattern = "{A}{VP:0.00%}"; series1.Name = "Ряд 1"; overlappedRangeBarSeriesView1.BarWidth = 0.5D; overlappedRangeBarSeriesView1.Border.Visibility = DevExpress.Utils.DefaultBoolean.True; overlappedRangeBarSeriesView1.ColorEach = true; overlappedRangeBarSeriesView1.FillStyle.FillMode = DevExpress.XtraCharts.FillMode.Hatch; series1.View = overlappedRangeBarSeriesView1; series1.Visible = false; pieSeriesLabel1.EnableAntialiasing = DevExpress.Utils.DefaultBoolean.True; pieSeriesLabel1.ResolveOverlappingMode = DevExpress.XtraCharts.ResolveOverlappingMode.Default; pieSeriesLabel1.TextPattern = "{A} {VP:0.00%}"; series2.Label = pieSeriesLabel1; series2.LegendName = "Default Legend"; series2.LegendTextPattern = "{A}"; series2.Name = "Ряд 2"; pieSeriesView1.Border.Visibility = DevExpress.Utils.DefaultBoolean.False; pieSeriesView1.FillStyle.FillMode = DevExpress.XtraCharts.FillMode.Solid; pieSeriesView1.Rotation = 270; pieSeriesView1.SweepDirection = DevExpress.XtraCharts.PieSweepDirection.Clockwise; series2.View = pieSeriesView1; this.xrChart1.SeriesSerializable = new DevExpress.XtraCharts.Series[] { series1, series2 }; this.xrChart1.SizeF = new System.Drawing.SizeF(1809F, 1585.066F); this.xrChart1.StylePriority.UseBorderDashStyle = false; // // xrLabel10 // this.xrLabel10.BackColor = System.Drawing.Color.White; this.xrLabel10.BorderColor = System.Drawing.Color.Black; this.xrLabel10.Borders = DevExpress.XtraPrinting.BorderSide.None; this.xrLabel10.Dpi = 254F; this.xrLabel10.Font = new System.Drawing.Font("Times New Roman", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(204))); this.xrLabel10.LocationFloat = new DevExpress.Utils.PointFloat(0.0003229777F, 0F); this.xrLabel10.Name = "xrLabel10"; this.xrLabel10.Padding = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 0, 0, 254F); this.xrLabel10.SizeF = new System.Drawing.SizeF(1243.804F, 45.47914F); this.xrLabel10.StylePriority.UseBackColor = false; this.xrLabel10.StylePriority.UseBorderColor = false; this.xrLabel10.StylePriority.UseBorders = false; this.xrLabel10.StylePriority.UseFont = false; this.xrLabel10.StylePriority.UseTextAlignment = false; this.xrLabel10.Text = "Итого:"; this.xrLabel10.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight; // // xrLabel6 // this.xrLabel6.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(224)))), ((int)(((byte)(192))))); this.xrLabel6.BorderColor = System.Drawing.Color.Red; this.xrLabel6.BorderDashStyle = DevExpress.XtraPrinting.BorderDashStyle.Solid; this.xrLabel6.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrLabel6.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "time_span") }); this.xrLabel6.Dpi = 254F; this.xrLabel6.Font = new System.Drawing.Font("Times New Roman", 11.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(204))); this.xrLabel6.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))); this.xrLabel6.LocationFloat = new DevExpress.Utils.PointFloat(1243.804F, 0F); this.xrLabel6.Name = "xrLabel6"; this.xrLabel6.Padding = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 0, 0, 254F); this.xrLabel6.SizeF = new System.Drawing.SizeF(527.1958F, 45.47914F); this.xrLabel6.StylePriority.UseBackColor = false; this.xrLabel6.StylePriority.UseBorderColor = false; this.xrLabel6.StylePriority.UseBorderDashStyle = false; this.xrLabel6.StylePriority.UseBorders = false; this.xrLabel6.StylePriority.UseFont = false; this.xrLabel6.StylePriority.UseForeColor = false; this.xrLabel6.StylePriority.UsePadding = false; this.xrLabel6.StylePriority.UseTextAlignment = false; xrSummary2.FormatString = "{0:HH:mm}"; xrSummary2.IgnoreNullValues = true; xrSummary2.Running = DevExpress.XtraReports.UI.SummaryRunning.Report; this.xrLabel6.Summary = xrSummary2; this.xrLabel6.Text = "xrLabel6"; this.xrLabel6.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; this.xrLabel6.WordWrap = false; this.xrLabel6.XlsxFormatString = "[h]:mm"; this.xrLabel6.SummaryGetResult += new DevExpress.XtraReports.UI.SummaryGetResultHandler(this.xrLabel6_SummaryGetResult); this.xrLabel6.SummaryRowChanged += new System.EventHandler(this.xrLabel6_SummaryRowChanged); // // xrLabel2 // this.xrLabel2.Dpi = 254F; this.xrLabel2.Font = new System.Drawing.Font("Times New Roman", 16F); this.xrLabel2.LocationFloat = new DevExpress.Utils.PointFloat(0F, 109.455F); this.xrLabel2.Multiline = true; this.xrLabel2.Name = "xrLabel2"; this.xrLabel2.Padding = new DevExpress.XtraPrinting.PaddingInfo(5, 5, 0, 0, 254F); this.xrLabel2.SizeF = new System.Drawing.SizeF(1809F, 213.3366F); this.xrLabel2.StylePriority.UseFont = false; this.xrLabel2.StylePriority.UseTextAlignment = false; this.xrLabel2.Text = "Отчет по видам работ c "; this.xrLabel2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; // // month // this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.topMarginBand1, this.pageHeaderBand1, this.groupHeaderBand1, this.detailBand1, this.groupFooterBand1, this.reportFooterBand1, this.bottomMarginBand1 }); this.Dpi = 254F; this.Margins = new System.Drawing.Printing.Margins(201, 87, 323, 254); this.PageHeight = 2970; this.PageWidth = 2100; this.PaperKind = System.Drawing.Printing.PaperKind.A4; this.ReportUnit = DevExpress.XtraReports.UI.ReportUnit.TenthsOfAMillimeter; this.SnapGridSize = 25F; this.StyleSheet.AddRange(new DevExpress.XtraReports.UI.XRControlStyle[] { this.ReportHeaderBandStyle, this.ReportGroupHeaderBandStyle, this.ReportDetailBandStyle, this.ReportGroupFooterBandStyle, this.ReportFooterBandStyle, this.ReportOddStyle, this.ReportEvenStyle }); this.Version = "18.1"; ((System.ComponentModel.ISupportInitialize)(this.totalBindingSource)).EndInit(); ((System.ComponentModel.ISupportInitialize)(simpleDiagram1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(rangeBarSeriesLabel1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(overlappedRangeBarSeriesView1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(series1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(pieSeriesLabel1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(pieSeriesView1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(series2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrChart1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this)).EndInit(); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.Detail = new DevExpress.XtraReports.UI.DetailBand(); this.xrLabel23 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel22 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel21 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel14 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel6 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel5 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel4 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLine1 = new DevExpress.XtraReports.UI.XRLine(); this.PageHeader = new DevExpress.XtraReports.UI.PageHeaderBand(); this.xrLabel13 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel11 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel3 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel2 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel1 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel12 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel10 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel9 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel8 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel7 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel19 = new DevExpress.XtraReports.UI.XRLabel(); this.PageFooter = new DevExpress.XtraReports.UI.PageFooterBand(); this.xrPageInfo1 = new DevExpress.XtraReports.UI.XRPageInfo(); this.GroupFooter1 = new DevExpress.XtraReports.UI.GroupFooterBand(); this.xrLine4 = new DevExpress.XtraReports.UI.XRLine(); this.xrLine3 = new DevExpress.XtraReports.UI.XRLine(); this.xrLine2 = new DevExpress.XtraReports.UI.XRLine(); this.xrLabel30 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel29 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel28 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel27 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel15 = new DevExpress.XtraReports.UI.XRLabel(); this.DetailReport = new DevExpress.XtraReports.UI.DetailReportBand(); this.Detail1 = new DevExpress.XtraReports.UI.DetailBand(); this.xrLabel26 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel25 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel24 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel20 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel18 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel17 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel16 = new DevExpress.XtraReports.UI.XRLabel(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // Detail // this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel23, this.xrLabel22, this.xrLabel21, this.xrLabel14, this.xrLabel6, this.xrLabel5, this.xrLabel4, this.xrLine1 }); this.Detail.Height = 25; this.Detail.Name = "Detail"; // // xrLabel23 // this.xrLabel23.Location = new System.Drawing.Point(208, 0); this.xrLabel23.Name = "xrLabel23"; this.xrLabel23.Size = new System.Drawing.Size(100, 17); this.xrLabel23.Text = "STYLE"; // // xrLabel22 // this.xrLabel22.Location = new System.Drawing.Point(108, 0); this.xrLabel22.Name = "xrLabel22"; this.xrLabel22.Size = new System.Drawing.Size(100, 17); this.xrLabel22.Text = "BRAND"; // // xrLabel21 // this.xrLabel21.Location = new System.Drawing.Point(8, 0); this.xrLabel21.Name = "xrLabel21"; this.xrLabel21.Size = new System.Drawing.Size(100, 17); this.xrLabel21.Text = "ITEMCODE"; // // xrLabel14 // this.xrLabel14.Location = new System.Drawing.Point(308, 0); this.xrLabel14.Name = "xrLabel14"; this.xrLabel14.Size = new System.Drawing.Size(100, 17); this.xrLabel14.Text = "COLOR"; // // xrLabel6 // this.xrLabel6.Location = new System.Drawing.Point(592, 0); this.xrLabel6.Name = "xrLabel6"; this.xrLabel6.Size = new System.Drawing.Size(58, 17); this.xrLabel6.Text = "QTY"; // // xrLabel5 // this.xrLabel5.Location = new System.Drawing.Point(467, 0); this.xrLabel5.Name = "xrLabel5"; this.xrLabel5.Size = new System.Drawing.Size(125, 17); this.xrLabel5.Text = "DESCRIPTION"; // // xrLabel4 // this.xrLabel4.Location = new System.Drawing.Point(408, 0); this.xrLabel4.Name = "xrLabel4"; this.xrLabel4.Size = new System.Drawing.Size(59, 17); this.xrLabel4.Text = "SIZE"; // // xrLine1 // this.xrLine1.Location = new System.Drawing.Point(8, 17); this.xrLine1.Name = "xrLine1"; this.xrLine1.Size = new System.Drawing.Size(642, 8); // // PageHeader // this.PageHeader.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel13, this.xrLabel11, this.xrLabel3, this.xrLabel2, this.xrLabel1, this.xrLabel12, this.xrLabel10, this.xrLabel9, this.xrLabel8, this.xrLabel7, this.xrLabel19 }); this.PageHeader.Height = 155; this.PageHeader.Name = "PageHeader"; // // xrLabel13 // this.xrLabel13.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "IBT.RequestedBy", "") }); this.xrLabel13.Location = new System.Drawing.Point(67, 125); this.xrLabel13.Name = "xrLabel13"; this.xrLabel13.Size = new System.Drawing.Size(583, 25); this.xrLabel13.Text = "xrLabel13"; // // xrLabel11 // this.xrLabel11.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "IBT.ToBranch", "") }); this.xrLabel11.Location = new System.Drawing.Point(350, 100); this.xrLabel11.Name = "xrLabel11"; this.xrLabel11.Size = new System.Drawing.Size(100, 25); this.xrLabel11.Text = "xrLabel11"; // // xrLabel3 // this.xrLabel3.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "IBT.FromBranch", "") }); this.xrLabel3.Location = new System.Drawing.Point(67, 100); this.xrLabel3.Name = "xrLabel3"; this.xrLabel3.Size = new System.Drawing.Size(100, 25); this.xrLabel3.Text = "xrLabel3"; // // xrLabel2 // this.xrLabel2.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "IBT.nIBTNo", "") }); this.xrLabel2.Location = new System.Drawing.Point(67, 42); this.xrLabel2.Name = "xrLabel2"; this.xrLabel2.Size = new System.Drawing.Size(100, 25); this.xrLabel2.Text = "xrLabel2"; // // xrLabel1 // this.xrLabel1.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "IBT.Date", "{0:dd/MM/yyyy}") }); this.xrLabel1.Location = new System.Drawing.Point(67, 67); this.xrLabel1.Name = "xrLabel1"; this.xrLabel1.Size = new System.Drawing.Size(208, 25); this.xrLabel1.Text = "xrLabel1"; // // xrLabel12 // this.xrLabel12.Location = new System.Drawing.Point(8, 42); this.xrLabel12.Name = "xrLabel12"; this.xrLabel12.Size = new System.Drawing.Size(59, 25); this.xrLabel12.Text = "No:"; // // xrLabel10 // this.xrLabel10.Location = new System.Drawing.Point(8, 67); this.xrLabel10.Name = "xrLabel10"; this.xrLabel10.Size = new System.Drawing.Size(59, 25); this.xrLabel10.Text = "Date:"; // // xrLabel9 // this.xrLabel9.Location = new System.Drawing.Point(8, 125); this.xrLabel9.Name = "xrLabel9"; this.xrLabel9.Size = new System.Drawing.Size(59, 25); this.xrLabel9.Text = "By:"; // // xrLabel8 // this.xrLabel8.Location = new System.Drawing.Point(292, 100); this.xrLabel8.Name = "xrLabel8"; this.xrLabel8.Size = new System.Drawing.Size(59, 25); this.xrLabel8.Text = "To:"; // // xrLabel7 // this.xrLabel7.Location = new System.Drawing.Point(8, 100); this.xrLabel7.Name = "xrLabel7"; this.xrLabel7.Size = new System.Drawing.Size(59, 25); this.xrLabel7.Text = "From:"; // // xrLabel19 // this.xrLabel19.Font = new System.Drawing.Font("Times New Roman", 16F, System.Drawing.FontStyle.Bold); this.xrLabel19.Location = new System.Drawing.Point(8, 8); this.xrLabel19.Name = "xrLabel19"; this.xrLabel19.ParentStyleUsing.UseFont = false; this.xrLabel19.Size = new System.Drawing.Size(317, 25); this.xrLabel19.Text = "INTER BRANCH TRANSFER"; // // PageFooter // this.PageFooter.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrPageInfo1 }); this.PageFooter.Height = 30; this.PageFooter.Name = "PageFooter"; // // xrPageInfo1 // this.xrPageInfo1.Format = "Page : {0 } / {1}"; this.xrPageInfo1.Location = new System.Drawing.Point(550, 0); this.xrPageInfo1.Name = "xrPageInfo1"; this.xrPageInfo1.Size = new System.Drawing.Size(100, 25); // // GroupFooter1 // this.GroupFooter1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLine4, this.xrLine3, this.xrLine2, this.xrLabel30, this.xrLabel29, this.xrLabel28, this.xrLabel27, this.xrLabel15 }); this.GroupFooter1.Height = 158; this.GroupFooter1.Name = "GroupFooter1"; // // xrLine4 // this.xrLine4.Location = new System.Drawing.Point(125, 133); this.xrLine4.Name = "xrLine4"; this.xrLine4.Size = new System.Drawing.Size(250, 25); // // xrLine3 // this.xrLine3.Location = new System.Drawing.Point(125, 92); this.xrLine3.Name = "xrLine3"; this.xrLine3.Size = new System.Drawing.Size(250, 25); // // xrLine2 // this.xrLine2.Location = new System.Drawing.Point(125, 50); this.xrLine2.Name = "xrLine2"; this.xrLine2.Size = new System.Drawing.Size(250, 25); // // xrLabel30 // this.xrLabel30.Location = new System.Drawing.Point(8, 133); this.xrLabel30.Name = "xrLabel30"; this.xrLabel30.Size = new System.Drawing.Size(117, 25); this.xrLabel30.Text = "Received By"; // // xrLabel29 // this.xrLabel29.Location = new System.Drawing.Point(8, 92); this.xrLabel29.Name = "xrLabel29"; this.xrLabel29.Size = new System.Drawing.Size(117, 25); this.xrLabel29.Text = "Delivery Personnel"; // // xrLabel28 // this.xrLabel28.Location = new System.Drawing.Point(8, 50); this.xrLabel28.Name = "xrLabel28"; this.xrLabel28.Size = new System.Drawing.Size(117, 25); this.xrLabel28.Text = "Sent By "; // // xrLabel27 // this.xrLabel27.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "IBT.Remark", "") }); this.xrLabel27.Location = new System.Drawing.Point(67, 0); this.xrLabel27.Name = "xrLabel27"; this.xrLabel27.Size = new System.Drawing.Size(583, 25); this.xrLabel27.Text = "xrLabel27"; // // xrLabel15 // this.xrLabel15.Location = new System.Drawing.Point(8, 0); this.xrLabel15.Name = "xrLabel15"; this.xrLabel15.Size = new System.Drawing.Size(59, 25); this.xrLabel15.Text = "Remark:"; // // DetailReport // this.DetailReport.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.Detail1 }); this.DetailReport.DataMember = "IBTEntries"; this.DetailReport.Name = "DetailReport"; // // Detail1 // this.Detail1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel26, this.xrLabel25, this.xrLabel24, this.xrLabel20, this.xrLabel18, this.xrLabel17, this.xrLabel16 }); this.Detail1.Height = 25; this.Detail1.Name = "Detail1"; // // xrLabel26 // this.xrLabel26.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "IBTEntries.Quantity", "") }); this.xrLabel26.Location = new System.Drawing.Point(600, 0); this.xrLabel26.Name = "xrLabel26"; this.xrLabel26.Size = new System.Drawing.Size(50, 25); this.xrLabel26.Text = "xrLabel26"; // // xrLabel25 // this.xrLabel25.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "IBTEntries.Description", "") }); this.xrLabel25.Location = new System.Drawing.Point(467, 0); this.xrLabel25.Name = "xrLabel25"; this.xrLabel25.Size = new System.Drawing.Size(125, 25); this.xrLabel25.Text = "xrLabel25"; // // xrLabel24 // this.xrLabel24.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "IBTEntries.Size", "") }); this.xrLabel24.Location = new System.Drawing.Point(408, 0); this.xrLabel24.Name = "xrLabel24"; this.xrLabel24.Size = new System.Drawing.Size(58, 25); this.xrLabel24.Text = "xrLabel24"; // // xrLabel20 // this.xrLabel20.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "IBTEntries.Color", "") }); this.xrLabel20.Location = new System.Drawing.Point(308, 0); this.xrLabel20.Name = "xrLabel20"; this.xrLabel20.Size = new System.Drawing.Size(100, 25); this.xrLabel20.Text = "xrLabel20"; // // xrLabel18 // this.xrLabel18.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "IBTEntries.Style", "") }); this.xrLabel18.Location = new System.Drawing.Point(208, 0); this.xrLabel18.Name = "xrLabel18"; this.xrLabel18.Size = new System.Drawing.Size(100, 25); this.xrLabel18.Text = "xrLabel18"; // // xrLabel17 // this.xrLabel17.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "IBTEntries.Brand", "") }); this.xrLabel17.Location = new System.Drawing.Point(108, 0); this.xrLabel17.Name = "xrLabel17"; this.xrLabel17.Size = new System.Drawing.Size(100, 25); this.xrLabel17.Text = "xrLabel17"; // // xrLabel16 // this.xrLabel16.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "IBTEntries.ItemCode", "") }); this.xrLabel16.Location = new System.Drawing.Point(8, 0); this.xrLabel16.Name = "xrLabel16"; this.xrLabel16.Size = new System.Drawing.Size(100, 25); this.xrLabel16.Text = "xrLabel16"; // // rptIBT // this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.Detail, this.PageHeader, this.PageFooter, this.GroupFooter1, this.DetailReport }); ((System.ComponentModel.ISupportInitialize)(this)).EndInit(); }
private MemoryStream PrintPL_Airhouse(string refN, string jobN, string userId) { string user = HttpContext.Current.User.Identity.Name; XtraReport rpt = new XtraReport(); rpt.LoadLayout(Server.MapPath(@"~\ReportAir\repx\Import\PL.repx")); DataSet set = AirFreightDocPrint.PrintPl_house(refN, jobN, userId); DataTable tab_mast = set.Tables[0]; DataTable tab_Inv = set.Tables[1]; DataTable tab_Dn = set.Tables[2]; DataTable tab_Ts = set.Tables[3]; DataTable tab_Cn = set.Tables[4]; DataTable tab_Pl = set.Tables[5]; DataTable tab_Vo = set.Tables[6]; DataTable tab_Cost = set.Tables[7]; if (tab_Inv.Rows.Count > 0) { DevExpress.XtraReports.UI.GroupFooterBand groupFooter_Inv = rpt.Report.Bands["GroupFooter_Inv"] as DevExpress.XtraReports.UI.GroupFooterBand; DevExpress.XtraReports.UI.XRSubreport subReport_Inv = new XRSubreport(); subReport_Inv.Name = "groupFooter_Inv"; groupFooter_Inv.Controls.Add(subReport_Inv); XtraReport rpt_Inv = new XtraReport(); rpt_Inv.LoadLayout(Server.MapPath(@"~\ReportAir\repx\import\Pl_1_Inv.repx")); subReport_Inv.ReportSource = rpt_Inv; rpt_Inv.DataSource = tab_Inv; } if (tab_Dn.Rows.Count > 0) { DevExpress.XtraReports.UI.GroupFooterBand groupFooter_Dn = rpt.Report.Bands["GroupFooter_Dn"] as DevExpress.XtraReports.UI.GroupFooterBand; DevExpress.XtraReports.UI.XRSubreport subReport_Dn = new XRSubreport(); subReport_Dn.Name = "groupFooter_Dn"; groupFooter_Dn.Controls.Add(subReport_Dn); XtraReport rpt_Dn = new XtraReport(); rpt_Dn.LoadLayout(Server.MapPath(@"~\ReportAir\repx\import\Pl_2_Dn.repx")); subReport_Dn.ReportSource = rpt_Dn; rpt_Dn.DataSource = tab_Dn; } if (tab_Ts.Rows.Count > 0) { DevExpress.XtraReports.UI.GroupFooterBand groupFooter_Ts = rpt.Report.Bands["GroupFooter_Ts"] as DevExpress.XtraReports.UI.GroupFooterBand; DevExpress.XtraReports.UI.XRSubreport subReport_Ts = new XRSubreport(); subReport_Ts.Name = "groupFooter_Ts"; groupFooter_Ts.Controls.Add(subReport_Ts); XtraReport rpt_Ts = new XtraReport(); rpt_Ts.LoadLayout(Server.MapPath(@"~\ReportAir\repx\import\Pl_3_Ts.repx")); subReport_Ts.ReportSource = rpt_Ts; rpt_Ts.DataSource = tab_Ts; } if (tab_Cn.Rows.Count > 0) { DevExpress.XtraReports.UI.GroupFooterBand groupFooter_Cn = rpt.Report.Bands["GroupFooter_Cn"] as DevExpress.XtraReports.UI.GroupFooterBand; DevExpress.XtraReports.UI.XRSubreport subReport_Cn = new XRSubreport(); subReport_Cn.Name = "groupFooter_Cn"; groupFooter_Cn.Controls.Add(subReport_Cn); XtraReport rpt_Cn = new XtraReport(); rpt_Cn.LoadLayout(Server.MapPath(@"~\ReportAir\repx\import\Pl_4_Cn.repx")); subReport_Cn.ReportSource = rpt_Cn; rpt_Cn.DataSource = tab_Cn; } if (tab_Pl.Rows.Count > 0) { DevExpress.XtraReports.UI.GroupFooterBand groupFooter_Pl = rpt.Report.Bands["GroupFooter_Pl"] as DevExpress.XtraReports.UI.GroupFooterBand; DevExpress.XtraReports.UI.XRSubreport subReport_Pl = new XRSubreport(); subReport_Pl.Name = "groupFooter_Pl"; groupFooter_Pl.Controls.Add(subReport_Pl); XtraReport rpt_Pl = new XtraReport(); rpt_Pl.LoadLayout(Server.MapPath(@"~\ReportAir\repx\import\Pl_5_Pl.repx")); subReport_Pl.ReportSource = rpt_Pl; rpt_Pl.DataSource = tab_Pl; } if (tab_Vo.Rows.Count > 0) { DevExpress.XtraReports.UI.GroupFooterBand groupFooter_Vo = rpt.Report.Bands["GroupFooter_Vo"] as DevExpress.XtraReports.UI.GroupFooterBand; DevExpress.XtraReports.UI.XRSubreport subReport_Vo = new XRSubreport(); subReport_Vo.Name = "groupFooter_Vo"; groupFooter_Vo.Controls.Add(subReport_Vo); XtraReport rpt_Vo = new XtraReport(); rpt_Vo.LoadLayout(Server.MapPath(@"~\ReportAir\repx\import\Pl_6_Vo.repx")); subReport_Vo.ReportSource = rpt_Vo; rpt_Vo.DataSource = tab_Vo; } if (tab_Cost.Rows.Count > 0) { DevExpress.XtraReports.UI.GroupFooterBand groupFooter_Cost = rpt.Report.Bands["GroupFooter_Costing"] as DevExpress.XtraReports.UI.GroupFooterBand; DevExpress.XtraReports.UI.XRSubreport subReport_Cost = new XRSubreport(); subReport_Cost.Name = "subReport_Cost"; groupFooter_Cost.Controls.Add(subReport_Cost); XtraReport rpt_Cost = new XtraReport(); rpt_Cost.LoadLayout(Server.MapPath(@"~\ReportAir\repx\import\Pl_7_Cost.repx")); subReport_Cost.ReportSource = rpt_Cost; rpt_Cost.DataSource = tab_Cost; } rpt.DataSource = tab_mast; System.IO.MemoryStream str = new MemoryStream(); if (docType == "1") { rpt.ExportToXls(str); } else { rpt.ExportToPdf(str); } return(str); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.Detail = new DevExpress.XtraReports.UI.DetailBand(); this.xrLabel11 = new DevExpress.XtraReports.UI.XRLabel(); this.consItem1 = new CMSM.Report.ConsItem(); this.xrLabel13 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel14 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel15 = new DevExpress.XtraReports.UI.XRLabel(); this.PageHeader = new DevExpress.XtraReports.UI.PageHeaderBand(); this.xrLabel29 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel28 = new DevExpress.XtraReports.UI.XRLabel(); this.xrlCardID = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel27 = new DevExpress.XtraReports.UI.XRLabel(); this.xrlIg = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel26 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel25 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel24 = new DevExpress.XtraReports.UI.XRLabel(); this.xrlCharge = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel23 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLine1 = new DevExpress.XtraReports.UI.XRLine(); this.xrLabel6 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel5 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel4 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel3 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel2 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel1 = new DevExpress.XtraReports.UI.XRLabel(); this.GroupHeader0 = new DevExpress.XtraReports.UI.GroupHeaderBand(); this.xrLabel10 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel9 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel8 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel7 = new DevExpress.XtraReports.UI.XRLabel(); this.GroupFooter0 = new DevExpress.XtraReports.UI.GroupFooterBand(); this.ndRate = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel30 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel17 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel20 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLine2 = new DevExpress.XtraReports.UI.XRLine(); this.xrLabel12 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel16 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel18 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel19 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel21 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel22 = new DevExpress.XtraReports.UI.XRLabel(); this.sqlDataAdapter1 = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlConnection1 = new System.Data.SqlClient.SqlConnection(); this.PageFooter = new DevExpress.XtraReports.UI.PageFooterBand(); ((System.ComponentModel.ISupportInitialize)(this.consItem1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // Detail // this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel11, this.xrLabel13, this.xrLabel14, this.xrLabel15 }); this.Detail.Font = new System.Drawing.Font("宋体", 9.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0))); this.Detail.Height = 16; this.Detail.Name = "Detail"; this.Detail.ParentStyleUsing.UseFont = false; // // xrLabel11 // this.xrLabel11.DataBindings.Add(new DevExpress.XtraReports.UI.XRBinding("Text", this.consItem1, "tbConsItem.vcGoodsName", "")); this.xrLabel11.Font = new System.Drawing.Font("宋体", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134))); this.xrLabel11.Location = new System.Drawing.Point(0, 0); this.xrLabel11.Name = "xrLabel11"; this.xrLabel11.ParentStyleUsing.UseFont = false; this.xrLabel11.Size = new System.Drawing.Size(86, 16); this.xrLabel11.TextAlign = System.Drawing.ContentAlignment.MiddleLeft; // // consItem1 // this.consItem1.DataSetName = "ConsItem"; this.consItem1.Locale = new System.Globalization.CultureInfo("zh-CN"); // // xrLabel13 // this.xrLabel13.DataBindings.Add(new DevExpress.XtraReports.UI.XRBinding("Text", this.consItem1, "tbConsItem.nPrice", "")); this.xrLabel13.Font = new System.Drawing.Font("宋体", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134))); this.xrLabel13.Location = new System.Drawing.Point(86, 0); this.xrLabel13.Name = "xrLabel13"; this.xrLabel13.ParentStyleUsing.UseFont = false; this.xrLabel13.Size = new System.Drawing.Size(32, 16); this.xrLabel13.TextAlign = System.Drawing.ContentAlignment.MiddleCenter; // // xrLabel14 // this.xrLabel14.DataBindings.Add(new DevExpress.XtraReports.UI.XRBinding("Text", this.consItem1, "tbConsItem.iCount", "")); this.xrLabel14.Font = new System.Drawing.Font("宋体", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134))); this.xrLabel14.Location = new System.Drawing.Point(118, 0); this.xrLabel14.Name = "xrLabel14"; this.xrLabel14.ParentStyleUsing.UseFont = false; this.xrLabel14.Size = new System.Drawing.Size(30, 16); this.xrLabel14.TextAlign = System.Drawing.ContentAlignment.MiddleCenter; // // xrLabel15 // this.xrLabel15.DataBindings.Add(new DevExpress.XtraReports.UI.XRBinding("Text", this.consItem1, "tbConsItem.nFee", "")); this.xrLabel15.Font = new System.Drawing.Font("宋体", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134))); this.xrLabel15.Location = new System.Drawing.Point(148, 0); this.xrLabel15.Name = "xrLabel15"; this.xrLabel15.ParentStyleUsing.UseFont = false; this.xrLabel15.Size = new System.Drawing.Size(41, 16); this.xrLabel15.TextAlign = System.Drawing.ContentAlignment.MiddleCenter; // // PageHeader // this.PageHeader.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel29, this.xrLabel28, this.xrlCardID, this.xrLabel27, this.xrlIg, this.xrLabel26, this.xrLabel25, this.xrLabel24, this.xrlCharge, this.xrLabel23, this.xrLine1, this.xrLabel6, this.xrLabel5, this.xrLabel4, this.xrLabel3, this.xrLabel2, this.xrLabel1 }); this.PageHeader.Height = 201; this.PageHeader.Name = "PageHeader"; // // xrLabel29 // this.xrLabel29.Font = new System.Drawing.Font("宋体", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134))); this.xrLabel29.Location = new System.Drawing.Point(58, 133); this.xrLabel29.Name = "xrLabel29"; this.xrLabel29.ParentStyleUsing.UseFont = false; this.xrLabel29.Size = new System.Drawing.Size(93, 17); // // xrLabel28 // this.xrLabel28.Font = new System.Drawing.Font("宋体", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134))); this.xrLabel28.Location = new System.Drawing.Point(2, 133); this.xrLabel28.Name = "xrLabel28"; this.xrLabel28.ParentStyleUsing.UseFont = false; this.xrLabel28.Size = new System.Drawing.Size(48, 17); this.xrLabel28.Text = "操作员:"; this.xrLabel28.TextAlign = System.Drawing.ContentAlignment.MiddleLeft; // // xrlCardID // this.xrlCardID.Font = new System.Drawing.Font("宋体", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134))); this.xrlCardID.Location = new System.Drawing.Point(46, 67); this.xrlCardID.Name = "xrlCardID"; this.xrlCardID.ParentStyleUsing.UseFont = false; this.xrlCardID.Size = new System.Drawing.Size(127, 17); // // xrLabel27 // this.xrLabel27.Font = new System.Drawing.Font("宋体", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134))); this.xrLabel27.Location = new System.Drawing.Point(0, 67); this.xrLabel27.Name = "xrLabel27"; this.xrLabel27.ParentStyleUsing.UseFont = false; this.xrLabel27.Size = new System.Drawing.Size(46, 17); this.xrLabel27.Text = "会员卡:"; this.xrLabel27.TextAlign = System.Drawing.ContentAlignment.MiddleLeft; // // xrlIg // this.xrlIg.Font = new System.Drawing.Font("宋体", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134))); this.xrlIg.Location = new System.Drawing.Point(73, 117); this.xrlIg.Name = "xrlIg"; this.xrlIg.ParentStyleUsing.UseFont = false; this.xrlIg.Size = new System.Drawing.Size(93, 17); this.xrlIg.Text = "0分"; // // xrLabel26 // this.xrLabel26.Font = new System.Drawing.Font("宋体", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134))); this.xrLabel26.Location = new System.Drawing.Point(0, 117); this.xrLabel26.Name = "xrLabel26"; this.xrLabel26.ParentStyleUsing.UseFont = false; this.xrLabel26.Size = new System.Drawing.Size(73, 16); this.xrLabel26.Text = "会员积分:"; this.xrLabel26.TextAlign = System.Drawing.ContentAlignment.MiddleLeft; // // xrLabel25 // this.xrLabel25.Font = new System.Drawing.Font("宋体", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134))); this.xrLabel25.Location = new System.Drawing.Point(58, 167); this.xrLabel25.Name = "xrLabel25"; this.xrLabel25.ParentStyleUsing.UseFont = false; this.xrLabel25.Size = new System.Drawing.Size(126, 17); // // xrLabel24 // this.xrLabel24.Font = new System.Drawing.Font("宋体", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134))); this.xrLabel24.Location = new System.Drawing.Point(2, 167); this.xrLabel24.Name = "xrLabel24"; this.xrLabel24.ParentStyleUsing.UseFont = false; this.xrLabel24.Size = new System.Drawing.Size(67, 17); this.xrLabel24.Text = "服务电话:"; this.xrLabel24.TextAlign = System.Drawing.ContentAlignment.MiddleLeft; // // xrlCharge // this.xrlCharge.Font = new System.Drawing.Font("宋体", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134))); this.xrlCharge.Location = new System.Drawing.Point(57, 83); this.xrlCharge.Name = "xrlCharge"; this.xrlCharge.ParentStyleUsing.UseFont = false; this.xrlCharge.Size = new System.Drawing.Size(119, 16); this.xrlCharge.Text = "0元"; // // xrLabel23 // this.xrLabel23.Font = new System.Drawing.Font("宋体", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134))); this.xrLabel23.Location = new System.Drawing.Point(0, 83); this.xrLabel23.Name = "xrLabel23"; this.xrLabel23.ParentStyleUsing.UseFont = false; this.xrLabel23.Size = new System.Drawing.Size(57, 16); this.xrLabel23.Text = "会员余额:"; this.xrLabel23.TextAlign = System.Drawing.ContentAlignment.MiddleLeft; // // xrLine1 // this.xrLine1.LineStyle = System.Drawing.Drawing2D.DashStyle.DashDot; this.xrLine1.Location = new System.Drawing.Point(0, 175); this.xrLine1.Name = "xrLine1"; this.xrLine1.Size = new System.Drawing.Size(186, 8); // // xrLabel6 // this.xrLabel6.Font = new System.Drawing.Font("宋体", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134))); this.xrLabel6.Location = new System.Drawing.Point(50, 100); this.xrLabel6.Name = "xrLabel6"; this.xrLabel6.ParentStyleUsing.UseFont = false; this.xrLabel6.Size = new System.Drawing.Size(123, 16); this.xrLabel6.Text = "0"; // // xrLabel5 // this.xrLabel5.Font = new System.Drawing.Font("宋体", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134))); this.xrLabel5.Location = new System.Drawing.Point(3, 100); this.xrLabel5.Name = "xrLabel5"; this.xrLabel5.ParentStyleUsing.UseFont = false; this.xrLabel5.Size = new System.Drawing.Size(46, 16); this.xrLabel5.Text = "小票号:"; // // xrLabel4 // this.xrLabel4.Font = new System.Drawing.Font("宋体", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134))); this.xrLabel4.Location = new System.Drawing.Point(58, 150); this.xrLabel4.Name = "xrLabel4"; this.xrLabel4.ParentStyleUsing.UseFont = false; this.xrLabel4.Size = new System.Drawing.Size(112, 20); this.xrLabel4.Text = "2007-04-28"; // // xrLabel3 // this.xrLabel3.Font = new System.Drawing.Font("宋体", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134))); this.xrLabel3.Location = new System.Drawing.Point(2, 150); this.xrLabel3.Name = "xrLabel3"; this.xrLabel3.ParentStyleUsing.UseFont = false; this.xrLabel3.Size = new System.Drawing.Size(48, 19); this.xrLabel3.Text = "日 期:"; // // xrLabel2 // this.xrLabel2.Font = new System.Drawing.Font("宋体", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134))); this.xrLabel2.Location = new System.Drawing.Point(0, 33); this.xrLabel2.Name = "xrLabel2"; this.xrLabel2.ParentStyleUsing.UseFont = false; this.xrLabel2.Size = new System.Drawing.Size(185, 27); this.xrLabel2.Text = "谢谢惠顾!"; // // xrLabel1 // this.xrLabel1.Font = new System.Drawing.Font("宋体", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134))); this.xrLabel1.Location = new System.Drawing.Point(50, 8); this.xrLabel1.Name = "xrLabel1"; this.xrLabel1.ParentStyleUsing.UseFont = false; this.xrLabel1.Size = new System.Drawing.Size(97, 16); // // GroupHeader0 // this.GroupHeader0.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel10, this.xrLabel9, this.xrLabel8, this.xrLabel7 }); this.GroupHeader0.Height = 16; this.GroupHeader0.Name = "GroupHeader0"; // // xrLabel10 // this.xrLabel10.Font = new System.Drawing.Font("宋体", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134))); this.xrLabel10.Location = new System.Drawing.Point(148, 0); this.xrLabel10.Name = "xrLabel10"; this.xrLabel10.ParentStyleUsing.UseFont = false; this.xrLabel10.Size = new System.Drawing.Size(41, 16); this.xrLabel10.Text = "小计"; this.xrLabel10.TextAlign = System.Drawing.ContentAlignment.MiddleCenter; // // xrLabel9 // this.xrLabel9.Font = new System.Drawing.Font("宋体", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134))); this.xrLabel9.Location = new System.Drawing.Point(118, 0); this.xrLabel9.Name = "xrLabel9"; this.xrLabel9.ParentStyleUsing.UseFont = false; this.xrLabel9.Size = new System.Drawing.Size(30, 16); this.xrLabel9.Text = "数量"; this.xrLabel9.TextAlign = System.Drawing.ContentAlignment.MiddleCenter; // // xrLabel8 // this.xrLabel8.Font = new System.Drawing.Font("宋体", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134))); this.xrLabel8.Location = new System.Drawing.Point(86, 0); this.xrLabel8.Name = "xrLabel8"; this.xrLabel8.ParentStyleUsing.UseFont = false; this.xrLabel8.Size = new System.Drawing.Size(32, 16); this.xrLabel8.Text = "单价"; this.xrLabel8.TextAlign = System.Drawing.ContentAlignment.MiddleCenter; // // xrLabel7 // this.xrLabel7.Font = new System.Drawing.Font("宋体", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134))); this.xrLabel7.Location = new System.Drawing.Point(0, 0); this.xrLabel7.Name = "xrLabel7"; this.xrLabel7.ParentStyleUsing.UseFont = false; this.xrLabel7.Size = new System.Drawing.Size(86, 16); this.xrLabel7.Text = "商品名称"; // // GroupFooter0 // this.GroupFooter0.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.ndRate, this.xrLabel30, this.xrLabel17, this.xrLabel20, this.xrLine2, this.xrLabel12, this.xrLabel16, this.xrLabel18, this.xrLabel19, this.xrLabel21, this.xrLabel22 }); this.GroupFooter0.Height = 88; this.GroupFooter0.Name = "GroupFooter0"; // // ndRate // this.ndRate.Font = new System.Drawing.Font("宋体", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134))); this.ndRate.Location = new System.Drawing.Point(133, 16); this.ndRate.Name = "ndRate"; this.ndRate.ParentStyleUsing.UseFont = false; this.ndRate.Size = new System.Drawing.Size(56, 16); this.ndRate.TextAlign = System.Drawing.ContentAlignment.MiddleCenter; // // xrLabel30 // this.xrLabel30.Font = new System.Drawing.Font("宋体", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134))); this.xrLabel30.Location = new System.Drawing.Point(65, 16); this.xrLabel30.Name = "xrLabel30"; this.xrLabel30.ParentStyleUsing.UseFont = false; this.xrLabel30.Size = new System.Drawing.Size(67, 16); this.xrLabel30.Text = "折扣率:"; this.xrLabel30.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // xrLabel17 // this.xrLabel17.Font = new System.Drawing.Font("宋体", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134))); this.xrLabel17.Location = new System.Drawing.Point(65, 32); this.xrLabel17.Name = "xrLabel17"; this.xrLabel17.ParentStyleUsing.UseFont = false; this.xrLabel17.Size = new System.Drawing.Size(67, 16); this.xrLabel17.Text = "折扣合计:"; this.xrLabel17.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // xrLabel20 // this.xrLabel20.Font = new System.Drawing.Font("宋体", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134))); this.xrLabel20.Location = new System.Drawing.Point(65, 64); this.xrLabel20.Name = "xrLabel20"; this.xrLabel20.ParentStyleUsing.UseFont = false; this.xrLabel20.Size = new System.Drawing.Size(67, 16); this.xrLabel20.Text = "找零:"; this.xrLabel20.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // xrLine2 // this.xrLine2.LineStyle = System.Drawing.Drawing2D.DashStyle.DashDot; this.xrLine2.Location = new System.Drawing.Point(0, 80); this.xrLine2.Name = "xrLine2"; this.xrLine2.Size = new System.Drawing.Size(186, 8); // // xrLabel12 // this.xrLabel12.Font = new System.Drawing.Font("宋体", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134))); this.xrLabel12.Location = new System.Drawing.Point(65, 0); this.xrLabel12.Name = "xrLabel12"; this.xrLabel12.ParentStyleUsing.UseFont = false; this.xrLabel12.Size = new System.Drawing.Size(67, 16); this.xrLabel12.Text = "应收合计:"; this.xrLabel12.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // xrLabel16 // this.xrLabel16.DataBindings.Add(new DevExpress.XtraReports.UI.XRBinding("Text", this.consItem1, "tbConsItem.nTFee", "")); this.xrLabel16.Font = new System.Drawing.Font("宋体", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134))); this.xrLabel16.Location = new System.Drawing.Point(133, 0); this.xrLabel16.Name = "xrLabel16"; this.xrLabel16.ParentStyleUsing.UseFont = false; this.xrLabel16.Size = new System.Drawing.Size(55, 16); this.xrLabel16.TextAlign = System.Drawing.ContentAlignment.MiddleCenter; // // xrLabel18 // this.xrLabel18.DataBindings.Add(new DevExpress.XtraReports.UI.XRBinding("Text", this.consItem1, "tbConsItem.nTRate", "")); this.xrLabel18.Font = new System.Drawing.Font("宋体", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134))); this.xrLabel18.Location = new System.Drawing.Point(133, 32); this.xrLabel18.Name = "xrLabel18"; this.xrLabel18.ParentStyleUsing.UseFont = false; this.xrLabel18.Size = new System.Drawing.Size(55, 16); this.xrLabel18.TextAlign = System.Drawing.ContentAlignment.MiddleCenter; // // xrLabel19 // this.xrLabel19.DataBindings.Add(new DevExpress.XtraReports.UI.XRBinding("Text", this.consItem1, "tbConsItem.vcCommName", "")); this.xrLabel19.Font = new System.Drawing.Font("宋体", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134))); this.xrLabel19.Location = new System.Drawing.Point(65, 48); this.xrLabel19.Name = "xrLabel19"; this.xrLabel19.ParentStyleUsing.UseFont = false; this.xrLabel19.Size = new System.Drawing.Size(67, 16); this.xrLabel19.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // xrLabel21 // this.xrLabel21.DataBindings.Add(new DevExpress.XtraReports.UI.XRBinding("Text", this.consItem1, "tbConsItem.nPay", "")); this.xrLabel21.Font = new System.Drawing.Font("宋体", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134))); this.xrLabel21.Location = new System.Drawing.Point(133, 48); this.xrLabel21.Name = "xrLabel21"; this.xrLabel21.ParentStyleUsing.UseFont = false; this.xrLabel21.Size = new System.Drawing.Size(55, 16); this.xrLabel21.TextAlign = System.Drawing.ContentAlignment.MiddleCenter; // // xrLabel22 // this.xrLabel22.DataBindings.Add(new DevExpress.XtraReports.UI.XRBinding("Text", this.consItem1, "tbConsItem.nBalance", "")); this.xrLabel22.Font = new System.Drawing.Font("宋体", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134))); this.xrLabel22.Location = new System.Drawing.Point(133, 64); this.xrLabel22.Name = "xrLabel22"; this.xrLabel22.ParentStyleUsing.UseFont = false; this.xrLabel22.Size = new System.Drawing.Size(55, 16); this.xrLabel22.TextAlign = System.Drawing.ContentAlignment.MiddleCenter; // // sqlDataAdapter1 // this.sqlDataAdapter1.SelectCommand = this.sqlSelectCommand1; this.sqlDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "tbConsItem", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("vcGoodsName", "vcGoodsName"), new System.Data.Common.DataColumnMapping("nPrice", "nPrice"), new System.Data.Common.DataColumnMapping("iCount", "iCount"), new System.Data.Common.DataColumnMapping("nFee", "nFee"), new System.Data.Common.DataColumnMapping("nTRate", "nTRate"), new System.Data.Common.DataColumnMapping("nTFee", "nTFee"), new System.Data.Common.DataColumnMapping("nPay", "nPay"), new System.Data.Common.DataColumnMapping("nBalance", "nBalance"), new System.Data.Common.DataColumnMapping("vcCommName", "vcCommName") }) }); // // sqlSelectCommand1 // this.sqlSelectCommand1.CommandText = @"SELECT tbGoods.vcGoodsName, tbConsItem.vcCardID, tbConsItem.nPrice, tbConsItem.iCount, tbConsItem.nFee, tbBill.nTRate, tbBill.nFee AS nTFee, tbBill.nPay, tbBill.nBalance, tbCommCode.vcCommName, tbConsItem.vcOperName FROM tbConsItem INNER JOIN tbGoods ON tbConsItem.vcGoodsID = tbGoods.vcGoodsID INNER JOIN tbBill ON tbConsItem.iSerial = tbBill.iSerial INNER JOIN tbCommCode ON tbBill.vcConsType = tbCommCode.vcCommCode"; this.sqlSelectCommand1.Connection = this.sqlConnection1; // // sqlConnection1 // this.sqlConnection1.ConnectionString = "workstation id=\"KMDX-Z9E5N5MK76\";packet size=4096;user id=sa;data source=\".\\sqlex" + "press\";persist security info=False;initial catalog=AMSCM_GY"; this.sqlConnection1.InfoMessage += new System.Data.SqlClient.SqlInfoMessageEventHandler(this.sqlConnection1_InfoMessage); // // PageFooter // this.PageFooter.Height = 0; this.PageFooter.Name = "PageFooter"; // // xrConsTiny // this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.Detail, this.PageHeader, this.GroupHeader0, this.GroupFooter0, this.PageFooter }); this.DataAdapter = this.sqlDataAdapter1; this.DataSource = this.consItem1; this.PageWidth = 392; ((System.ComponentModel.ISupportInitialize)(this.consItem1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this)).EndInit(); }