private void cmdadd_Click(object sender, EventArgs e) { std stdn = new std(); stdn.stdno = txtstdno.Text; if (!stdn.SelectfornameCheck().Equals(txtname.Text)) { MessageBox.Show("نام هنرجو با شماره پرونده مطابقت ندارد", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error); txtname.Focus(); return; } ghabz gh = new ghabz(); gh.id = txtid.Text; gh.stdno = txtstdno.Text; gh.name = txtname.Text.Trim(); gh.artcourse = txtartcourse.Text.Trim(); gh.date = txtdate.Text; gh.lastcheck = txtlastcheck.Text; gh.lastdate = txtlastdate.Text; gh.mablagh = long.Parse(txtmablagh.Text); gh.paid = long.Parse(txtpaid.Text); gh.sharh = txtsharh.Text; gh.Update(); if (!stdno.Equals(txtstdno.Text)) { std_history st = new std_history(); st.ghabz_id = txtid.Text; st.stdno = stdno; // old stdno st.Delete(); pardakht(); Daryaft(); } else { std_history sh = new std_history(); sh.ghabz_id = txtid.Text; sh.stdno = txtstdno.Text;; sh.sharh = "شهریه " + txtlastcheck.Text + "-" + txtsharh.Text; sh.date = txtdate.Text; sh.bedehkari = long.Parse(txtmablagh.Text); sh.bestankari = long.Parse(txtmablagh.Text); sh.UpdateAfterEslahGhabz(); } MessageBox.Show("قبض با موفقیت ویرایش گردید"); this.Close(); }
private void btnUpdate_Click(object sender, EventArgs e) { std_history sh = new std_history(); sh.stdno = txtstdno.Text; DataTable dt = sh.Search("select sum (bedehkari- bestankari) as bedsum from std_history where (stdno=N'" + txtstdno.Text + "' and radif>1)"); long sumbed = 0; long newmandeh = long.Parse(txtmandeh.Text); long mandehafter = 0; string tashkhisafter = ""; if (txttashkhis.Text.Equals("بستانکار")) { newmandeh = -newmandeh; } if (dt.Rows.Count > 0) { if (dt.Rows[0]["bedsum"].ToString().Trim().Equals("") || dt.Rows[0]["bedsum"].ToString().Trim().Equals("NULL")) { sumbed = 0; } else { sumbed = long.Parse(dt.Rows[0]["bedsum"].ToString()); } //sumbed = Math.Abs(sumbed); mandehafter = newmandeh - sumbed; if (mandehafter >= 0) { sh.bestankari = 0; sh.bedehkari = mandehafter; tashkhisafter = "بدهکار"; } else { sh.bedehkari = 0; sh.bestankari = Math.Abs(mandehafter); tashkhisafter = "بستانکار"; } sh.tashkhis = tashkhisafter; sh.mandeh = Math.Abs(mandehafter); sh.UpdateAfterMandehChanged(); } this.Close(); }
private void btnAdd_Click(object sender, EventArgs e) { string position; std st = new std(); st.stdno = txtstdno.Text.Trim(); st.reg_date = txtreg_date.Text; st.name = txtname.Text.Trim(); st.father = txtfather.Text.Trim(); st.idno = txtidno.Text.Trim(); st.degree = txtdegree.Text.Trim(); st.course = txtcourse.Text.Trim(); st.birthdate = txtbirthdate.Text; st.job = txtjob.Text.Trim(); st.tel = txttel.Text.Trim(); st.mob = txtmob.Text.Trim(); st.address = txtaddress.Text.Trim(); st.resume = txtresume.Text.Trim(); st.status = txtstatus.Text; st.hesab = long.Parse(txthesab.Text); st.flag = flag; st.photo = photo; st.Add(); std_history sickh = new std_history(); sickh.ghabz_id = "-"; sickh.sharh = "مانده اولیه"; sickh.date = cur_date; sickh.stdno = txtstdno.Text; sickh.tashkhis = txtstatus.Text.Trim(); sickh.mandeh = long.Parse(txthesab.Text); sickh.Add_firstly(); FillDataSetAndView(); BindFields(); // Set the record position // to the one that you saved... objCurrencyManager.Position = objCurrencyManager.Count - 1; // Show the current record position... ShowPosition(); // Display a message that the record was added... toolStripStatusLabel1.Text = "عملیات درج رکورد با موفقیت انجام شد"; // Save the current record position... position = objCurrencyManager.Position.ToString(); btnNew_Click(null, null); }
private void Daryaft() { std_history sh = new std_history(); // Elame bedehkari sh.ghabz_id = txtid.Text; sh.stdno = txtstdno.Text;; sh.sharh = "پرداخت وجه از بابت شهریه " + txtlastcheck.Text + "-" + txtsharh.Text; sh.date = txtdate.Text; sh.bestankari = long.Parse(txtpaid.Text); //sh.tashkhis = status_after; //sh.mandeh = long.Parse(hesab_after); sh.Add(); }
private void pardakht() { std_history sh = new std_history(); // Elame bedehkari sh.ghabz_id = txtid.Text; sh.stdno = txtstdno.Text;; sh.sharh = "شهریه " + txtlastcheck.Text + "-" + txtsharh.Text; sh.date = txtdate.Text; sh.bedehkari = long.Parse(txtmablagh.Text); //sh.tashkhis = status_after; //sh.mandeh = long.Parse(hesab_after); sh.Add(); }
private void fillHistoryInfo() { std_history sickh = new std_history(); DataTable dt = new DataTable(); sickh.stdno = txtstdno.Text; dt = sickh.Select(); grdDataViewHistory.DataSource = dt; grdDataViewHistory.Columns[0].HeaderText = "ردیف"; grdDataViewHistory.Columns[0].Width = 50; grdDataViewHistory.Columns[1].HeaderText = "کد قبض"; grdDataViewHistory.Columns[1].Width = 70; grdDataViewHistory.Columns[2].HeaderText = "شماره هنرجو"; grdDataViewHistory.Columns[2].Width = 100; grdDataViewHistory.Columns[3].HeaderText = "شرح"; grdDataViewHistory.Columns[3].Width = 210; grdDataViewHistory.Columns[4].HeaderText = "تاریخ"; grdDataViewHistory.Columns[4].Width = 70; grdDataViewHistory.Columns[5].HeaderText = "بدهکار"; grdDataViewHistory.Columns[5].Width = 80; grdDataViewHistory.Columns[6].HeaderText = "بستانکار"; grdDataViewHistory.Columns[6].Width = 80; grdDataViewHistory.Columns[7].HeaderText = "تشخیص"; grdDataViewHistory.Columns[7].Width = 80; grdDataViewHistory.Columns[8].HeaderText = "مانده"; grdDataViewHistory.Columns[8].Width = 80; if (grdDataViewHistory.Rows.Count > 0) { grdDataViewHistory.CurrentCell = grdDataViewHistory.Rows[grdDataViewHistory.Rows.Count - 1].Cells[0]; } DataGridViewCellStyle dataGridViewCellStyle1 = new DataGridViewCellStyle(); dataGridViewCellStyle1.BackColor = Color.LightBlue; dataGridViewCellStyle1.Font = new Font("tahoma", 8, FontStyle.Bold); dataGridViewCellStyle1.Format = "N0"; dataGridViewCellStyle1.NullValue = null; grdDataViewHistory.Columns["bedehkari"].DefaultCellStyle = dataGridViewCellStyle1; grdDataViewHistory.Columns["bestankari"].DefaultCellStyle = dataGridViewCellStyle1; grdDataViewHistory.Columns["mandeh"].DefaultCellStyle = dataGridViewCellStyle1; }
private void btndel_Click_1(object sender, EventArgs e) { if (grdDataViewer.CurrentRow != null) { DialogResult dr; dr = MessageBox.Show("آیا از حذف این قبض اطمینان دارید؟", "حذف", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (dr == DialogResult.Yes) { int icol = 0; int irow = grdDataViewer.CurrentRow.Index; string val = grdDataViewer[icol, irow].Value.ToString(); ghabz gha = new ghabz(); gha.id = val; gha.Delete(); std_history st = new std_history(); st.ghabz_id = val; st.stdno = grdDataViewer["stdno", irow].Value.ToString(); st.Delete(); if (btnfilter.Enabled == true) { btnfilter.PerformClick(); } else { ghabz pm = new ghabz(); DataTable dt = new DataTable(); dt = pm.Select(); grdDataViewer.DataSource = dt; } } } }
private void btnfilter_Click(object sender, EventArgs e) { try { Boolean check = false; string SQL = "select * from std_history where "; check = false; if (txtstdno.Text != "") { SQL = SQL + "stdno=N'" + txtstdno.Text.Trim() + "'AND "; check = true; } if (txtfrom_date.MaskCompleted) { SQL = SQL + "date>=N'" + txtfrom_date.Text.Trim() + "'AND "; check = true; } if (txttodate.MaskCompleted) { SQL = SQL + "date<=N'" + txttodate.Text.Trim() + "'AND "; check = true; } if (check == true) { SQL = SQL.Remove(SQL.Length - 4); } std_history sickh = new std_history(); DataTable dt = new DataTable(); dt = sickh.Search(SQL); /////////////////////////////////////////////////////////////////// dataGridView1.DataSource = dt; dataGridView1.Columns[0].HeaderText = "ردیف"; dataGridView1.Columns[0].Width = 50; dataGridView1.Columns[1].HeaderText = "کد قبض"; dataGridView1.Columns[1].Width = 70; dataGridView1.Columns[2].HeaderText = "شماره هنرجو"; dataGridView1.Columns[2].Width = 100; dataGridView1.Columns[3].HeaderText = "شرح"; dataGridView1.Columns[3].Width = 170; dataGridView1.Columns[4].HeaderText = "تاریخ"; dataGridView1.Columns[4].Width = 70; dataGridView1.Columns[5].HeaderText = "بدهکار"; dataGridView1.Columns[5].Width = 80; dataGridView1.Columns[6].HeaderText = "بستانکار"; dataGridView1.Columns[6].Width = 80; dataGridView1.Columns[7].HeaderText = "تشخیص"; dataGridView1.Columns[7].Width = 80; dataGridView1.Columns[8].HeaderText = "مانده"; dataGridView1.Columns[8].Width = 80; std si = new std(); si.stdno = txtstdno.Text; txtname.Text = si.Selectforedit().Rows[0]["name"].ToString(); if (dataGridView1.Rows.Count > 0) { dataGridView1.CurrentCell = dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells[0]; } DataGridViewCellStyle dataGridViewCellStyle1 = new DataGridViewCellStyle(); dataGridViewCellStyle1.BackColor = Color.LightBlue; dataGridViewCellStyle1.Font = new Font("tahoma", 8, FontStyle.Bold); dataGridViewCellStyle1.Format = "N0"; dataGridViewCellStyle1.NullValue = null; dataGridView1.Columns["bedehkari"].DefaultCellStyle = dataGridViewCellStyle1; dataGridView1.Columns["bestankari"].DefaultCellStyle = dataGridViewCellStyle1; dataGridView1.Columns["mandeh"].DefaultCellStyle = dataGridViewCellStyle1; } catch (Exception) { MessageBox.Show("اطلاعاتی موجود نمی باشد!!!"); txtstdno.Text = ""; } }