31-07-17, 02:03 AM
السلام عليكم و رحمة الله و بركاته
الاخ ابو راشد لا ادري ما المشكلة لديك و لكن وفق المثال الخاص بك , و التعديل الذ جرى عليه
البرنامج يعمل بشكل سلس دون اي اشارة الى خطأ يذكر
وهذا الكود و مكان وضعه في الاجراء
و هذا كود النموذج لديك
بالتوفيق
الاخ ابو راشد لا ادري ما المشكلة لديك و لكن وفق المثال الخاص بك , و التعديل الذ جرى عليه
البرنامج يعمل بشكل سلس دون اي اشارة الى خطأ يذكر
وهذا الكود و مكان وضعه في الاجراء
PHP كود :
private void btnAdd_Click(object sender, EventArgs e)
{
this.ID_Orders.Text = ORD.ADD_ID_ORDERS().Rows[0][0].ToString();
FRM_CUST_N_ORD frm = new FRM_CUST_N_ORD();
frm.ShowDialog();
this.ID_Customer.Text = frm.DGV_ORD_PRNT.CurrentRow.Cells[0].Value.ToString();
this.name_Customer.Text = frm.DGV_ORD_PRNT.CurrentRow.Cells[1].Value.ToString();
this.comb_type_Customer.Text = frm.DGV_ORD_PRNT.CurrentRow.Cells[3].Value.ToString();
dgv_Orders.Focus();
btnAdd.Enabled = false;
btn_save.Enabled = true;
print.Enabled = true;
note.Enabled = true;
datetim.Enabled = true;
ID_Customer.Enabled = false;
name_Customer.Enabled = false;
comb_type_Customer.Enabled = false;
txtSALESMAN.Enabled = false;
dgv_Orders.Enabled = true;
TOTAL.Enabled = true;
txt_PAID.Enabled = true;
txt_SURPLUS.Enabled = true;
dgv_Orders.CurrentCell = dgv_Orders.Rows[0].Cells[1];
dgv_Orders.BeginEdit(true);
}
و هذا كود النموذج لديك
PHP كود :
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Globalization;
namespace test_orders.PL
{
public partial class FRM_ORDERS : Form
{
private static FRM_ORDERS frm;
static void frm_FormClosed(object sender, FormClosedEventArgs e)
{
frm = null;
}
public static FRM_ORDERS getMainForm
{
get
{
if (frm == null)
{
frm = new FRM_ORDERS();
frm.FormClosed += new FormClosedEventHandler(frm_FormClosed);
}
return frm;
}
}
BL.CLS_ORDERS ORD = new BL.CLS_ORDERS();
void calculateAmount()
{
try
{
if (txt_PAID.Text != string.Empty || TOTAL.Text != string.Empty)
{
double SURPLUS = Convert.ToDouble(txt_PAID.Text) - Convert.ToDouble(TOTAL.Text);
txt_SURPLUS.Text = SURPLUS.ToString();
}
}
catch
{
MessageBox.Show("لايمكن ترك الحقل فارغا", "تنبيه", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return;
}
void ResizDGV()
{
this.dgv_Orders.RowHeadersWidth = 4;
this.dgv_Orders.Columns[0].Width = 50;
this.dgv_Orders.Columns[1].Width = 140;
this.dgv_Orders.Columns[2].Width = 345;
this.dgv_Orders.Columns[3].Width = 95;
this.dgv_Orders.Columns[4].Width = 95;
this.dgv_Orders.Columns[5].Width = 95;
// this.dgv_Orders.Columns[6].Width = 95;
}
DataTable Dt = new DataTable();
void createDataTable()
{
Dt.Columns.Add("تسلسل");
Dt.Columns.Add("الباركود");
Dt.Columns.Add("اسم الصنف");
DataColumn Qt = new DataColumn {Caption="الكمية" ,ColumnName= "Qt", DataType=Type.GetType("System.Decimal") };
DataColumn Price = new DataColumn { Caption = "السعر", ColumnName = "Price", DataType = Type.GetType("System.Decimal") };
DataColumn Totals = new DataColumn { Caption = "الاجمالي", ColumnName = "Totals", DataType = Type.GetType("System.Decimal"), Expression = "Price * Qt" };
Dt.Columns.Add(Qt);
Dt.Columns.Add(Price);
Dt.Columns.Add(Totals);
dgv_Orders.DataSource = Dt;
}
public FRM_ORDERS()
{
InitializeComponent();
if (frm == null)
frm = this;
createDataTable();
ResizDGV();
}
private void btnAdd_Click(object sender, EventArgs e)
{
this.ID_Orders.Text = ORD.ADD_ID_ORDERS().Rows[0][0].ToString();
FRM_CUST_N_ORD frm = new FRM_CUST_N_ORD();
frm.ShowDialog();
this.ID_Customer.Text = frm.DGV_ORD_PRNT.CurrentRow.Cells[0].Value.ToString();
this.name_Customer.Text = frm.DGV_ORD_PRNT.CurrentRow.Cells[1].Value.ToString();
this.comb_type_Customer.Text = frm.DGV_ORD_PRNT.CurrentRow.Cells[3].Value.ToString();
dgv_Orders.Focus();
btnAdd.Enabled = false;
btn_save.Enabled = true;
print.Enabled = true;
note.Enabled = true;
datetim.Enabled = true;
ID_Customer.Enabled = false;
name_Customer.Enabled = false;
comb_type_Customer.Enabled = false;
txtSALESMAN.Enabled = false;
dgv_Orders.Enabled = true;
TOTAL.Enabled = true;
txt_PAID.Enabled = true;
txt_SURPLUS.Enabled = true;
dgv_Orders.CurrentCell = dgv_Orders.Rows[0].Cells[1];
dgv_Orders.BeginEdit(true);
}
private void btn_save_Click(object sender, EventArgs e)
{
if (ID_Orders.Text == string.Empty || datetim.Text == string.Empty || name_Customer.Text == string.Empty
|| TOTAL.Text == string.Empty /*|| txt_PAID.Text == string.Empty || txt_SURPLUS.Text == string.Empty */|| dgv_Orders.Rows.Count < 1)
{
MessageBox.Show("لايمكن حفظ الفاتورة خالية من المعلومات", "تنبيه", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
int p = 0;
for (int i = 0; i < dgv_Orders.Rows.Count - 1; i++)
{
if (Checkthis(i) == true)
{
p += 1;
ORD.ADD_ORDERS_DETAILS(dgv_Orders.Rows[i].Cells[1].Value.ToString(),
Convert.ToInt32(ID_Orders.Text),
Convert.ToInt32(dgv_Orders.Rows[i].Cells[3].Value),
dgv_Orders.Rows[i].Cells[4].Value.ToString());
}
}
if (p>0)
{
ORD.ADD_ORDERS(Convert.ToInt32(ID_Orders.Text), datetim.Value, Convert.ToInt32(ID_Customer.Text), note.Text, txtSALESMAN.Text, TOTAL.Text, txt_PAID.Text, txt_SURPLUS.Text);
MessageBox.Show("تم حفظ الفاتورة بنجاح", "الحفظ");
btnAdd.Enabled = true;
btn_save.Enabled = false;
print.Enabled = true;
note.Enabled = false;
datetim.Enabled = false;
ID_Customer.Enabled = false;
name_Customer.Enabled = false;
comb_type_Customer.Enabled = false;
txtSALESMAN.Enabled = false;
dgv_Orders.Enabled = false;
TOTAL.Enabled = false;
txt_PAID.Enabled = false;
txt_SURPLUS.Enabled = false;
note.Clear();
ID_Customer.Clear();
name_Customer.Clear();
comb_type_Customer.Clear(); ;
txtSALESMAN.Clear();
TOTAL.Clear();
txt_PAID.Clear();
txt_SURPLUS.Clear();
Dt.Clear();
}
}
private bool Checkthis(int i)
{
if (String.IsNullOrEmpty(dgv_Orders.Rows [i].Cells [1].Value.ToString()) || String.IsNullOrEmpty(ID_Orders.Text) || String.IsNullOrEmpty(dgv_Orders.Rows [i].Cells [3].Value.ToString())
|| String.IsNullOrEmpty(dgv_Orders.Rows [i].Cells [4].Value.ToString()))
{
return false;
}
else
{
return true;
}
}
private bool Check(int i)
{
if (String.IsNullOrEmpty(dgv_Orders.Rows[i].Cells[1].Value.ToString()) || String.IsNullOrEmpty(ID_Orders.Text) || String.IsNullOrEmpty(dgv_Orders.Rows[i].Cells[3].Value.ToString())
|| String.IsNullOrEmpty(dgv_Orders.Rows[i].Cells[4].Value.ToString()))
{
return false;
}
else
{
return true;
}
}
private void dgv_Orders_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
}
private void dgv_Orders_CellEnter(object sender, DataGridViewCellEventArgs e)
{
dgv_Orders.Rows[e.RowIndex].Cells[0].Value = e.RowIndex + 1;
if (dgv_Orders.CurrentCell.ColumnIndex == 1)
{
if (dgv_Orders.CurrentRow.Index > 0)
{
BL.CLS_ORDERS order = new BL.CLS_ORDERS();
DataTable dt = order.LIST_BARCODE(dgv_Orders.Rows[dgv_Orders.CurrentRow.Index - 1].Cells[1].Value.ToString());
if (dt.Rows.Count > 0)
{
dgv_Orders.Rows[dgv_Orders.CurrentRow.Index - 1].Cells[2].Value = dt.Rows[0][2].ToString();
dgv_Orders.Rows[dgv_Orders.CurrentRow.Index - 1].Cells[3].Value = "1";
dgv_Orders.Rows[dgv_Orders.CurrentRow.Index - 1].Cells[4].Value = dt.Rows[0][4].ToString();
}
else
{
try
{
dgv_Orders.Rows[dgv_Orders.CurrentRow.Index - 1].Cells[1].Value.ToString();
MessageBox.Show(" هذا الصنف لم يتم تسجيله", "تنبيه", MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
catch
{
dgv_Orders.CurrentRow.Cells[1] = null;
}
}
}
}
TOTAL.Text =
(from DataGridViewRow row in dgv_Orders.Rows
where
row.Cells["Totals"].FormattedValue.ToString() != string.Empty
select Convert.ToDecimal (row.Cells["Totals"].FormattedValue)).Sum().ToString();
}
private void print_Click(object sender, EventArgs e)
{
this.Cursor = Cursors.WaitCursor;
int ID_ORDER = Convert.ToInt32(ORD.get_lest_orders_for_prnt().Rows[0][0]);
RPT.CrystalReport1 REPORT = new RPT.CrystalReport1();
RPT.FRM_RPT_PRUNT frm = new RPT.FRM_RPT_PRUNT();
REPORT.SetDataSource(ORD.PRINT_ORDERS(ID_ORDER));
frm.crystalReportViewer1.ReportSource = REPORT;
frm.ShowDialog();
this.Cursor = Cursors.Default;
}
private void button1_Click(object sender, EventArgs e)
{
FRM_ORDERS_LIST frm = new FRM_ORDERS_LIST();
frm.ShowDialog();
}
private void FRM_ORDERS_Load(object sender, EventArgs e)
{
}
}
}
بالتوفيق
اللهم لك الحمد كما ينبغي لجلال وجهك و عظيم سلطانك
في حل و ترحال


