private void load_data_2_cbo_don_vi_lien_quan()
{
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;
// Linhdh: 2014-05-22: Chọn trường liên quan đến câu hỏi trùng với trường sinh viên đang học
if (m_cbo_truong.SelectedIndex != 0)
{
DataRow[] v_drs = v_ds_tu_dien_dv_lien_quan.CM_DM_TU_DIEN.Select(CM_DM_TU_DIEN.MA_TU_DIEN + "='" + m_cbo_truong.SelectedValue + "'");
decimal v_dc_id = 0;
if (v_drs.Length > 0)
{
v_dc_id = CIPConvert.ToDecimal(v_drs[0][CM_DM_TU_DIEN.ID]);
}
m_cbo_don_vi_lien_quan.SelectedValue = v_dc_id;
}
}
private void load_data_2_cbo_don_vi_truong()
{
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.TO_CHUC_TRUONG, CM_DM_TU_DIEN.MA_TU_DIEN, v_ds_tu_dien_trang_thai);
m_cbo_don_vi_truong.DataSource = v_ds_tu_dien_trang_thai.CM_DM_TU_DIEN;
m_cbo_don_vi_truong.DisplayMember = CM_DM_TU_DIEN.TEN;
m_cbo_don_vi_truong.ValueMember = CM_DM_TU_DIEN.ID;
}
private void load_data_2_cbo_nhom_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.NHOM_CAU_HOI, CM_DM_TU_DIEN.MA_TU_DIEN, v_ds_tu_dien_trang_thai);
m_cbo_nhom_cau_hoi.DataSource = v_ds_tu_dien_trang_thai.CM_DM_TU_DIEN;
m_cbo_nhom_cau_hoi.DisplayMember = CM_DM_TU_DIEN.TEN;
m_cbo_nhom_cau_hoi.ValueMember = CM_DM_TU_DIEN.ID;
}
private void load_data_2_cbo_danh_gia_cau_tra_loi()
{
US_CM_DM_TU_DIEN v_us_tu_dien_danh_gia = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds_tu_dien_danh_gia = new DS_CM_DM_TU_DIEN();
v_us_tu_dien_danh_gia.fill_tu_dien_cung_loai_ds(LOAI_TU_DIEN_TEXT.HANG_DANH_GIA, CM_DM_TU_DIEN.MA_TU_DIEN, v_ds_tu_dien_danh_gia);
m_cbo_danh_gia_tra_loi.DataSource = v_ds_tu_dien_danh_gia.CM_DM_TU_DIEN;
m_cbo_danh_gia_tra_loi.DisplayMember = CM_DM_TU_DIEN.TEN;
m_cbo_danh_gia_tra_loi.ValueMember = CM_DM_TU_DIEN.ID;
}
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_tra_loi()
{
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);
v_ds_tu_dien_trang_thai.CM_DM_TU_DIEN.Rows.RemoveAt(1);
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;
m_cbo_trang_thai_cau_hoi.SelectedIndex = 1;
}
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_DM_CAU_TRA_LOI, 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);
}
public static void load_data_to_cbo_tu_dien(
eLOAI_TU_DIEN ip_e_trang_thai_chuc_vu
, eTAT_CA ip_e_tat_ca
, ComboBox 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_tu_dien = "";
switch (ip_e_trang_thai_chuc_vu)
{
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;
}
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 load_data_2_trang_thai_don_hang()
{
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_DON_HANG
, CM_DM_TU_DIEN.TEN
, v_ds_tu_dien);
m_cbo_trang_thai_don_hang.DataSource = v_ds_tu_dien.CM_DM_TU_DIEN;
m_cbo_trang_thai_don_hang.DisplayMember = CM_DM_TU_DIEN.TEN;
m_cbo_trang_thai_don_hang.ValueMember = CM_DM_TU_DIEN.ID;
m_e_cbo_trang_thai_don_hang = e_cbo_state.DA_FILL_DATA_XONG;
}
private void load_data_2_cbo_loai_hanh_dong()
{
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();
DataRow v_dr = v_ds_cm_dm_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ả";
v_ds_cm_dm_tu_dien.EnforceConstraints = false;
v_us_cm_dm_tu_dien.fill_tu_dien_cung_loai_ds(LOAI_TU_DIEN_TEXT.LOG_LOAI_HANH_DONG
, CM_DM_TU_DIEN.TEN
, v_ds_cm_dm_tu_dien);
v_ds_cm_dm_tu_dien.CM_DM_TU_DIEN.Rows.InsertAt(v_dr, 0);
m_cbo_loai_hanh_dong.DisplayMember = CM_DM_TU_DIEN.TEN;
m_cbo_loai_hanh_dong.ValueMember = CM_DM_TU_DIEN.ID;
m_cbo_loai_hanh_dong.DataSource = v_ds_cm_dm_tu_dien.CM_DM_TU_DIEN;
}
public static void load_data_to_cbo_tu_dien(
eLOAI_TU_DIEN ip_e_trang_thai_chuc_vu
, eTAT_CA ip_e_tat_ca
, ComboBox 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_tu_dien = "";
switch (ip_e_trang_thai_chuc_vu)
{
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;
}
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 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_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_data_2_cbo_loai_cau_hoi_duoi()
{
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_duoi.DataSource = v_ds_tu_dien_truong.CM_DM_TU_DIEN;
m_cbo_loai_cau_hoi_duoi.DisplayMember = CM_DM_TU_DIEN.TEN;
m_cbo_loai_cau_hoi_duoi.ValueMember = CM_DM_TU_DIEN.ID;
}
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;
}
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_grid()
{
try {
m_us_dm_tu_dien.fill_tu_dien_cung_loai_ds(CIPConvert.ToStr(m_cbo_loai_tu_dien_grv.SelectedValue), m_ds_dm_tu_dien);
m_grv_dm_tu_dien.DataSource = m_ds_dm_tu_dien.CM_DM_TU_DIEN;
m_grv_dm_tu_dien.DataBind();
if (m_ds_dm_tu_dien.CM_DM_TU_DIEN.Rows.Count == 0)
{
m_lbl_thong_bao.Text = "Chưa có nội dung thanh toán cho lọai hợp đồng này";
m_lbl_thong_bao.Visible = true;
}
else
{
m_lbl_thong_bao.Visible = false;
}
}
catch (Exception v_e) {
throw v_e;
}
}
private void load_data_2_cbo_nhom_cau_hoi()
{
m_e_trang_thai_load_nhom_cau_hoi = e_trang_thai_load_cbo_nhom_cau_hoi.DANG_FILL_DU_LIEU;
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.NHOM_CAU_HOI, 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ả nhóm--";
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_nhom_cau_hoi.DataSource = v_ds_tu_dien_trang_thai.CM_DM_TU_DIEN;
m_cbo_nhom_cau_hoi.DisplayMember = CM_DM_TU_DIEN.TEN;
m_cbo_nhom_cau_hoi.ValueMember = CM_DM_TU_DIEN.ID;
m_e_trang_thai_load_nhom_cau_hoi = e_trang_thai_load_cbo_nhom_cau_hoi.DA_FILL_XONG_DU_LIEU;
}
private void load_data_2_cbo_don_vi_truong()
{
m_e_trang_thai_load_to_chuc = e_trang_thai_load_cbo_to_chuc.DANG_FILL_DU_LIEU;
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.TO_CHUC_TRUONG, 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ả đơn vị--";
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_don_vi.DataSource = v_ds_tu_dien_trang_thai.CM_DM_TU_DIEN;
m_cbo_don_vi.DisplayMember = CM_DM_TU_DIEN.TEN;
m_cbo_don_vi.ValueMember = CM_DM_TU_DIEN.ID;
m_e_trang_thai_load_to_chuc = e_trang_thai_load_cbo_to_chuc.DA_FILL_XONG_DU_LIEU;
}
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_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_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_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;
}
private void load_data_2_cbo_trang_thai_cau_tra_loi()
{
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_DM_CAU_TRA_LOI, CM_DM_TU_DIEN.MA_TU_DIEN, v_ds_tu_dien_trang_thai);
m_cbo_trang_thai_cau_tra_loi.DataSource = v_ds_tu_dien_trang_thai.CM_DM_TU_DIEN;
m_cbo_trang_thai_cau_tra_loi.DisplayMember = CM_DM_TU_DIEN.TEN;
m_cbo_trang_thai_cau_tra_loi.ValueMember = CM_DM_TU_DIEN.ID;
}
// 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_danh_gia_tu_khach_hang()
{
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.HANG_DANH_GIA
, 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ả --";
v_ds_tu_dien.EnforceConstraints = false;
v_ds_tu_dien.CM_DM_TU_DIEN.Rows.InsertAt(v_dr, 0);
m_cbo_danh_gia_tu_khach_hang.DataSource = v_ds_tu_dien.CM_DM_TU_DIEN;
m_cbo_danh_gia_tu_khach_hang.DisplayMember = CM_DM_TU_DIEN.TEN;
m_cbo_danh_gia_tu_khach_hang.ValueMember = CM_DM_TU_DIEN.ID;
}
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_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_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_cbo_trang_thai_cau_tra_loi()
{
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);
v_ds_tu_dien_trang_thai.CM_DM_TU_DIEN.Rows.RemoveAt(1);
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;
m_cbo_trang_thai_cau_hoi.SelectedIndex = 1;
}
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_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_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_loai_hanh_dong()
{
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();
DataRow v_dr = v_ds_cm_dm_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ả";
v_ds_cm_dm_tu_dien.EnforceConstraints = false;
v_us_cm_dm_tu_dien.fill_tu_dien_cung_loai_ds(LOAI_TU_DIEN_TEXT.LOG_LOAI_HANH_DONG
, CM_DM_TU_DIEN.TEN
, v_ds_cm_dm_tu_dien);
v_ds_cm_dm_tu_dien.CM_DM_TU_DIEN.Rows.InsertAt(v_dr, 0);
m_cbo_loai_hanh_dong.DisplayMember = CM_DM_TU_DIEN.TEN;
m_cbo_loai_hanh_dong.ValueMember = CM_DM_TU_DIEN.ID;
m_cbo_loai_hanh_dong.DataSource = v_ds_cm_dm_tu_dien.CM_DM_TU_DIEN;
}
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_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_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 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_don_vi_lien_quan()
{
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;
// Linhdh: 2014-05-22: Chọn trường liên quan đến câu hỏi trùng với trường sinh viên đang học
if (m_cbo_truong.SelectedIndex != 0)
{
DataRow[] v_drs = v_ds_tu_dien_dv_lien_quan.CM_DM_TU_DIEN.Select(CM_DM_TU_DIEN.MA_TU_DIEN + "='" + m_cbo_truong.SelectedValue + "'");
decimal v_dc_id = 0;
if(v_drs.Length > 0)
v_dc_id = CIPConvert.ToDecimal(v_drs[0][CM_DM_TU_DIEN.ID]);
m_cbo_don_vi_lien_quan.SelectedValue = v_dc_id;
}
}
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);
}
private void load_data_2_cbo_danh_gia_cau_tra_loi()
{
US_CM_DM_TU_DIEN v_us_tu_dien_danh_gia = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds_tu_dien_danh_gia = new DS_CM_DM_TU_DIEN();
v_us_tu_dien_danh_gia.fill_tu_dien_cung_loai_ds(LOAI_TU_DIEN_TEXT.HANG_DANH_GIA, CM_DM_TU_DIEN.MA_TU_DIEN, v_ds_tu_dien_danh_gia);
m_cbo_danh_gia_tra_loi.DataSource = v_ds_tu_dien_danh_gia.CM_DM_TU_DIEN;
m_cbo_danh_gia_tra_loi.DisplayMember = CM_DM_TU_DIEN.TEN;
m_cbo_danh_gia_tra_loi.ValueMember = CM_DM_TU_DIEN.ID;
}
private void load_data_2_loai_thoi_gian_hoan_thanh()
{
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.LOAI_TG_HOAN_THANH
, CM_DM_TU_DIEN.GHI_CHU
, 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ả --";
v_ds_tu_dien.EnforceConstraints = false;
v_ds_tu_dien.CM_DM_TU_DIEN.Rows.InsertAt(v_dr, 0);
m_cbo_tho_han_xu_ly.DataSource = v_ds_tu_dien.CM_DM_TU_DIEN;
m_cbo_tho_han_xu_ly.DisplayMember = CM_DM_TU_DIEN.TEN;
m_cbo_tho_han_xu_ly.ValueMember = CM_DM_TU_DIEN.ID;
}
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();
}
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()));
}
}
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_data_to_cbo_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_NHA, CM_DM_TU_DIEN.GHI_CHU, v_ds_cm_dm_tu_dien);
m_cbo_trang_thai.DisplayMember = CM_DM_TU_DIEN.TEN;
m_cbo_trang_thai.ValueMember = CM_DM_TU_DIEN.ID;
m_cbo_trang_thai.DataSource = v_ds_cm_dm_tu_dien.CM_DM_TU_DIEN;
}
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 void load_data_2_cbo_don_vi_truong()
{
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.PHONG_BAN_NOI_BO, CM_DM_TU_DIEN.MA_TU_DIEN, v_ds_tu_dien_trang_thai);
m_cbo_don_vi_truong.DataSource = v_ds_tu_dien_trang_thai.CM_DM_TU_DIEN;
m_cbo_don_vi_truong.DisplayMember = CM_DM_TU_DIEN.TEN;
m_cbo_don_vi_truong.ValueMember = CM_DM_TU_DIEN.ID;
}
private void load_data_2_loai_trang_thai_don_hang()
{
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_DON_HANG
, CM_DM_TU_DIEN.GHI_CHU
, 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ả --";
v_ds_tu_dien.EnforceConstraints = false;
v_ds_tu_dien.CM_DM_TU_DIEN.Rows.InsertAt(v_dr, 0);
m_cbo_trang_thai_don_hang.DataSource = v_ds_tu_dien.CM_DM_TU_DIEN;
m_cbo_trang_thai_don_hang.DisplayMember = CM_DM_TU_DIEN.TEN;
m_cbo_trang_thai_don_hang.ValueMember = CM_DM_TU_DIEN.ID;
}
// 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_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()));
}
}
