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(); }