private void load_data_2_sle_chon_vi_tri() { m_sle_chon_vi_tri.EditValue = null; US_DM_CHUC_VU v_us = new US_DM_CHUC_VU(); DS_DM_CHUC_VU v_ds = new DS_DM_CHUC_VU(); v_us.FillDataset(v_ds, " where id_don_vi = " + Convert.ToDecimal(m_sle_chon_don_vi.EditValue)); m_sle_chon_vi_tri.Properties.DataSource = v_ds.Tables[0]; }
private bool check_ma_cv_da_ton_tai() { US_DM_CHUC_VU v_us = new US_DM_CHUC_VU(); DS_DM_CHUC_VU v_ds = new DS_DM_CHUC_VU(); v_us.FillDataset(v_ds, "where ma_chuc_vu = N'" + m_txt_ma_chuc_vu.Text +"'"); if (m_us.strMA_CHUC_VU != m_txt_ma_chuc_vu.Text && v_ds.Tables[0].Rows.Count !=0) { return true; } return false; }
private bool check_cv_dang_su_dung(decimal ip_id_don_vi) { US_DM_CHUC_VU v_us = new US_DM_CHUC_VU(); DS_DM_CHUC_VU v_ds = new DS_DM_CHUC_VU(); v_us.FillDataset(v_ds, "where id_don_vi = " + ip_id_don_vi); if (v_ds.Tables[0].Rows.Count == 0) { return false; } else return true; }
private void load_data_to_sle_chuc_vu() { US_DM_CHUC_VU v_us = new US_DM_CHUC_VU(); DS_DM_CHUC_VU v_ds = new DS_DM_CHUC_VU(); v_us.FillDataset(v_ds, " where id_don_vi = " + Convert.ToDecimal(m_sle_don_vi.EditValue)); m_sle_chuc_vu.Properties.DataSource = v_ds.Tables[0]; m_sle_chuc_vu.Properties.DisplayMember = DM_CHUC_VU.TEN_CHUC_VU; m_sle_chuc_vu.Properties.ValueMember = DM_CHUC_VU.ID; //m_sle_chuc_vu.Properties.NullText = "---Chọn chức vụ---"; m_sle_chuc_vu.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard; m_sle_chuc_vu.Properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFit; }
private DataTable load_data_to_chuc_vu() { US_DM_CHUC_VU v_us = new US_DM_CHUC_VU(); DS_DM_CHUC_VU v_ds = new DS_DM_CHUC_VU(); v_us.FillDataset(v_ds); return v_ds.Tables[0]; }
private void load_data_2_sle_chon_vi_tri() { US_DM_CHUC_VU v_us = new US_DM_CHUC_VU(); DS_DM_CHUC_VU v_ds = new DS_DM_CHUC_VU(); v_us.FillDataset(v_ds, " where id_don_vi = " + Convert.ToDecimal(m_sle_chon_don_vi.EditValue)); m_sle_chon_vi_tri.Properties.DataSource = v_ds.Tables[0]; m_sle_chon_vi_tri.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard; m_sle_chon_vi_tri.Properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFit; }
private void load_data_to_sle_chuc_vu() { US_DM_CHUC_VU v_us = new US_DM_CHUC_VU(); DS_DM_CHUC_VU v_ds = new DS_DM_CHUC_VU(); v_us.FillDataset(v_ds); m_sle_chuc_vu.Properties.DataSource = v_ds.Tables[0]; m_sle_chuc_vu.Properties.DisplayMember = DM_CHUC_VU.TEN_CHUC_VU; m_sle_chuc_vu.Properties.ValueMember = DM_CHUC_VU.ID; m_sle_chuc_vu.Properties.NullText = "---Chọn chức vụ---"; }