private void btn_delete_Click(object sender, EventArgs e)
{
RPT.rpt_supplaye_code rpc = new RPT.rpt_supplaye_code();
RPT.rpt_supplay_date rpd = new RPT.rpt_supplay_date();
RPT.rpt_supplay_b2d b2d = new RPT.rpt_supplay_b2d();
RPT.frm_report frm_rep = new RPT.frm_report();
// بحث حسب رقم الصرف
if (chk_suplye_code.Checked)
{
rpc.SetDataSource(RS.SEARCH_RE_SUPPLYE_1(txt_serch.Text));
frm_rep.crystalReportViewer1.ReportSource = rpc;
frm_rep.ShowDialog();
}
// بحث حسب التاريخ
if (chk_date.Checked)
{
rpd.SetDataSource(RS.SEARCH_RE_SUPPLYE_4(dt_date.Value));
frm_rep.crystalReportViewer1.ReportSource = rpd;
frm_rep.ShowDialog();
}
// بحث حسب بين تاريخين
if (chk_b2d.Checked)
{
b2d.SetDataSource(RS.SEARCH_RE_SUPPLYE_3(dt_from.Value, dt_to.Value));
frm_rep.crystalReportViewer1.ReportSource = b2d;
frm_rep.ShowDialog();
}
}
private void btn_delete_Click(object sender, EventArgs e)
{
RPT.rpt_first_qty qty = new RPT.rpt_first_qty();
RPT.frm_report frm = new RPT.frm_report();
qty.SetDataSource(RS.GET_FIRST_QTE_PRINT(Convert.ToDateTime(this.dgv_supplye.CurrentRow.Cells[0].Value.ToString())));
frm.crystalReportViewer1.ReportSource = qty;
frm.ShowDialog();
}
//طباعة المحدد
private void bunifuFlatButton6_Click(object sender, EventArgs e)
{
RPT.rpt_spend_1 rsp1 = new RPT.rpt_spend_1();
RPT.frm_report frm = new RPT.frm_report();
rsp1.SetDataSource(RS.SEARCH_RE_SPEND_1(this.dgv_spend.CurrentRow.Cells[1].Value.ToString()));
frm.crystalReportViewer1.ReportSource = rsp1;
frm.ShowDialog();
}
private void bunifuThinButton21_Click(object sender, EventArgs e)
{
RPT.rpt_palance_1 rpt_1 = new RPT.rpt_palance_1();
RPT.frm_report frm1 = new RPT.frm_report();
DateTime date_1 = Convert.ToDateTime(this.dgv_balance.CurrentRow.Cells[0].Value.ToString());
rpt_1.SetDataSource(rpt.GET_ALL_PALANCE_DETAILS(date_1));
frm1.crystalReportViewer1.ReportSource = rpt_1;
frm1.ShowDialog();
}
private void btn_print_all_Click(object sender, EventArgs e)
{
RPT.rpt_inv_details rpt_1 = new RPT.rpt_inv_details();
RPT.frm_report frm1 = new RPT.frm_report();
rpt_1.SetDataSource(rep.RPT_SALES_POINT(Convert.ToDateTime(dgv_date.CurrentRow.Cells[0].Value.ToString())));
frm1.crystalReportViewer1.ReportSource = rpt_1;
frm1.ShowDialog();
}
private void bunifuThinButton21_Click(object sender, EventArgs e)
{
RPT.rpt_sales_point rpt_1 = new RPT.rpt_sales_point();
RPT.frm_report frm1 = new RPT.frm_report();
rpt_1.SetDataSource(rep.GET_INV_CODE(Convert.ToDateTime(dgv_date.CurrentRow.Cells[0].Value.ToString())));
frm1.crystalReportViewer1.ReportSource = rpt_1;
frm1.ShowDialog();
}
private void btn_search_Click(object sender, EventArgs e)
{
RPT.rpt_products rpt_1 = new RPT.rpt_products();
RPT.frm_report frm1 = new RPT.frm_report();
rpt_1.SetDataSource(rpt.GET_ALL_PRODUCT());
frm1.crystalReportViewer1.ReportSource = rpt_1;
frm1.ShowDialog();
}
private void btn_delete_Click(object sender, EventArgs e)
{
RPT.rpt_spend_b2d rep = new RPT.rpt_spend_b2d();
RPT.rpt_spend_code spc = new RPT.rpt_spend_code();
RPT.rpt_spend_date rpd = new RPT.rpt_spend_date();
RPT.rpt_spend_dep rpdp = new RPT.rpt_spend_dep();
RPT.frm_report frm_rep = new RPT.frm_report();
// بحث حسب تاريخ معين
if (chk_b2d.Checked)
{
rep.SetDataSource(RS.SEARCH_RE_SPEND_3(dt_from.Value, dt_to.Value));
frm_rep.crystalReportViewer1.ReportSource = rep;
frm_rep.ShowDialog();
}
if (chk_date.Checked)
{
rpd.SetDataSource(RS.SEARCH_RE_SPEND_4(dt_date.Value));
frm_rep.crystalReportViewer1.ReportSource = rpd;
frm_rep.ShowDialog();
}
// بحث حسب رقم الصرف
if (chk_spend_code.Checked)
{
spc.SetDataSource(RS.SEARCH_RE_SPEND_1(txt_serch.Text));
frm_rep.crystalReportViewer1.ReportSource = spc;
frm_rep.ShowDialog();
}
// بحث حسب القسم
if (chk_dep.Checked)
{
rpdp.SetDataSource(RS.SEARCH_RE_SPEND_2(Convert.ToInt32(cmb_department.SelectedValue)));
frm_rep.crystalReportViewer1.ReportSource = rpdp;
frm_rep.ShowDialog();
}
}
private void btn_print_all_Click(object sender, EventArgs e)
{
RPT.rpt_category_dep cdp = new RPT.rpt_category_dep();
RPT.rpt_cat_sub_cat csc = new RPT.rpt_cat_sub_cat();
RPT.frm_report frm_rep = new RPT.frm_report();
if (chk_dep.Checked)
{
cdp.SetDataSource(RS.SEARCH_RE_CAT_DEP(Convert.ToInt32(cmb_dep.SelectedValue)));
frm_rep.crystalReportViewer1.ReportSource = cdp;
frm_rep.ShowDialog();
}
if (chk_category.Checked)
{
cdp.SetDataSource(RS.SEARCH_RE_CAT_SUB_CAT(Convert.ToInt32(cmb_category.SelectedValue)));
frm_rep.crystalReportViewer1.ReportSource = cdp;
frm_rep.ShowDialog();
}
}