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 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 = ""; } }