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