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