public static List <chucnang> Loadchucnang(string username, int idnhomchucnang)
{ //load chuc nang theo id nhom chuc nang
DataTable dt = new DataTable();
if (username == "admin")
{
string[] namepara = { "@idnhomchucnang" };
object[] valuepara = { idnhomchucnang };
dt = dataAsset.data.outputdataTable("user_chucnang_all", namepara, valuepara);
}
else
{
string[] namepara = { "@username", "@idnhomchucnang" };
object[] valuepara = { username, idnhomchucnang };
dt = dataAsset.data.outputdataTable("user_chucnang", namepara, valuepara);
}
List <chucnang> list = new List <chucnang>();
for (int i = 0; i < dt.Rows.Count; i++)
{
chucnang cm = new chucnang();
cm.Id = int.Parse(dt.Rows[i]["Id_ChucNang"].ToString());
cm.Links = dt.Rows[i]["Links_ChuNang"].ToString();
cm.Thutu = int.Parse(dt.Rows[i]["ThuTu_ChucNang"].ToString());
cm.Tenchucnang = dt.Rows[i]["TENCHUCNANG"].ToString();
list.Add(cm);
}
return(list);
}
public JsonResult ht_phanquyen_loadChucNang(string moduleID, int type, string manhom = null)
{
// type check 1-load het du lieu, 2-load, kiem tra nhom co quyen hay chua
List <chucnang> cn = new List <chucnang>();
string[] namepara = { "@moduleid" };
object[] valuepara = { moduleID };
DataTable dt = dataAsset.data.outputdataTable("ht_phanquyen_loadNhomChucNang", namepara, valuepara);
for (int i = 0; i < dt.Rows.Count; i++)
{
int idnhom = int.Parse(dt.Rows[i]["ID"].ToString());
DataTable dtcn = new DataTable();
if (type == 1)
{
string[] namepara2 = { "@idnhom" };
object[] valuepara2 = { idnhom };
dtcn = dataAsset.data.outputdataTable("ht_phanquyen_loadChucNangAll", namepara2, valuepara2);
}
else
{
string[] namepara2 = { "@idnhom", "@manhom" };
object[] valuepara2 = { idnhom, manhom };
dtcn = dataAsset.data.outputdataTable("ht_phanquyen_loadChucNang", namepara2, valuepara2);
}
for (int j = 0; j < dtcn.Rows.Count; j++)
{
chucnang c = new chucnang();
c.Id = int.Parse(dtcn.Rows[j]["ID"].ToString());
c.Tenchucnang = dtcn.Rows[j]["TENCHUCNANG"].ToString();
cn.Add(c);
}
}
return(Json(cn, JsonRequestBehavior.AllowGet));
}
