public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
RptCrystalReport rpt = new RptCrystalReport();
rpt.Site = this.Site;
return(rpt);
}
private void btnPrint_Click(object sender, EventArgs e)
{
if (txtBarcode.Text == "" || txtProName.Text == "" || txtSalesPrice.Text == "")
{
MessageBox.Show("من فضلك اكمل البيانات", "تاكيد");
return;
}
DataSet1 DS = new DataSet1();
DS.Clear();
RptCrystalReport rpt = new RptCrystalReport();
DS.Tables["PrintBarcode"].Rows.Add(txtProName.Text, txtBarcode.Text, txtSalesPrice.Text, "*" + txtBarcode.Text.Trim() + "*");
rpt.SetDataSource(DS);
Frm_Print frm = new Frm_Print();
frm.crystalReportViewer1.ReportSource = rpt;
frm.crystalReportViewer1.Refresh();
//frm.ShowDialog();
System.Drawing.Printing.PrintDocument printDocument = new System.Drawing.Printing.PrintDocument();
rpt.PrintOptions.PrinterName = printDocument.PrinterSettings.PrinterName;
rpt.PrintToPrinter(1, true, 0, 0);
Properties.Settings.Default.Pro_Barcode = txtBarcode.Text;
Properties.Settings.Default.Save();
db.exceuteData("update Products set Barcode=N'" + txtBarcode.Text + "' where Pro_Name=N'" + txtProName.Text + "'", "");
}
private void btnPrintPreview_Click(object sender, EventArgs e)
{
if (txtBarcode.Text == "" || txtProName.Text == "" || txtSalesPrice.Text == "")
{
MessageBox.Show("من فضلك اكمل البيانات", "تاكيد");
return;
}
DataSet1 DS = new DataSet1();
DS.Clear();
RptCrystalReport rpt = new RptCrystalReport();
DS.Tables["PrintBarcode"].Rows.Add(txtProName.Text, txtBarcode.Text, txtSalesPrice.Text, "*" + txtBarcode.Text.Trim() + "*");
//decimal count = 0;
//try {
// count =Convert.ToDecimal( db.readData("select * from Barcode_Print", "").Rows[0][0]);
//} catch (Exception) { }
//if (count >= 1)
//{
// db.exceuteData("update Barcode_Print set Pro_Name=N'"+txtProName.Text+ "' ,Pro_Barcode=N'"+txtBarcode.Text+ "' ,Pro_Price=N'"+txtSalesPrice.Text+"' ,barcode=N'"+txtBarcode.Text+"'", "");
//}else
//{
// db.exceuteData("insert into Barcode_Print values(N'" + txtProName.Text + "' ,N'" + txtBarcode.Text + "' ,N'" + txtSalesPrice.Text + "' ,N'" + txtBarcode.Text + "')", "");
//}
//DataTable tblS = new DataTable();
//tblS.Clear();
//tblS = db.readData("select * from Barcode_Print", "");
rpt.SetDataSource(DS);
Frm_Print frm = new Frm_Print();
frm.crystalReportViewer1.ReportSource = rpt;
frm.crystalReportViewer1.Refresh();
frm.ShowDialog();
Properties.Settings.Default.Pro_Barcode = txtBarcode.Text;
Properties.Settings.Default.Save();
db.exceuteData("update Products set Barcode=N'" + txtBarcode.Text + "' where Pro_Name=N'" + txtProName.Text + "'", "");
}
