public static List <Permissios> Menu_Select()
{
string sql = "select * from MS_Permissios where Parent_Permissions is null";
DataTable table = DBHelper.Select(sql);
List <Permissios> lst_permissios = new List <Permissios>();
foreach (DataRow row in table.Rows)
{
Permissios permissios = new Permissios
{
PermissiosID = Convert.ToInt32(row["Permissions_Id"]),
PermissiosName = row["Permissions_name"].ToString(),
PermissiosName2 = new List <Permissios>()
};
lst_permissios.Add(permissios);
string sql2 = "select * from MS_Permissios where [Parent_Permissions]=" + permissios.PermissiosID;
DataTable table2 = DBHelper.Select(sql2);
foreach (DataRow item in table2.Rows)
{
Permissios per = new Permissios
{
PermissiosID = Convert.ToInt32(item["Permissions_Id"]),
PermissiosName = item["Permissions_name"].ToString()
};
permissios.PermissiosName2.Add(per);
}
}
return(lst_permissios);
}
/// <summary>
/// 显示权限
/// </summary>
/// <param name="q"></param>
/// <returns></returns>
public List <Permissios> GetPermissios()
{
string sql = string.Format("select * from MS_Permissios where Parent_Permissions IS null ");
var table = DBHelper.Select(sql);
List <Permissios> list = new List <Permissios>();
foreach (DataRow item in table.Rows)
{
Permissios permissios = new Permissios
{
PermissiosID = Convert.ToInt32(item["Permissions_Id"]),
PermissiosName = item["Permissions_name"].ToString(),
PermissionsCode = item["Permissions_Code"].ToString(),
PermissiosName2 = new List <Permissios>()
};
list.Add(permissios);
string sql1 = string.Format("select * from MS_Permissios where Parent_Permissions IS not null and Parent_Permissions like '%{0}%'", Convert.ToInt32(item["Permissions_Id"]));
var table1 = DBHelper.Select(sql1);
foreach (DataRow item1 in table1.Rows)
{
Permissios per = new Permissios
{
PermissiosID = Convert.ToInt32(item1["Permissions_Id"]),
PermissiosName1 = item1["Permissions_name"].ToString()
};
permissios.PermissiosName2.Add(per);
}
}
return(list);
}
/// <summary>
/// 一级菜单
/// </summary>
/// <returns></returns>
public List <Permissios> getSeYJ()
{
string sql = string.Format("select * from MS_Permissios where Parent_Permissions IS null ");
var table = DBHelper.Select(sql);
List <Permissios> list = new List <Permissios>();
foreach (DataRow item in table.Rows)
{
Permissios permissios = new Permissios {
PermissiosID = Convert.ToInt32(item["Permissions_Id"]),
PermissiosName = item["Permissions_name"].ToString(),
PermissionsCode = item["Permissions_Code"].ToString()
};
list.Add(permissios);
}
return(list);
}
/// <summary>
/// 菜单
/// </summary>
public List <Permissios> getSeCD(string s, string d, string f)
{
string sql = string.Format("select a.Permissions_Id f,b.Permissions_Id a,a.Permissions_name b,b.Permissions_Code c,b.Permissions_name d from MS_Permissios " +
"a join MS_Permissios b on a.Permissions_Id=b.Parent_Permissions where a.Permissions_Id like '%{0}%' and b.Permissions_Id like '%{1}%' and a.Permissions_name like '%{2}%'", d, f, s);
var table = DBHelper.Select(sql);
List <Permissios> list = new List <Permissios>();
foreach (DataRow item in table.Rows)
{
Permissios permissios = new Permissios
{
PermissiosID = Convert.ToInt32(item["a"]),
PermissiosName = item["b"].ToString(),
PermissionsCode = item["c"].ToString(),
PermissiosName1 = item["d"].ToString()
};
list.Add(permissios);
}
return(list);
}
