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