private void cmdadd_Click(object sender, EventArgs e)
{
payments gh = new payments();
gh.id = txtid.Text;
gh.name = txtname.Text.Trim();
gh.date = txtdate.Text;
gh.paidformonth = txtpaidformonth.Text;
gh.mablagh = long.Parse(txtmablagh.Text);
gh.sharh = txtsharh.Text;
gh.Add();
MessageBox.Show("قبض با موفقیت ثبت گردید");
frmPayments_PrintViewer pv = new frmPayments_PrintViewer();
pv.P = gh.Search("select * from payments where (id=" + txtid.Text.Trim() + ")");
pv.Show();
this.Close();
}
private void btnfilter_Click(object sender, EventArgs e)
{
try
{
Boolean check = false;
string SQL = "select * from payments where ";
check = false;
if (txtname.Text != "")
{
SQL = SQL + "name like N'%" + txtname.Text.Trim() + "%'AND ";
check = true;
}
if (txtmos_date.MaskCompleted)
{
checkBox1.Checked = false;
SQL = SQL + "date>=N'" + txtmos_date.Text.Trim() + "'AND ";
check = true;
}
if (txttodate.MaskCompleted)
{
checkBox1.Checked = false;
SQL = SQL + "date<=N'" + txttodate.Text.Trim() + "'AND ";
check = true;
}
if (txtlastdatefrom.MaskCompleted)
{
checkBox1.Checked = false;
SQL = SQL + "paidformonth>=N'" + txtlastdatefrom.Text.Trim() + "'AND ";
check = true;
}
if (txtlastdateto.MaskCompleted)
{
checkBox1.Checked = false;
SQL = SQL + "paidformonth<=N'" + txtlastdateto.Text.Trim() + "'AND ";
check = true;
}
if (checkBox1.Checked)
{
SQL = SQL + "date=N'" + cur_date.Trim() + "'AND ";
check = true;
}
if (check == true)
{
SQL = SQL.Remove(SQL.Length - 4);
}
payments rm = new payments();
DataTable dt = new DataTable();
dt = rm.Search(SQL);
grdDataViewer.DataSource = dt;
}
catch (Exception)
{
MessageBox.Show("لطفا اطلاعات را به صورت درست وارد نمایید!!!");
txtname.Text = "";
}
}