private void load_data_2_cbo_quyet_dinh()
{
IP.Core.IPUserService.US_CM_DM_TU_DIEN v_us_dm_tu_dien = new IP.Core.IPUserService.US_CM_DM_TU_DIEN();
IP.Core.IPData.DS_CM_DM_TU_DIEN v_ds_dm_tu_dien = new IP.Core.IPData.DS_CM_DM_TU_DIEN();
v_us_dm_tu_dien.FillDataset(v_ds_dm_tu_dien, "Where ID IN (643,645,646,648,649)");
m_cbo_quyet_dinh.DisplayMember = CM_DM_TU_DIEN.TEN;;
m_cbo_quyet_dinh.ValueMember = CM_DM_TU_DIEN.ID;
m_cbo_quyet_dinh.DataSource = v_ds_dm_tu_dien.CM_DM_TU_DIEN;
}
private void load_data_2_cbo_vi_tri()
{
IP.Core.IPUserService.US_CM_DM_TU_DIEN v_us = new IP.Core.IPUserService.US_CM_DM_TU_DIEN();
IP.Core.IPData.DS_CM_DM_TU_DIEN v_ds = new IP.Core.IPData.DS_CM_DM_TU_DIEN();
v_us.FillDatasetByIdLoaiTuDien(v_ds, (int)e_number.VI_TRI_DU_AN);
m_cbo_vi_tri.DataSource = v_ds.Tables[0];
m_cbo_vi_tri.ValueMember = CM_DM_TU_DIEN.ID;
m_cbo_vi_tri.DisplayMember = CM_DM_TU_DIEN.TEN_NGAN;
}
public static void load_data_to_cbo_tu_dien(
eLOAI_TU_DIEN ip_e
, eTAT_CA ip_e_tat_ca
, ComboBox ip_obj_cbo_trang_thai)
{
IP.Core.IPUserService.US_CM_DM_TU_DIEN v_us_dm_tu_dien = new IP.Core.IPUserService.US_CM_DM_TU_DIEN();
IP.Core.IPData.DS_CM_DM_TU_DIEN v_ds_dm_tu_dien = new IP.Core.IPData.DS_CM_DM_TU_DIEN();
string v_str_loai_tu_dien = "";
switch (ip_e)
{
case eLOAI_TU_DIEN.TRANG_THAI_CHUC_VU:
v_str_loai_tu_dien = MA_LOAI_TU_DIEN.TRANG_THAI_CHUC_VU;
break;
case eLOAI_TU_DIEN.LOAI_HOP_DONG:
v_str_loai_tu_dien = MA_LOAI_TU_DIEN.LOAI_HOP_DONG;
break;
case eLOAI_TU_DIEN.LOAI_DON_VI:
v_str_loai_tu_dien = MA_LOAI_TU_DIEN.LOAI_DON_VI;
break;
case eLOAI_TU_DIEN.CAP_DON_VI:
v_str_loai_tu_dien = MA_LOAI_TU_DIEN.CAP_DON_VI;
break;
case eLOAI_TU_DIEN.LOAI_QUYET_DINH:
v_str_loai_tu_dien = MA_LOAI_TU_DIEN.LOAI_QUYET_DINH;
break;
case eLOAI_TU_DIEN.TRANG_THAI_LAO_DONG:
v_str_loai_tu_dien = MA_LOAI_TU_DIEN.TRANG_THAI_LAO_DONG;
break;
case eLOAI_TU_DIEN.DM_CA_HOC:
v_str_loai_tu_dien = MA_LOAI_TU_DIEN.DM_CA_HOC;
break;
}
v_us_dm_tu_dien.fill_tu_dien_cung_loai_ds(
v_str_loai_tu_dien
, CM_DM_TU_DIEN.GHI_CHU
, v_ds_dm_tu_dien);
ip_obj_cbo_trang_thai.DataSource = v_ds_dm_tu_dien.CM_DM_TU_DIEN;
ip_obj_cbo_trang_thai.DisplayMember = CM_DM_TU_DIEN.TEN;
ip_obj_cbo_trang_thai.ValueMember = CM_DM_TU_DIEN.ID;
if (ip_e_tat_ca == eTAT_CA.YES)
{
DataRow v_dr = v_ds_dm_tu_dien.CM_DM_TU_DIEN.NewRow();
v_dr[CM_DM_TU_DIEN.ID] = -1;
v_dr[CM_DM_TU_DIEN.TEN] = "------ Tất cả ------";
v_dr[CM_DM_TU_DIEN.MA_TU_DIEN] = "";
v_dr[CM_DM_TU_DIEN.TEN_NGAN] = "";
v_dr[CM_DM_TU_DIEN.ID_LOAI_TU_DIEN] = 1;
v_dr[CM_DM_TU_DIEN.GHI_CHU] = "";
v_ds_dm_tu_dien.CM_DM_TU_DIEN.Rows.InsertAt(v_dr, 0);
ip_obj_cbo_trang_thai.SelectedIndex = 0;
}
}
private void tao_cot_trang_thai_grid_don_vi(IP.Core.IPData.DS_CM_DM_TU_DIEN ip_ds_tu_dien)
{
m_fg_donvi.Cols.Count = ip_ds_tu_dien.CM_DM_TU_DIEN.Rows.Count + 4;
m_fg_donvi.Cols[1].Caption = "Mã đơn vị cấp trên";
m_fg_donvi.Cols[1].Visible = false;
m_fg_donvi.Cols[2].Caption = "Mã đơn vị";
m_fg_donvi.Cols[3].Caption = "Tổng";
m_fg_donvi.Cols[3].UserData = 0;
//m_fg.Cols[1].Style.ForeColor = Color.Black;
for (int i = 4; i < m_fg_donvi.Cols.Count; i++)
{
m_fg_donvi.Cols[i].Caption = ip_ds_tu_dien.CM_DM_TU_DIEN.Rows[i - 4][3].ToString();
m_fg_donvi.Cols[i].UserData = ip_ds_tu_dien.CM_DM_TU_DIEN.Rows[i - 4][0];
}
}
private void load_cbo_user_group()
{
try
{
US_CM_DM_TU_DIEN us_cm_tu_dien = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN ds_cm_tu_dien = new DS_CM_DM_TU_DIEN();
us_cm_tu_dien.FillDataset(ds_cm_tu_dien, " WHERE ID_LOAI_TU_DIEN =7");
m_cbo_trang_thai.DataSource = ds_cm_tu_dien.CM_DM_TU_DIEN;
m_cbo_trang_thai.DataTextField = CM_DM_TU_DIEN.TEN_NGAN;
m_cbo_trang_thai.DataValueField = CM_DM_LOAI_TD.ID;
m_cbo_trang_thai.DataBind();
}
catch (Exception v_e)
{
throw v_e;
}
}
private void khoi_tao_grid_don_vi()
{
m_fg_donvi.Clear();
m_fg_donvi.Cols[0].Width = m_width_col;
//DS_V_DM_DON_VI v_ds_v_dm_don_vi = new DS_V_DM_DON_VI();
//US_V_DM_DON_VI v_us_v_dm_don_vi = new US_V_DM_DON_VI();
IP.Core.IPUserService.US_CM_DM_TU_DIEN v_us_dm_tu_dien = new IP.Core.IPUserService.US_CM_DM_TU_DIEN();
IP.Core.IPData.DS_CM_DM_TU_DIEN v_ds_dm_tu_dien = new IP.Core.IPData.DS_CM_DM_TU_DIEN();
v_us_dm_tu_dien.FillDataset(v_ds_dm_tu_dien, "WHERE Id_loai_tu_dien = 5");
//1.tạo danh sách cột trạng thái
tao_cot_trang_thai_grid_don_vi(v_ds_dm_tu_dien);
//m_fg.Cols[0].Width = 150;
//m_fg.Cols[1].Caption = "Trạng thái/Chức vụ";
//2. tạo danh sách dòng trạng thái
tao_dong_don_vi_grid_don_vi();
//v_ds_v_dm_don_vi.Clear();
}
public static void load_data_to_cbo_tu_dien(
eLOAI_TU_DIEN ip_e
, eTAT_CA ip_e_tat_ca
, ComboBox ip_obj_cbo_trang_thai)
{
IP.Core.IPUserService.US_CM_DM_TU_DIEN v_us_dm_tu_dien = new IP.Core.IPUserService.US_CM_DM_TU_DIEN();
IP.Core.IPData.DS_CM_DM_TU_DIEN v_ds_dm_tu_dien = new IP.Core.IPData.DS_CM_DM_TU_DIEN();
string v_str_loai_tu_dien = "";
switch (ip_e)
{
case eLOAI_TU_DIEN.TRANG_THAI_CHUC_VU:
v_str_loai_tu_dien = MA_LOAI_TU_DIEN.TRANG_THAI_CHUC_VU;
break;
case eLOAI_TU_DIEN.LOAI_HOP_DONG:
v_str_loai_tu_dien = MA_LOAI_TU_DIEN.LOAI_HOP_DONG;
break;
case eLOAI_TU_DIEN.LOAI_DON_VI:
v_str_loai_tu_dien = MA_LOAI_TU_DIEN.LOAI_DON_VI;
break;
case eLOAI_TU_DIEN.CAP_DON_VI:
v_str_loai_tu_dien = MA_LOAI_TU_DIEN.CAP_DON_VI;
break;
case eLOAI_TU_DIEN.LOAI_QUYET_DINH:
v_str_loai_tu_dien = MA_LOAI_TU_DIEN.LOAI_QUYET_DINH;
break;
case eLOAI_TU_DIEN.TRANG_THAI_LAO_DONG:
v_str_loai_tu_dien = MA_LOAI_TU_DIEN.TRANG_THAI_LAO_DONG;
break;
case eLOAI_TU_DIEN.NGACH:
v_str_loai_tu_dien = MA_LOAI_TU_DIEN.NGACH;
break;
case eLOAI_TU_DIEN.LOAI_CHUC_VU:
v_str_loai_tu_dien = MA_LOAI_TU_DIEN.LOAI_CHUC_VU;
break;
case eLOAI_TU_DIEN.TRANG_THAI_HOP_DONG:
v_str_loai_tu_dien = MA_LOAI_TU_DIEN.TRANG_THAI_HOP_DONG;
break;
case eLOAI_TU_DIEN.TRANG_THAI_DU_AN:
v_str_loai_tu_dien = MA_LOAI_TU_DIEN.TRANG_THAI_DU_AN;
break;
case eLOAI_TU_DIEN.MA_HOP_DONG:
v_str_loai_tu_dien = MA_LOAI_TU_DIEN.MA_HOP_DONG;
break;
case eLOAI_TU_DIEN.DANH_HIEU:
v_str_loai_tu_dien = MA_LOAI_TU_DIEN.DANH_HIEU;
break;
case eLOAI_TU_DIEN.CO_CHE:
v_str_loai_tu_dien = MA_LOAI_TU_DIEN.CO_CHE;
break;
case eLOAI_TU_DIEN.LOAI_DU_AN:
v_str_loai_tu_dien = MA_LOAI_TU_DIEN.LOAI_DU_AN;
break;
case eLOAI_TU_DIEN.MA_QUYET_DINH:
v_str_loai_tu_dien = MA_LOAI_TU_DIEN.MA_QUYET_DINH;
break;
case eLOAI_TU_DIEN.DIA_BAN:
v_str_loai_tu_dien = MA_LOAI_TU_DIEN.DIA_BAN;
break;
}
v_us_dm_tu_dien.fill_tu_dien_cung_loai_ds(
v_str_loai_tu_dien
, CM_DM_TU_DIEN.GHI_CHU
, v_ds_dm_tu_dien);
ip_obj_cbo_trang_thai.DisplayMember = CM_DM_TU_DIEN.TEN;
ip_obj_cbo_trang_thai.ValueMember = CM_DM_TU_DIEN.ID;
ip_obj_cbo_trang_thai.DataSource = v_ds_dm_tu_dien.CM_DM_TU_DIEN;
if (ip_e_tat_ca == eTAT_CA.YES)
{
DataRow v_dr = v_ds_dm_tu_dien.CM_DM_TU_DIEN.NewRow();
v_dr[CM_DM_TU_DIEN.ID] = -1;
v_dr[CM_DM_TU_DIEN.TEN] = "------ Tất cả ------";
v_dr[CM_DM_TU_DIEN.MA_TU_DIEN] = "";
v_dr[CM_DM_TU_DIEN.TEN_NGAN] = "";
v_dr[CM_DM_TU_DIEN.ID_LOAI_TU_DIEN] = 1;
v_dr[CM_DM_TU_DIEN.GHI_CHU] = "";
v_ds_dm_tu_dien.CM_DM_TU_DIEN.Rows.InsertAt(v_dr, 0);
ip_obj_cbo_trang_thai.SelectedIndex = 0;
}
}
public static void load_data_to_ddl_loai_nhiem_vu_unc(
DateTime ip_dat_tu_ngay
, DateTime ip_dat_den_ngay
, decimal ip_dc_id_don_Vi
, DropDownList op_ddl)
{
US_CM_DM_TU_DIEN v_us = new IP.Core.IPUserService.US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds = new DS_CM_DM_TU_DIEN();
CStoredProc v_sp = new IP.Core.IPUserService.CStoredProc("pr_cm_dm_tu_dien_get_loai_nhiem_vu_unc");
v_sp.addDatetimeInputParam("@ip_dat_tu_ngay", ip_dat_tu_ngay);
v_sp.addDatetimeInputParam("@ip_dat_den_ngay", ip_dat_den_ngay);
v_sp.addDecimalInputParam("@ip_dc_id_don_vi", ip_dc_id_don_Vi);
v_sp.fillDataSetByCommand(v_us, v_ds);
op_ddl.DataTextField = CM_DM_TU_DIEN.TEN;
op_ddl.DataValueField = CM_DM_TU_DIEN.ID;
op_ddl.DataSource = v_ds.CM_DM_TU_DIEN;
op_ddl.DataBind();
}
public static void load_data_to_ddl_loai_nhiem_vu(DropDownList op_ddl, bool ip_b_is_nguon_ns, bool ip_b_is_chi_du_an)
{
/*
* Tác dụng: Load dữ liệu Loại nhiệm vụ theo điều kiện sau:
* 1. Nguồn Quỹ BT
* - Chi Dự án: Dữ liệu A - Bảo dưỡng..., B - Sửa chữa định kỳ, C -.., D -..., E - ..., F - Văn phòng cục
* - Chi theo CLKM: như Chi Dự án, mặc định chọn F - Văn phòng Cục
* 2. Nguồn Ngân Sách
* - Chi Dự án: A - ..., B - ..., C -..., D - ..., E - ..., F - ...
* - Chi theo CLKM: I - Thu, chi, nộp ngân sách phí, lệ phí; II - Dự toán chi ngân sách nhà nước;
* Mặc định chọn II và không cho chọn option khác
* Giải pháp:
* 1. Fill data vào dataset theo điều kiện trên
* 2. Convert lại dữ liệu: ghép tên: Sửa chữa thường xuyên, ghi chú: A -> A - Sửa chữa thường xuyên
* 3. Fill data vào dropdownlist
* 4. Đặt giá trị mặc định cho dropdownlist
*/
US_CM_DM_TU_DIEN v_us = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds = new DS_CM_DM_TU_DIEN();
//1. Fill data vào dataset
if (ip_b_is_chi_du_an)//Chi Dự án
{
v_us.FillDataset(v_ds, "where " + CM_DM_TU_DIEN.ID_LOAI_TU_DIEN + "=" + ID_LOAI_TU_DIEN.LOAI_NHIEM_VU +
"order by " + CM_DM_TU_DIEN.GHI_CHU);
}
else//Chi theo CLKM - Chương Loại Khoản Mục
{
if (!ip_b_is_nguon_ns)//Nguồn Quỹ BT
{
v_us.FillDataset(v_ds, "where " + CM_DM_TU_DIEN.ID_LOAI_TU_DIEN + "=" + ID_LOAI_TU_DIEN.LOAI_NHIEM_VU +
"order by " + CM_DM_TU_DIEN.GHI_CHU);
}
else//Nguồn Ngân sách
{
v_us.FillDataset(v_ds, "where " + CM_DM_TU_DIEN.ID_LOAI_TU_DIEN + "=" + ID_LOAI_TU_DIEN.LOAI_NHIEM_VU_NS +
"order by " + CM_DM_TU_DIEN.GHI_CHU);
}
}
//2. Convert dữ liệu
string v_str_data_default = "---Chọn loại nhiệm vụ---";
for (int i = 0; i < v_ds.CM_DM_TU_DIEN.Count; i++)
{
v_ds.Tables[0].Rows[i][CM_DM_TU_DIEN.TEN] = v_ds.Tables[0].Rows[i][CM_DM_TU_DIEN.GHI_CHU].ToString() + " - " +
v_ds.Tables[0].Rows[i][CM_DM_TU_DIEN.TEN];
v_ds.AcceptChanges();
}
//3. Fill dữ liệu vào dropdownlist
op_ddl.DataTextField = CM_DM_TU_DIEN.TEN;
op_ddl.DataValueField = CM_DM_TU_DIEN.ID;
op_ddl.DataSource = v_ds.CM_DM_TU_DIEN;
op_ddl.DataBind();
op_ddl.Items.Insert(0, new ListItem(v_str_data_default, "-1"));
op_ddl.Enabled = true;
//4. Đặt giá trị mặc định cho dropdownlist
if (!ip_b_is_chi_du_an)//Chi theo CLKM
if (!ip_b_is_nguon_ns)//Nguồn Quỹ BT
{
//op_ddl.SelectedValue = ID_LOAI_NHIEM_VU.VAN_PHONG_CUC.ToString();
}
else
{
op_ddl.SelectedValue = ID_LOAI_NHIEM_VU_NS.DU_TOAN_CHI_NS_NN.ToString();
op_ddl.Enabled = false;
}
}
// Load dữ liệu vào list loại báo cáo
private void load_data_loai_bao_cao()
{
US_CM_DM_TU_DIEN v_us_dm_tu_dien = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds_dm_tu_dien = new DS_CM_DM_TU_DIEN();
v_us_dm_tu_dien.fill_tu_dien_cung_loai_ds(
MA_LOAI_TU_DIEN.LOAI_BAO_CAO
, CM_DM_TU_DIEN.GHI_CHU
, v_ds_dm_tu_dien);
m_lst_loai_bao_cao.DataSource = v_ds_dm_tu_dien.CM_DM_TU_DIEN;
m_lst_loai_bao_cao.DataTextField = CM_DM_TU_DIEN.TEN;
m_lst_loai_bao_cao.DataValueField = CM_DM_TU_DIEN.ID;
m_lst_loai_bao_cao.DataBind();
}
private void load_data_2_cbo_trang_thai_oto()
{
US_CM_DM_TU_DIEN v_us_cm_dm_tu_dien = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds_cm_dm_tu_dien = new DS_CM_DM_TU_DIEN();
v_us_cm_dm_tu_dien.fill_tu_dien_cung_loai_ds(MA_LOAI_TU_DIEN.TRANG_THAI_OTO, v_ds_cm_dm_tu_dien);
m_cbo_trang_thai_tai_san.DisplayMember = CM_DM_TU_DIEN.TEN;
m_cbo_trang_thai_tai_san.ValueMember = CM_DM_TU_DIEN.ID;
m_cbo_trang_thai_tai_san.SelectedValueChanged -= new EventHandler(m_cbo_bo_tinh_SelectedValueChanged);
m_cbo_trang_thai_tai_san.DataSource = v_ds_cm_dm_tu_dien.CM_DM_TU_DIEN;
m_cbo_trang_thai_tai_san.SelectedValueChanged += new EventHandler(m_cbo_bo_tinh_SelectedValueChanged);
}
public static void load_data_to_cbo_loai_hinh_don_vi(
eLOAI_TU_DIEN ip_e_trang_thai_tai_san
, eTAT_CA ip_e_tat_ca
, DropDownList ip_obj_cbo_trang_thai)
{
US_CM_DM_TU_DIEN v_us_dm_tu_dien = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds_dm_tu_dien = new DS_CM_DM_TU_DIEN();
string v_str_loai_trang_thai = "";
v_str_loai_trang_thai = MA_LOAI_TU_DIEN.LOAI_HINH_DON_VI;
v_us_dm_tu_dien.fill_tu_dien_cung_loai_ds(
v_str_loai_trang_thai
, CM_DM_TU_DIEN.GHI_CHU
, v_ds_dm_tu_dien);
ip_obj_cbo_trang_thai.DataSource = v_ds_dm_tu_dien.CM_DM_TU_DIEN;
ip_obj_cbo_trang_thai.DataTextField = CM_DM_TU_DIEN.TEN;
ip_obj_cbo_trang_thai.DataValueField = CM_DM_TU_DIEN.MA_TU_DIEN;
ip_obj_cbo_trang_thai.DataBind();
if (ip_e_tat_ca == eTAT_CA.YES)
{
ip_obj_cbo_trang_thai.Items.Insert(0, new ListItem(CONST_QLDB.TAT_CA, CONST_QLDB.ID_TAT_CA.ToString()));
}
}
private void load_data_2_cbo_loai_cau_hoi_tren()
{
m_e_trangThai_cbo_Nhom_cau_hoi = e_trangThai_cbo_Nhom_cau_hoi.DANG_FILL_DATA;
US_CM_DM_TU_DIEN v_us_tu_dien_truong = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds_tu_dien_truong = new DS_CM_DM_TU_DIEN();
v_us_tu_dien_truong.fill_tu_dien_cung_loai_ds(LOAI_TU_DIEN_TEXT.NHOM_CAU_HOI, CM_DM_TU_DIEN.MA_TU_DIEN, v_ds_tu_dien_truong);
DataRow v_dr = v_ds_tu_dien_truong.CM_DM_TU_DIEN.NewCM_DM_TU_DIENRow();
v_dr[CM_DM_TU_DIEN.ID] = "0";
v_dr[CM_DM_TU_DIEN.MA_TU_DIEN] = "- Tất cả -";
v_dr[CM_DM_TU_DIEN.TEN] = "- Tất cả -";
v_ds_tu_dien_truong.EnforceConstraints = false;
v_ds_tu_dien_truong.CM_DM_TU_DIEN.Rows.InsertAt(v_dr, 0);
m_cbo_loai_cau_hoi_tren.DataSource = v_ds_tu_dien_truong.CM_DM_TU_DIEN;
m_cbo_loai_cau_hoi_tren.DisplayMember = CM_DM_TU_DIEN.TEN;
m_cbo_loai_cau_hoi_tren.ValueMember = CM_DM_TU_DIEN.ID;
m_e_trangThai_cbo_Nhom_cau_hoi = e_trangThai_cbo_Nhom_cau_hoi.DA_FILL_XONG;
}
private Hashtable get_data_map_trang_thai()
{
US_CM_DM_TU_DIEN v_us = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds = new DS_CM_DM_TU_DIEN();
v_us.fill_tu_dien_cung_loai_ds(LOAI_TU_DIEN_TEXT.TRANG_THAI_GD_CAU_HOI_SV, CM_DM_TU_DIEN.MA_TU_DIEN, v_ds);
Hashtable v_htb = new Hashtable();
foreach (DS_CM_DM_TU_DIEN.CM_DM_TU_DIENRow v_tu_dien in v_ds.CM_DM_TU_DIEN.Rows)
{
v_htb.Add(v_tu_dien[CM_DM_TU_DIEN.ID], v_tu_dien[CM_DM_TU_DIEN.TEN]);
}
return v_htb;
}
private void load_data_2_cbo_truong()
{
US_CM_DM_TU_DIEN v_us_tu_dien = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds_tu_dien = new DS_CM_DM_TU_DIEN();
string v_str_loai_tu_dien = LOAI_TU_DIEN_ID.TO_CHUC_TRUONG.ToString();
v_us_tu_dien.fill_tu_dien_by_procedure("pr_CM_DM_TU_DIEN_Load_tu_dien_by_procedure", v_str_loai_tu_dien, v_ds_tu_dien);
m_cbo_truong.DataTextField = CM_DM_TU_DIEN.MA_TU_DIEN;
m_cbo_truong.DataValueField = CM_DM_TU_DIEN.TEN_NGAN;
m_cbo_truong.DataSource = v_ds_tu_dien.CM_DM_TU_DIEN;
m_cbo_truong.DataBind();
}
private void load_data_trang_thai()
{
DS_CM_DM_TU_DIEN v_ds_cm_dm_tu_dien = new DS_CM_DM_TU_DIEN();
US_CM_DM_TU_DIEN v_us_cm_dm_tu_dien = new US_CM_DM_TU_DIEN();
v_us_cm_dm_tu_dien.fill_tu_dien_cung_loai_ds(MA_LOAI_TU_DIEN.TRANG_THAI_DAT, CM_DM_TU_DIEN.GHI_CHU, v_ds_cm_dm_tu_dien);
m_cbo_trang_thai_dat_up.DataSource = v_ds_cm_dm_tu_dien.CM_DM_TU_DIEN;
m_cbo_trang_thai_dat_up.DataTextField = CM_DM_TU_DIEN.TEN;
m_cbo_trang_thai_dat_up.DataValueField = CM_DM_TU_DIEN.ID;
m_cbo_trang_thai_dat_up.DataBind();
m_cbo_trang_thai_dat_up.SelectedValue = ID_TRANG_THAI_DAT.DANG_SU_DUNG.ToString();
}
private void load_data_to_cbo_loai_don_vi()
{
DS_CM_DM_TU_DIEN v_ds_cm_dm_tu_dien = new DS_CM_DM_TU_DIEN();
US_CM_DM_TU_DIEN v_us_cm_dm_tu_dien = new US_CM_DM_TU_DIEN();
v_us_cm_dm_tu_dien.fill_tu_dien_cung_loai_ds(
MA_LOAI_TU_DIEN.LOAI_DON_VI
, v_ds_cm_dm_tu_dien);
m_cbo_loai_don_vi.DataSource = v_ds_cm_dm_tu_dien.CM_DM_TU_DIEN;
m_cbo_loai_don_vi.DataValueField = CM_DM_TU_DIEN.ID;
m_cbo_loai_don_vi.DataTextField = CM_DM_TU_DIEN.TEN;
m_cbo_loai_don_vi.DataBind();
m_cbo_loai_don_vi.Enabled = false;
}
private void load_cbo_loai_don_vi()
{
try
{
US_CM_DM_TU_DIEN m_us = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN m_ds = new DS_CM_DM_TU_DIEN();
m_us.FillDataset(m_ds, "WHERE ID_LOAI_TU_DIEN = 4");
m_cbo_loai_hinh_don_vi.DataSource = m_ds.CM_DM_TU_DIEN;
m_cbo_loai_hinh_don_vi.DataTextField = CM_DM_TU_DIEN.TEN_NGAN;
m_cbo_loai_hinh_don_vi.DataValueField = CM_DM_TU_DIEN.ID;
m_cbo_loai_hinh_don_vi.DataBind();
}
catch (Exception v_e)
{
throw v_e;
}
}
global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs)
{
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
DS_CM_DM_TU_DIEN ds = new DS_CM_DM_TU_DIEN();
global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny();
any1.Namespace = "http://www.w3.org/2001/XMLSchema";
any1.MinOccurs = new decimal(0);
any1.MaxOccurs = decimal.MaxValue;
any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any1);
global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny();
any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
any2.MinOccurs = new decimal(1);
any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any2);
global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute();
attribute1.Name = "namespace";
attribute1.FixedValue = ds.Namespace;
type.Attributes.Add(attribute1);
global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute();
attribute2.Name = "tableTypeName";
attribute2.FixedValue = "CM_DM_TU_DIENDataTable";
type.Attributes.Add(attribute2);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace))
{
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try
{
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator();
while (schemas.MoveNext())
{
schema = (global::System.Xml.Schema.XmlSchema) schemas.Current;
s2.SetLength(0);
schema.Write(s2);
if (s1.Length == s2.Length)
{
s1.Position = 0;
s2.Position = 0;
while ((s1.Position != s1.Length)
&& (s1.ReadByte() == s2.ReadByte()))
{
}
if (s1.Position == s1.Length)
{
return type;
}
}
}
}
finally
{
if (!((s1) == null))
{
s1.Close();
}
if (!((s2) == null))
{
s2.Close();
}
}
}
xs.Add(dsSchema);
return type;
}
global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs)
{
DS_CM_DM_TU_DIEN ds = new DS_CM_DM_TU_DIEN();
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny();
any.Namespace = ds.Namespace;
sequence.Items.Add(any);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace))
{
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try
{
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator();
while (schemas.MoveNext())
{
schema = (global::System.Xml.Schema.XmlSchema) schemas.Current;
s2.SetLength(0);
schema.Write(s2);
if (s1.Length == s2.Length)
{
s1.Position = 0;
s2.Position = 0;
while ((s1.Position != s1.Length)
&& (s1.ReadByte() == s2.ReadByte()))
{
}
if (s1.Position == s1.Length)
{
return type;
}
}
}
}
finally
{
if (!((s1) == null))
{
s1.Close();
}
if (!((s2) == null))
{
s2.Close();
}
}
}
xs.Add(dsSchema);
return type;
}
private void load_data_2_cbo_truong()
{
US_CM_DM_TU_DIEN v_us_tu_dien_truong = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds_tu_dien_truong = new DS_CM_DM_TU_DIEN();
v_us_tu_dien_truong.fill_tu_dien_cung_loai_ds(LOAI_TU_DIEN_TEXT.TO_CHUC_TRUONG, CM_DM_TU_DIEN.MA_TU_DIEN, v_ds_tu_dien_truong);
DataRow v_dr = v_ds_tu_dien_truong.CM_DM_TU_DIEN.NewCM_DM_TU_DIENRow();
v_dr[CM_DM_TU_DIEN.TEN] = "------";
v_dr[CM_DM_TU_DIEN.MA_TU_DIEN] = "------";
v_ds_tu_dien_truong.EnforceConstraints = false;
v_ds_tu_dien_truong.CM_DM_TU_DIEN.Rows.InsertAt(v_dr, 0);
m_cbo_truong.DataSource = v_ds_tu_dien_truong.CM_DM_TU_DIEN;
m_cbo_truong.DisplayMember = CM_DM_TU_DIEN.TEN;
m_cbo_truong.ValueMember = CM_DM_TU_DIEN.MA_TU_DIEN;
}
private void load_data_2_grid()
{
m_ds = new DS_CM_DM_TU_DIEN();
switch (m_e_form_mode)
{
case e_formMode.VIEW_TOAN_BO:
m_us.fill_tu_dien_cung_loai_ds(LOAI_TU_DIEN_TEXT.PHONG_BAN_NOI_BO, CM_DM_TU_DIEN.ID, m_ds);
break;
case e_formMode.VIEW_QLHT:
m_us.fill_tu_dien_by_procedure("pr_CM_DM_TU_DIEN_Load_Phong_QLHT", "", m_ds);
break;
}
m_fg.Redraw = false;
CGridUtils.Dataset2C1Grid(m_ds, m_fg, m_obj_trans);
m_fg.Redraw = true;
load_data_2_grid_nguoi_dai_dien(0);
private void load_cbo_truong()
{
US_CM_DM_TU_DIEN v_us_tu_dien = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds_tu_dien = new DS_CM_DM_TU_DIEN();
string v_str_loai_tu_dien = LOAI_TU_DIEN_ID.TO_CHUC_TRUONG.ToString();
v_us_tu_dien.fill_tu_dien_by_procedure("pr_CM_DM_TU_DIEN_Load_tu_dien_by_procedure", v_str_loai_tu_dien, v_ds_tu_dien);
m_cbo_qlht_truong.DisplayMember = CM_DM_TU_DIEN.TEN;
m_cbo_qlht_truong.ValueMember = CM_DM_TU_DIEN.MA_TU_DIEN;
m_cbo_qlht_truong.DataSource = v_ds_tu_dien.CM_DM_TU_DIEN;
}
private void load_data_2_cbo_don_vi_lien_quan()
{
m_e_trangThai_cbo_Don_vi = e_trangThai_cbo_Don_vi.DANG_FILL_DATA;
US_CM_DM_TU_DIEN v_us_tu_dien_dv_lien_quan = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds_tu_dien_dv_lien_quan = new DS_CM_DM_TU_DIEN();
v_us_tu_dien_dv_lien_quan.fill_tu_dien_cung_loai_ds(LOAI_TU_DIEN_TEXT.TO_CHUC_TRUONG, CM_DM_TU_DIEN.MA_TU_DIEN, v_ds_tu_dien_dv_lien_quan);
DataRow v_dr = v_ds_tu_dien_dv_lien_quan.CM_DM_TU_DIEN.NewCM_DM_TU_DIENRow();
v_dr[CM_DM_TU_DIEN.ID] = "0";
v_dr[CM_DM_TU_DIEN.MA_TU_DIEN] = "- Tất cả -";
v_dr[CM_DM_TU_DIEN.TEN] = "- Tất cả -";
v_ds_tu_dien_dv_lien_quan.EnforceConstraints = false;
v_ds_tu_dien_dv_lien_quan.CM_DM_TU_DIEN.Rows.InsertAt(v_dr, 0);
m_cbo_don_vi_lien_quan.DataSource = v_ds_tu_dien_dv_lien_quan.CM_DM_TU_DIEN;
m_cbo_don_vi_lien_quan.DisplayMember = CM_DM_TU_DIEN.TEN;
m_cbo_don_vi_lien_quan.ValueMember = CM_DM_TU_DIEN.ID;
m_e_trangThai_cbo_Don_vi = e_trangThai_cbo_Don_vi.DA_FILL_XONG;
}
private void load_cbo_truong_sinh_vien()
{
US_CM_DM_TU_DIEN v_us_tu_dien = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds_tu_dien = new DS_CM_DM_TU_DIEN();
v_us_tu_dien.fill_tu_dien_cung_loai_ds(LOAI_TU_DIEN_TEXT.TO_CHUC_TRUONG, CM_DM_TU_DIEN.ID, v_ds_tu_dien);
m_cbo_sv_truong.DisplayMember = CM_DM_TU_DIEN.MA_TU_DIEN;
m_cbo_sv_truong.ValueMember = CM_DM_TU_DIEN.TEN;
m_cbo_sv_truong.DataSource = v_ds_tu_dien.CM_DM_TU_DIEN;
}
private void load_data_2_cbo_trang_thai_cau_hoi()
{
US_CM_DM_TU_DIEN v_us_tu_dien = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds_tu_dien = new DS_CM_DM_TU_DIEN();
v_us_tu_dien.fill_tu_dien_cung_loai_ds(LOAI_TU_DIEN_TEXT.TRANG_THAI_GD_CAU_HOI_SV, CM_DM_TU_DIEN.ID, v_ds_tu_dien);
DataRow v_dr = v_ds_tu_dien.CM_DM_TU_DIEN.NewCM_DM_TU_DIENRow();
v_dr[CM_DM_TU_DIEN.ID] = "0";
v_dr[CM_DM_TU_DIEN.TEN] = "-- Tất cả trạng thái --";
v_ds_tu_dien.EnforceConstraints = false;
v_ds_tu_dien.CM_DM_TU_DIEN.Rows.InsertAt(v_dr, 0);
m_cbo_trang_thai.DataValueField = CM_DM_TU_DIEN.ID;
m_cbo_trang_thai.DataTextField = CM_DM_TU_DIEN.TEN;
m_cbo_trang_thai.DataSource = v_ds_tu_dien.CM_DM_TU_DIEN;
m_cbo_trang_thai.DataBind();
}
private void load_data_2_cbo_don_vi_noi_bo()
{
m_e_trang_thai_cbo_dv = e_trang_thai_cbo_don_vi.DANG_FILL_DATA;
US_CM_DM_TU_DIEN v_us_tu_dien_trang_thai = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds_tu_dien_trang_thai = new DS_CM_DM_TU_DIEN();
DataRow v_dr = v_ds_tu_dien_trang_thai.CM_DM_TU_DIEN.NewCM_DM_TU_DIENRow();
v_dr[CM_DM_TU_DIEN.ID] = "0";
v_dr[CM_DM_TU_DIEN.TEN] = "-- Chọn đơn vị liên quan --";
v_ds_tu_dien_trang_thai.EnforceConstraints = false;
v_us_tu_dien_trang_thai.fill_tu_dien_cung_loai_ds(LOAI_TU_DIEN_TEXT.PHONG_BAN_NOI_BO, CM_DM_TU_DIEN.MA_TU_DIEN, v_ds_tu_dien_trang_thai);
v_ds_tu_dien_trang_thai.CM_DM_TU_DIEN.Rows.InsertAt(v_dr, 0);
m_cbo_don_vi_noi_bo.DataSource = v_ds_tu_dien_trang_thai.CM_DM_TU_DIEN;
m_cbo_don_vi_noi_bo.DisplayMember = CM_DM_TU_DIEN.TEN;
m_cbo_don_vi_noi_bo.ValueMember = CM_DM_TU_DIEN.ID;
m_e_trang_thai_cbo_dv = e_trang_thai_cbo_don_vi.DA_FILL_XONG;
}
private void load_data_2_cbo_trang_thai_cau_hoi()
{
US_CM_DM_TU_DIEN v_us_tu_dien_trang_thai = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds_tu_dien_trang_thai = new DS_CM_DM_TU_DIEN();
v_us_tu_dien_trang_thai.fill_tu_dien_cung_loai_ds(LOAI_TU_DIEN_TEXT.TRANG_THAI_GD_CAU_HOI_SV, CM_DM_TU_DIEN.MA_TU_DIEN, v_ds_tu_dien_trang_thai);
DataRow v_dr = v_ds_tu_dien_trang_thai.CM_DM_TU_DIEN.NewCM_DM_TU_DIENRow();
v_dr[CM_DM_TU_DIEN.ID] = "0";
v_dr[CM_DM_TU_DIEN.TEN] = "-- Tất cả --";
v_ds_tu_dien_trang_thai.EnforceConstraints = false;
v_ds_tu_dien_trang_thai.CM_DM_TU_DIEN.Rows.InsertAt(v_dr, 0);
m_cbo_trang_thai_cau_hoi.DataSource = v_ds_tu_dien_trang_thai.CM_DM_TU_DIEN;
m_cbo_trang_thai_cau_hoi.DisplayMember = CM_DM_TU_DIEN.TEN;
m_cbo_trang_thai_cau_hoi.ValueMember = CM_DM_TU_DIEN.ID;
}
private void load_data_2_trang_thai_thanh_toan()
{
US_CM_DM_TU_DIEN v_us_tu_dien = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds_tu_dien = new DS_CM_DM_TU_DIEN();
v_us_tu_dien.fill_tu_dien_cung_loai_ds(LOAI_TU_DIEN_TEXT.TRANG_THAI_LUONG_ONL
, CM_DM_TU_DIEN.TEN
, v_ds_tu_dien);
DataRow v_dr = v_ds_tu_dien.CM_DM_TU_DIEN.NewCM_DM_TU_DIENRow();
v_dr[CM_DM_TU_DIEN.ID] = 0;
v_dr[CM_DM_TU_DIEN.TEN] = "- Tất cả trạng thái -";
v_ds_tu_dien.EnforceConstraints = false;
v_ds_tu_dien.CM_DM_TU_DIEN.Rows.InsertAt(v_dr, 0);
m_cbo_trang_thai_thanh_toan.DataSource = v_ds_tu_dien.CM_DM_TU_DIEN;
m_cbo_trang_thai_thanh_toan.DisplayMember = CM_DM_TU_DIEN.TEN;
m_cbo_trang_thai_thanh_toan.ValueMember = CM_DM_TU_DIEN.ID;
m_e_cbo_trang_thai_tt_state = e_cbo_state_data.DA_FILL_DATA_XONG;
}
private void load_data_2_cbo_truong()
{
US_CM_DM_TU_DIEN v_us_tu_dien_truong = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds_tu_dien_truong = new DS_CM_DM_TU_DIEN();
v_us_tu_dien_truong.fill_tu_dien_cung_loai_ds(LOAI_TU_DIEN_TEXT.TO_CHUC_TRUONG, CM_DM_TU_DIEN.MA_TU_DIEN, v_ds_tu_dien_truong);
m_cbo_truong.DataSource = v_ds_tu_dien_truong.CM_DM_TU_DIEN;
m_cbo_truong.DisplayMember = CM_DM_TU_DIEN.TEN;
m_cbo_truong.ValueMember = CM_DM_TU_DIEN.TEN_NGAN;
}
private void load_data_2_truong_quan_ly()
{
US_CM_DM_TU_DIEN v_us_tu_dien = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds_tu_dien = new DS_CM_DM_TU_DIEN();
v_us_tu_dien.fill_tu_dien_cung_loai_ds(LOAI_TU_DIEN_TEXT.DON_VI_QUAN_LY_CHINH
, CM_DM_TU_DIEN.TEN
, v_ds_tu_dien);
DataRow v_dr = v_ds_tu_dien.CM_DM_TU_DIEN.NewCM_DM_TU_DIENRow();
v_dr[CM_DM_TU_DIEN.ID] = 0;
v_dr[CM_DM_TU_DIEN.TEN] = "- Chọn một trường quản lý -";
v_ds_tu_dien.EnforceConstraints = false;
v_ds_tu_dien.CM_DM_TU_DIEN.Rows.InsertAt(v_dr, 0);
m_cbo_dv_quan_ly.DataSource = v_ds_tu_dien.CM_DM_TU_DIEN;
m_cbo_dv_quan_ly.DisplayMember = CM_DM_TU_DIEN.TEN;
m_cbo_dv_quan_ly.ValueMember = CM_DM_TU_DIEN.ID;
}
public static void load_data_to_cbo_tu_dien(
eLOAI_TU_DIEN ip_e_trang_thai_tai_san
, eTAT_CA ip_e_tat_ca
, DropDownList ip_obj_cbo_trang_thai)
{
US_CM_DM_TU_DIEN v_us_dm_tu_dien = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds_dm_tu_dien = new DS_CM_DM_TU_DIEN();
string v_str_loai_trang_thai = "";
switch (ip_e_trang_thai_tai_san)
{
case eLOAI_TU_DIEN.TRANG_THAI_DAT:
v_str_loai_trang_thai = MA_LOAI_TU_DIEN.TRANG_THAI_DAT;
break;
case eLOAI_TU_DIEN.TRANG_THAI_NHA:
v_str_loai_trang_thai = MA_LOAI_TU_DIEN.TRANG_THAI_NHA;
break;
case eLOAI_TU_DIEN.TRANG_THAI_OTO:
v_str_loai_trang_thai = MA_LOAI_TU_DIEN.TRANG_THAI_OTO;
break;
case eLOAI_TU_DIEN.TRANG_THAI_TAI_SAN_KHAC:
v_str_loai_trang_thai = MA_LOAI_TU_DIEN.TRANG_THAI_TAI_SAN_KHAC;
break;
case eLOAI_TU_DIEN.LOAI_HINH_DON_VI:
v_str_loai_trang_thai = MA_LOAI_TU_DIEN.LOAI_HINH_DON_VI;
break;
case eLOAI_TU_DIEN.PHAN_LOAI_TAI_SAN:
v_str_loai_trang_thai = MA_LOAI_TU_DIEN.PHAN_LOAI_TAI_SAN;
break;
case eLOAI_TU_DIEN.LOAI_BAO_CAO:
v_str_loai_trang_thai = MA_LOAI_TU_DIEN.LOAI_BAO_CAO;
break;
case eLOAI_TU_DIEN.TINH_TRANG_TAI_SAN:
v_str_loai_trang_thai = MA_LOAI_TU_DIEN.TINH_TRANG_TAI_SAN;
break;
case eLOAI_TU_DIEN.LY_DO_TANG_GIAM_TS:
v_str_loai_trang_thai = MA_LOAI_TU_DIEN.LY_DO_TANG_GIAM_TS;
break;
}
v_us_dm_tu_dien.fill_tu_dien_cung_loai_ds(
v_str_loai_trang_thai
, CM_DM_TU_DIEN.GHI_CHU
, v_ds_dm_tu_dien);
ip_obj_cbo_trang_thai.DataSource = v_ds_dm_tu_dien.CM_DM_TU_DIEN;
ip_obj_cbo_trang_thai.DataTextField = CM_DM_TU_DIEN.TEN;
ip_obj_cbo_trang_thai.DataValueField = CM_DM_TU_DIEN.ID;
ip_obj_cbo_trang_thai.DataBind();
if (ip_e_tat_ca == eTAT_CA.YES)
{
ip_obj_cbo_trang_thai.Items.Insert(0, new ListItem(CONST_QLDB.TAT_CA, CONST_QLDB.ID_TAT_CA.ToString()));
}
}
public static void load_data_to_cbo_tu_dien(
string ip_str_ma_loai_tu_dien
, eTAT_CA ip_e_tat_ca
, DropDownList ip_obj_cbo_trang_thai)
{
US_CM_DM_TU_DIEN v_us_dm_tu_dien = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds_dm_tu_dien = new DS_CM_DM_TU_DIEN();
v_us_dm_tu_dien.fill_tu_dien_cung_loai_ds(
ip_str_ma_loai_tu_dien
, CM_DM_TU_DIEN.GHI_CHU
, v_ds_dm_tu_dien);
ip_obj_cbo_trang_thai.DataSource = v_ds_dm_tu_dien.CM_DM_TU_DIEN;
ip_obj_cbo_trang_thai.DataTextField = CM_DM_TU_DIEN.TEN;
ip_obj_cbo_trang_thai.DataValueField = CM_DM_TU_DIEN.ID;
ip_obj_cbo_trang_thai.DataBind();
if (ip_e_tat_ca == eTAT_CA.YES)
{
ip_obj_cbo_trang_thai.Items.Insert(0, new ListItem(CONST_GIAO_DICH.STR_VALUE_TAT_CA, CONST_GIAO_DICH.ID_TAT_CA.ToString()));
}
}
// Load dữ liệu vào combo trạng thái
private void load_data_trang_thai()
{
try
{
DS_CM_DM_TU_DIEN v_ds_cm_dm_tu_dien = new DS_CM_DM_TU_DIEN();
US_CM_DM_TU_DIEN v_us_cm_dm_tu_dien = new US_CM_DM_TU_DIEN();
v_us_cm_dm_tu_dien.fill_tu_dien_cung_loai_ds(MA_LOAI_TU_DIEN.TRANG_THAI_OTO, CM_DM_TU_DIEN.GHI_CHU, v_ds_cm_dm_tu_dien);
m_ddl_trang_thai_oto.DataSource = v_ds_cm_dm_tu_dien.CM_DM_TU_DIEN;
m_ddl_trang_thai_oto.DataTextField = CM_DM_TU_DIEN.TEN;
m_ddl_trang_thai_oto.DataValueField = CM_DM_TU_DIEN.ID;
m_ddl_trang_thai_oto.DataBind();
}
catch (Exception v_e)
{
throw v_e;
}
}
public static void load_data_to_ddl_loai_nhiem_vu(DropDownList op_ddl)
{
US_CM_DM_TU_DIEN v_us = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds = new DS_CM_DM_TU_DIEN();
v_us.FillDataset(v_ds, "where " + CM_DM_TU_DIEN.ID_LOAI_TU_DIEN + "=" + ID_LOAI_TU_DIEN.LOAI_NHIEM_VU_NS +
"order by " + CM_DM_TU_DIEN.GHI_CHU);
string v_str_data_default = "---Chọn loại nhiệm vụ---";
for (int i = 0; i < v_ds.CM_DM_TU_DIEN.Count; i++)
{
v_ds.Tables[0].Rows[i][CM_DM_TU_DIEN.TEN] = v_ds.Tables[0].Rows[i][CM_DM_TU_DIEN.GHI_CHU].ToString() + " - " +
v_ds.Tables[0].Rows[i][CM_DM_TU_DIEN.TEN];
v_ds.AcceptChanges();
}
op_ddl.DataTextField = CM_DM_TU_DIEN.TEN;
op_ddl.DataValueField = CM_DM_TU_DIEN.ID;
op_ddl.DataSource = v_ds.CM_DM_TU_DIEN;
op_ddl.DataBind();
op_ddl.Items.Insert(0, new ListItem(v_str_data_default, "-1"));
}
