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];
}
