private void button13_Click(object sender, EventArgs e)
{
#region old
/*if (label25.Text == "")
{
MessageBox.Show("�������� �� ������! ������� �������� ��������!");
return;
}
DBWork.dbReader reader = new DBWork.dbReader(int.Parse(label25.Text));
Conn.ReaderDA.SelectCommand.CommandText = "select * from Main where";
//DataSet ds = dbw.GetFormular("149921");
//int i = ds.Tables.Count;
//CrystalReport11.SetDataSource(dbw.GetFormular("149921"));
Conn.SQLDA.SelectCommand.Parameters["@IDR"].Value = reader.id;
Conn.SQLDA.SelectCommand.CommandText = " select " +
"max(case when tmp.mnf = 200 then pl end) as Zag, " +
"max(case when tmp.mnf = 200 then srt end) as zag_sort, " +
"max(case when tmp.mnf = 700 then pl end) as avt, " +
"max(case when tmp.mnf = 700 then srt end) as avt_sort, " +
"max(case when tmp.mnf = 2100 then pl end) as god, " +
"max(case when tmp.mnf = 200 then pl end) as mesto, " +
"max(case when tmp.mnf = 200 then idm end) as idmain, " +
"max(case when tmp.mnf = 200 then iss end) as issue, " +
"max(case when tmp.mnf = 200 then vozv end) as vozv, " +
"max(case when tmp.mnf = 200 then fct end) as fact, " +
"max(case when tmp.mnf = 200 then zakid end) as zkid, " +
"max(case when tmp.mnf = 200 then zi end) as zid, " +
"((case when (tmp.pnlt = 'false' or tmp.pnlt is NULL) then 'false' else 'true' end)) as penalty, " +
"((case when (tmp.rempnlt = 'false' or tmp.rempnlt is NULL) then 'false' else 'true' end)) as rempenalty " +
"from " +
"(select Z.ID as zi,Z.IDMAIN as zakid, Z.DATE_ISSUE as iss, Z.DATE_VOZV as vozv, Z.DATE_FACT_VOZV as fct, Z.PENALTY as pnlt,Z.REMPENALTY as rempnlt, X.IDMAIN as idm, X.PLAIN as pl, Y.SORT as srt, Y.MNFIELD as mnf " +
"from BJACC..DATAEXTPLAIN X " +
"join BJACC..DATAEXT Y on Y.ID=X.IDDATAEXT " +
"join Reservation_R..ISSUED Z on ((Z.IDMAIN = Y.IDMAIN) or (Z.IDMAIN_CONST=Y.IDMAIN and Z.PENALTY='true')) " +
//"--join Reservation_R..ISSUED ZZ on Z.IDMAIN = ZZ.IDMAIN_CONST "+
"where (((Y.MNFIELD = 200 and Y.MSFIELD = '$a') " +
"or (Y.MSFIELD = '$a' and Y.MNFIELD = 700) " +
"or (Y.MSFIELD = '$d' and Y.MNFIELD = 2100) " +
"or (Y.MSFIELD = '$a' and Y.MNFIELD = 210)) and (Z.IDREADER = @IDR) and (( ((Z.IDMAIN!=0)and(Z.REMPENALTY = 'false')and (Z.PENALTY='true')) or ((Z.IDMAIN=0)and(Z.PENALTY='true')) or ((Z.IDMAIN!=0)and(Z.REMPENALTY = 'false')and (Z.PENALTY='false')) ) )) " +
"group by Z.ID, Z.IDMAIN, X.PLAIN, Y.SORT, Y.MNFIELD, X.IDMAIN,Z.DATE_ISSUE,Z.DATE_VOZV, Z.DATE_FACT_VOZV,Z.PENALTY, Z.REMPENALTY " +
") as tmp " +
"group by idm,pnlt,rempnlt ";
Conn.SQLDA.SelectCommand.Connection = Conn.ZakazCon;
DataSet R = new DataSet();
R.Tables.Add("form");
int i = Conn.SQLDA.Fill(R.Tables["form"]);
CrystalReport1 cr1 = new CrystalReport1();
cr1.SetDataSource(R.Tables["form"]);
crystalReportViewer1.ReportSource = cr1;
CrystalDecisions.CrystalReports.Engine.TextObject txtReaderName;
CrystalDecisions.CrystalReports.Engine.TextObject txtReaderNum;
txtReaderName = cr1.ReportDefinition.ReportObjects["Text19"] as TextObject;
txtReaderNum = cr1.ReportDefinition.ReportObjects["Text20"] as TextObject;
txtReaderName.Text = reader.Surname + " " + reader.Name + " " + reader.SecondName;
txtReaderNum.Text = reader.id;
//crystalReportViewer1.PrintReport();
cr1.PrintToPrinter(2, false, 1, 99999);*/
#endregion
if (lFromularNumber.Text == "")
{
MessageBox.Show("�������� �� ������! ������� �������� ��������!");
return;
}
DBWork.dbReader reader = new DBWork.dbReader(int.Parse(lFromularNumber.Text));
Conn.ReaderDA.SelectCommand.CommandText = "select * from Main where";
//DataSet ds = dbw.GetFormular("149921");
//int i = ds.Tables.Count;
//CrystalReport11.SetDataSource(dbw.GetFormular("149921"));
Conn.SQLDA.SelectCommand.Parameters["@IDR"].Value = reader.id;
Conn.SQLDA.SelectCommand.CommandText = "select zagp.PLAIN zag,avtp.PLAIN avt, B.INV inv, B.DATE_ISSUE iss,B.DATE_VOZV vzv " +
" from BJACC..DATAEXT A " +
" inner join Reservation_R..ISSUED B on B.INV collate Cyrillic_General_CI_AI = A.SORT and A.MNFIELD = 899 and A.MSFIELD = '$p' " +
" left join BJACC..DATAEXT zag on zag.MNFIELD = 200 and zag.MSFIELD = '$a' and zag.IDMAIN = A.IDMAIN " +
" left join BJACC..DATAEXT avt on avt.MNFIELD = 700 and avt.MSFIELD = '$a' and avt.IDMAIN = A.IDMAIN " +
" left join BJACC..DATAEXTPLAIN zagp on zagp.IDDATAEXT = zag.ID " +
" left join BJACC..DATAEXTPLAIN avtp on avtp.IDDATAEXT = avt.ID " +
" where B.IDREADER = @IDR and B.IDMAIN != 0";
Conn.SQLDA.SelectCommand.Connection = Conn.ZakazCon;
DataSet R = new DataSet();
R.Tables.Add("form");
int i = Conn.SQLDA.Fill(R.Tables["form"]);
CrystalReport1 cr1 = new CrystalReport1();
cr1.SetDataSource(R.Tables["form"]);
crystalReportViewer1.ReportSource = cr1;
CrystalDecisions.CrystalReports.Engine.TextObject txtReaderName;
CrystalDecisions.CrystalReports.Engine.TextObject txtReaderNum;
txtReaderName = cr1.ReportDefinition.ReportObjects["Text19"] as TextObject;
txtReaderNum = cr1.ReportDefinition.ReportObjects["Text20"] as TextObject;
txtReaderName.Text = reader.Surname + " " + reader.Name + " " + reader.SecondName;
txtReaderNum.Text = reader.id;
//crystalReportViewer1.PrintReport();
cr1.PrintToPrinter(1, false, 1, 99999);
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
CrystalReport1 rpt = new CrystalReport1();
rpt.Site = this.Site;
return rpt;
}
