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