void PRINT_POS() { try { this.Cursor = Cursors.WaitCursor; int order_ID = Convert.ToInt32(PosOrderId.Text); ReportDocument rep_ill = new ReportDocument(); string Patch = Application.StartupPath + "\\settings\\Print\\PosBill\\PosBill.rpt"; rep_ill.Load(Patch); Reports.Frm_CrstalReport frm = new Reports.Frm_CrstalReport(); rep_ill.SetDataSource(ClsPos.PrintPOsBill(order_ID)); frm.crystalReportViewer1.ReportSource = rep_ill; rep_ill.PrintOptions.PaperOrientation = CrystalDecisions.Shared.PaperOrientation.Portrait; rep_ill.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.DefaultPaperSize; //frm.ShowDialog(); rep_ill.PrintToPrinter(1, false, 0, 0); rep_ill.PrintOptions.PrinterName = Properties.Settings.Default.POS_PRINT; this.Cursor = Cursors.Default; } catch { MessageBox.Show("خطأ بعملية الطباعة", "واى إن للبرمجيات", MessageBoxButtons.OK, MessageBoxIcon.Error); this.Cursor = Cursors.Default; return; } }
private void BtnPintAll_Click(object sender, EventArgs e) { try { this.Cursor = Cursors.WaitCursor; Reports.items.ItemPrintAll report = new Reports.items.ItemPrintAll(); report.SetDataSource(ClsItem.GatAllItemsPrintAll()); Reports.Frm_CrstalReport frm = new Reports.Frm_CrstalReport(); frm.crystalReportViewer1.ReportSource = report; frm.ShowDialog(); this.Cursor = Cursors.Default; } catch { MessageBox.Show("خطأ بعملية الطباعة", "واى إن للبرمجيات", MessageBoxButtons.OK, MessageBoxIcon.Error); this.Cursor = Cursors.Default; return; } }
private void BtnPrint_Click(object sender, EventArgs e) { try { this.Cursor = Cursors.WaitCursor; Reports.items.SinglItemPrint report = new Reports.items.SinglItemPrint(); int order_ID = Convert.ToInt32(this.DGV_Items.CurrentRow.Cells[0].Value.ToString()); report.SetParameterValue("@ID", order_ID); Reports.Frm_CrstalReport frm = new Reports.Frm_CrstalReport(); frm.crystalReportViewer1.ReportSource = report; frm.ShowDialog(); this.Cursor = Cursors.Default; } catch { MessageBox.Show("خطأ بعملية الطباعة", "واى إن للبرمجيات", MessageBoxButtons.OK, MessageBoxIcon.Error); this.Cursor = Cursors.Default; return; } }
private void BtnPrintSingle_Click(object sender, EventArgs e) { try { this.Cursor = Cursors.WaitCursor; Reports.Purchase.OnePruchaseBill report = new Reports.Purchase.OnePruchaseBill(); int id = Convert.ToInt32(this.DGV_PruChaseOrder.CurrentRow.Cells[0].Value.ToString()); report.SetDataSource(ClsPru.PrintOne(id)); Reports.Frm_CrstalReport frm = new Reports.Frm_CrstalReport(); frm.crystalReportViewer1.ReportSource = report; frm.ShowDialog(); this.Cursor = Cursors.Default; } catch { MessageBox.Show("خطأ بعملية الطباعة", "واى إن للبرمجيات", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } }
private void BtnAdd_Click(object sender, EventArgs e) { try { if (SalesOrder_Id.Text == string.Empty || SalesOrder_Desc.Text == string.Empty || DGV_salesOrder.Rows.Count < 1 || Cust_Name.Text == string.Empty || Cust_ID.Text == string.Empty || User_SalesOrder.Text == string.Empty) { MessageBox.Show("عفوا!! بعض الخانات فارغة يرجى التاكد", "تنبيه", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (CMB_TSDID.Text == "نقدى") { ClsSales.Add_SalesOrder(Convert.ToInt32(SalesOrder_Id.Text), SalesOrder_Date.DateTime, SalesOrder_Desc.Text, Convert.ToInt32(Cust_ID.Text), User_SalesOrder.Text); for (int i = 0; i < DGV_salesOrder.Rows.Count; i++) { ClsSales.AddSalesOrderDetailes(Convert.ToInt32(DGV_salesOrder.Rows[i].Cells[0].Value.ToString()), Convert.ToInt32(SalesOrder_Id.Text), DGV_salesOrder.Rows[i].Cells[1].Value.ToString(), DGV_salesOrder.Rows[i].Cells[2].Value.ToString(), Convert.ToDouble(DGV_salesOrder.Rows[i].Cells[3].Value.ToString()), Convert.ToDouble(DGV_salesOrder.Rows[i].Cells[4].Value), Convert.ToDouble(DGV_salesOrder.Rows[i].Cells[6].Value.ToString()), Convert.ToDouble(DGV_salesOrder.Rows[i].Cells[7].Value.ToString()), Convert.ToDouble(Total_Amount.Text), Total_Amount_Ar.Text); } } if (CMB_TSDID.Text == "آجل") { ClsRV.AddVoucher(Convert.ToInt32(VoucherCode.Text), "رقم سند الاستلام : " + VoucherCode.Text, SalesOrder_Date.DateTime, Convert.ToDouble(Total_Amount.Text), Total_Amount_Ar.Text, "السيد / " + Cust_Name.Text, "سند قبض تابع لفاتورة مبيعات رقم :" + VoucherCode.Text, User_SalesOrder.Text, Convert.ToDouble(txtmadfoa.Text), NewDofaaAr.Text, Convert.ToDouble(txtmotbqi.Text), txtBaqiAr.Text); // ClsRV.AddVoucher(Convert.ToInt32(VoucherCode.Text),VoucherCode.Text, SalesOrder_Date.DateTime, Convert.ToDouble(Total_Amount.Text), //Total_Amount_Ar.Text, "السيد / " + Cust_Name.Text, VoucherCode.Text, User_SalesOrder.Text, Convert.ToDouble(txtmadfoa), //NewDofaaAr.Text, Convert.ToDouble(txtmotbqi.Text), txtBaqiAr.Text); ClsSales.Add_SalesOrder(Convert.ToInt32(SalesOrder_Id.Text), SalesOrder_Date.DateTime, SalesOrder_Desc.Text, Convert.ToInt32(Cust_ID.Text), User_SalesOrder.Text); for (int i = 0; i < DGV_salesOrder.Rows.Count; i++) { ClsSales.AddSalesOrderDetailes(Convert.ToInt32(DGV_salesOrder.Rows[i].Cells[0].Value.ToString()), Convert.ToInt32(SalesOrder_Id.Text), DGV_salesOrder.Rows[i].Cells[1].Value.ToString(), DGV_salesOrder.Rows[i].Cells[2].Value.ToString(), Convert.ToDouble(DGV_salesOrder.Rows[i].Cells[3].Value.ToString()), Convert.ToDouble(DGV_salesOrder.Rows[i].Cells[4].Value), Convert.ToDouble(DGV_salesOrder.Rows[i].Cells[6].Value.ToString()), Convert.ToDouble(DGV_salesOrder.Rows[i].Cells[7].Value.ToString()), Convert.ToDouble(Total_Amount.Text), Total_Amount_Ar.Text); } } MessageBox.Show("تمت عملية الحفظ بنجاح", "عملية الحفظ", MessageBoxButtons.OK, MessageBoxIcon.Information); try { if (MessageBox.Show("هل تريد طباعة هذة الفاتورة؟", "واى إن للبرمجيات", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { this.Cursor = Cursors.WaitCursor; Reports.SalesBill.OneSaleBill report = new Reports.SalesBill.OneSaleBill(); int order_ID = Convert.ToInt32(SalesOrder_Id.Text); report.SetParameterValue("@ID", order_ID); Reports.Frm_CrstalReport frm = new Reports.Frm_CrstalReport(); frm.crystalReportViewer1.ReportSource = report; frm.ShowDialog(); this.Cursor = Cursors.Default; } } catch (Exception ex) { MessageBox.Show("خطأ بعملية الطباعة" + ex.ToString(), "واى إن للبرمجيات", MessageBoxButtons.OK, MessageBoxIcon.Error); this.Cursor = Cursors.Default; return; } } catch { return; } ClearBoxes(); BtnNew.Enabled = true; BtnAdd.Enabled = false; }
private void BtnAdd_Click(object sender, EventArgs e) { try { if (PurOrder_Id.Text == string.Empty || User_PurOrder.Text == string.Empty || DGV_PruChaseOrder.Rows.Count < 1 || PurOrder_Desc.Text == string.Empty || PurSup_ID.Text == string.Empty) { MessageBox.Show("برجاء اكمال كافة الحقول!!", "واى إن للبرمجيات", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } try { if (CMB_TSDID.Text == "نقدي") { //إضافة معلومات الفاتورة ClsPru.Add_PruChaseOrder(Convert.ToInt32(PurOrder_Id.Text), PurOrder_Date.DateTime, PurOrder_Desc.Text, Convert.ToInt32(PurSup_ID.Text), User_PurOrder.Text); //إضافة المنتجات المدخلة for (int i = 0; i < DGV_PruChaseOrder.Rows.Count; i++) { ClsPru.InsertPruchaseOrderDetailes( Convert.ToInt32(PurOrder_Id.Text), DGV_PruChaseOrder.Rows[i].Cells[0].Value.ToString(), DGV_PruChaseOrder.Rows[i].Cells[1].Value.ToString(), DGV_PruChaseOrder.Rows[i].Cells[2].Value.ToString(), Convert.ToDouble(DGV_PruChaseOrder.Rows[i].Cells[3].Value.ToString()), Convert.ToDouble(DGV_PruChaseOrder.Rows[i].Cells[4].Value.ToString()), Convert.ToDouble(DGV_PruChaseOrder.Rows[i].Cells[6].Value.ToString()), Convert.ToDouble(Total_Amount.Text), Total_Amount_Ar.Text, Status.Text, Convert.ToDouble(DGV_PruChaseOrder.Rows[i].Cells[5].Value.ToString())); } } if (CMB_TSDID.Text == "آجل") { Clsfs.AddAllFinancialSupport(Convert.ToInt32(VoucherCode.Text), PurOrder_Date.DateTime, Convert.ToDouble(Total_Amount.Text), Total_Amount_Ar.Text, "السيد / " + Sup_Name.Text, "سند دفع تابع لفاتورة مشتريات رقم :" + VoucherCode.Text, User_PurOrder.Text, Convert.ToDouble(txtmadfoa.Text), NewDofaaAr.Text, Convert.ToDouble(txtmotbqi.Text), txtBaqiAr.Text); //إضافة معلومات الفاتورة ClsPru.Add_PruChaseOrder(Convert.ToInt32(PurOrder_Id.Text), PurOrder_Date.DateTime, PurOrder_Desc.Text, Convert.ToInt32(PurSup_ID.Text), User_PurOrder.Text); //إضافة المنتجات المدخلة for (int i = 0; i < DGV_PruChaseOrder.Rows.Count; i++) { ClsPru.InsertPruchaseOrderDetailes( Convert.ToInt32(PurOrder_Id.Text), DGV_PruChaseOrder.Rows[i].Cells[0].Value.ToString(), DGV_PruChaseOrder.Rows[i].Cells[1].Value.ToString(), DGV_PruChaseOrder.Rows[i].Cells[2].Value.ToString(), Convert.ToDouble(DGV_PruChaseOrder.Rows[i].Cells[3].Value.ToString()), Convert.ToDouble(DGV_PruChaseOrder.Rows[i].Cells[4].Value.ToString()), Convert.ToDouble(DGV_PruChaseOrder.Rows[i].Cells[6].Value.ToString()), Convert.ToDouble(Total_Amount.Text), Total_Amount_Ar.Text, Status.Text, Convert.ToDouble(DGV_PruChaseOrder.Rows[i].Cells[5].Value.ToString())); } } } catch (Exception ex) { MessageBox.Show(ex.ToString()); //return; } MessageBox.Show("تمت عملية الحفظ بنجاح", "عملية الحفظ", MessageBoxButtons.OK, MessageBoxIcon.Information); try { if (MessageBox.Show("هل تريد طباعة هذة الفاتورة؟", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { this.Cursor = Cursors.WaitCursor; Reports.Purchase.OnePruchaseBill report = new Reports.Purchase.OnePruchaseBill(); int order_ID = Convert.ToInt32(PurOrder_Id.Text); report.SetParameterValue("@ID", order_ID); Reports.Frm_CrstalReport frm = new Reports.Frm_CrstalReport(); frm.crystalReportViewer1.ReportSource = report; frm.ShowDialog(); this.Cursor = Cursors.Default; } } catch (Exception ex) { MessageBox.Show("خطأ بعملية الطباعة" + ex.ToString(), "واى إن للبرمجيات", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } ClearBoxes(); BtnNew.Enabled = true; BtnAdd.Enabled = false; } catch { return; } }