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