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