public static void load_data_to_cbo_bo_tinh( eTAT_CA ip_e_tat_ca , DropDownList ip_obj_cbo_bo_tinh) { US_DM_DON_VI v_us_dm_don_vi = new US_DM_DON_VI(); DS_DM_DON_VI v_ds_dm_don_vi = new DS_DM_DON_VI(); //v_us_dm_don_vi.FillDataset(v_ds_dm_don_vi, "where ID_LOAI_DON_VI = " + ID_LOAI_DON_VI.BO_TINH); string v_str_user_name = HttpContext.Current.Session[SESSION.UserName].ToString(); v_us_dm_don_vi.FillDataset( v_ds_dm_don_vi , ID_LOAI_DON_VI.BO_TINH , CONST_QLDB.ID_TAT_CA , CONST_QLDB.ID_TAT_CA , v_str_user_name); ip_obj_cbo_bo_tinh.DataSource = v_ds_dm_don_vi.DM_DON_VI; ip_obj_cbo_bo_tinh.DataTextField = DM_DON_VI.TEN_DON_VI; ip_obj_cbo_bo_tinh.DataValueField = DM_DON_VI.ID; ip_obj_cbo_bo_tinh.DataBind(); if (ip_e_tat_ca == eTAT_CA.YES) { ip_obj_cbo_bo_tinh.Items.Insert(0, new ListItem(CONST_QLDB.TAT_CA, CONST_QLDB.ID_TAT_CA.ToString())); } }
public static void load_data_to_cbo_bo_tinh( eTAT_CA ip_e_tat_ca , ComboBox ip_obj_cbo_bo_tinh) { US_DM_DON_VI v_us_dm_don_vi = new US_DM_DON_VI(); DS_DM_DON_VI v_ds_dm_don_vi = new DS_DM_DON_VI(); //v_us_dm_don_vi.FillDataset(v_ds_dm_don_vi, "where ID_LOAI_DON_VI = " + ID_LOAI_DON_VI.BO_TINH); string v_str_user_name = HttpContext.Current.Session[SESSION.UserName].ToString(); v_us_dm_don_vi.FillDataset( v_ds_dm_don_vi , ID_LOAI_DON_VI.BO_TINH , CONST_QLDB.ID_TAT_CA , CONST_QLDB.ID_TAT_CA , v_str_user_name); if (ip_e_tat_ca == eTAT_CA.YES) { DataRow v_dr = v_ds_dm_don_vi.DM_DON_VI.NewDM_DON_VIRow(); v_dr[DM_DON_VI.ID] = CONST_QLDB.ID_TAT_CA; v_dr[DM_DON_VI.TEN_DON_VI] = CONST_QLDB.TAT_CA; v_ds_dm_don_vi.DM_DON_VI.Rows.InsertAt(v_dr, 0); } ip_obj_cbo_bo_tinh.DataSource = v_ds_dm_don_vi.DM_DON_VI; ip_obj_cbo_bo_tinh.DisplayMember = DM_DON_VI.TEN_DON_VI; ip_obj_cbo_bo_tinh.ValueMember = DM_DON_VI.ID; }
public string get_ma_don_vi_su_dung() { string v_str_ma_don_vi = ""; if (m_cbo_don_vi_su_dung_tai_san.SelectedValue == null) return v_str_ma_don_vi; if (m_cbo_don_vi_su_dung_tai_san.SelectedValue.Equals(CONST_QLDB.MA_TAT_CA)) return v_str_ma_don_vi; US_DM_DON_VI v_us_dm_don_vi = new US_DM_DON_VI(CIPConvert.ToDecimal(m_cbo_don_vi_su_dung_tai_san.SelectedValue)); return v_us_dm_don_vi.strMA_DON_VI; }
public string get_ten_don_vi_chu_quan() { string v_str_ten_don_vi_chu_quan = ""; if (m_cbo_don_vi_chu_quan.SelectedValue == null) return v_str_ten_don_vi_chu_quan; if (m_cbo_don_vi_chu_quan.SelectedValue.Equals(CONST_QLDB.MA_TAT_CA)) return CONST_QLDB.TAT_CA; US_DM_DON_VI v_us_dm_don_vi = new US_DM_DON_VI(CIPConvert.ToDecimal(m_cbo_don_vi_chu_quan.SelectedValue)); return v_us_dm_don_vi.strTEN_DON_VI; }
protected void m_cmd_xuat_excel_Click(object sender, EventArgs e) { US_DM_DON_VI v_us = new US_DM_DON_VI(Person.get_id_don_vi()); WebformReport.export_gridview_2_excel( m_grv_bao_cao_giao_von , "BaoCaoTongHopDaGiaoDuToan-DaoTao.xls" ); }
private void load_data_to_lst_don_vi(BKI_QLDTEntities ip_db, decimal ip_dc_id_don_vi) { DS_DM_DON_VI v_ds = new DS_DM_DON_VI(); US_DM_DON_VI v_us = new US_DM_DON_VI(); v_us.load_danh_sach_don_vi_X_duoc_xem_du_lieu(ip_dc_id_don_vi, v_ds); m_lst_don_vi = v_ds.Tables[0].ToList<DBClassModel.DM_DON_VI>() .ToList(); }
protected void m_cmd_xuat_excel_Click(object sender, EventArgs e) { US_DM_DON_VI v_us = new US_DM_DON_VI(Person.get_id_don_vi()); WebformReport.export_gridview_2_excel( m_grv , "[" + ConvertToUnsign3(v_us.strTEN_DON_VI) + "]BaoCaoTinhHinhGiaoKeHoach.xls" ); }
private void export_excel() { US_DM_DON_VI v_us = new US_DM_DON_VI(CIPConvert.ToDecimal(m_ddl_don_vi.SelectedValue)); WebformReport.export_gridview_2_excel( m_grv , "[" + v_us.strTEN_DON_VI + "]"+FormInfo.ExportExcelReportName.F290 ); }
private void load_data_to_ddl_ten_don_vi() { US_DM_DON_VI v_us_don_vi = new US_DM_DON_VI(); DS_DM_DON_VI v_ds_don_vi = new DS_DM_DON_VI(); v_us_don_vi.FillDataset(v_ds_don_vi); m_ddl_ten_don_vi.DataTextField = DM_DON_VI.TEN_DON_VI; m_ddl_ten_don_vi.DataValueField = DM_DON_VI.ID; m_ddl_ten_don_vi.DataSource = v_ds_don_vi.DM_DON_VI; m_ddl_ten_don_vi.DataBind(); }
protected void m_cmd_xuat_excel_Click(object sender, EventArgs e) { try { US_DM_DON_VI v_us = new US_DM_DON_VI(CIPConvert.ToDecimal(m_ddl_don_vi.SelectedValue)); WebformReport.export_gridview_2_excel( m_grv , "[" + v_us.strTEN_DON_VI + "]" + FormInfo.ExportExcelReportName.F257 ); } catch (Exception v_e) { CSystemLog_301.ExceptionHandle(this, v_e); } }
// Events protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack) { if (Session[SESSION.AccounLoginYN] != null) { if (Session[SESSION.AccounLoginYN].ToString().Equals("Y")) { if (Session[SESSION.UserID] == null) return; US_DM_DON_VI v_us = new US_DM_DON_VI(Person.get_id_don_vi()); m_lhk_user_name.Text = "Đơn vị: " + v_us.strTEN_DON_VI; m_str_user_name = CIPConvert.ToStr(Session[SESSION.UserName]); if (!IsPostBack) { m_us_ht_chuc_nang.get_parent_table(m_str_user_name, m_ds_ht_chuc_nang); // Lấy toàn bộ các menu cấp 1 được cấp quyền và được hiển thị rptMainMenu.DataSource = m_ds_ht_chuc_nang.HT_CHUC_NANG.Select("CHUC_NANG_PARENT_ID IS NULL AND HIEN_THI_YN='Y'", "VI_TRI"); rptMainMenu.DataBind(); //if (!Person.check_user_have_menu()) //{ // Response.Redirect("/Default.aspx", false); //} } } else { Response.Redirect("/Account/Login.aspx"); } } else { Response.Redirect("/Account/Login.aspx", false); } } } catch (Exception v_e) { //CSystemLog_301.ExceptionHandle(this,v_e); } }
protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack) { DateTime v_dat_now = DateTime.Now; DateTime v_dat_dau_nam = v_dat_now.AddDays(-v_dat_now.Day + 1); v_dat_dau_nam = v_dat_dau_nam.AddMonths(-v_dat_dau_nam.Month + 1); m_txt_tu_ngay.Text = CIPConvert.ToStr(v_dat_dau_nam, "dd/MM/yyyy"); m_txt_den_ngay.Text = CIPConvert.ToStr(v_dat_now, "dd/MM/yyyy"); load_data_to_grid(); } US_DM_DON_VI v_us = new US_DM_DON_VI(Person.get_id_don_vi()); m_lbl_ten_don_vi.Text = v_us.strTEN_DON_VI; } catch (Exception v_e) { CSystemLog_301.ExceptionHandle(this, v_e); } }
public static DataSet get_dataset_muc_tieu_muc_from_data_giao_kh( DateTime ip_dat_tu_ngay , DateTime ip_dat_den_ngay) { /* * Mục tiêu: * Tạo dataset để binding dữ liệu vào dropdownlist * Với dữ liệu CLKM lấy trong dữ liệu bảng Giao vốn * Đặc thù: * Vì để binding vào dropdownlist cần 2 giá trị: Text và Value * Mà: Lại có 3 value: ID Chương, ID Khoản, ID Mục hoặc ID Tiểu Mục cần lấy * 3 value này không quan hệ cha con với nhau * => Phải tạo 1 value mới từ 3 value: ID_MIX = ID_CHUONG|ID_KHOAN|ID_MUC hoặc ID_TIEU_MUC * Tóm tắt: * 1. Khởi tạo US * 2. Tạo DataSet để lưu dữ liệu * 3. Đổ dữ liệu vào dataset vừa tạo */ //1. Khởi tạo US decimal v_dc_id_don_vi = Person.get_id_don_vi(); US_DM_DON_VI v_us = new WebUS.US_DM_DON_VI(); CStoredProc v_sp = new CStoredProc("pr_get_chuong_loai_khoan_muc_tieu_muc_giao_kh"); v_sp.addDatetimeInputParam("@ip_dat_den_ngay", ip_dat_den_ngay); v_sp.addDatetimeInputParam("@ip_dat_tu_ngay", ip_dat_tu_ngay); v_sp.addDecimalInputParam("@ip_dc_id_don_vi", v_dc_id_don_vi); //2. Tạo DataSet để lưu dữ liệu DataSet op_ds = new DataSet(); DataTable v_dt = new DataTable(); //Thêm cột ID_MIX để lưu giá trị mix id_chuong, id_khoan, id_muc hoặc id_tieu_muc v_dt.Columns.Add("ID_MIX"); //Thêm cột DISPLAY hiển thị text của ID_MIX, vd: Loại 220 - 223, Tiểu mục 6000:.... v_dt.Columns.Add("DISPLAY"); op_ds.Tables.Add(v_dt); op_ds.AcceptChanges(); //3. Đổ dữ liệu vào dataset vừa tạo v_sp.fillDataSetByCommand(v_us, op_ds); return op_ds; }
private void load_thong_tin_don_vi_lap_uy_nhiem_chi() { /* * Mục tiêu: Hiển thị thông tin của đơn vị lập uỷ nhiệm chi * Tóm tắt: * 1. Khởi tạo các us cần thiết * 2. Hiển thị thông tin đơn vị * 2.1 Hiển thị thông tin cơ bản của đơn vị * 2.2 Hiển thị số tài khoản của đơn vị thông qua control List Radio Button */ //1. Khởi tạo các us cần thiết US_DM_DON_VI v_us_dv = new US_DM_DON_VI(CIPConvert.ToDecimal(m_ddl_don_vi.SelectedValue)); US_DM_THONG_TIN_DON_VI v_us_ttdv = new US_DM_THONG_TIN_DON_VI(); v_us_ttdv.InitByID_DON_VI(CIPConvert.ToDecimal(m_ddl_don_vi.SelectedValue)); //2. Hiển thị thông tin đơn vị //2.1 Hiển thị thông tin cơ bản của đơn vị m_lbl_dia_chi.Text = v_us_ttdv.strDIA_CHI; m_lbl_tai_kho_bac_nha_nuoc.Text = v_us_ttdv.strKHO_BAC; m_rdb_ma_dvqhns.Text = v_us_ttdv.IsMA_DVQHNSNull() ? "Mã DVQHNS 1" : v_us_ttdv.strMA_DVQHNS; m_rdb_ma_dvqhns_1.Text = v_us_ttdv.IsMA_DVQHNS_1Null() ? "Mã DVQHNS 1" : v_us_ttdv.strMA_DVQHNS_1; m_rdb_ma_dvqhns_2.Text = v_us_ttdv.IsMA_DVQHNS_2Null() ? "Mã DVQHNS 1" : v_us_ttdv.strMA_DVQHNS_2; //m_lbl_ma_dvqhns.Text = v_us_ttdv.strMA_DVQHNS; //2.2 Hiển thị số tài khoản của đơn vị thông qua control List Radio Button /* * Mỗi đơn vị nhiều nhất có 2 tài khoản: 1 tài khoản NS và 1 tài khoản QBT * Item 1: Lưu thông tin tài khoản QBT - tương ứng trường Ma_TKKT_1 trong CSDL * Item 2: Lưu thông tin tài khoản NS - tương ứng với trường Ma_TKKT_2 trong CSDL */ //Xoá tất cả item cũ //m_rbl_ma_tkkt.Items.Clear(); //Nếu đơn vị chưa nhập thông tin tài khoản -> Không thể lập UNC -> Trở về //if (v_us_ttdv.IsMA_TKKT1Null() && v_us_ttdv.IsMA_TKKT2Null()) return; ////Nếu không có tài khoản 2 => Có tài khoản 1 => Hiển thị thông tin tài khoản 1 //if (v_us_ttdv.IsMA_TKKT2Null() | v_us_ttdv.strMA_TKKT2.Trim().Equals("")) //{ // ListItem v_li_1 = new ListItem(v_us_ttdv.strMA_TKKT1); // m_rbl_ma_tkkt.Items.Add(v_li_1); // m_rbl_ma_tkkt.Items[0].Selected = true; //} //else//Trường hợp có cả 2 tài khoản //{ // ListItem v_li_1 = new ListItem(v_us_ttdv.strMA_TKKT1); // ListItem v_li_2 = new ListItem(v_us_ttdv.strMA_TKKT2); // m_rbl_ma_tkkt.Items.Add(v_li_1); // m_rbl_ma_tkkt.Items.Add(v_li_2); // //Đặt mặc định chọn Tài khoản QBT - Ma_TKKT_1 // m_rbl_ma_tkkt.Items[0].Selected = true; //} m_rdb_ma_tkkt_quy.Text = v_us_ttdv.strMA_TKKT1 == "" ? "Mã TKKT Quỹ 1" : v_us_ttdv.strMA_TKKT1; m_rdb_ma_tkkt_quy_2.Text = v_us_ttdv.strMA_TKKT_QBT_2 == "" ? "Mã TKKT Quỹ 2" : v_us_ttdv.strMA_TKKT_QBT_2; m_rdb_ma_tkkt_quy_3.Text = v_us_ttdv.strMA_TKKT_QBT_3 == "" ? "Mã TKKT Quỹ 3" : v_us_ttdv.strMA_TKKT_QBT_3; m_rdb_ma_tkkt_quy_4.Text = v_us_ttdv.strMA_TKKT_QBT_4 == "" ? "Mã TKKT Quỹ 4" : v_us_ttdv.strMA_TKKT_QBT_4; }
private void load_list_don_vi_su_dung() { US_DM_DON_VI v_us_dm_don_vi = new US_DM_DON_VI(); DS_DM_DON_VI v_ds_dm_don_vi = new DS_DM_DON_VI(); string v_id_don_vi_chu_quan = m_ddl_don_vi_chu_quan.SelectedValue; string v_str_user_name = HttpContext.Current.Session[SESSION.UserName].ToString(); v_us_dm_don_vi.FillDataset( v_ds_dm_don_vi , ID_LOAI_DON_VI.DV_SU_DUNG , CIPConvert.ToDecimal(m_ddl_don_vi_chu_quan.SelectedValue) , CONST_QLDB.ID_TAT_CA , v_str_user_name); v_ds_dm_don_vi.EnforceConstraints = false; DataRow v_dr = v_ds_dm_don_vi.DM_DON_VI.NewDM_DON_VIRow(); v_dr[DM_DON_VI.ID] = CONST_QLDB.ID_TAT_CA; v_dr[DM_DON_VI.TEN_DON_VI] = CONST_QLDB.TAT_CA; v_ds_dm_don_vi.DM_DON_VI.Rows.InsertAt(v_dr, 0); m_lst_don_vi_su_dung.DataSource = v_ds_dm_don_vi.DM_DON_VI; m_lst_don_vi_su_dung.DataTextField = DM_DON_VI.TEN_DON_VI; m_lst_don_vi_su_dung.DataValueField = DM_DON_VI.ID; m_lst_don_vi_su_dung.DataBind(); }
public static void load_data_to_cbo_don_vi_su_dung_theo_loai_hinh( string ip_str_loai_hinh_don_vi , string ip_str_id_don_vi_chu_quan , string ip_str_id_bo_tinh , eTAT_CA ip_e_tat_ca , DropDownList ip_obj_cbo_dv_su_dung ) { if (ip_str_id_bo_tinh.Length == 0) { ip_obj_cbo_dv_su_dung.Items.Clear(); return; } if (ip_str_id_don_vi_chu_quan.Length == 0) { ip_obj_cbo_dv_su_dung.Items.Clear(); return; } US_DM_DON_VI v_us_dm_don_vi = new US_DM_DON_VI(); DS_DM_DON_VI v_ds_dm_don_vi = new DS_DM_DON_VI(); string v_str_user_name = HttpContext.Current.Session[SESSION.UserName].ToString(); if (!Person.check_session_valid()) return; decimal v_dc_id_don_vi_chu_quan = CIPConvert.ToDecimal(ip_str_id_don_vi_chu_quan); decimal v_dc_id_bo_tinh = CIPConvert.ToDecimal(ip_str_id_bo_tinh); v_us_dm_don_vi.FillDataset( v_ds_dm_don_vi , ID_LOAI_DON_VI.DV_SU_DUNG , v_dc_id_don_vi_chu_quan , v_dc_id_bo_tinh , ip_str_loai_hinh_don_vi , v_str_user_name); ip_obj_cbo_dv_su_dung.DataSource = v_ds_dm_don_vi.DM_DON_VI; ip_obj_cbo_dv_su_dung.DataTextField = DM_DON_VI.TEN_DON_VI; ip_obj_cbo_dv_su_dung.DataValueField = DM_DON_VI.ID; ip_obj_cbo_dv_su_dung.DataBind(); if (ip_e_tat_ca == eTAT_CA.YES) { ip_obj_cbo_dv_su_dung.Items.Insert(0, new ListItem(CONST_QLDB.TAT_CA, CONST_QLDB.ID_TAT_CA.ToString())); } }
private void update_thong_tin_tai_san(US_DM_NHA op_us_dm_nha) { US_DM_DON_VI v_us_dm_don_vi = new US_DM_DON_VI(); string v_str_ma_don_vi = new Random().Next(1000).ToString(); v_us_dm_don_vi.strMA_DON_VI = v_str_ma_don_vi; v_us_dm_don_vi.dcID_DON_VI_CAP_TREN = ID_DON_VI.DON_VI_CHU_QUAN_KHAC; v_us_dm_don_vi.dcID_LOAI_DON_VI = ID_LOAI_DON_VI.DV_SU_DUNG; v_us_dm_don_vi.dcLEVEL_MODE = 3; v_us_dm_don_vi.strTEN_DON_VI = m_txt_don_vi_nhan_dieu_chuyen.Text.Trim(); v_us_dm_don_vi.strLOAI_HINH_DON_VI = TEN_LOAI_HINH_DON_VI.DON_VI_SU_NGHIEP_CTCTC; v_us_dm_don_vi.Insert(); decimal v_id_don_vi_moi = v_us_dm_don_vi.dcID; v_us_dm_don_vi.strMA_DON_VI = "DVK" + v_id_don_vi_moi.ToString(); v_us_dm_don_vi.Update(); US_HT_QUAN_HE_SU_DUNG_DU_LIEU v_us_ht_qhsddl = new US_HT_QUAN_HE_SU_DUNG_DU_LIEU(); v_us_ht_qhsddl.dcID_DON_VI = v_us_dm_don_vi.dcID; v_us_ht_qhsddl.dcID_USER_GROUP = 2; v_us_ht_qhsddl.Insert(); v_us_ht_qhsddl = new US_HT_QUAN_HE_SU_DUNG_DU_LIEU(); v_us_ht_qhsddl.dcID_DON_VI = v_us_dm_don_vi.dcID; v_us_ht_qhsddl.dcID_USER_GROUP = 5; v_us_ht_qhsddl.Insert(); op_us_dm_nha.dcID_DON_VI_SU_DUNG = v_us_dm_don_vi.dcID; op_us_dm_nha.dcID_DON_VI_CHU_QUAN = ID_DON_VI.DON_VI_CHU_QUAN_KHAC; }
public void export_excel_TH_THSD( TINH_HINH_SU_DUNG ip_str_loai_bao_cao , ref IP.Core.QltsFormControls.CObjExcelAssetParameters op_obj_excel_parameters) { m_obj_trans = get_trans_object(m_fg); US_DM_DON_VI v_us_dm_don_vi_bo_tinh; CExcelWebReport v_obj_exe_report; if (op_obj_excel_parameters.dcID_BO_TINH != CONST_QLDB.ID_TAT_CA) { v_us_dm_don_vi_bo_tinh = new US_DM_DON_VI(op_obj_excel_parameters.dcID_BO_TINH); } else { v_us_dm_don_vi_bo_tinh = new US_DM_DON_VI(); } switch (ip_str_loai_bao_cao) { case TINH_HINH_SU_DUNG.TONG_HOP_CHUNG: v_obj_exe_report = new CExcelWebReport("BC-400 BCTH-THSDTSK-THC.xls", 17, 1); ; load_data_to_grid_thsd_tong_hop_chung(op_obj_excel_parameters); break; case TINH_HINH_SU_DUNG.DON_VI_SU_DUNG: v_obj_exe_report = new CExcelWebReport("BC-400 BCTH-THSDTSK-CT.xls", 17, 1); ; load_data_to_grid_thsd_theo_don_vi(op_obj_excel_parameters); break; default: v_obj_exe_report = new CExcelWebReport("BC-400 BCTH-THSDTSK-THC.xls", 17, 1); ; load_data_to_grid_thsd_tong_hop_chung(op_obj_excel_parameters); break; } v_obj_exe_report.AddFindAndReplaceItem("<BO_TINH>", op_obj_excel_parameters.strTEN_BO_TINH); v_obj_exe_report.AddFindAndReplaceItem("<DON_VI_CHU_QUAN>", op_obj_excel_parameters.strTEN_DON_VI_CHU_QUAN); v_obj_exe_report.AddFindAndReplaceItem("<DON_VI_BO_TINH>", v_us_dm_don_vi_bo_tinh.strTEN_DON_VI); v_obj_exe_report.AddFindAndReplaceItem("<MA_DON_VI>", v_us_dm_don_vi_bo_tinh.strMA_DON_VI); v_obj_exe_report.AddFindAndReplaceItem("<NGAY>", DateTime.Now.Day); v_obj_exe_report.AddFindAndReplaceItem("<THANG>", DateTime.Now.Month); v_obj_exe_report.AddFindAndReplaceItem("<NAM>", DateTime.Now.Year); v_obj_exe_report.FindAndReplace(false); v_obj_exe_report.Export2ExcelWithoutFixedRows(m_fg, 1, m_fg.Cols.Count - 1, true); op_obj_excel_parameters.strFILE_NAME_RESULT = v_obj_exe_report.GetStrOutputFileNameWithPath(); }
public static void load_data_to_cbo_don_vi_chu_quan( string ip_str_id_bo_tinh , eTAT_CA ip_e_tat_ca , DropDownList ip_obj_cbo_dv_chu_quan) { US_DM_DON_VI v_us_dm_don_vi = new US_DM_DON_VI(); DS_DM_DON_VI v_ds_dm_don_vi = new DS_DM_DON_VI(); if (ip_str_id_bo_tinh.Length == 0) { ip_obj_cbo_dv_chu_quan.Items.Clear(); return; } string v_str_user_name = HttpContext.Current.Session[SESSION.UserName].ToString(); decimal v_dc_id_bo_tinh = CIPConvert.ToDecimal(ip_str_id_bo_tinh); v_us_dm_don_vi.FillDataset( v_ds_dm_don_vi , ID_LOAI_DON_VI.DV_CHU_QUAN , v_dc_id_bo_tinh , CONST_QLDB.ID_TAT_CA , v_str_user_name); ip_obj_cbo_dv_chu_quan.DataSource = v_ds_dm_don_vi.DM_DON_VI; ip_obj_cbo_dv_chu_quan.DataTextField = DM_DON_VI.TEN_DON_VI; ip_obj_cbo_dv_chu_quan.DataValueField = DM_DON_VI.ID; ip_obj_cbo_dv_chu_quan.DataBind(); if (ip_e_tat_ca == eTAT_CA.YES) { ip_obj_cbo_dv_chu_quan.Items.Insert(0, new ListItem(CONST_QLDB.TAT_CA, CONST_QLDB.ID_TAT_CA.ToString())); } }
//Select các cbo theo id dơn vị sử dụng khi có id_don_vi_su_dung trên url private void Select_cac_cbo_theo_id_dvsd(decimal ip_id_dvsd) { US_DM_DON_VI v_us_don_vi_su_dung = new US_DM_DON_VI(ip_id_dvsd); US_DM_DON_VI v_us_don_vi_chu_quan = new US_DM_DON_VI(v_us_don_vi_su_dung.dcID_DON_VI_CAP_TREN); m_cbo_bo_tinh.SelectedValue = v_us_don_vi_chu_quan.dcID_DON_VI_CAP_TREN.ToString(); m_cbo_don_vi_chu_quan.SelectedValue = v_us_don_vi_chu_quan.dcID.ToString(); m_cbo_loai_hinh_don_vi.SelectedValue = v_us_don_vi_su_dung.strLOAI_HINH_DON_VI; m_cbo_don_vi_su_dung_tai_san.SelectedValue = ip_id_dvsd.ToString(); reset_thong_bao(); if (Request.QueryString[CONST_QLDB.MA_THAM_SO_URL.LOAI_BAO_CAO].Equals(null)) return; string v_str_id_loai_bao_cao = Request.QueryString[CONST_QLDB.MA_THAM_SO_URL.LOAI_BAO_CAO]; switch (v_str_id_loai_bao_cao) { case "1": WinFormControls.load_data_to_cbo_dia_chi_theo_loai_hinh( CIPConvert.ToDecimal(m_cbo_bo_tinh.SelectedValue) , CIPConvert.ToDecimal(m_cbo_don_vi_chu_quan.SelectedValue) , CIPConvert.ToDecimal(m_cbo_don_vi_su_dung_tai_san.SelectedValue) , ID_TRANG_THAI_DAT.DANG_SU_DUNG , m_cbo_loai_hinh_don_vi.SelectedValue , WinFormControls.eTAT_CA.NO , m_cbo_dia_chi); break; case "2": WinFormControls.load_data_to_cbo_dia_chi_theo_loai_hinh( CIPConvert.ToDecimal(m_cbo_bo_tinh.SelectedValue) , CIPConvert.ToDecimal(m_cbo_don_vi_chu_quan.SelectedValue) , CIPConvert.ToDecimal(m_cbo_don_vi_su_dung_tai_san.SelectedValue) , ID_TRANG_THAI_DAT.DANG_SU_DUNG , m_cbo_loai_hinh_don_vi.SelectedValue , WinFormControls.eTAT_CA.NO , m_cbo_dia_chi); break; case "3": WinFormControls.load_data_to_cbo_dia_chi_theo_loai_hinh( CIPConvert.ToDecimal(m_cbo_bo_tinh.SelectedValue) , CIPConvert.ToDecimal(m_cbo_don_vi_chu_quan.SelectedValue) , CIPConvert.ToDecimal(m_cbo_don_vi_su_dung_tai_san.SelectedValue) , ID_TRANG_THAI_DAT.DANG_SU_DUNG , m_cbo_loai_hinh_don_vi.SelectedValue , WinFormControls.eTAT_CA.YES , m_cbo_dia_chi); break; } m_cmd_loc_du_lieu_Click(m_cmd_loc_du_lieu, EventArgs.Empty); }
private void load_data_to_cbo_bo_tinh() { try { DS_DM_DON_VI v_ds_dm_don_vi = new DS_DM_DON_VI(); US_DM_DON_VI v_us_dm_don_vi = new US_DM_DON_VI(); v_us_dm_don_vi.FillDataset(v_ds_dm_don_vi, "WHERE ID_LOAI_DON_VI = 574"); m_cbo_bo_tinh.DataSource = v_ds_dm_don_vi.DM_DON_VI; m_cbo_bo_tinh.ValueMember = DM_DON_VI.ID; m_cbo_bo_tinh.DisplayMember = DM_DON_VI.TEN_DON_VI; } catch (System.Exception ex) { CSystemLog_301.ExceptionHandle(ex); } }
private void load_data_from_select_don_vi_su_dung() { reset_thong_bao(); if (Request.QueryString[CONST_QLDB.MA_THAM_SO_URL.LOAI_BAO_CAO] == null) { Response.Clear(); Response.Redirect("/QuanLyTaiSan/", false); return; } string v_str_id_loai_bao_cao = Request.QueryString[CONST_QLDB.MA_THAM_SO_URL.LOAI_BAO_CAO]; WinFormControls.eTAT_CA v_e_tat_ca = WinFormControls.eTAT_CA.NO; switch (v_str_id_loai_bao_cao) { case C_STR_LOAI_KE_KHAI: v_e_tat_ca = WinFormControls.eTAT_CA.NO; break; case C_STR_LOAI_DE_NGHI_XU_LY: v_e_tat_ca = WinFormControls.eTAT_CA.NO; break; case C_STR_LOAI_THONG_KE: v_e_tat_ca = WinFormControls.eTAT_CA.YES; break; } WinFormControls.load_data_to_cbo_dia_chi_theo_loai_hinh( CIPConvert.ToDecimal(m_cbo_bo_tinh.SelectedValue) , CIPConvert.ToDecimal(m_cbo_don_vi_chu_quan.SelectedValue) , CIPConvert.ToDecimal(m_cbo_don_vi_su_dung_tai_san.SelectedValue) , ID_TRANG_THAI_DAT.DANG_SU_DUNG , m_cbo_loai_hinh_don_vi.SelectedValue , v_e_tat_ca , m_cbo_dia_chi); US_DM_DON_VI v_us_dm_don_vi = new US_DM_DON_VI(CIPConvert.ToDecimal(m_cbo_don_vi_su_dung_tai_san.SelectedValue)); m_cbo_loai_hinh_don_vi.SelectedValue = v_us_dm_don_vi.strLOAI_HINH_DON_VI; m_pnl_thong_tin_nha_dat.Visible = false; m_grv_nha.Visible = false; }
public void export_excel( eFormMode ip_form_mode , decimal ip_dc_id_dat , ref CObjExcelAssetParameters op_obj_excel_parameters) { //1. Đưa dữ liệu lên trên grid m_obj_trans = get_trans_object(m_fg_nha); m_e_form_mode = ip_form_mode; US_V_DM_DAT v_us_v_dm_dat; if (ip_dc_id_dat != CONST_QLDB.ID_TAT_CA) { v_us_v_dm_dat = new US_V_DM_DAT(ip_dc_id_dat); } else { v_us_v_dm_dat = new US_V_DM_DAT(); } US_DM_DON_VI v_us_dm_don_vi; if (op_obj_excel_parameters.dcID_DON_VI_SU_DUNG != CONST_QLDB.ID_TAT_CA) { v_us_dm_don_vi = new US_DM_DON_VI(op_obj_excel_parameters.dcID_DON_VI_SU_DUNG); } else { v_us_dm_don_vi = new US_DM_DON_VI(); } //2. Xuất dữ liệu ra file excel //CExcelWebReport v_obj_exe_report = new CExcelWebReport("BC-18 Bao cao danh muc tru so lam viec co so hoat dong su nghiep.xls", 21, 1); CExcelWebReport v_obj_exe_report = new CExcelWebReport(); switch (m_e_form_mode) { case eFormMode.KE_KHAI: load_data_2_grid(op_obj_excel_parameters, ip_dc_id_dat); v_obj_exe_report = new CExcelWebReport(TEN_BAO_CAO.BCDM_TSLM_KE_KHAI, 21, 1); break; case eFormMode.DE_NGHI_XU_LY: load_data_2_grid(op_obj_excel_parameters, ip_dc_id_dat); v_obj_exe_report = new CExcelWebReport(TEN_BAO_CAO.BCDM_TSLM_DE_NGHI_XU_LY, 21, 1); break; case eFormMode.THONG_KE: load_data_2_grid(op_obj_excel_parameters, ip_dc_id_dat); v_obj_exe_report = new CExcelWebReport(TEN_BAO_CAO.BCDM_TSLM_THONG_KE, 21, 1); break; default: break; } // Thông tin phần đầu v_obj_exe_report.AddFindAndReplaceItem("<BO_TINH>", op_obj_excel_parameters.strTEN_BO_TINH); v_obj_exe_report.AddFindAndReplaceItem("<DON_VI_CHU_QUAN>", op_obj_excel_parameters.strTEN_DON_VI_CHU_QUAN); v_obj_exe_report.AddFindAndReplaceItem("<DON_VI_SU_DUNG_TAI_SAN>", op_obj_excel_parameters.strTEN_DON_VI_SU_DUNG); v_obj_exe_report.AddFindAndReplaceItem("<MA_DON_VI>", v_us_dm_don_vi.strMA_DON_VI); v_obj_exe_report.AddFindAndReplaceItem("<LOAI_HINH_DON_VI>", op_obj_excel_parameters.strLOAI_HINH_DON_VI); // Thông tin đất v_obj_exe_report.AddFindAndReplaceItem("<DIA_CHI>", v_us_v_dm_dat.strDIA_CHI); v_obj_exe_report.AddFindAndReplaceItem("<DT_KHUON_VIEN>", v_us_v_dm_dat.dcDT_KHUON_VIEN.ToString("#,##0.00")); v_obj_exe_report.AddFindAndReplaceItem("<TRU_SO_LAM_VIEC>", v_us_v_dm_dat.dcDT_TRU_SO_LAM_VIEC.ToString("#,##0.00")); v_obj_exe_report.AddFindAndReplaceItem("<CO_SO_HDSN>", v_us_v_dm_dat.dcDT_CO_SO_HOAT_DONG_SU_NGHIEP.ToString("#,##0.00")); v_obj_exe_report.AddFindAndReplaceItem("<LAM_NHA_O>", v_us_v_dm_dat.dcDT_LAM_NHA_O.ToString("#,##0.00")); v_obj_exe_report.AddFindAndReplaceItem("<CHO_THUE>", v_us_v_dm_dat.dcDT_CHO_THUE.ToString("#,##0.00")); v_obj_exe_report.AddFindAndReplaceItem("<BO_TRONG>", v_us_v_dm_dat.dcDT_BO_TRONG.ToString("#,##0.00")); v_obj_exe_report.AddFindAndReplaceItem("<BI_LAN_CHIEM>", v_us_v_dm_dat.dcDT_BI_LAN_CHIEM.ToString("#,##0.00")); v_obj_exe_report.AddFindAndReplaceItem("<KHAC>", v_us_v_dm_dat.dcDT_SU_DUNG_MUC_DICH_KHAC.ToString("#,##0.00")); v_obj_exe_report.AddFindAndReplaceItem("<GT_THEO_SO_KE_TOAN>", v_us_v_dm_dat.dcGT_THEO_SO_KE_TOAN.ToString("#,##0.00")); // Thông tin phần cuối //v_obj_exe_report.AddFindAndReplaceItem("<HO_SO_GIAY_TO_LIEN_QUAN>", v_us_dm_dat.strDIA_CHI); v_obj_exe_report.AddFindAndReplaceItem("<NGAY>", DateTime.Now.Day); v_obj_exe_report.AddFindAndReplaceItem("<THANG>", DateTime.Now.Month); v_obj_exe_report.AddFindAndReplaceItem("<NAM>", DateTime.Now.Year); // Thông tin bảng v_obj_exe_report.FindAndReplace(false); v_obj_exe_report.Export2ExcelWithoutFixedRows(m_fg_nha, 1, m_fg_nha.Cols.Count - 1, true); //3. Trả về địa chỉ file op_obj_excel_parameters.strFILE_NAME_RESULT = v_obj_exe_report.GetStrOutputFileNameWithPath(); }
void m_cbo_don_vi_su_dung_SelectedValueChanged(object sender, EventArgs e) { try { if (m_cbo_don_vi_su_dung.SelectedValue == null) return; US_DM_DON_VI v_us_dm_don_vi = new US_DM_DON_VI(CIPConvert.ToDecimal(m_cbo_don_vi_su_dung.SelectedValue)); m_txt_loai_hinh_don_vi.Text = v_us_dm_don_vi.strLOAI_HINH_DON_VI; m_txt_ma_don_vi.Text = v_us_dm_don_vi.strMA_DON_VI; if (m_cbo_trang_thai_tai_san.SelectedValue == null) return; load_data_2_grid( CIPConvert.ToDecimal(m_cbo_bo_tinh.SelectedValue) , CIPConvert.ToDecimal(m_cbo_don_vi_chu_quan.SelectedValue) , CIPConvert.ToDecimal(m_cbo_don_vi_su_dung.SelectedValue) , CONST_QLDB.ID_TAT_CA , CIPConvert.ToDecimal(m_cbo_trang_thai_tai_san.SelectedValue) , m_txt_search.Text); } catch (Exception v_e) { CSystemLog_301.ExceptionHandle(v_e); } }
private void load_thong_tin_don_vi() { US_DM_DON_VI v_us_dv = new US_DM_DON_VI(CIPConvert.ToDecimal(m_ddl_don_vi.SelectedValue)); //m_lbl_don_vi_tra_tien.Text = v_us_dv.strTEN_DON_VI; US_DM_THONG_TIN_DON_VI v_us_ttdv = new US_DM_THONG_TIN_DON_VI(); v_us_ttdv.InitByID_DON_VI(CIPConvert.ToDecimal(m_ddl_don_vi.SelectedValue)); m_lbl_dia_chi.Text = v_us_ttdv.strDIA_CHI; m_lbl_tai_kho_bac_nha_nuoc.Text = v_us_ttdv.strKHO_BAC; m_lbl_ma_dvqhns.Text = v_us_ttdv.strMA_DVQHNS; m_rbl_ma_tkkt.Items.Clear(); if (v_us_ttdv.IsMA_TKKT1Null() && v_us_ttdv.IsMA_TKKT2Null()) return; if (v_us_ttdv.IsMA_TKKT2Null() | v_us_ttdv.strMA_TKKT2.Trim().Equals("")) { ListItem v_li_1 = new ListItem(v_us_ttdv.strMA_TKKT1); m_rbl_ma_tkkt.Items.Add(v_li_1); m_rbl_ma_tkkt.Items[0].Selected = true; } else { ListItem v_li_1 = new ListItem(v_us_ttdv.strMA_TKKT1); ListItem v_li_2 = new ListItem(v_us_ttdv.strMA_TKKT2); m_rbl_ma_tkkt.Items.Add(v_li_1); m_rbl_ma_tkkt.Items.Add(v_li_2); m_rbl_ma_tkkt.Items[0].Selected = true; } }
public void export_excel( eFormMode ip_form_mode , ref IP.Core.QltsFormControls.CObjExcelAssetParameters op_obj_excel_parameters ) { //1. Đưa dữ liệu lên trên grid m_obj_trans = get_trans_object(m_fg); m_e_form_mode = ip_form_mode; US_DM_DON_VI v_us_don_vi = new US_DM_DON_VI(); if (op_obj_excel_parameters.dcID_DON_VI_SU_DUNG != CONST_QLDB.ID_TAT_CA) { v_us_don_vi = new US_DM_DON_VI(op_obj_excel_parameters.dcID_DON_VI_SU_DUNG); } else { v_us_don_vi.strTEN_DON_VI = CONST_QLDB.TAT_CA; v_us_don_vi.strLOAI_HINH_DON_VI = CONST_QLDB.TAT_CA; } //2. Xuất dữ liệu ra file excel CExcelWebReport v_obj_exe_report = new CExcelWebReport(); switch (m_e_form_mode) { case eFormMode.KE_KHAI_O_TO: load_data_2_grid( op_obj_excel_parameters.dcID_BO_TINH , op_obj_excel_parameters.dcID_DON_VI_CHU_QUAN , op_obj_excel_parameters.dcID_DON_VI_SU_DUNG , op_obj_excel_parameters.dcID_LOAI_TAI_SAN , ID_TRANG_THAI_OTO.DANG_SU_DUNG , op_obj_excel_parameters.strKEY_SEARCH); v_obj_exe_report = new CExcelWebReport(TEN_BAO_CAO.BCDM_OTO_KE_KHAI, 13, 1); break; case eFormMode.O_TO_DE_NGHI_XU_LY: load_data_2_grid( op_obj_excel_parameters.dcID_BO_TINH , op_obj_excel_parameters.dcID_DON_VI_CHU_QUAN , op_obj_excel_parameters.dcID_DON_VI_SU_DUNG , op_obj_excel_parameters.dcID_LOAI_TAI_SAN , ID_TRANG_THAI_OTO.DE_NGHI_XU_LY , op_obj_excel_parameters.strKEY_SEARCH); v_obj_exe_report = new CExcelWebReport(TEN_BAO_CAO.BCDM_OTO_DE_NGHI_XU_LY, 13, 1); break; case eFormMode.THONG_KE_O_TO: // Chỗ này đang chưa chuẩn vì chưa hiểu sự nghiệp là gì load_data_2_grid( op_obj_excel_parameters.dcID_BO_TINH , op_obj_excel_parameters.dcID_DON_VI_CHU_QUAN , op_obj_excel_parameters.dcID_DON_VI_SU_DUNG , op_obj_excel_parameters.dcID_LOAI_TAI_SAN , op_obj_excel_parameters.dcID_TRANG_THAI_TAI_SAN , op_obj_excel_parameters.strKEY_SEARCH); v_obj_exe_report = new CExcelWebReport(TEN_BAO_CAO.BCDM_OTO_THONG_KE, 13, 1); break; case eFormMode.O_TO_GIAO_DON_VI_SU_NGHIEP: // Chỗ này đang chưa chuẩn vì chưa hiểu sự nghiệp là gì load_data_2_grid( op_obj_excel_parameters.dcID_BO_TINH , op_obj_excel_parameters.dcID_DON_VI_CHU_QUAN , op_obj_excel_parameters.dcID_DON_VI_SU_DUNG , op_obj_excel_parameters.dcID_LOAI_TAI_SAN , ID_TRANG_THAI_OTO.DANG_SU_DUNG , op_obj_excel_parameters.strKEY_SEARCH); v_obj_exe_report = new CExcelWebReport(TEN_BAO_CAO.BCDM_OTO_GIAO_CHO_DON_VI_CONG_LAP_TU_CHU_TAI_CHINH, 13, 1); break; default: break; } v_obj_exe_report.AddFindAndReplaceItem("<BO_TINH>", op_obj_excel_parameters.strTEN_BO_TINH); v_obj_exe_report.AddFindAndReplaceItem("<DON_VI_CHU_QUAN>", op_obj_excel_parameters.strTEN_DON_VI_CHU_QUAN); v_obj_exe_report.AddFindAndReplaceItem("<DON_VI_SU_DUNG_TAI_SAN>", op_obj_excel_parameters.strTEN_DON_VI_SU_DUNG); v_obj_exe_report.AddFindAndReplaceItem("<MA_DON_VI>", v_us_don_vi.strMA_DON_VI); v_obj_exe_report.AddFindAndReplaceItem("<LOAI_HINH_DON_VI>", v_us_don_vi.strLOAI_HINH_DON_VI); v_obj_exe_report.AddFindAndReplaceItem("<NGAY>", DateTime.Now.Day); v_obj_exe_report.AddFindAndReplaceItem("<THANG>", DateTime.Now.Month); v_obj_exe_report.AddFindAndReplaceItem("<NAM>", DateTime.Now.Year); v_obj_exe_report.FindAndReplace(false); v_obj_exe_report.Export2ExcelWithoutFixedRows(m_fg, 1, m_fg.Cols.Count - 1, true); //3. Trả về địa chỉ file op_obj_excel_parameters.strFILE_NAME_RESULT = v_obj_exe_report.GetStrOutputFileNameWithPath(); }
/// <summary> /// Load dữ liệu từ US đổ vào form /// </summary> /// <param name="ip_dm_noi_dung_thanh_toan"></param> private void us_obj_2_form(US_DM_OTO ip_us_oto) { m_hdf_id.Value = ip_us_oto.dcID.ToString(); m_txt_tai_trong.Text = ip_us_oto.dcSO_CHO_NGOI.ToString(); m_txt_ma_ts.Text = ip_us_oto.strMA_TAI_SAN; m_txt_nam_su_dung.Text = ip_us_oto.dcNAM_SU_DUNG.ToString(); m_txt_nam_san_xuat.Text = ip_us_oto.dcNAM_SAN_XUAT.ToString(); m_txt_gia_tri_con_lai.Text = ip_us_oto.dcGIA_TRI_CON_LAI.ToString("#,##0.##"); m_txt_ten_nhan_hieu.Text = ip_us_oto.strNHAN_HIEU; m_txt_nuoc_san_xuat.Text = ip_us_oto.strNUOC_SAN_XUAT; m_txt_bien_kiem_soat.Text = ip_us_oto.strBIEN_KIEM_SOAT; m_txt_chuc_danh_sd_xe.Text = ip_us_oto.strCHUC_DANH_SU_DUNG; m_txt_nguon_goc_xe.Text = ip_us_oto.strNGUON_GOC_XE; m_txt_cong_suat_xe.Text = ip_us_oto.dcCONG_SUAT_XE.ToString(); m_txt_hd_khac.Text = ip_us_oto.dcHD_KHAC.ToString(); m_txt_khong_kinh_doanh.Text = ip_us_oto.dcKHONG_KINH_DOANH.ToString(); m_txt_kinh_doanh.Text = ip_us_oto.dcKINH_DOANH.ToString(); m_txt_nguon_khac.Text = ip_us_oto.dcNGUON_KHAC.ToString("#,##0.##"); m_txt_nguon_ns.Text = ip_us_oto.dcNGUON_NS.ToString("#,##0.##"); m_txt_qlnn.Text = ip_us_oto.dcQLNN.ToString(); m_txt_ten_ts.Text = ip_us_oto.strTEN_TAI_SAN; m_ddl_loai_xe.SelectedValue = ip_us_oto.dcID_LOAI_TAI_SAN.ToString(); US_DM_DON_VI v_us_don_vi = new US_DM_DON_VI(ip_us_oto.dcID_DON_VI_CHU_QUAN); m_ddl_bo_tinh.SelectedValue = v_us_don_vi.dcID_DON_VI_CAP_TREN.ToString(); WinFormControls.load_data_to_cbo_don_vi_chu_quan( m_ddl_bo_tinh.SelectedValue , WinFormControls.eTAT_CA.NO , m_ddl_dv_chu_quan); m_ddl_dv_chu_quan.SelectedValue = ip_us_oto.dcID_DON_VI_CHU_QUAN.ToString(); WinFormControls.load_data_to_cbo_don_vi_su_dung( m_ddl_dv_chu_quan.SelectedValue , m_ddl_bo_tinh.SelectedValue , WinFormControls.eTAT_CA.NO , m_ddl_dv_sd_ts); m_ddl_dv_sd_ts.SelectedValue = ip_us_oto.dcID_DON_VI_SU_DUNG.ToString(); m_ddl_trang_thai_oto.SelectedValue = ip_us_oto.dcID_TRANG_THAI.ToString(); }
private void load_data_to_cbo_don_vi_su_dung() { try { if (m_cbo_don_vi_chu_quan.SelectedValue == null) { m_cbo_don_vi_su_dung.DataSource = null; m_cbo_dia_chi.DataSource = null; return; } DS_DM_DON_VI v_ds_dm_don_vi = new DS_DM_DON_VI(); US_DM_DON_VI v_us_dm_don_vi = new US_DM_DON_VI(); v_us_dm_don_vi.FillDataset(v_ds_dm_don_vi, "where ID_LOAI_DON_VI = 576 and ID_DON_VI_CAP_TREN = " + CIPConvert.ToDecimal(m_cbo_don_vi_chu_quan.SelectedValue)); m_cbo_don_vi_su_dung.DataSource = v_ds_dm_don_vi.DM_DON_VI; m_cbo_don_vi_su_dung.DisplayMember = DM_DON_VI.TEN_DON_VI; m_cbo_don_vi_su_dung.ValueMember = DM_DON_VI.ID; } catch (System.Exception ex) { CSystemLog_301.ExceptionHandle(ex); } }
public void expor_excel_delete( eFormMode ip_form_mode , string ip_str_bo_tinh , string ip_str_don_vi_chu_quan , decimal ip_dc_don_vi_su_dung , ref string op_str_excel_file_name) { //1. Đưa dữ liệu lên trên grid m_obj_trans = get_trans_object(m_fg); m_e_form_mode = ip_form_mode; US_DM_DON_VI v_us_don_vi = new US_DM_DON_VI(); if (ip_dc_don_vi_su_dung != CONST_QLDB.ID_TAT_CA) { v_us_don_vi = new US_DM_DON_VI(ip_dc_don_vi_su_dung); } else { v_us_don_vi.strTEN_DON_VI = CONST_QLDB.TAT_CA; v_us_don_vi.strLOAI_HINH_DON_VI = CONST_QLDB.TAT_CA; } //2. Xuất dữ liệu ra file excel CExcelWebReport v_obj_exe_report = new CExcelWebReport("BC-002 Bao cao ke khai xe o to.xls", 13, 1); ; switch (m_e_form_mode) { case eFormMode.KE_KHAI_O_TO: //load_data_2_grid(ip_dc_don_vi_su_dung, ID_TRANG_THAI_OTO.DANG_SU_DUNG); v_obj_exe_report = new CExcelWebReport("BC-002 Bao cao ke khai xe o to.xls", 13, 1); break; case eFormMode.O_TO_DE_NGHI_XU_LY: //load_data_2_grid(ip_dc_don_vi_su_dung, ID_TRANG_THAI_OTO.DE_NGHI_XU_LY); v_obj_exe_report = new CExcelWebReport("BC-005 Danh muc xe oto de nghi xu ly.xls", 13, 1); break; case eFormMode.O_TO_GIAO_DON_VI_SU_NGHIEP: // Chỗ này đang chưa chuẩn vì chưa hiểu sự nghiệp là gì //load_data_2_grid(ip_dc_don_vi_su_dung, ID_TRANG_THAI_OTO.DANG_SU_DUNG); v_obj_exe_report = new CExcelWebReport("BC-023 Bao cao danh muc xe o to giao cho don vi su nghiep cong lap tu chu tai chinh.xls", 13, 1); break; default: break; } v_obj_exe_report.AddFindAndReplaceItem("<BO_TINH>", ip_str_bo_tinh); v_obj_exe_report.AddFindAndReplaceItem("<DON_VI_CHU_QUAN>", ip_str_don_vi_chu_quan); v_obj_exe_report.AddFindAndReplaceItem("<DON_VI_SU_DUNG_TAI_SAN>", v_us_don_vi.strTEN_DON_VI); v_obj_exe_report.AddFindAndReplaceItem("<MA_DON_VI>", v_us_don_vi.strMA_DON_VI); v_obj_exe_report.AddFindAndReplaceItem("<LOAI_HINH_DON_VI>", v_us_don_vi.strLOAI_HINH_DON_VI); v_obj_exe_report.FindAndReplace(false); v_obj_exe_report.Export2ExcelWithoutFixedRows(m_fg, 1, m_fg.Cols.Count - 1, true); //3. Trả về địa chỉ file op_str_excel_file_name = v_obj_exe_report.GetStrOutputFileNameWithPath(); }
private void load_data_to_grid() { m_grv_danh_sach_tai_san_khac.Visible = true; US_V_DM_TAI_SAN_KHAC m_us_v_tai_san_khac = new US_V_DM_TAI_SAN_KHAC(); DS_V_DM_TAI_SAN_KHAC m_ds_v_tai_san_khac = new DS_V_DM_TAI_SAN_KHAC(); US_DM_DON_VI m_us_don_vi = new US_DM_DON_VI(); DS_DM_DON_VI m_ds_don_vi = new DS_DM_DON_VI(); m_us_v_tai_san_khac.FillDataSetLoadDataToGridTaiSanKhacLoaiHinh(CIPConvert.ToStr(m_txt_tim_kiem.Text) , CIPConvert.ToStr(m_cbo_loai_hinh_don_vi.SelectedValue) , Person.get_user_name() , CIPConvert.ToDecimal(m_cbo_bo_tinh.SelectedValue) , CIPConvert.ToDecimal(m_cbo_don_vi_chu_quan.SelectedValue) , CIPConvert.ToDecimal(m_cbo_don_vi_su_dung_tai_san.SelectedValue) , CIPConvert.ToDecimal(m_cbo_trang_thai.SelectedValue) , CIPConvert.ToDecimal(m_cbo_loai_tai_san.SelectedValue) , m_ds_v_tai_san_khac); m_lbl_title.Text = "DANH MỤC TÀI SẢN KHÁC (TRỪ TRỤ SỞ LÀM VIỆC, CƠ SỞ HOẠT ĐỘNG SỰ NGHIỆP VÀ XE Ô TÔ)"; string v_str_thong_tin = " (Có " + m_ds_v_tai_san_khac.V_DM_TAI_SAN_KHAC.Rows.Count + " bản ghi)"; m_lbl_title.Text += v_str_thong_tin; m_grv_danh_sach_tai_san_khac.DataSource = m_ds_v_tai_san_khac.V_DM_TAI_SAN_KHAC; m_grv_danh_sach_tai_san_khac.DataBind(); }