private void load_data_2_grid()
{
US_RPT_BC_TINH_HINH_GIAI_NGAN v_us = new US_RPT_BC_TINH_HINH_GIAI_NGAN();
DS_RPT_BC_TINH_HINH_GIAI_NGAN v_ds = new DS_RPT_BC_TINH_HINH_GIAI_NGAN();
//v_us.bc_tinh_hinh_giai_ngan_tong_cuc(
// v_ds,
// CIPConvert.ToDatetime(m_txt_tu_ngay.Text, c_configuration.DEFAULT_DATETIME_FORMAT),
// CIPConvert.ToDatetime(m_txt_den_ngay.Text, c_configuration.DEFAULT_DATETIME_FORMAT),
// m_txt_tu_khoa_tim_kiem.Text
//);
m_grv_bao_cao_giai_ngan.DataSource = v_ds.RPT_BC_TINH_HINH_GIAI_NGAN;
m_grv_bao_cao_giai_ngan.DataBind();
}
private void load_data_to_grid()
{
US_RPT_BC_TINH_HINH_GIAI_NGAN v_us = new US_RPT_BC_TINH_HINH_GIAI_NGAN();
DataSet v_ds = new DataSet();
DataTable v_dt = new DataTable();
v_ds.Tables.Add(v_dt);
v_ds.AcceptChanges();
v_us.bc_tinh_hinh_giai_ngan_tong_cuc(v_ds
, CIPConvert.ToDatetime(m_txt_tu_ngay.Text, "dd/MM/yyyy")
, CIPConvert.ToDatetime(m_txt_den_ngay.Text, "dd/MM/yyyy")
);
m_grv.DataSource = v_ds.Tables[0];
m_grv.DataBind();
}
private void load_data_to_grid()
{
xoaCotDong();
DataSet v_ds = new DataSet();
DataTable v_dt = new DataTable();
v_ds.Tables.Add(v_dt);
v_ds.AcceptChanges();
US_RPT_BC_TINH_HINH_GIAI_NGAN v_us = new US_RPT_BC_TINH_HINH_GIAI_NGAN();
v_us.FillDatasetByProc(
v_ds,
"pr_F510_giao_du_toan_theo_loai_khoan_nguon_ns",
CIPConvert.ToDatetime(m_txt_tu_ngay.Text, c_configuration.DEFAULT_DATETIME_FORMAT),
CIPConvert.ToDatetime(m_txt_den_ngay.Text, c_configuration.DEFAULT_DATETIME_FORMAT),
m_txt_tu_khoa_tim_kiem.Text);
addNewColumnToGridView(v_ds);
v_dt = v_ds.Tables[0];
v_dt.Columns.Add("TONG_SO");
v_dt.Columns.Add("THUONG_XUYEN");
v_dt.Columns.Add("KHONG_THUONG_XUYEN");
v_dt.Columns.Add("CMMTQG");
groupData(v_ds);
updateCell(v_dt);
m_grv_bao_cao_giao_von.DataSource = v_dt;
m_grv_bao_cao_giao_von.DataBind();
}
private void load_data_to_grid()
{
// xóa cột động
xoaCotDong();
DataSet v_ds = new DataSet();
DataTable v_dt = new DataTable();
v_ds.Tables.Add(v_dt);
v_ds.AcceptChanges();
US_RPT_BC_TINH_HINH_GIAI_NGAN v_us = new US_RPT_BC_TINH_HINH_GIAI_NGAN();
v_us.FillDatasetByProc(
v_ds
, "pr_F150_giao_du_toan_vp_tong_cuc"
, CIPConvert.ToDatetime(m_txt_tu_ngay.Text, c_configuration.DEFAULT_DATETIME_FORMAT)
, CIPConvert.ToDatetime(m_txt_den_ngay.Text, c_configuration.DEFAULT_DATETIME_FORMAT)
, CIPConvert.ToDecimal(m_ddl_don_vi.SelectedValue)
, m_txt_tu_khoa_tim_kiem.Text
, "Y");
addNewColumnToGridView(v_ds);
v_dt = v_ds.Tables[0];
v_dt.Columns.Add("TONG_SO");
v_dt.Columns.Add("TU_CHU");
v_dt.Columns.Add("KHONG_TU_CHU");
updateCell(v_dt);
m_grv_bao_cao_giao_von.DataSource = v_dt;
m_grv_bao_cao_giao_von.DataBind();
}
private void load_data_to_grid()
{
US_RPT_BC_TINH_HINH_GIAI_NGAN v_us = new US_RPT_BC_TINH_HINH_GIAI_NGAN();
DS_RPT_BC_TINH_HINH_GIAI_NGAN v_ds = new DS_RPT_BC_TINH_HINH_GIAI_NGAN();
v_ds.EnforceConstraints = false;
v_ds.AcceptChanges();
v_us.bc_tinh_hinh_giai_ngan_don_vi(v_ds
, CIPConvert.ToDatetime(m_txt_tu_ngay.Text, "dd/MM/yyyy")
, CIPConvert.ToDatetime(m_txt_den_ngay.Text, "dd/MM/yyyy")
, Person.get_id_don_vi()
, Person.get_user_id());
m_grv.DataSource = v_ds.Tables[0];
m_grv.DataBind();
DateTime v_dat_den_ngay=CIPConvert.ToDatetime(m_txt_den_ngay.Text,"dd/MM/yyyy");
m_lbl_thang.Text = v_dat_den_ngay.Month.ToString();
m_lbl_nam.Text = v_dat_den_ngay.Year.ToString();
}
