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()));
}
}
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();
}
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()));
}
}
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()));
}
}
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);
}
}
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);
}
}
public static void load_data_to_cbo_don_vi(DropDownList op_ddl_don_vi)
{
/*
* Ham load all don vi trong bang dm_don_vi
* Order by ten 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.FillDataset(v_ds, "order by " + DM_DON_VI.TEN_DON_VI);
op_ddl_don_vi.DataTextField = DM_DON_VI.TEN_DON_VI;
op_ddl_don_vi.DataValueField = DM_DON_VI.ID;
op_ddl_don_vi.DataSource = v_ds.DM_DON_VI;
op_ddl_don_vi.DataBind();
}
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 static void load_data_to_cbo_don_vi_su_dung(
decimal ip_dc_id_don_vi_chu_quan
, decimal ip_dc_id_bo_tinh
, eTAT_CA ip_e_tat_ca
, ComboBox ip_obj_cbo_dv_su_dung)
{
if (ip_dc_id_bo_tinh == 0) {
ip_obj_cbo_dv_su_dung.Items.Clear();
return;
}
if (ip_dc_id_don_vi_chu_quan == 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();
v_us_dm_don_vi.FillDataset(
v_ds_dm_don_vi
, ID_LOAI_DON_VI.DV_SU_DUNG
, ip_dc_id_don_vi_chu_quan
, ip_dc_id_bo_tinh
, 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_dv_su_dung.DataSource = v_ds_dm_don_vi.DM_DON_VI;
ip_obj_cbo_dv_su_dung.DisplayMember = DM_DON_VI.TEN_DON_VI;
ip_obj_cbo_dv_su_dung.ValueMember = DM_DON_VI.ID;
}
private void load_cbo_ds_don_vi_duoc_su_dung()
{
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(
CIPConvert.ToDecimal(m_cbo_user_group.SelectedValue)
, true
, v_ds_don_vi);
m_lst_don_vi_user_group.DataSource = v_ds_don_vi.DM_DON_VI;
m_lst_don_vi_user_group.DataTextField = DM_DON_VI.TEN_DON_VI;
m_lst_don_vi_user_group.DataValueField = DM_DON_VI.ID;
m_lst_don_vi_user_group.DataBind();
}
private void load_data_2_cbo_don_vi_su_dung()
{
if (m_cbo_don_vi_chu_quan.SelectedValue == null)
{
m_cbo_don_vi_su_dung.DataSource = null;
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();
v_us_dm_don_vi.FillDataset(v_ds_dm_don_vi, "where " + DM_DON_VI.ID_DON_VI_CAP_TREN + " = " + CIPConvert.ToDecimal(m_cbo_don_vi_chu_quan.SelectedValue));
m_cbo_don_vi_su_dung.DisplayMember = DM_DON_VI.TEN_DON_VI;
m_cbo_don_vi_su_dung.ValueMember = DM_DON_VI.ID;
m_cbo_don_vi_su_dung.SelectedValueChanged -= new EventHandler(m_cbo_bo_tinh_SelectedValueChanged);
m_cbo_don_vi_su_dung.DataSource = v_ds_dm_don_vi.DM_DON_VI;
m_cbo_don_vi_su_dung.SelectedValueChanged += new EventHandler(m_cbo_bo_tinh_SelectedValueChanged);
}
private void load_data_2_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 " + DM_DON_VI.LEVEL_MODE + " = 1");
m_cbo_bo_tinh.DisplayMember = DM_DON_VI.TEN_DON_VI;
m_cbo_bo_tinh.ValueMember = DM_DON_VI.ID;
m_cbo_bo_tinh.SelectedValueChanged -= new EventHandler(m_cbo_bo_tinh_SelectedValueChanged);
m_cbo_bo_tinh.DataSource = v_ds_dm_don_vi.DM_DON_VI;
m_cbo_bo_tinh.SelectedValueChanged += new EventHandler(m_cbo_bo_tinh_SelectedValueChanged);
}