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 + "'", ""); }