(14-07-19, 06:11 PM)asemshahen5 كتب : أضف الكود التالي :

PHP كود :

       private void cmbaccountnameIndexChanged()
        {
            if (cmbaccountname.Text != "System.Data.DataRowView" && cmbprojectnumber.Text != "")
            {
                string SqlStr = "SELECT * FROM CHEQUES WHERE S_N in (SELECT MAX(S_N) AS S_N FROM CHEQUES AS CHEQUES_1 WHERE Beneficiary_Name = N'" + cmbaccountname.Text + "' AND Project_Number = " + cmbprojectnumber.Text + ")";
                DataTable Dtx = new DataTable();
                SqlDataAdapter SqlAdapter = new SqlDataAdapter(SqlStr, sqlcon);
                SqlAdapter.Fill(Dtx);
                textBox5.Clear();
                foreach (DataRow item in Dtx.Rows)
                {
                    if (item["Beneficiary_Name"].ToString() == cmbaccountname.Text && item["Project_Number"].ToString() == cmbprojectnumber.Text)
                    {
                        textBox5.Text = item["Description"].ToString();
                    }
                }
                int k = 0;
                int n = 0;
                if (textBox5.TextLength > 0)
                {
                    string newString = Regex.Replace(textBox5.Text, "[^.0-9]", "");
                    k = int.Parse(newString);
                }
                n = k;
                n += 1;
                textBox5.Text = textBox5.Text.Replace(k.ToString(), n.ToString());
                if (textBox5.Text.Length == 0)
                {
                    textBox5.Text = "payment 1";
                }
            }
        } 


عدل كود cmbaccountname_SelectedIndexChanged ليصبح هكذا :

PHP كود :

       private void cmbaccountname_SelectedIndexChanged(object sender, EventArgs e)
        {
            cmbaccountnameIndexChanged();
        } 


عدل كود زر الحفظ ليصبح هكذا :

PHP كود :

       private void button1_Click(object sender, EventArgs e)
        {
            if (string.IsNullOrWhiteSpace(textBox2.Text))
            {
                try
                {
                    dat.Add_Cheque(Convert.ToInt32(textBox1.Text), cmbaccountname.Text, textBox3.Text, textBox4.Text, textBox5.Text, Convert.ToInt32(cmbprojectnumber.Text), textBox7.Text);
                    MessageBox.Show("Add Successful", "Add", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    this.dataGridView1.DataSource = dat.Get_Cheque_Data();
                    cmbaccountnameIndexChanged();
                }
                catch
                {
                    return;
                }
            }
            else
            {
                try
                {
                    dat.Add_Cheque(Convert.ToInt32(textBox1.Text), textBox2.Text, textBox3.Text, textBox4.Text, textBox5.Text, Convert.ToInt32(cmbprojectnumber.Text), textBox7.Text);
                    MessageBox.Show("Add Successful", "Add", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    this.dataGridView1.DataSource = dat.Get_Cheque_Data();
                    cmbaccountnameIndexChanged();
                }
                catch
                {
                    return;
                }
            }
        } 


و بكدا تكون مشكلتك انحلت باذن الله .

(14-07-19, 10:26 PM)asemshahen5 كتب : معليش تعديل أخير :

PHP كود :

       private void cmbaccountnameIndexChanged()
        {
            if (cmbaccountname.Text != "System.Data.DataRowView" && cmbprojectnumber.Text != "")
            {
                string SqlStr = "SELECT * FROM CHEQUES WHERE S_N in (SELECT MAX(S_N) AS S_N FROM CHEQUES AS CHEQUES_1 WHERE Beneficiary_Name = N'" + cmbaccountname.Text + "' AND Project_Number = " + cmbprojectnumber.Text + ")";
                DataTable Dtx = new DataTable();
                SqlDataAdapter SqlAdapter = new SqlDataAdapter(SqlStr, sqlcon);
                SqlAdapter.Fill(Dtx);
                textBox5.Clear();
                if (Dtx.Rows.Count > 0)
                {
                    textBox5.Text = Dtx.Rows[0]["Description"].ToString();
                }
                int k = 0;
                int n = 0;
                if (textBox5.TextLength > 0)
                {
                    string newString = Regex.Replace(textBox5.Text, "[^.0-9]", "");
                    k = int.Parse(newString);
                }
                n = k;
                n += 1;
                textBox5.Text = textBox5.Text.Replace(k.ToString(), n.ToString());
                if (textBox5.Text.Length == 0)
                {
                    textBox5.Text = "payment 1";
                }
            }
        } 


سنوات الخبرة ضرورية بس محبة الشيء ضرورية أكثر .

(15-07-19, 04:04 PM)asemshahen5 كتب : ضع هذا الكود :

PHP كود :

       private void SumAmount() 
        {
            string SqlStr = "SELECT sum(Amount)as Amount, Beneficiary_Name, Project_Number FROM CHEQUES WHERE(Beneficiary_Name = N'" + cmbaccountname.Text + "') AND (Project_Number = " + cmbprojectnumber.Text + ") group by Beneficiary_Name, Project_Number";
            SqlDataAdapter Fadp = new SqlDataAdapter(SqlStr, sqlcon);
            DataTable Fdt = new DataTable();
            Fadp.Fill(Fdt);
            if (Fdt.Rows.Count>0)
            {
                textBox6.Text = Fdt.Rows[0]["Amount"].ToString();
            }
            else
            {
                textBox6.Clear();
            }
        } 


عدل الكود التالي ليصبح هكذا :

PHP كود :

       private void cmbaccountnameIndexChanged()
        {
            if (cmbaccountname.Text != "System.Data.DataRowView" && cmbprojectnumber.Text != "")
            {
                string SqlStr = "SELECT * FROM CHEQUES WHERE S_N in (SELECT MAX(S_N) AS S_N FROM CHEQUES AS CHEQUES_1 WHERE Beneficiary_Name = N'" + cmbaccountname.Text + "' AND Project_Number = " + cmbprojectnumber.Text + ")";
                DataTable Dtx = new DataTable();
                SqlDataAdapter SqlAdapter = new SqlDataAdapter(SqlStr, sqlcon);
                SqlAdapter.Fill(Dtx);
                textBox5.Clear();
                if (Dtx.Rows.Count > 0)
                {
                    textBox5.Text = Dtx.Rows[0]["Description"].ToString();
                }
                int k = 0;
                int n = 0;
                if (textBox5.TextLength > 0)
                {
                    string newString = Regex.Replace(textBox5.Text, "[^.0-9]", "");
                    k = int.Parse(newString);
                }
                n = k;
                n += 1;
                textBox5.Text = textBox5.Text.Replace(k.ToString(), n.ToString());
                if (textBox5.Text.Length == 0)
                {
                    textBox5.Text = "payment 1";
                }
                SumAmount();
            }
        } 


انا افترضت أن textBox6.Text هو التكست الذي تريد عرض المجموع فيه .