public JsonResult CancelPrinttoPrinters(string PrintDate, int LocKy, int OrdKy) { bool success = true; try { string TempDate = PrintDate.Replace("-", "/"); string[] afdate = TempDate.Split('/'); string Date = afdate.GetValue(0).ToString(); string ddlfmonth = afdate.GetValue(1).ToString(); string ddlfyear = afdate.GetValue(2).ToString(); string sDlydate = ddlfyear + "/" + ddlfmonth + "/" + Date; int UsrKy = HTNSession.UsrKy; int CKy = HTNSession.CKy; List <SplLocWithPrinter> list = new List <SplLocWithPrinter>(); list = apiOpr.AmendedPrintToLoc(HTNSession.Environment, CKy, OrdKy, UsrKy, sDlydate, LocKy); for (int i = 0; i < list.Count; i++) { if (list[i].PrinterNm == "error") { } else { try { System.Drawing.Printing.PrinterSettings printerSettings = new System.Drawing.Printing.PrinterSettings(); printerSettings.PrinterName = list[i].PrinterNm; if (printerSettings.IsValid) { Telerik.Reporting.UriReportSource uriReportSource = new Telerik.Reporting.UriReportSource(); uriReportSource.Uri = AppDomain.CurrentDomain.BaseDirectory + "\\Amendedpnssplorder_report.trdx"; uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter("OrdKy", OrdKy)); uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter("UsrKy", UsrKy)); uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter("PrinterLoc", list[i].ProdLocCd)); uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter("ProdLocKy", LocKy)); uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter("DlryDt", sDlydate)); PrintController printController = new StandardPrintController(); ReportProcessor reportProcessor = new ReportProcessor(); reportProcessor.PrintController = printController; reportProcessor.PrintReport(uriReportSource, printerSettings); } } catch { } } } return(Json("Success", JsonRequestBehavior.AllowGet)); } catch { return(Json("False", JsonRequestBehavior.AllowGet)); } }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { Telerik.Reporting.UriReportSource uriReportSource1 = new Telerik.Reporting.UriReportSource(); this.reportViewer1 = new Telerik.ReportViewer.WinForms.ReportViewer(); this.SuspendLayout(); // // reportViewer1 // this.reportViewer1.Dock = System.Windows.Forms.DockStyle.Fill; this.reportViewer1.Location = new System.Drawing.Point(0, 0); this.reportViewer1.Name = "reportViewer1"; uriReportSource1.Uri = "Reports/SampleReport.trdx"; this.reportViewer1.ReportSource = uriReportSource1; this.reportViewer1.Size = new System.Drawing.Size(900, 700); this.reportViewer1.TabIndex = 0; this.reportViewer1.Load += new System.EventHandler(this.reportViewer1_Load); // // ReportViewerFormZakaz // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.ClientSize = new System.Drawing.Size(900, 700); this.Controls.Add(this.reportViewer1); this.Name = "ReportViewerFormZakaz"; this.Text = "Report Viewer Form"; this.Load += new System.EventHandler(this.ReportViewerFormZakaz_Load); this.ResumeLayout(false); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { Telerik.Reporting.UriReportSource uriReportSource1 = new Telerik.Reporting.UriReportSource(); //this.reportViewer1 = new Telerik.ReportViewer.WinForms.ReportViewer(); this.SuspendLayout(); // // reportViewer1 // //this.reportViewer1.Dock = System.Windows.Forms.DockStyle.Fill; //this.reportViewer1.Location = new System.Drawing.Point(0, 0); //this.reportViewer1.Name = "reportViewer1"; //uriReportSource1.Uri = "StudentAssessment.CS"; //this.reportViewer1.ReportSource = uriReportSource1; //this.reportViewer1.Size = new System.Drawing.Size(526, 637); //this.reportViewer1.TabIndex = 0; // // StudentAssessmentForm // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.ClientSize = new System.Drawing.Size(526, 637); //this.Controls.Add(this.reportViewer1); this.Name = "StudentAssessmentForm"; this.Text = "Report Viewer Form"; this.Load += new System.EventHandler(this.StudentAssessmentForm_Load); this.ResumeLayout(false); }
public JsonResult PrintPendingInvoice(string OrdKy) { bool success = true; int CKy = HTNSession.CKy; int UsrKy = HTNSession.UsrKy; string EnvironmentName = HTNSession.Environment; String printerName = WebConfigurationManager.AppSettings["PendingInvoicePrinterName"]; String PendingInvoiceReportPath = WebConfigurationManager.AppSettings["PendingInvoiceReportPath"]; try { System.Drawing.Printing.PrinterSettings printerSettings = new System.Drawing.Printing.PrinterSettings(); List <UsrMasPrinter_Select> list = new List <UsrMasPrinter_Select>(); list = apiOpr.GetUsrMasPrinter_Select(CKy, UsrKy, 1, 1, EnvironmentName); if (list.Count > 0) { printerName = list[0].PrinterNm; } printerSettings.PrinterName = printerName; if (printerSettings.IsValid) { Telerik.Reporting.UriReportSource uriReportSource = new Telerik.Reporting.UriReportSource(); uriReportSource.Uri = AppDomain.CurrentDomain.BaseDirectory + PendingInvoiceReportPath; uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter("OrdKy", OrdKy)); uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter("UsrKy", UsrKy)); uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter("CKy", CKy)); PrintController printController = new StandardPrintController(); ReportProcessor reportProcessor = new ReportProcessor(); reportProcessor.PrintController = printController; reportProcessor.PrintReport(uriReportSource, printerSettings); apiOpr.PrintLog_Insert(HTNSession.Environment, CKy, UsrKy, 1, Convert.ToInt32(OrdKy), printerName, DateTime.Now.ToString(), "Pending Invoice Done"); return(Json("Success", JsonRequestBehavior.AllowGet)); } apiOpr.PrintLog_Insert(HTNSession.Environment, CKy, UsrKy, 1, Convert.ToInt32(OrdKy), printerName, DateTime.Now.ToString(), "Pending Invoice Valid Fail"); return(Json("Printer Not valid", JsonRequestBehavior.AllowGet)); } catch { throw; } }
public JsonResult PrinttoPrinters(string PrintDate, int LocKy, int OrdKy) { String KOTReportPath = WebConfigurationManager.AppSettings["KOTReportPath"]; string states = "Fail"; List <string> Printers = new List <string>(); foreach (var printer in System.Drawing.Printing.PrinterSettings.InstalledPrinters) { Printers.Add(printer.ToString()); //Its created for incase of find Printers list on this PC } try { string[] afdate = PrintDate.Split('/'); string Date = afdate.GetValue(0).ToString(); string ddlfmonth = afdate.GetValue(1).ToString(); string ddlfyear = afdate.GetValue(2).ToString(); string sDlydate = ddlfyear + "/" + ddlfmonth + "/" + Date; int UsrKy = HTNSession.UsrKy; int CKy = HTNSession.CKy; List <SplLocWithPrinter> list = new List <SplLocWithPrinter>(); list = apiOpr.PrintToLoc(HTNSession.Environment, CKy, OrdKy, UsrKy, sDlydate, LocKy); if (list.Count <= 0) { apiOpr.PrintLog_Insert(HTNSession.Environment, CKy, UsrKy, Convert.ToInt32(LocKy), OrdKy, "No record return from SP", sDlydate, states); } for (int i = 0; i < list.Count; i++) { if (list[i].PrinterNm == "error") { // Here Printer name is NULL } else { try { System.Drawing.Printing.PrinterSettings printerSettings = new System.Drawing.Printing.PrinterSettings(); printerSettings.PrinterName = list[i].PrinterIP; // +"\\" + list[i].PrinterNm; if (printerSettings.IsValid) { Telerik.Reporting.UriReportSource uriReportSource = new Telerik.Reporting.UriReportSource(); uriReportSource.Uri = AppDomain.CurrentDomain.BaseDirectory + KOTReportPath; uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter("OrdKy", OrdKy)); uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter("UsrKy", UsrKy)); uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter("PrinterLoc", list[i].ProdLocCd)); uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter("ProdLocKy", LocKy)); uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter("DlryDt", sDlydate)); PrintController printController = new StandardPrintController(); ReportProcessor reportProcessor = new ReportProcessor(); reportProcessor.PrintController = printController; reportProcessor.PrintReport(uriReportSource, printerSettings); states = "Print Done"; } else { states = "It's Not Valid Printer"; } } catch (Exception ex) { states = "Exception"; } } apiOpr.PrintLog_Insert(HTNSession.Environment, CKy, UsrKy, Convert.ToInt32(LocKy), OrdKy, list[i].PrinterIP, sDlydate, states); } return(Json(states, JsonRequestBehavior.AllowGet)); } catch { return(Json(states, JsonRequestBehavior.AllowGet)); } }
/// <summary> /// Required method for telerik Reporting designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { Telerik.Reporting.Barcodes.Code128Encoder code128Encoder1 = new Telerik.Reporting.Barcodes.Code128Encoder(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Report1)); Telerik.Reporting.UriReportSource uriReportSource1 = new Telerik.Reporting.UriReportSource(); Telerik.Reporting.Barcodes.Code25StandardEncoder code25StandardEncoder1 = new Telerik.Reporting.Barcodes.Code25StandardEncoder(); Telerik.Reporting.Group group1 = new Telerik.Reporting.Group(); Telerik.Reporting.Drawing.TextWatermark textWatermark1 = new Telerik.Reporting.Drawing.TextWatermark(); Telerik.Reporting.ReportParameter reportParameter1 = new Telerik.Reporting.ReportParameter(); Telerik.Reporting.ReportParameter reportParameter2 = new Telerik.Reporting.ReportParameter(); Telerik.Reporting.ReportParameter reportParameter3 = new Telerik.Reporting.ReportParameter(); Telerik.Reporting.Drawing.StyleRule styleRule1 = new Telerik.Reporting.Drawing.StyleRule(); Telerik.Reporting.Drawing.StyleRule styleRule2 = new Telerik.Reporting.Drawing.StyleRule(); Telerik.Reporting.Drawing.StyleRule styleRule3 = new Telerik.Reporting.Drawing.StyleRule(); Telerik.Reporting.Drawing.StyleRule styleRule4 = new Telerik.Reporting.Drawing.StyleRule(); this.groupFooterSection1 = new Telerik.Reporting.GroupFooterSection(); this.groupHeaderSection1 = new Telerik.Reporting.GroupHeaderSection(); this.panel5 = new Telerik.Reporting.Panel(); this.Text1 = new Telerik.Reporting.TextBox(); this.barcode2 = new Telerik.Reporting.Barcode(); this.pictureBox1 = new Telerik.Reporting.PictureBox(); this.textBox1 = new Telerik.Reporting.TextBox(); this.panel3 = new Telerik.Reporting.Panel(); this.Id1 = new Telerik.Reporting.TextBox(); this.Text8 = new Telerik.Reporting.TextBox(); this.Field6 = new Telerik.Reporting.TextBox(); this.shape3 = new Telerik.Reporting.Shape(); this.OrderNumbers = new Telerik.Reporting.SqlDataSource(); this.Invoices = new Telerik.Reporting.SqlDataSource(); this.detail = new Telerik.Reporting.DetailSection(); this.panel4 = new Telerik.Reporting.Panel(); this.textBox14 = new Telerik.Reporting.TextBox(); this.textBox10 = new Telerik.Reporting.TextBox(); this.textBox9 = new Telerik.Reporting.TextBox(); this.textBox8 = new Telerik.Reporting.TextBox(); this.textBox6 = new Telerik.Reporting.TextBox(); this.textBox4 = new Telerik.Reporting.TextBox(); this.textBox12 = new Telerik.Reporting.TextBox(); this.textBox13 = new Telerik.Reporting.TextBox(); this.textBox11 = new Telerik.Reporting.TextBox(); this.textBox16 = new Telerik.Reporting.TextBox(); this.textBox17 = new Telerik.Reporting.TextBox(); this.textBox18 = new Telerik.Reporting.TextBox(); this.textBox19 = new Telerik.Reporting.TextBox(); this.textBox21 = new Telerik.Reporting.TextBox(); this.panel1 = new Telerik.Reporting.Panel(); this.textBox24 = new Telerik.Reporting.TextBox(); this.textBox23 = new Telerik.Reporting.TextBox(); this.textBox25 = new Telerik.Reporting.TextBox(); this.textBox26 = new Telerik.Reporting.TextBox(); this.textBox27 = new Telerik.Reporting.TextBox(); this.textBox30 = new Telerik.Reporting.TextBox(); this.textBox29 = new Telerik.Reporting.TextBox(); this.textBox28 = new Telerik.Reporting.TextBox(); this.textBox32 = new Telerik.Reporting.TextBox(); this.textBox31 = new Telerik.Reporting.TextBox(); this.panel2 = new Telerik.Reporting.Panel(); this.textBox7 = new Telerik.Reporting.TextBox(); this.textBox2 = new Telerik.Reporting.TextBox(); this.textBox3 = new Telerik.Reporting.TextBox(); this.subReport1 = new Telerik.Reporting.SubReport(); this.pageFooterSection1 = new Telerik.Reporting.PageFooterSection(); this.textBox5 = new Telerik.Reporting.TextBox(); this.textBox22 = new Telerik.Reporting.TextBox(); this.shape1 = new Telerik.Reporting.Shape(); this.barcode1 = new Telerik.Reporting.Barcode(); this.pictureBox2 = new Telerik.Reporting.PictureBox(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // groupFooterSection1 // this.groupFooterSection1.Height = Telerik.Reporting.Drawing.Unit.Inch(0.23999999463558197D); this.groupFooterSection1.Name = "groupFooterSection1"; this.groupFooterSection1.Style.Visible = false; // // groupHeaderSection1 // this.groupHeaderSection1.Height = Telerik.Reporting.Drawing.Unit.Inch(3.0200004577636719D); this.groupHeaderSection1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.panel5}); this.groupHeaderSection1.Name = "groupHeaderSection1"; // // panel5 // this.panel5.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.Text1, this.barcode2, this.pictureBox1, this.textBox1, this.panel3, this.shape1, this.barcode1, this.pictureBox2}); this.panel5.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.0099999997764825821D), Telerik.Reporting.Drawing.Unit.Inch(0D)); this.panel5.Name = "panel5"; this.panel5.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Cm(20.549999237060547D), Telerik.Reporting.Drawing.Unit.Cm(7.6708011627197266D)); // // Text1 // this.Text1.CanGrow = false; this.Text1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Cm(5.3899998664855957D), Telerik.Reporting.Drawing.Unit.Cm(0.74000000953674316D)); this.Text1.Name = "Text1"; this.Text1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Cm(7.070000171661377D), Telerik.Reporting.Drawing.Unit.Cm(1.3899999856948853D)); this.Text1.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D); this.Text1.Value = "275 Grove St., Suite 2-400, Newton, MA 02466\r\nPhone: +1.888.365.2779\r\nFax: +1.617" + ".249.2116"; // // barcode2 // this.barcode2.Encoder = code128Encoder1; this.barcode2.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Cm(15.100000381469727D), Telerik.Reporting.Drawing.Unit.Cm(0D)); this.barcode2.Name = "barcode2"; this.barcode2.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Cm(5.4499998092651367D), Telerik.Reporting.Drawing.Unit.Cm(2.1800000667572021D)); this.barcode2.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right; this.barcode2.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Bottom; this.barcode2.Value = "=Fields.PurchaseOrderNumber"; // // pictureBox1 // this.pictureBox1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0D)); this.pictureBox1.MimeType = "image/jpeg"; this.pictureBox1.Name = "pictureBox1"; this.pictureBox1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.8899999856948853D), Telerik.Reporting.Drawing.Unit.Inch(0.86000001430511475D)); this.pictureBox1.Value = ((object)(resources.GetObject("pictureBox1.Value"))); // // textBox1 // this.textBox1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.119999885559082D), Telerik.Reporting.Drawing.Unit.Inch(0D)); this.textBox1.Name = "textBox1"; this.textBox1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.9099999666213989D), Telerik.Reporting.Drawing.Unit.Inch(0.28999999165534973D)); this.textBox1.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(195)))), ((int)(((byte)(47)))), ((int)(((byte)(11))))); this.textBox1.Value = "AdventureWorks"; // // panel3 // this.panel3.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.Id1, this.Text8, this.Field6, this.shape3}); this.panel3.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0.93999999761581421D)); this.panel3.Name = "panel3"; this.panel3.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.09000015258789D), Telerik.Reporting.Drawing.Unit.Inch(0.5D)); // // Id1 // this.Id1.CanGrow = false; this.Id1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Cm(0D), Telerik.Reporting.Drawing.Unit.Cm(0D)); this.Id1.Name = "Id1"; this.Id1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Cm(10.239999771118164D), Telerik.Reporting.Drawing.Unit.Inch(0.44999998807907104D)); this.Id1.Style.BackgroundColor = System.Drawing.Color.Empty; this.Id1.Style.BorderColor.Default = System.Drawing.Color.Black; this.Id1.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.None; this.Id1.StyleName = "Header"; this.Id1.Value = "Sales Order: {Fields.SalesOrderID}"; // // Text8 // this.Text8.CanGrow = false; this.Text8.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Cm(13.569999694824219D), Telerik.Reporting.Drawing.Unit.Cm(0D)); this.Text8.Name = "Text8"; this.Text8.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Cm(1.5199999809265137D), Telerik.Reporting.Drawing.Unit.Inch(0.44999998807907104D)); this.Text8.Style.BackgroundColor = System.Drawing.Color.Empty; this.Text8.Style.Visible = true; this.Text8.StyleName = "Header"; this.Text8.Value = "Date:"; // // Field6 // this.Field6.CanGrow = false; this.Field6.Format = "{0:d}"; this.Field6.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Cm(15.130000114440918D), Telerik.Reporting.Drawing.Unit.Cm(0D)); this.Field6.Name = "Field6"; this.Field6.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Cm(5.4099998474121094D), Telerik.Reporting.Drawing.Unit.Inch(0.44999998807907104D)); this.Field6.Style.BackgroundColor = System.Drawing.Color.Empty; this.Field6.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right; this.Field6.StyleName = "Header"; this.Field6.Value = "= Fields.OrderDate"; // // shape3 // this.shape3.Anchoring = ((Telerik.Reporting.AnchoringStyles)((Telerik.Reporting.AnchoringStyles.Left | Telerik.Reporting.AnchoringStyles.Right))); this.shape3.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0.47999998927116394D)); this.shape3.Name = "shape3"; this.shape3.ShapeType = new Telerik.Reporting.Drawing.Shapes.LineShape(Telerik.Reporting.Drawing.Shapes.LineDirection.EW); this.shape3.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.09000015258789D), Telerik.Reporting.Drawing.Unit.Point(2D)); this.shape3.Stretch = true; this.shape3.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid; this.shape3.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid; this.shape3.Style.BorderWidth.Bottom = Telerik.Reporting.Drawing.Unit.Point(0.5D); this.shape3.Style.BorderWidth.Top = Telerik.Reporting.Drawing.Unit.Point(1.5D); this.shape3.Style.Color = System.Drawing.Color.Transparent; // // OrderNumbers // this.OrderNumbers.ConnectionString = "Telerik.Reporting.Examples.CSharp.Properties.Settings.TelerikConnectionString"; this.OrderNumbers.Name = "OrderNumbers"; this.OrderNumbers.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] { new Telerik.Reporting.SqlDataSourceParameter("@ForYear", System.Data.DbType.String, "=Parameters.ForYear.Value"), new Telerik.Reporting.SqlDataSourceParameter("@ForMonth", System.Data.DbType.String, "=Parameters.ForMonth.Value")}); this.OrderNumbers.SelectCommand = resources.GetString("OrderNumbers.SelectCommand"); // // Invoices // this.Invoices.ConnectionString = "Telerik.Reporting.Examples.CSharp.Properties.Settings.TelerikConnectionString"; this.Invoices.Name = "Invoices"; this.Invoices.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] { new Telerik.Reporting.SqlDataSourceParameter("@SalesOrderNumber", System.Data.DbType.String, "=Parameters.OrderNumber.Value")}); this.Invoices.SelectCommand = resources.GetString("Invoices.SelectCommand"); // // detail // this.detail.Height = Telerik.Reporting.Drawing.Unit.Inch(3.2200000286102295D); this.detail.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.panel4, this.subReport1}); this.detail.KeepTogether = false; this.detail.Name = "detail"; // // panel4 // this.panel4.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.textBox14, this.textBox10, this.textBox9, this.textBox8, this.textBox6, this.textBox4, this.textBox12, this.textBox13, this.textBox11, this.textBox16, this.textBox17, this.textBox18, this.textBox19, this.textBox21, this.panel1, this.panel2, this.textBox2, this.textBox3}); this.panel4.KeepTogether = false; this.panel4.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0D)); this.panel4.Name = "panel4"; this.panel4.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.1000003814697266D), Telerik.Reporting.Drawing.Unit.Inch(2.7200000286102295D)); // // textBox14 // this.textBox14.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.9000000953674316D), Telerik.Reporting.Drawing.Unit.Inch(0.5899999737739563D)); this.textBox14.Name = "textBox14"; this.textBox14.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.7899999618530273D), Telerik.Reporting.Drawing.Unit.Inch(0.20000000298023224D)); this.textBox14.Value = "=Fields.Store"; // // textBox10 // this.textBox10.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.0099999997764825821D), Telerik.Reporting.Drawing.Unit.Inch(1.5700000524520874D)); this.textBox10.Name = "textBox10"; this.textBox10.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.2799999713897705D), Telerik.Reporting.Drawing.Unit.Inch(0.28999999165534973D)); this.textBox10.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(13D); this.textBox10.Value = "=Fields.CustPhone"; // // textBox9 // this.textBox9.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0.81000000238418579D)); this.textBox9.Name = "textBox9"; this.textBox9.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.8999999761581421D), Telerik.Reporting.Drawing.Unit.Inch(0.25999999046325684D)); this.textBox9.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(13D); this.textBox9.Value = "=Fields.CustFirstName + \" \" + Fields.CustLastName"; // // textBox8 // this.textBox8.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.0099999997764825821D), Telerik.Reporting.Drawing.Unit.Inch(0.61000001430511475D)); this.textBox8.Name = "textBox8"; this.textBox8.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.72000002861022949D), Telerik.Reporting.Drawing.Unit.Inch(0.20000000298023224D)); this.textBox8.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D); this.textBox8.Value = "CONTACT:"; // // textBox6 // this.textBox6.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.9000000953674316D), Telerik.Reporting.Drawing.Unit.Inch(1.5700000524520874D)); this.textBox6.Name = "textBox6"; this.textBox6.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.7899999618530273D), Telerik.Reporting.Drawing.Unit.Inch(0.20000000298023224D)); this.textBox6.Value = "=Fields.BillCountryRegion"; // // textBox4 // this.textBox4.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.9000000953674316D), Telerik.Reporting.Drawing.Unit.Inch(1.3700000047683716D)); this.textBox4.Name = "textBox4"; this.textBox4.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.7899999618530273D), Telerik.Reporting.Drawing.Unit.Inch(0.20000000298023224D)); this.textBox4.Value = "=Fields.BillPostalCode + \" \" + Fields.BillCity"; // // textBox12 // this.textBox12.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.9000000953674316D), Telerik.Reporting.Drawing.Unit.Inch(1.1699999570846558D)); this.textBox12.Name = "textBox12"; this.textBox12.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.8799999952316284D), Telerik.Reporting.Drawing.Unit.Inch(0.20000000298023224D)); this.textBox12.Value = "=IsNull(Fields.BillAddress2, \'No secondary Address\')"; // // textBox13 // this.textBox13.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.9000000953674316D), Telerik.Reporting.Drawing.Unit.Inch(0.97000002861022949D)); this.textBox13.Name = "textBox13"; this.textBox13.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.7899999618530273D), Telerik.Reporting.Drawing.Unit.Inch(0.20000000298023224D)); this.textBox13.Value = "=Fields.BillAddress1"; // // textBox11 // this.textBox11.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(1.3700000047683716D)); this.textBox11.Name = "textBox11"; this.textBox11.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.72000002861022949D), Telerik.Reporting.Drawing.Unit.Inch(0.20000000298023224D)); this.textBox11.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D); this.textBox11.Value = "PHONE:"; // // textBox16 // this.textBox16.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(5.9499998092651367D), Telerik.Reporting.Drawing.Unit.Inch(0.57999998331069946D)); this.textBox16.Name = "textBox16"; this.textBox16.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.1500000953674316D), Telerik.Reporting.Drawing.Unit.Inch(0.20000000298023224D)); this.textBox16.Value = "=Fields.Store"; // // textBox17 // this.textBox17.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(5.9499998092651367D), Telerik.Reporting.Drawing.Unit.Inch(0.97000002861022949D)); this.textBox17.Name = "textBox17"; this.textBox17.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.1500000953674316D), Telerik.Reporting.Drawing.Unit.Inch(0.20000000298023224D)); this.textBox17.Value = "=Fields.ShipAddress1"; // // textBox18 // this.textBox18.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(5.9499998092651367D), Telerik.Reporting.Drawing.Unit.Inch(1.1699999570846558D)); this.textBox18.Name = "textBox18"; this.textBox18.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.1500000953674316D), Telerik.Reporting.Drawing.Unit.Inch(0.20000000298023224D)); this.textBox18.Value = "=IsNull(Fields.ShipAddress2, \'No secondary Address\')"; // // textBox19 // this.textBox19.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(5.9499998092651367D), Telerik.Reporting.Drawing.Unit.Inch(1.3700000047683716D)); this.textBox19.Name = "textBox19"; this.textBox19.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.1500000953674316D), Telerik.Reporting.Drawing.Unit.Inch(0.20000000298023224D)); this.textBox19.Value = "=Fields.ShipPostalCode + \" \" + Fields.ShipCity + \", \" + Fields.ShipStateProvince " + ""; // // textBox21 // this.textBox21.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(5.9499998092651367D), Telerik.Reporting.Drawing.Unit.Inch(1.5700000524520874D)); this.textBox21.Name = "textBox21"; this.textBox21.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.1500000953674316D), Telerik.Reporting.Drawing.Unit.Inch(0.20000000298023224D)); this.textBox21.Value = "=Fields.ShipCountryRegion"; // // panel1 // this.panel1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.textBox24, this.textBox23, this.textBox25, this.textBox26, this.textBox27, this.textBox30, this.textBox29, this.textBox28, this.textBox32, this.textBox31}); this.panel1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(2.0299999713897705D)); this.panel1.Name = "panel1"; this.panel1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.1000003814697266D), Telerik.Reporting.Drawing.Unit.Inch(0.550000011920929D)); // // textBox24 // this.textBox24.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0D)); this.textBox24.Name = "textBox24"; this.textBox24.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.1399999856948853D), Telerik.Reporting.Drawing.Unit.Inch(0.34000000357627869D)); this.textBox24.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid; this.textBox24.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid; this.textBox24.Style.BorderWidth.Default = Telerik.Reporting.Drawing.Unit.Point(0.5D); this.textBox24.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D); this.textBox24.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; this.textBox24.Value = "DATE:"; // // textBox23 // this.textBox23.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(1.1399999856948853D), Telerik.Reporting.Drawing.Unit.Inch(0D)); this.textBox23.Name = "textBox23"; this.textBox23.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.7599999904632568D), Telerik.Reporting.Drawing.Unit.Inch(0.34000000357627869D)); this.textBox23.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid; this.textBox23.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid; this.textBox23.Style.BorderWidth.Default = Telerik.Reporting.Drawing.Unit.Point(0.5D); this.textBox23.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D); this.textBox23.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; this.textBox23.Value = "ORDER DATE:"; // // textBox25 // this.textBox25.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.9000000953674316D), Telerik.Reporting.Drawing.Unit.Inch(0D)); this.textBox25.Name = "textBox25"; this.textBox25.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.6799999475479126D), Telerik.Reporting.Drawing.Unit.Inch(0.34000000357627869D)); this.textBox25.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid; this.textBox25.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid; this.textBox25.Style.BorderWidth.Default = Telerik.Reporting.Drawing.Unit.Point(0.5D); this.textBox25.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D); this.textBox25.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; this.textBox25.Value = "SALES PERSON:"; // // textBox26 // this.textBox26.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(4.5799999237060547D), Telerik.Reporting.Drawing.Unit.Inch(0D)); this.textBox26.Name = "textBox26"; this.textBox26.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.3799999952316284D), Telerik.Reporting.Drawing.Unit.Inch(0.34000000357627869D)); this.textBox26.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid; this.textBox26.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid; this.textBox26.Style.BorderWidth.Default = Telerik.Reporting.Drawing.Unit.Point(0.5D); this.textBox26.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D); this.textBox26.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; this.textBox26.Value = "PURCHASE ORDER:"; // // textBox27 // this.textBox27.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(5.9499998092651367D), Telerik.Reporting.Drawing.Unit.Inch(0D)); this.textBox27.Name = "textBox27"; this.textBox27.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.1500000953674316D), Telerik.Reporting.Drawing.Unit.Inch(0.34000000357627869D)); this.textBox27.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid; this.textBox27.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid; this.textBox27.Style.BorderWidth.Default = Telerik.Reporting.Drawing.Unit.Point(0.5D); this.textBox27.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D); this.textBox27.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right; this.textBox27.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; this.textBox27.Value = "SHIPMENT METHOD"; // // textBox30 // this.textBox30.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.9000000953674316D), Telerik.Reporting.Drawing.Unit.Inch(0.34000000357627869D)); this.textBox30.Name = "textBox30"; this.textBox30.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.6799999475479126D), Telerik.Reporting.Drawing.Unit.Inch(0.20000000298023224D)); this.textBox30.Value = "=Fields.SalesFirstName + \" \" + Fields.SalesLastName"; // // textBox29 // this.textBox29.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(4.5799999237060547D), Telerik.Reporting.Drawing.Unit.Inch(0.34000000357627869D)); this.textBox29.Name = "textBox29"; this.textBox29.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.3799999952316284D), Telerik.Reporting.Drawing.Unit.Inch(0.20000000298023224D)); this.textBox29.Value = "=Fields.PurchaseOrderNumber"; // // textBox28 // this.textBox28.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(5.9499998092651367D), Telerik.Reporting.Drawing.Unit.Inch(0.34000000357627869D)); this.textBox28.Name = "textBox28"; this.textBox28.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.1500000953674316D), Telerik.Reporting.Drawing.Unit.Inch(0.20000000298023224D)); this.textBox28.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right; this.textBox28.Value = "=Fields.ShipMethod"; // // textBox32 // this.textBox32.Format = "{0:d}"; this.textBox32.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(1.1399999856948853D), Telerik.Reporting.Drawing.Unit.Inch(0.34000000357627869D)); this.textBox32.Name = "textBox32"; this.textBox32.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.7599999904632568D), Telerik.Reporting.Drawing.Unit.Inch(0.20000000298023224D)); this.textBox32.Value = "=Fields.OrderDate"; // // textBox31 // this.textBox31.Format = "{0:d}"; this.textBox31.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0.34000000357627869D)); this.textBox31.Name = "textBox31"; this.textBox31.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.1399999856948853D), Telerik.Reporting.Drawing.Unit.Inch(0.20000000298023224D)); this.textBox31.Value = "=Now()"; // // panel2 // this.panel2.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.textBox7}); this.panel2.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0D)); this.panel2.Name = "panel2"; this.panel2.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.1000003814697266D), Telerik.Reporting.Drawing.Unit.Inch(0.44999998807907104D)); this.panel2.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid; this.panel2.Style.BorderWidth.Default = Telerik.Reporting.Drawing.Unit.Point(0.5D); // // textBox7 // this.textBox7.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0D)); this.textBox7.Name = "textBox7"; this.textBox7.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.9000000953674316D), Telerik.Reporting.Drawing.Unit.Inch(0.44999998807907104D)); this.textBox7.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; this.textBox7.StyleName = "Header"; this.textBox7.Value = "Customer Details"; // // textBox2 // this.textBox2.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.130000114440918D), Telerik.Reporting.Drawing.Unit.Inch(0.61000001430511475D)); this.textBox2.Name = "textBox2"; this.textBox2.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.6600000262260437D), Telerik.Reporting.Drawing.Unit.Inch(0.20000000298023224D)); this.textBox2.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D); this.textBox2.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right; this.textBox2.Value = "ADDRESS:"; // // textBox3 // this.textBox3.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(5.3499999046325684D), Telerik.Reporting.Drawing.Unit.Inch(0.57999998331069946D)); this.textBox3.Name = "textBox3"; this.textBox3.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.56999999284744263D), Telerik.Reporting.Drawing.Unit.Inch(0.20000000298023224D)); this.textBox3.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D); this.textBox3.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right; this.textBox3.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Top; this.textBox3.Value = "SHIP TO:"; // // subReport1 // this.subReport1.KeepTogether = false; this.subReport1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.0099999997764825821D), Telerik.Reporting.Drawing.Unit.Inch(2.869999885559082D)); this.subReport1.Name = "subReport1"; uriReportSource1.Parameters.Add(new Telerik.Reporting.Parameter("SaledOrderID", "=Fields.SalesOrderID")); uriReportSource1.Uri = "Sales Order Details.trdx"; this.subReport1.ReportSource = uriReportSource1; this.subReport1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.09000015258789D), Telerik.Reporting.Drawing.Unit.Inch(0.2800000011920929D)); // // pageFooterSection1 // this.pageFooterSection1.Height = Telerik.Reporting.Drawing.Unit.Inch(0.23000000417232513D); this.pageFooterSection1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.textBox5, this.textBox22}); this.pageFooterSection1.Name = "pageFooterSection1"; this.pageFooterSection1.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid; // // textBox5 // this.textBox5.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0D)); this.textBox5.Name = "textBox5"; this.textBox5.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.9000000953674316D), Telerik.Reporting.Drawing.Unit.Inch(0.23000000417232513D)); this.textBox5.Value = "=PageExec(\"lineTotalDataTextBox\",Count(Fields.ProductNumber)) + \" products, \" + P" + "ageExec(\"lineTotalDataTextBox\",Sum(Fields.OrderQty)) + \" items on page \" + Page" + "Number"; // // textBox22 // this.textBox22.Format = "{0:C2}"; this.textBox22.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(5.96999979019165D), Telerik.Reporting.Drawing.Unit.Inch(0D)); this.textBox22.Name = "textBox22"; this.textBox22.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.130000114440918D), Telerik.Reporting.Drawing.Unit.Inch(0.23000000417232513D)); this.textBox22.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right; this.textBox22.Value = "=PageExec(\"lineTotalDataTextBox\",sum(LineTotal))"; // // shape1 // this.shape1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(5.4899997711181641D), Telerik.Reporting.Drawing.Unit.Inch(0.40000000596046448D)); this.shape1.Name = "shape1"; this.shape1.ShapeType = new Telerik.Reporting.Drawing.Shapes.PolygonShape(4, 45D, 0); this.shape1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1D), Telerik.Reporting.Drawing.Unit.Inch(1.0000001192092896D)); // // barcode1 // this.barcode1.Encoder = code25StandardEncoder1; this.barcode1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(5.3899998664855957D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D)); this.barcode1.Name = "barcode1"; this.barcode1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2D), Telerik.Reporting.Drawing.Unit.Inch(1.2000001668930054D)); // // pictureBox2 // this.pictureBox2.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.6900002956390381D), Telerik.Reporting.Drawing.Unit.Inch(0.099999986588954926D)); this.pictureBox2.Name = "pictureBox2"; this.pictureBox2.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(3.7000000476837158D), Telerik.Reporting.Drawing.Unit.Inch(2.9200005531311035D)); // // Report1 // this.DataSource = this.Invoices; this.Filters.Add(new Telerik.Reporting.Filter("=Fields.SalesOrderNumber", Telerik.Reporting.FilterOperator.Equal, "=Parameters.OrderNumber.Value")); group1.GroupFooter = this.groupFooterSection1; group1.GroupHeader = this.groupHeaderSection1; group1.Name = "group1"; this.Groups.AddRange(new Telerik.Reporting.Group[] { group1}); this.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.groupHeaderSection1, this.groupFooterSection1, this.detail, this.pageFooterSection1}); this.Name = "Invoice"; this.PageSettings.ColumnCount = 1; this.PageSettings.ColumnSpacing = Telerik.Reporting.Drawing.Unit.Inch(0D); this.PageSettings.Landscape = false; this.PageSettings.Margins = new Telerik.Reporting.Drawing.MarginsU(Telerik.Reporting.Drawing.Unit.Inch(0.20000000298023224D), Telerik.Reporting.Drawing.Unit.Inch(0.20000000298023224D), Telerik.Reporting.Drawing.Unit.Inch(0.30000001192092896D), Telerik.Reporting.Drawing.Unit.Inch(0.40000000596046448D)); this.PageSettings.PaperKind = System.Drawing.Printing.PaperKind.Letter; textWatermark1.Color = System.Drawing.Color.Black; textWatermark1.Font.Bold = false; textWatermark1.Font.Italic = false; textWatermark1.Font.Name = "Tahoma"; textWatermark1.Font.Size = Telerik.Reporting.Drawing.Unit.Point(150D); textWatermark1.Font.Strikeout = false; textWatermark1.Font.Underline = false; textWatermark1.Opacity = 0.02D; textWatermark1.Orientation = Telerik.Reporting.Drawing.WatermarkOrientation.Diagonal; textWatermark1.Position = Telerik.Reporting.Drawing.WatermarkPosition.Front; textWatermark1.PrintOnFirstPage = true; textWatermark1.PrintOnLastPage = true; textWatermark1.Text = "Original"; this.PageSettings.Watermarks.Add(textWatermark1); reportParameter1.AutoRefresh = true; reportParameter1.AvailableValues.DataSource = this.OrderNumbers; reportParameter1.AvailableValues.DisplayMember = "SalesOrderNumber"; reportParameter1.AvailableValues.Sortings.Add(new Telerik.Reporting.Sorting("=Fields.SalesOrderNumber", Telerik.Reporting.SortDirection.Asc)); reportParameter1.AvailableValues.ValueMember = "SalesOrderNumber"; reportParameter1.Name = "OrderNumber"; reportParameter1.Text = "Order #"; reportParameter1.Value = "=First(Fields.SalesOrderNumber)"; reportParameter1.Visible = true; reportParameter2.Name = "ForYear"; reportParameter2.Type = Telerik.Reporting.ReportParameterType.Integer; reportParameter2.Value = "=2003"; reportParameter3.Name = "ForMonth"; reportParameter3.Type = Telerik.Reporting.ReportParameterType.Integer; reportParameter3.Value = "=7"; this.ReportParameters.Add(reportParameter1); this.ReportParameters.Add(reportParameter2); this.ReportParameters.Add(reportParameter3); this.Style.BackgroundColor = System.Drawing.Color.White; styleRule1.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] { new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.TextItemBase)), new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.HtmlTextBox))}); styleRule1.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Point(2D); styleRule1.Style.Padding.Right = Telerik.Reporting.Drawing.Unit.Point(2D); styleRule2.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] { new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.TextItemBase)), new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.HtmlTextBox))}); styleRule2.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Point(2D); styleRule2.Style.Padding.Right = Telerik.Reporting.Drawing.Unit.Point(2D); styleRule3.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] { new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.TextBox))}); styleRule3.Style.Font.Name = "Segoe UI"; styleRule3.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(10D); styleRule4.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] { new Telerik.Reporting.Drawing.StyleSelector("Header")}); styleRule4.Style.Font.Bold = true; styleRule4.Style.Font.Name = "Segoe UI Light"; styleRule4.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(16D); styleRule4.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Inch(0D); this.StyleSheet.AddRange(new Telerik.Reporting.Drawing.StyleRule[] { styleRule1, styleRule2, styleRule3, styleRule4}); this.Width = Telerik.Reporting.Drawing.Unit.Inch(8.10055160522461D); ((System.ComponentModel.ISupportInitialize)(this)).EndInit(); }
protected void Page_Load(object sender, EventArgs e) { if ((!Page.IsPostBack)) { List <paramClass> listParam = new List <paramClass>(); try { ReportViewer1.Visible = true; string CKy = HTNSession.CKy.ToString(); string UsrKy = HTNSession.UsrKy.ToString(); string CNm = HTNSession.CNm.ToString(); string UsrNm = HTNSession.UsrId.ToString(); string SelectedReportObjKy = Session["SelectedReportObjKy"].ToString(); string SelectedReportObjKyX = "SESSIONXREPORT"; string ServerName = ConfigurationManager.AppSettings["ReportServerName"].ToString(); string EnvironmentName = HTNSession.Environment; string NeededReportParams = Session["NeededReportParams"].ToString(); string NeededReportParamsFromObjMas = Session["NeededReportParamsFromObjMas"].ToString(); ApiOperation apiOpr = new ApiOperation(); List <ObjMasModel> selectedReportProp = apiOpr.ObjMas_SelectWeb(EnvironmentName, Convert.ToInt32(UsrKy), Convert.ToInt32(CKy), SelectedReportObjKy); string ReportServerUrl = WebConfigurationManager.AppSettings["ReportpathforServer"]; string _userName = ConfigurationManager.AppSettings["ReportServerUserName"]; string _pasword = ConfigurationManager.AppSettings["ReportServerPwd"]; List <ReportParameter> paramList = new List <ReportParameter>(); List <Object> paramObject = new List <Object>(); JavaScriptSerializer js = new JavaScriptSerializer(); dynamic dynNeededReportParams = js.Deserialize <dynamic>(NeededReportParams); var varNeededObjVal = dynNeededReportParams as IDictionary <String, object>; dynamic dynNeededReportParamsFromObjMas = js.Deserialize <dynamic>(NeededReportParamsFromObjMas); var uriReportSource = new Telerik.Reporting.UriReportSource(); string URL = AppDomain.CurrentDomain.BaseDirectory + @"\Reports\TelerikReport\" + selectedReportProp[0].ReportPath; foreach (dynamic dynobj in dynNeededReportParamsFromObjMas) { paramClass param = new paramClass(); var varObj = dynobj as IDictionary <String, object>; string ObjNm = varObj["ObjNm"].ToString(); if (string.Equals(ObjNm, "CKy", StringComparison.CurrentCultureIgnoreCase)) { uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter(ObjNm, Convert.ToInt32(CKy))); } else if (string.Equals(ObjNm, "UsrKy", StringComparison.CurrentCultureIgnoreCase)) { uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter(ObjNm, Convert.ToInt32(UsrKy))); } else if (ObjNm == "ObjKy") { uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter(ObjNm, SelectedReportObjKy)); } else if (string.Equals(ObjNm, "CNm", StringComparison.CurrentCultureIgnoreCase)) { uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter(ObjNm, CNm)); } else if (string.Equals(ObjNm, "UsrID", StringComparison.CurrentCultureIgnoreCase)) { uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter(ObjNm, CNm)); } else if (string.Equals(ObjNm, "RtpTitle", StringComparison.CurrentCultureIgnoreCase)) { uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter(ObjNm, selectedReportProp[0].ObjCaptn)); } else if (string.Equals(ObjNm, "RptTitle", StringComparison.CurrentCultureIgnoreCase)) { uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter(ObjNm, selectedReportProp[0].ObjCaptn)); } else if (ObjNm == "ServerName") { uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter(ObjNm, ServerName)); } else if (ObjNm == "EnvironmentName") { uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter(ObjNm, EnvironmentName)); } else { if (varNeededObjVal.ContainsKey(ObjNm)) { //********** Default Setting If NULL : VgSan #region Default Setting If NULL if (ObjNm.EndsWith("Ky") || ObjNm.EndsWith("ky")) { if (varNeededObjVal[ObjNm].ToString() == "") { varNeededObjVal[ObjNm] = 1; } } else if ( ObjNm.EndsWith("Cd") || ObjNm.EndsWith("cd") || ObjNm.EndsWith("CD") || ObjNm.EndsWith("cD") || ObjNm.EndsWith("ID") || ObjNm.EndsWith("Id") || ObjNm.EndsWith("id") || ObjNm.EndsWith("iD") || ObjNm.EndsWith("Nm") || ObjNm.EndsWith("nm") || ObjNm.EndsWith("NM") || ObjNm.EndsWith("nM")) { if (varNeededObjVal[ObjNm].ToString() == "") { varNeededObjVal[ObjNm] = " "; } } else if ( ObjNm.StartsWith("datPic")) { if (varNeededObjVal[ObjNm].ToString() == "") { varNeededObjVal[ObjNm] = null; } } else if ( ObjNm.StartsWith("numricBox")) { if (varNeededObjVal[ObjNm].ToString() == "") { varNeededObjVal[ObjNm] = null; } } #endregion Default Setting If NULL if (varNeededObjVal.ContainsKey(ObjNm)) { string paramObjNm = ObjNm; if (ObjNm.StartsWith("datPic")) { paramObjNm = ObjNm.Replace("datPic", ""); string joinstring = "/"; if (varNeededObjVal[ObjNm] != null) { string[] tempsplit = varNeededObjVal[ObjNm].ToString().Split('/'); varNeededObjVal[ObjNm] = tempsplit[2] + joinstring + tempsplit[1] + joinstring + tempsplit[0]; } } if (ObjNm.StartsWith("cmb")) { paramObjNm = ObjNm.Replace("cmb", ""); } if (ObjNm.StartsWith("cmFrmCdMas_")) { paramObjNm = ObjNm.Replace("cmFrmCdMas_", ""); } if (ObjNm.StartsWith("chckBox")) { paramObjNm = ObjNm.Replace("chckBox", ""); } if (ObjNm.StartsWith("numricBox")) { paramObjNm = ObjNm.Replace("numricBox", ""); } if (ObjNm.StartsWith("textBox")) { paramObjNm = ObjNm.Replace("textBox", ""); } if (varNeededObjVal[ObjNm] != null) { uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter(paramObjNm, varNeededObjVal[ObjNm].ToString())); } param.Paramname = paramObjNm; } } else { string paramObjNm = ObjNm; if (ObjNm.StartsWith("cmb")) { paramObjNm = ObjNm.Replace("cmb", ""); } if (ObjNm.StartsWith("cmFrmCdMas_")) { paramObjNm = ObjNm.Replace("cmFrmCdMas_", ""); } if (ObjNm.StartsWith("chckBox")) { paramObjNm = ObjNm.Replace("chckBox", ""); } if (ObjNm.StartsWith("datPic")) { paramObjNm = ObjNm.Replace("datPic", ""); } if (ObjNm.StartsWith("numricBox")) { paramObjNm = ObjNm.Replace("numricBox", ""); } if (ObjNm.StartsWith("textBox")) { paramObjNm = ObjNm.Replace("textBox", ""); } //********** Default Setting If NULL : VgSan #region Default Setting If NULL if (ObjNm.EndsWith("Ky") || ObjNm.EndsWith("ky")) { param.ParamValue = "1"; paramList.Add(new ReportParameter(paramObjNm, "1")); } else if ( ObjNm.EndsWith("Cd") || ObjNm.EndsWith("cd") || ObjNm.EndsWith("CD") || ObjNm.EndsWith("cD") || ObjNm.EndsWith("ID") || ObjNm.EndsWith("Id") || ObjNm.EndsWith("id") || ObjNm.EndsWith("iD") || ObjNm.EndsWith("Nm") || ObjNm.EndsWith("nm") || ObjNm.EndsWith("NM") || ObjNm.EndsWith("nM")) { uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter(paramObjNm, " ")); } else if ( ObjNm.StartsWith("datPic")) { uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter(paramObjNm, string.Empty)); } else if ( ObjNm.StartsWith("numricBox")) { uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter(paramObjNm, null)); } #endregion Default Setting If NULL param.Paramname = paramObjNm; } } listParam.Add(param); } List <paramClass> listParamTemp = new List <paramClass>(); listParamTemp = listParam; uriReportSource.Uri = URL; ReportViewer1.ReportSource = uriReportSource; ReportViewer1.ParametersAreaVisible = false; ReportViewer1.ShowHistoryButtons = false; ReportViewer1.ShowParametersButton = false; ReportViewer1.RefreshReport(); } catch (Exception ex) { string errMsg = ex.Message.ToString(); throw new Exception(ex.Message.ToString()); } } }