public void get_child_menu(decimal ip_dc_parent_id, string ip_str_user_name, DS_HT_CHUC_NANG ip_ds_ht_chuc_nang_con)
{
CStoredProc v_cstore = new CStoredProc("pr_HT_CHUC_NANG_GetQuyenChucNang_Con");
v_cstore.addNVarcharInputParam("@PARENT_ID", ip_dc_parent_id);
v_cstore.fillDataSetByCommand(this, ip_ds_ht_chuc_nang_con);
}
public void load_all_data_by_root_parent_id(decimal ip_dc_root_parent_id, DS_HT_CHUC_NANG ip_ds_ht_chuc_nang)
{
CStoredProc v_cstore = new CStoredProc("pr_HT_CHUC_NANG_Select_by_Root_ParentId");
v_cstore.addDecimalInputParam("@CHUC_NANG_PARENT_ID", ip_dc_root_parent_id);
v_cstore.fillDataSetByCommand(this, ip_ds_ht_chuc_nang);
}
public void get_parent_table(string ip_str_user_name, DS_HT_CHUC_NANG ip_ds_ht_chuc_nang)
{
CStoredProc v_cstore = new CStoredProc("pr_HT_CHUC_NANG_GetQuyenChucNang");
v_cstore.addNVarcharInputParam("@USER_NAME", ip_str_user_name);
v_cstore.fillDataSetByCommand(this, ip_ds_ht_chuc_nang);
}
public void get_parent_table_by_id_user_group(
decimal ip_dc_id_user_group
, DS_HT_CHUC_NANG ip_ds_ht_chuc_nang)
{
CStoredProc v_cstore = new CStoredProc("pr_HT_CHUC_NANG_GetQuyenChucNang_by_ID_user_group");
v_cstore.addNVarcharInputParam("@ID_USER_group", ip_dc_id_user_group);
v_cstore.fillDataSetByCommand(this, ip_ds_ht_chuc_nang);
}
public void load_chuc_nang_max_vi_tri_by_parent_id(
decimal ip_dc_chuc_nang_parent_id
, DS_HT_CHUC_NANG ip_ds_ht_chuc_nang)
{
CStoredProc v_cstore = new CStoredProc("pr_HT_CHUC_NANG_Select_Chuc_Nang_Max_Vi_Tri");
v_cstore.addDecimalInputParam("@CHUC_NANG_PARENT_ID", ip_dc_chuc_nang_parent_id);
v_cstore.fillDataSetByCommand(this, ip_ds_ht_chuc_nang);
}
public void FillDatasetByTuKhoa(
string ip_str_tu_khoa
, DS_HT_CHUC_NANG ip_ds_ht_chuc_nang_con)
{
CStoredProc v_cstore = new CStoredProc("pr_HT_CHUC_NANG_search_by_tu_khoa");
v_cstore.addNVarcharInputParam("@ip_str_tu_khoa", ip_str_tu_khoa);
v_cstore.fillDataSetByCommand(this, ip_ds_ht_chuc_nang_con);
}
public string get_TEN_CHUC_NANG_PARENT(object ip_chuc_nang_parent_id)
{
if (ip_chuc_nang_parent_id.ToString().Equals("") | ip_chuc_nang_parent_id.ToString().Equals("0")) return "Không có";
else
{
DS_HT_CHUC_NANG v_ds_ht_chuc_nang = new DS_HT_CHUC_NANG();
US_HT_CHUC_NANG v_us_ht_chuc_nang = new US_HT_CHUC_NANG(CIPConvert.ToDecimal(ip_chuc_nang_parent_id));
return v_us_ht_chuc_nang.strTEN_CHUC_NANG;
}
}
public US_HT_CHUC_NANG(decimal i_dbID)
{
pm_objDS = new DS_HT_CHUC_NANG();
pm_strTableName = c_TableName;
IMakeSelectCmd v_objMkCmd = new CMakeAndSelectCmd(pm_objDS, c_TableName);
v_objMkCmd.AddCondition("ID", i_dbID, eKieuDuLieu.KieuNumber, eKieuSoSanh.Bang);
SqlCommand v_cmdSQL;
v_cmdSQL = v_objMkCmd.getSelectCmd();
this.FillDatasetByCommand(pm_objDS, v_cmdSQL);
pm_objDR = getRowClone(pm_objDS.Tables[pm_strTableName].Rows[0]);
}
// Hàm này dựa vào parent id để lấy được vị trí lớn nhất mà chức năng con đang có
private decimal get_max_vi_tri(decimal ip_dc_parent_chuc_nang_id)
{
US_HT_CHUC_NANG v_us_ht_chuc_nang = new US_HT_CHUC_NANG();
DS_HT_CHUC_NANG v_ds_ht_chuc_nang = new DS_HT_CHUC_NANG();
v_us_ht_chuc_nang.load_chuc_nang_max_vi_tri_by_parent_id(ip_dc_parent_chuc_nang_id, v_ds_ht_chuc_nang);
if (v_ds_ht_chuc_nang.HT_CHUC_NANG.Rows.Count == 0)
{
return(0);
}
return(CIPConvert.ToDecimal(v_ds_ht_chuc_nang.HT_CHUC_NANG.Rows[0][HT_CHUC_NANG.VI_TRI]));
}
private void load_data_2_cbo_chuc_nang_search()
{
US_HT_CHUC_NANG v_us_ht_chuc_nang = new US_HT_CHUC_NANG();
DS_HT_CHUC_NANG v_ds_ht_chuc_nang = new DS_HT_CHUC_NANG();
v_us_ht_chuc_nang.FillDataset(v_ds_ht_chuc_nang, " WHERE CHUC_NANG_PARENT_ID = 0 ORDER BY ID");
m_cbo_chuc_nang_cap_1.Items.Add(new ListItem("Tất cả", "0"));
for (int v_i = 0; v_i < v_ds_ht_chuc_nang.HT_CHUC_NANG.Rows.Count; v_i++)
{
m_cbo_chuc_nang_cap_1.Items.Add(new ListItem(CIPConvert.ToStr(v_ds_ht_chuc_nang.HT_CHUC_NANG.Rows[v_i][HT_CHUC_NANG.TEN_CHUC_NANG]), CIPConvert.ToStr(v_ds_ht_chuc_nang.HT_CHUC_NANG.Rows[v_i][HT_CHUC_NANG.ID])));
}
}
public void FillDatasetFillFullTreeChucNang(
string ip_str_hien_thi_yn
, decimal ip_dc_user_group
, string ip_str_having_quyen_yn
, DS_HT_CHUC_NANG op_ds_ht_chuc_nang)
{
CStoredProc v_cstore = new CStoredProc("pr_HT_CHUC_NANG_select_full_tree_chuc_nang");
v_cstore.addNVarcharInputParam("@ip_str_hien_thi_yn", ip_str_hien_thi_yn);
v_cstore.addDecimalInputParam("@ip_id_user_group", ip_dc_user_group);
v_cstore.addNVarcharInputParam("@ip_str_having_quyen_yn", ip_str_having_quyen_yn);
v_cstore.fillDataSetByCommand(this, op_ds_ht_chuc_nang);
}
public US_HT_CHUC_NANG(decimal i_dbID)
{
pm_objDS = new DS_HT_CHUC_NANG();
pm_strTableName = c_TableName;
IMakeSelectCmd v_objMkCmd = new CMakeAndSelectCmd(pm_objDS, c_TableName);
v_objMkCmd.AddCondition("ID", i_dbID, eKieuDuLieu.KieuNumber, eKieuSoSanh.Bang);
SqlCommand v_cmdSQL;
v_cmdSQL = v_objMkCmd.getSelectCmd();
this.FillDatasetByCommand(pm_objDS, v_cmdSQL);
pm_objDR = getRowClone(pm_objDS.Tables[pm_strTableName].Rows[0]);
}
private void load_cbo_chuc_nang_phan_mem()
{
try
{
US_HT_CHUC_NANG v_us_chuc_nang = new US_HT_CHUC_NANG();
DS_HT_CHUC_NANG v_ds_chuc_nang = new DS_HT_CHUC_NANG();
v_us_chuc_nang.FillDataset(v_ds_chuc_nang, " WHERE ID NOT IN (SELECT ID_QUYEN FROM HT_QUYEN_GROUP WHERE ID_USER_GROUP =" + CIPConvert.ToDecimal(m_cbo_user_group.SelectedValue) + ")");
m_lst_chuc_nang.DataSource = v_ds_chuc_nang.HT_CHUC_NANG;
m_lst_chuc_nang.DataTextField = HT_CHUC_NANG.TEN_CHUC_NANG;
m_lst_chuc_nang.DataValueField = HT_CHUC_NANG.ID;
m_lst_chuc_nang.DataBind();
}
catch (Exception v_e)
{
throw v_e;
}
}
public void get_child_menu(
decimal ip_dc_parent_id
, string ip_str_user_name
, DS_HT_CHUC_NANG ip_ds_ht_chuc_nang_con)
{
CStoredProc v_cstore = new CStoredProc("pr_HT_CHUC_NANG_GetQuyenChucNang_Con");
v_cstore.addNVarcharInputParam("@PARENT_ID", ip_dc_parent_id);
v_cstore.fillDataSetByCommand(this, ip_ds_ht_chuc_nang_con);
}
public void FillDatasetByTuKhoa(
string ip_str_tu_khoa
, DS_HT_CHUC_NANG ip_ds_ht_chuc_nang_con)
{
CStoredProc v_cstore = new CStoredProc("pr_HT_CHUC_NANG_search_by_tu_khoa");
v_cstore.addNVarcharInputParam("@ip_str_tu_khoa", ip_str_tu_khoa);
v_cstore.fillDataSetByCommand(this, ip_ds_ht_chuc_nang_con);
}
public US_HT_CHUC_NANG()
{
pm_objDS = new DS_HT_CHUC_NANG();
pm_strTableName = c_TableName;
pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow();
}
private void load_cbo_chuc_nang_phan_mem_user()
{
US_HT_CHUC_NANG v_us_chuc_nang = new US_HT_CHUC_NANG();
DS_HT_CHUC_NANG v_ds_chuc_nang = new DS_HT_CHUC_NANG();
//v_us_chuc_nang.FillDataset(v_ds_chuc_nang, " WHERE ID IN (SELECT ID_QUYEN FROM HT_QUYEN_GROUP WHERE ID_USER_GROUP =" + CIPConvert.ToDecimal(m_cbo_user_group.SelectedValue) + ")");
v_ds_chuc_nang.EnforceConstraints = false;
v_us_chuc_nang.FillDatasetFillFullTreeChucNang(
"Y"
, CIPConvert.ToDecimal(m_cbo_user_group.SelectedValue)
,"Y"
, v_ds_chuc_nang);
m_lst_chuc_nang_user.DataSource = v_ds_chuc_nang.HT_CHUC_NANG;
m_lst_chuc_nang_user.DataTextField = HT_CHUC_NANG.TEN_CHUC_NANG;
m_lst_chuc_nang_user.DataValueField = HT_CHUC_NANG.ID;
m_lst_chuc_nang_user.DataBind();
}
public void get_parent_table_by_id_user_group(
decimal ip_dc_id_user_group
, DS_HT_CHUC_NANG ip_ds_ht_chuc_nang)
{
CStoredProc v_cstore = new CStoredProc("pr_HT_CHUC_NANG_GetQuyenChucNang_by_ID_user_group");
v_cstore.addNVarcharInputParam("@ID_USER_group", ip_dc_id_user_group);
v_cstore.fillDataSetByCommand(this, ip_ds_ht_chuc_nang);
}
private void load_data_2_cbo_parent()
{
US_HT_CHUC_NANG v_us_ht_chuc_nang = new US_HT_CHUC_NANG();
DS_HT_CHUC_NANG v_ds_ht_chuc_nang = new DS_HT_CHUC_NANG();
//v_us_ht_chuc_nang.FillDataset(v_ds_ht_chuc_nang, " WHERE CHUC_NANG_PARENT_ID IS NULL ORDER BY ID");
v_us_ht_chuc_nang.FillDataset(v_ds_ht_chuc_nang, " ORDER BY ID");
m_cbo_chuc_nang_cha.Items.Add(new ListItem("Không có", "0"));
for (int v_i = 0; v_i < v_ds_ht_chuc_nang.HT_CHUC_NANG.Rows.Count; v_i++)
{
m_cbo_chuc_nang_cha.Items.Add(new ListItem(CIPConvert.ToStr(v_ds_ht_chuc_nang.HT_CHUC_NANG.Rows[v_i][HT_CHUC_NANG.TEN_CHUC_NANG]), CIPConvert.ToStr(v_ds_ht_chuc_nang.HT_CHUC_NANG.Rows[v_i][HT_CHUC_NANG.ID])));
}
}
public void FillDatasetFillFullTreeChucNang(
string ip_str_hien_thi_yn
, decimal ip_dc_user_group
, string ip_str_having_quyen_yn
, DS_HT_CHUC_NANG op_ds_ht_chuc_nang)
{
CStoredProc v_cstore = new CStoredProc("pr_HT_CHUC_NANG_select_full_tree_chuc_nang");
v_cstore.addNVarcharInputParam("@ip_str_hien_thi_yn", ip_str_hien_thi_yn);
v_cstore.addDecimalInputParam("@ip_id_user_group", ip_dc_user_group);
v_cstore.addNVarcharInputParam("@ip_str_having_quyen_yn", ip_str_having_quyen_yn);
v_cstore.fillDataSetByCommand(this, op_ds_ht_chuc_nang);
}
public void get_parent_table(
string ip_str_user_name
, DS_HT_CHUC_NANG ip_ds_ht_chuc_nang)
{
CStoredProc v_cstore = new CStoredProc("pr_HT_CHUC_NANG_GetQuyenChucNang");
v_cstore.addNVarcharInputParam("@USER_NAME", ip_str_user_name);
v_cstore.fillDataSetByCommand(this, ip_ds_ht_chuc_nang);
}
public void load_all_data_by_root_parent_id(
decimal ip_dc_root_parent_id
, DS_HT_CHUC_NANG ip_ds_ht_chuc_nang)
{
CStoredProc v_cstore = new CStoredProc("pr_HT_CHUC_NANG_Select_by_Root_ParentId");
v_cstore.addDecimalInputParam("@CHUC_NANG_PARENT_ID", ip_dc_root_parent_id);
v_cstore.fillDataSetByCommand(this, ip_ds_ht_chuc_nang);
}
// Hàm này dựa vào parent id để lấy được vị trí lớn nhất mà chức năng con đang có
private decimal get_max_vi_tri(decimal ip_dc_parent_chuc_nang_id)
{
US_HT_CHUC_NANG v_us_ht_chuc_nang = new US_HT_CHUC_NANG();
DS_HT_CHUC_NANG v_ds_ht_chuc_nang = new DS_HT_CHUC_NANG();
v_us_ht_chuc_nang.load_chuc_nang_max_vi_tri_by_parent_id(ip_dc_parent_chuc_nang_id, v_ds_ht_chuc_nang);
if (v_ds_ht_chuc_nang.HT_CHUC_NANG.Rows.Count == 0) return 0;
return CIPConvert.ToDecimal(v_ds_ht_chuc_nang.HT_CHUC_NANG.Rows[0][HT_CHUC_NANG.VI_TRI]);
}
public void load_chuc_nang_max_vi_tri_by_parent_id(
decimal ip_dc_chuc_nang_parent_id
, DS_HT_CHUC_NANG ip_ds_ht_chuc_nang)
{
CStoredProc v_cstore = new CStoredProc("pr_HT_CHUC_NANG_Select_Chuc_Nang_Max_Vi_Tri");
v_cstore.addDecimalInputParam("@CHUC_NANG_PARENT_ID", ip_dc_chuc_nang_parent_id);
v_cstore.fillDataSetByCommand(this, ip_ds_ht_chuc_nang);
}
private void load_data_2_cbo_chuc_nang_search()
{
US_HT_CHUC_NANG v_us_ht_chuc_nang = new US_HT_CHUC_NANG();
DS_HT_CHUC_NANG v_ds_ht_chuc_nang = new DS_HT_CHUC_NANG();
v_us_ht_chuc_nang.FillDataset(v_ds_ht_chuc_nang, " WHERE CHUC_NANG_PARENT_ID = 0 ORDER BY ID");
m_cbo_chuc_nang_cap_1.Items.Add(new ListItem("Tất cả", "0"));
for (int v_i = 0; v_i < v_ds_ht_chuc_nang.HT_CHUC_NANG.Rows.Count; v_i++)
{
m_cbo_chuc_nang_cap_1.Items.Add(new ListItem(CIPConvert.ToStr(v_ds_ht_chuc_nang.HT_CHUC_NANG.Rows[v_i][HT_CHUC_NANG.TEN_CHUC_NANG]), CIPConvert.ToStr(v_ds_ht_chuc_nang.HT_CHUC_NANG.Rows[v_i][HT_CHUC_NANG.ID])));
}
}
public US_HT_CHUC_NANG()
{
pm_objDS = new DS_HT_CHUC_NANG();
pm_strTableName = c_TableName;
pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow();
}
private void load_data_to_grid_by_tu_khoa()
{
DS_HT_CHUC_NANG v_ds = new DS_HT_CHUC_NANG();
US_HT_CHUC_NANG v_us = new US_HT_CHUC_NANG();
v_us.FillDatasetByTuKhoa(m_txt_tim_kiem.Text.Trim(), v_ds);
m_grv_dm_chuc_nang_he_thong.DataSource = v_ds.HT_CHUC_NANG;
report_count_rows(m_lbl_title, v_ds.HT_CHUC_NANG.Count, "Danh sách chức năng");
m_grv_dm_chuc_nang_he_thong.DataBind();
}
private void load_data_to_ddl_chuc_nang_phan_mem_user()
{
US_HT_CHUC_NANG v_us_chuc_nang = new US_HT_CHUC_NANG();
DS_HT_CHUC_NANG v_ds_chuc_nang = new DS_HT_CHUC_NANG();
v_ds_chuc_nang.EnforceConstraints = false;
v_us_chuc_nang.FillDatasetFillFullTreeChucNang(
"Y"
, CIPConvert.ToDecimal(m_cbo_user_group.SelectedValue)
, "Y"
, v_ds_chuc_nang
);
m_lst_chuc_nang_user.DataSource = v_ds_chuc_nang.HT_CHUC_NANG;
m_lst_chuc_nang_user.DataTextField = HT_CHUC_NANG.TEN_CHUC_NANG;
m_lst_chuc_nang_user.DataValueField = HT_CHUC_NANG.ID;
m_lst_chuc_nang_user.DataBind();
}
