private void load_data_to_grv() { US_DUNG_CHUNG v_us = new US_DUNG_CHUNG(); DataSet v_ds = new DataSet(); v_ds.Tables.Add(new DataTable()); string v_str_query; if ((us_user.dcIDNhom == 3 && v_us.get_id_pm_dich_vu(10,us_user.dcID) != 0) ||(us_user.dcIDNhom == 5 && v_us.get_id_td_dich_vu(10, us_user.dcID) != 0)) { if (us_user.dcIDNhom == 3) m_grv_ht_bo_pm_td_dich_vu.OptionsView.NewItemRowPosition = NewItemRowPosition.None; v_str_query = "SELECT * FROM V_DICH_VU_BO_PM_TD"; } else { m_grv_ht_bo_pm_td_dich_vu.OptionsView.NewItemRowPosition = NewItemRowPosition.None; if (us_user.dcIDNhom == 3) { v_str_query = "SELECT * FROM V_DICH_VU_BO_PM_TD WHERE ID_PM = " + us_user.dcID.ToString(); } else v_str_query = "SELECT * FROM V_DICH_VU_BO_PM_TD WHERE ID_TD = " + us_user.dcID.ToString(); } v_us.FillDatasetWithQuery(v_ds, v_str_query); m_grc_ht_bo_pm_td_dich_vu.DataSource = v_ds.Tables[0]; }
private void f999_ht_bo_pm_td_dich_vu_de_Load(object sender, EventArgs e) { US_DUNG_CHUNG v_us = new US_DUNG_CHUNG(); if (us_user.dcIDNhom == 3 && v_us.get_id_pm_dich_vu(11, us_user.dcID) == 0 || us_user.dcIDNhom == 5 && v_us.get_id_td_dich_vu(11, us_user.dcID) == 0) { if (m_e_form_mode == DataEntryFormMode.UpdateDataState) { txt_dich_vu.ReadOnly = true; cbo_loai_dich_vu.Enabled = false; cbo_nhom_dich_vu.Enabled = false; m_cbox_thoi_gian_xly.Enabled = false; m_cbox_thoi_gian_xu_ly.Enabled = false; m_txt_diem_khoi_luong.Enabled = false; } m_pan_xoa.Visible = false; m_pan_them_td.Visible = false; grc_danh_sach_td.Enabled = false; if (us_user.dcIDNhom == 3) { m_pan_them_pm.Visible = false; grc_danh_sach_pm.Enabled = false; } } }
private void f128_danh_sach_dich_vu_Load(object sender, EventArgs e) { US_DUNG_CHUNG v_us = new US_DUNG_CHUNG(); DataSet v_ds = new DataSet(); v_ds.Tables.Add(new DataTable()); if ((us_user.dcIDNhom == 3 && v_us.get_id_pm_dich_vu(11, us_user.dcID) != 0) || (us_user.dcIDNhom == 5 && v_us.get_id_td_dich_vu(11, us_user.dcID) != 0)) { v_us.FillDatasetWithTableName(v_ds, "V_DM_LOAI_YEU_CAU"); } else { v_us.FillDatasetWithQuery(v_ds, "SELECT dmyc.* FROM HT_BO_DICH_VU,V_DM_LOAI_YEU_CAU AS dmyc WHERE dmyc.ID =HT_BO_DICH_VU.ID_DICH_VU AND HT_BO_DICH_VU.ID_NGUOI_SU_DUNG = " + us_user.dcID.ToString()); } m_grc_dich_vu.DataSource = v_ds.Tables[0]; }
private void load_cap_xu_ly() { US_DUNG_CHUNG v_us = new US_DUNG_CHUNG(); string v_str_query = ""; if (us_user.dcIDNhom == 5 && v_us.get_id_td_dich_vu(10, us_user.dcID) == 0) { v_str_query = "SELECT ID, MA_NHOM FROM HT_NHOM_NGUOI_SU_DUNG WHERE ID NOT IN (6,5)"; } else if (us_user.dcIDNhom == 3 && v_us.get_id_pm_dich_vu(10, us_user.dcID) == 0) { v_str_query = "SELECT ID, MA_NHOM FROM HT_NHOM_NGUOI_SU_DUNG WHERE ID NOT IN (3,4,5,6)"; } else { v_str_query = "SELECT ID, MA_NHOM FROM HT_NHOM_NGUOI_SU_DUNG WHERE ID NOT IN (6)"; } WinFormControls.load_data_to_combobox_with_query(m_cbo_cap_xu_ly, "ID", "MA_NHOM", WinFormControls.eTAT_CA.NO, v_str_query); }
public f999_ht_nguoi_su_dung_de() { InitializeComponent(); US_DUNG_CHUNG v_us = new US_DUNG_CHUNG(); string v_str_query = ""; if (us_user.dcIDNhom == 5 && v_us.get_id_td_dich_vu(10, us_user.dcID) == 0) { v_str_query = "SELECT ID, MA_NHOM FROM HT_NHOM_NGUOI_SU_DUNG WHERE ID NOT IN (6,5)"; } else if (us_user.dcIDNhom == 3 && v_us.get_id_pm_dich_vu(10, us_user.dcID) == 0) { v_str_query = "SELECT ID, MA_NHOM FROM HT_NHOM_NGUOI_SU_DUNG WHERE ID NOT IN (3,4,5,6)"; } else { v_str_query = "SELECT ID, MA_NHOM FROM HT_NHOM_NGUOI_SU_DUNG WHERE ID NOT IN (6)"; } WinFormControls.load_data_to_combobox_with_query(m_cbo_cap_xu_ly, "ID", "MA_NHOM", WinFormControls.eTAT_CA.NO, v_str_query); }
private void load_data_to_grv() { US_DUNG_CHUNG v_us = new US_DUNG_CHUNG(); DataSet v_ds = new DataSet(); v_ds.Tables.Add(new DataTable()); string v_str_query; if ((us_user.dcIDNhom == 3 && v_us.get_id_pm_dich_vu(11, us_user.dcID) != 0) || (us_user.dcIDNhom == 5 && v_us.get_id_td_dich_vu(11, us_user.dcID) != 0)) { v_str_query = "SELECT * FROM V_DICH_VU_NGUOI_XU_LY"; } else { m_grv_ht_bo_pm_td_dich_vu.OptionsView.NewItemRowPosition = NewItemRowPosition.None; v_str_query = "SELECT * FROM V_DICH_VU_NGUOI_XU_LY WHERE ID = ANY (select *from dbo.f_get_ds_id_dich_vu(" + us_user.dcIDNhom.ToString() + "," + us_user.dcID.ToString() + "))"; } v_us.FillDatasetWithQuery(v_ds, v_str_query); m_grc_ht_bo_pm_td_dich_vu.DataSource = v_ds.Tables[0]; }