public HawbXR(int OPHid, bool Antetli) { InitializeComponent(); ReportDataSetTableAdapters.SMTPTableAdapter smtpTableAdapter = new ReportDataSetTableAdapters.SMTPTableAdapter(); ReportDataSet.SMTPDataTable SMTPTable = (ReportDataSet.SMTPDataTable)smtpTableAdapter.GetData(); ReportDataSet.SMTPRow SMTP = (ReportDataSet.SMTPRow)SMTPTable.Rows[0]; rprHAWBTableAdapter.Fill(reportDataSet.RPR_HAWB, OPHid); eMails = reportDataSet.RPR_HAWB.Rows[0]["EMAILS"].ToString(); eMailSubject = reportDataSet.RPR_HAWB.Rows[0]["EMAILSUBJECT"].ToString(); eMailBody = reportDataSet.RPR_HAWB.Rows[0]["EMAILBODY"].ToString(); this.ExportOptions.Email.Body = eMailBody; this.ExportOptions.Email.Subject = eMailSubject; this.ExportOptions.Email.RecipientAddress = eMails; antetli.Value = Antetli; ISO.Value = "TM-7.5-11"; if (Antetli) { ISO.Value = "TM-7.5-16"; } if (SMTP.FIRMA == "TUNASET") { xrPictureBox2.Visible = false; xrPictureBox3.Visible = false; xrLabel51.Text = "Istanbul Ticaret Sarayı, Oruç Reis Mah. Vadi Cad. No:108 Kat:1 No:68 Giyimkent-Esenler/Istanbul/Türkiye Tel: +90(212)438 6300 Fax: +90(212)438 2617 eMail: [email protected] Web: biotunaset.com"; } }
public Fatura32XR(int AFBid, string Antet, string Usr) { InitializeComponent(); // Force the report creation without requesting the parameter value from end-users. this.RequestParameters = false; ReportDataSetTableAdapters.SMTPTableAdapter smtpTableAdapter = new ReportDataSetTableAdapters.SMTPTableAdapter(); ReportDataSet.SMTPDataTable SMTPTable = (ReportDataSet.SMTPDataTable)smtpTableAdapter.GetData(); ReportDataSet.SMTPRow SMTP = (ReportDataSet.SMTPRow)SMTPTable.Rows[0]; rprIMGSTableAdapter.Fill(reportDataSet.RPR_IMGS); rprFaturaTableAdapter.Fill(reportDataSet.RPR_FATURA, AFBid, Usr); rprFaturaDtyTableAdapter.Fill(reportDataSet.RPR_FATURA_DTY, AFBid, "3"); rprFaturaDtyCumTableAdapter.Fill(reportDataSet.RPR_FATURA_DTY_CUM, AFBid); int nor = rprFaturaHouseTableAdapter.Fill(reportDataSet.RPR_FATURA_HOUSE, AFBid); if (nor > 0) { DetailReportMaster.Visible = false; } else { rprFaturaMasterTableAdapter.Fill(reportDataSet.RPR_FATURA_MASTER, AFBid); DetailReportHouse.Visible = false; } if (!reportDataSet.RPR_FATURA[0].IsOPIDNull()) { opInfoTableAdapter.Fill(reportDataSet.OP_INFO, reportDataSet.RPR_FATURA[0].OPID, reportDataSet.RPR_FATURA[0].OPHM); } string drm = reportDataSet.RPR_FATURA[0].DRM; string eFtr = reportDataSet.RPR_FATURA[0].EFTR; antetli.Value = false; if (Antet == "Antetli") { antetli.Value = true; } eMails = reportDataSet.RPR_FATURA.Rows[0]["EMAILS"].ToString(); eMailSubject = reportDataSet.RPR_FATURA.Rows[0]["EMAILSUBJECT"].ToString(); eMailBody = reportDataSet.RPR_FATURA.Rows[0]["EMAILBODY"].ToString(); if (Antet != "Antetli" && SMTP.FIRMA == "TUNASET") { TopMargin.HeightF = 50F; // 150F; PageFooter.Visible = false; Detail.HeightF = 1000F; // 1200F; //xrLabelAdr.SizeF = new System.Drawing.SizeF(800F, 300F); xrLabelTrh.LocationF = new PointF(1589.93F, 710F); //915 xrLabelRef.LocationF = new PointF(1351.81F, 775F); //975 } }
private void TopluAlertXF_Load(object sender, EventArgs e) { if (HM == "M") { refTO = "OPM"; } else if (HM == "H") { refTO = "OPH"; } checkSimpleButton.PerformClick(); ReportDataSetTableAdapters.SMTPTableAdapter smtpTableAdapter = new ReportDataSetTableAdapters.SMTPTableAdapter(); ReportDataSet.SMTPDataTable SMTPTable = (ReportDataSet.SMTPDataTable)smtpTableAdapter.GetData(); SMTP = (ReportDataSet.SMTPRow)SMTPTable.Rows[0]; }
private void TopluFaturaXF_Load(object sender, EventArgs e) { if (!string.IsNullOrEmpty(afbIDs)) { this.rprTopluFaturaTableAdapter.Fill(this.reportDataSet.RPR_TOPLUFATURA, afbIDs); } this.rptGetTableAdapter.Fill(this.reportDataSet.RPT_GET, 4); rptRow = this.reportDataSet.RPT_GET[0]; eMailSubjectTextEdit.Text = rptRow.EMAILSUBJECT; eMailBodyRichEditControl.Document.HtmlText = rptRow.EMAILBODY; ReportDataSetTableAdapters.SMTPTableAdapter smtpTableAdapter = new ReportDataSetTableAdapters.SMTPTableAdapter(); ReportDataSet.SMTPDataTable SMTPTable = (ReportDataSet.SMTPDataTable)smtpTableAdapter.GetData(); SMTP = (ReportDataSet.SMTPRow)SMTPTable.Rows[0]; }
//ReportDataSet.OWNERRow owner; public Fatura2XR(int AFBid, string Antet, string Usr) { InitializeComponent(); ReportDataSetTableAdapters.SMTPTableAdapter smtpTableAdapter = new ReportDataSetTableAdapters.SMTPTableAdapter(); ReportDataSet.SMTPDataTable SMTPTable = (ReportDataSet.SMTPDataTable)smtpTableAdapter.GetData(); ReportDataSet.SMTPRow SMTP = (ReportDataSet.SMTPRow)SMTPTable.Rows[0]; //ReportDataSetTableAdapters.OWNERTableAdapter ownerTableAdapter = new ReportDataSetTableAdapters.OWNERTableAdapter(); //ReportDataSet.OWNERDataTable ownerTable = (ReportDataSet.OWNERDataTable)ownerTableAdapter.GetData(); //owner = (ReportDataSet.OWNERRow)ownerTable.Rows[0]; // Force the report creation without requesting the parameter value from end-users. this.RequestParameters = false; rprIMGSTableAdapter.Fill(reportDataSet.RPR_IMGS); rprFaturaTableAdapter.Fill(reportDataSet.RPR_FATURA, AFBid, Usr); rprFaturaDtyTableAdapter.Fill(reportDataSet.RPR_FATURA_DTY, AFBid, "2"); if (reportDataSet.RPR_FATURA[0].ISAGN == "T") // Agent { rprFaturaMasterTableAdapter.Fill(reportDataSet.RPR_FATURA_MASTER, AFBid); //rprFaturaMasterCntnrsTableAdapter.Fill(reportDataSet.RPR_FATURA_MASTER_CNTNRS, AFBid); rprFaturaMasterHousesTableAdapter.Fill(reportDataSet.RPR_FATURA_MASTER_HOUSES, AFBid); } else { int nor = rprFaturaHouseTableAdapter.Fill(reportDataSet.RPR_FATURA_HOUSE, AFBid); if (nor > 0) { DetailReportMaster.Visible = false; } else { rprFaturaMasterTableAdapter.Fill(reportDataSet.RPR_FATURA_MASTER, AFBid); DetailReportHouse.Visible = false; } } if (!reportDataSet.RPR_FATURA[0].IsOPIDNull()) { opInfoTableAdapter.Fill(reportDataSet.OP_INFO, reportDataSet.RPR_FATURA[0].OPID, reportDataSet.RPR_FATURA[0].OPHM); } string drm = reportDataSet.RPR_FATURA[0].DRM; string eFtr = reportDataSet.RPR_FATURA[0].EFTR; antetli.Value = false; if (Antet == "Antetli") { antetli.Value = true; } eMails = reportDataSet.RPR_FATURA.Rows[0]["EMAILS"].ToString(); eMailSubject = reportDataSet.RPR_FATURA.Rows[0]["EMAILSUBJECT"].ToString(); eMailBody = reportDataSet.RPR_FATURA.Rows[0]["EMAILBODY"].ToString(); if (Antet != "Antetli" && SMTP.FIRMA == "TUNASET") { PaperKind = System.Drawing.Printing.PaperKind.A4; TopMargin.HeightF = 250F; // 50F; // 150F; BottomMargin.HeightF = 200F; // 50F; // 150F; PageFooter.Visible = false; Detail.HeightF = 1000F; // 1200F; xrLabelAdr.SizeF = new System.Drawing.SizeF(800F, 300F); xrLabelTrh.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; //xrLabelTrh2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; //xrLabelTrh2.Visible = true; xrLabelRef.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; xrLabelTrh.LocationF = new PointF(1380F, 475F); //PointF(1589.93F, 710F);//855,915, 1589 xrLabelRef.LocationF = new PointF(1580F, 475F); //PointF(1589.93F, 775F);//915,975 //xrLabelTrh2.LocationF = new PointF(1380F, 580F); //PointF(1589.93F, 710F);//855,915, 1589 /* * TopMargin.HeightF = 50F; // 150F; * PageFooter.Visible = false; * Detail.HeightF = 1000F; // 1200F; * * xrLabelAdr.SizeF = new System.Drawing.SizeF(800F, 300F); * xrLabelTrh.LocationF = new PointF(1589.93F, 710F);//915 * xrLabelRef.LocationF = new PointF(1351.81F, 775F);//975 */ } }
public Fatura5XR(int AFBid, string Antet, string Usr) { InitializeComponent(); // Force the report creation without requesting the parameter value from end-users. this.RequestParameters = false; ReportDataSetTableAdapters.SMTPTableAdapter smtpTableAdapter = new ReportDataSetTableAdapters.SMTPTableAdapter(); ReportDataSet.SMTPDataTable SMTPTable = (ReportDataSet.SMTPDataTable)smtpTableAdapter.GetData(); ReportDataSet.SMTPRow SMTP = (ReportDataSet.SMTPRow)SMTPTable.Rows[0]; rprIMGSTableAdapter.Fill(reportDataSet.RPR_IMGS); rprFaturaTableAdapter.Fill(reportDataSet.RPR_FATURA, AFBid, Usr); rprFaturaDtyAllTableAdapter.Fill(reportDataSet.RPR_FATURA_DTY_ALL, AFBid); string tur = reportDataSet.RPR_FATURA[0].TUR; string drm = reportDataSet.RPR_FATURA[0].DRM; string eFtr = reportDataSet.RPR_FATURA[0].EFTR; antetli.Value = false; if (Antet == "Antetli") { antetli.Value = true; } Watermark.Text = ""; if (drm == "A") { Watermark.Text = "DRAFT"; } if (eFtr == "T") { Watermark.Text += " eFatura"; } if (tur == "AA") { Watermark.Text += " Alış"; } if (tur == "AS") { Watermark.Text += " Satış İade"; } if (tur == "AV" || tur == "BV" || tur == "AM" || tur == "BM" || tur == "AD" || tur == "BD") // aVans/Belgesiz,fazlaMesai,Dekont { Watermark.Text = ""; } eMails = reportDataSet.RPR_FATURA.Rows[0]["EMAILS"].ToString(); eMailSubject = reportDataSet.RPR_FATURA.Rows[0]["EMAILSUBJECT"].ToString(); eMailBody = reportDataSet.RPR_FATURA.Rows[0]["EMAILBODY"].ToString(); if (Antet != "Antetli" && SMTP.FIRMA == "TUNASET") { TopMargin.HeightF = 50F; // 150F; xrRichTextFooter.Visible = false; Detail.HeightF = 1000F; // 1200F; xrLabelAdr.SizeF = new System.Drawing.SizeF(800F, 300F); xrLabelTrh.LocationF = new PointF(1589.93F, 710F); //855, 915 xrLabelRef.LocationF = new PointF(1351.81F, 775F); //915, 975 } }
public FaturaXR(int AFBid, string Antet, string Usr, bool AllIn = false) { InitializeComponent(); // Force the report creation without requesting the parameter value from end-users. this.RequestParameters = false; ReportDataSetTableAdapters.SMTPTableAdapter smtpTableAdapter = new ReportDataSetTableAdapters.SMTPTableAdapter(); ReportDataSet.SMTPDataTable SMTPTable = (ReportDataSet.SMTPDataTable)smtpTableAdapter.GetData(); ReportDataSet.SMTPRow SMTP = (ReportDataSet.SMTPRow)SMTPTable.Rows[0]; rprIMGSTableAdapter.Fill(reportDataSet.RPR_IMGS); rprFaturaTableAdapter.Fill(reportDataSet.RPR_FATURA, AFBid, Usr); //rprFaturaOpsTableAdapter.Fill(reportDataSet.RPR_FATURA_OPS, AFBid); rprFaturaDtyTableAdapter.Fill(reportDataSet.RPR_FATURA_DTY, AFBid, "1"); int nor = rprFaturaHouseTableAdapter.Fill(reportDataSet.RPR_FATURA_HOUSE, AFBid); if (nor > 0) { DetailReportMaster.Visible = false; } else { rprFaturaMasterTableAdapter.Fill(reportDataSet.RPR_FATURA_MASTER, AFBid); DetailReportHouse.Visible = false; } if (!reportDataSet.RPR_FATURA[0].IsOPIDNull()) { opInfoTableAdapter.Fill(reportDataSet.OP_INFO, reportDataSet.RPR_FATURA[0].OPID, reportDataSet.RPR_FATURA[0].OPHM); } string tur = reportDataSet.RPR_FATURA[0].TUR; string drm = reportDataSet.RPR_FATURA[0].DRM; string eFtr = reportDataSet.RPR_FATURA[0].EFTR; antetli.Value = false; if (Antet == "Antetli") { antetli.Value = true; } Watermark.Text = ""; if (drm == "A") { Watermark.Text = "DRAFT"; } if (eFtr == "T") { Watermark.Text += " eFatura"; } if (tur == "AA") { Watermark.Text += " Alış"; } if (tur == "AS") { Watermark.Text += " Satış İade"; } if (tur == "AV" || tur == "BV" || tur == "AM" || tur == "BM" || tur == "AD" || tur == "BD") // aVans/Belgesiz,fazlaMesai,Dekont { Watermark.Text = ""; } eMails = reportDataSet.RPR_FATURA.Rows[0]["EMAILS"].ToString(); eMailSubject = reportDataSet.RPR_FATURA.Rows[0]["EMAILSUBJECT"].ToString(); eMailBody = reportDataSet.RPR_FATURA.Rows[0]["EMAILBODY"].ToString(); if (Antet != "Antetli" && SMTP.FIRMA == "TUNASET") { PaperKind = System.Drawing.Printing.PaperKind.A4; TopMargin.HeightF = 250F; // 50F; // 150F; BottomMargin.HeightF = 200F; // 50F; // 150F; PageFooter.Visible = false; Detail.HeightF = 1000F; // 1200F; xrLabelAdr.SizeF = new System.Drawing.SizeF(800F, 300F); xrLabelTrh.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; xrLabelTrh2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; xrLabelTrh2.Visible = true; xrLabelRef.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; xrLabelTrh.LocationF = new PointF(1380F, 475F); //PointF(1589.93F, 710F);//855,915, 1589 xrLabelRef.LocationF = new PointF(1580F, 475F); //PointF(1589.93F, 775F);//915,975 xrLabelTrh2.LocationF = new PointF(1380F, 580F); //PointF(1589.93F, 710F);//855,915, 1589 } xrLabel53.Visible = !AllIn; xrLabel55.Visible = !AllIn; xrLine1.Visible = !AllIn; Detail1.Visible = !AllIn; xrLabelAll_In.Visible = AllIn; }
private void TopluExtreXF_Load(object sender, EventArgs e) { ReportDataSetTableAdapters.SMTPTableAdapter smtpTableAdapter = new ReportDataSetTableAdapters.SMTPTableAdapter(); ReportDataSet.SMTPDataTable SMTPTable = (ReportDataSet.SMTPDataTable)smtpTableAdapter.GetData(); SMTP = (ReportDataSet.SMTPRow)SMTPTable.Rows[0]; }