/// <summary>
/// 判断用户是否存在角色数据中
/// </summary>
/// <param name="roleGuid"></param>
/// <param name="userGuid"></param>
/// <returns></returns>
public static bool IsHasRole(string[] roleGuid, string userGuid)
{
API api = new API();
using (SysDbContext context = api.CreateDbContext())
{
var newRole = context.Roles.Where(r => roleGuid.Contains(r.Guid)).Select(r => r.Guid).ToList();
if (newRole.Count > 0)
{
var count = context.RoleUsers.Count(c => c.UserGuid == userGuid && newRole.Contains(c.RoleGuid));
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
}
/// <summary>
/// 根据code获取name
/// </summary>
/// <param name="dic"></param>
/// <returns></returns>
public static string GetMappingNameByGuid(string guid)
{
API api = new API();
using (SysDbContext context = api.CreateDbContext())
{
List <string> guidarr;
if (guid.Contains(","))
{
guidarr = guid.Split(',').ToList();
var dic = context.Mapping.Where(d => guidarr.Contains(d.Guid)).ToList();
if (dic.Count > 0)
{
string str = "";
foreach (var d in dic)
{
str += d.Name + ",";
}
return(str.TrimEnd(','));
}
}
else
{
var dic = context.Mapping.Where(d => d.Guid == guid).ToList();
if (dic.Count > 0)
{
return(dic[0].Name);
}
}
return("");
}
}
/// <summary>
/// 获取当前用户数据
/// </summary>
/// <param name="page">当前第几页</param>
/// <param name="UserGuid">用户主键</param>
/// <param name="sign">是否只看自己标记</param>
/// <returns>数据字符串</returns>
public static string GetDatas(int page, string UserGuid, string sign)
{
API api = new API();
SysDbContext context = api.CreateDbContext();
Database db = DatabaseFactory.CreateDatabase();
int pagenum = 12;//每页显示的问题个数
string sql = string.Format("SELECT * FROM(SELECT *, row_number() OVER(ORDER BY QuerstionTime desc) rownum,count(*) OVER() as allnum FROM Busi_OnlineQuestions where QuerstionPerson='{0}' and AnswerGuid is NULL) AS q WHERE rownum BETWEEN " + ((page - 1) * pagenum + 1) + " AND " + page * pagenum + " order by QuerstionTime desc;", UserGuid);
DataSet ds = db.ExecuteDataSet(sql);
DataTable Questions = ds.Tables[0];
string data = "<div class='tables'><div class='showtable'><table style='width: 99%;margin-left:5px' class='table' cellpadding='0' cellspacing='0'>";
data += "<tr><td class='TdLabel' style='width:50%;text-align:left;font-size: medium;'>提问内容</td><td class='TdLabel' style='width: 25%;text-align:left;font-size: medium;'>提问人</td><td class='TdLabel' style='width: 25%;text-align:left;font-size: medium;'>提问时间</td></tr>";
foreach (DataRow dr in Questions.Select("AnswerGuid is null"))
{
data += "<tr><td class='TdContent' style='text-align:left;'><a href='Index.aspx?Guid=" + dr["Guid"].ToString() + "&sign=" + sign + "'>" + dr["QuerstionContent"].ToString() + "</a></td>";
data += "<td class='TdContent' style='text-align:left'>" + context.Users.Find(dr["QuerstionPerson"].ToString()).UserCN + "</td><td class='TdContent' style='text-align:left'>" + dr["QuerstionTime"].ToString() + "</td>";
data += "</tr>";
}
int allnum = 0;
if (Questions.Rows.Count > 0)
{
allnum = Convert.ToInt32(Questions.Rows[0]["allnum"].ToString());
}
data += "</table></div></div>@" + allnum + "@" + (allnum % pagenum == 0 ? allnum / pagenum : (allnum / pagenum + 1));
return(data);
}
/// <summary>
/// 根据项目主键返回参建单位
/// </summary>
/// <param name="projGuid">项目主键</param>
/// <param name="uName">参建单位名字查询条件</param>
/// <returns>参建单位的DataTable</returns>
public static DataTable GetBuilderUnitsByProjGuid(string projGuid, string uName)
{
API api = new API();
SysDbContext context = api.CreateDbContext();
DataTable dt = SelectUnitAndPerson.GetBuilderUnitsByProjGuid(projGuid, uName);
string guid = "";
foreach (DataRow dr in dt.Select())
{
guid = dr["UnitsTypeName"].ToString();
var dic1 = context.Mapping.Where(d => d.Guid == guid).ToList();
if (dic1.Count > 0)
{
dr["UnitsTypeName"] = dic1[0].Name;
}
else
{
dr["UnitsTypeName"] = "";
}
guid = dr["UnitsQualityName"].ToString();
var dic2 = context.Mapping.Where(d => d.Guid == guid).ToList();
if (dic2.Count > 0)
{
dr["UnitsQualityName"] = dic2[0].Name;
}
else
{
dr["UnitsQualityName"] = "";
}
}
return(dt);
}
/// <summary>
/// 获取所有字典
/// </summary>
/// <returns></returns>
public static List <Mapping> GetMappings()
{
API api = new API();
using (SysDbContext context = api.CreateDbContext())
{
return(context.Mapping.ToList());
}
}
/// <summary>
/// 获取用户
/// </summary>
/// <param name="userGuid"></param>
/// <returns></returns>
public static User GetUser(string userGuid)
{
API api = new API();
using (SysDbContext context = api.CreateDbContext())
{
return(context.Users.Find(userGuid));
}
}
/// <summary>
/// 获取一组字典集合
/// </summary>
/// <param name="dic"></param>
/// <returns></returns>
public static List <Mapping> GetMappingByGuid(string guid)
{
API api = new API();
using (SysDbContext context = api.CreateDbContext())
{
return(context.Mapping.Where(d => d.DirectoryGuid == guid).OrderBy(m => m.Mark).ToList());
}
}
/// <summary>
/// 获取所有工作组
/// </summary>
/// <returns></returns>
public static List <Group> GetGroup()
{
API api = new API();
using (SysDbContext context = api.CreateDbContext())
{
return(context.Groups.OrderBy(g => g.SortNum).ToList());
}
}
/// <summary>
/// 添加角色
/// </summary>
/// <param name="role"></param>
/// <returns></returns>
public static int AddRole(Role role)
{
API api = new API();
using (SysDbContext context = api.CreateDbContext())
{
context.Roles.Add(role);
return(context.SaveChanges());
}
}
/// <summary>
/// 添加模块权限
/// </summary>
/// <param name="ml"></param>
/// <returns></returns>
public static int AddModelLicense(ModelLicenses ml)
{
API api = new API();
using (SysDbContext context = api.CreateDbContext())
{
context.ModelLicenses.Add(ml);
return(context.SaveChanges());
}
}
/// <summary>
/// 添加一个用户
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public static int AddUser(User user)
{
API api = new API();
using (SysDbContext context = api.CreateDbContext())
{
context.Users.Add(user);
return(context.SaveChanges());
}
}
/// <summary>
/// 删除一个用户
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public static int DeleteUser(User user)
{
API api = new API();
using (SysDbContext context = api.CreateDbContext())
{
context.Entry(user).State = System.Data.EntityState.Deleted;
return(context.SaveChanges());
}
}
/// <summary>
/// 删除模块
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int UpdateModel(Model model)
{
API api = new API();
using (SysDbContext context = api.CreateDbContext())
{
context.Entry(model).State = System.Data.EntityState.Modified;
return(context.SaveChanges());
}
}
/// <summary>
/// 添加字典
/// </summary>
/// <param name="dic"></param>
/// <returns></returns>
public static int AddMapping(Mapping mapping)
{
API api = new API();
using (SysDbContext context = api.CreateDbContext())
{
context.Mapping.Add(mapping);
return(context.SaveChanges());
}
}
/// <summary>
/// 添加菜单
/// </summary>
/// <param name="menu"></param>
/// <returns></returns>
public static int AddMenu(Menu menu)
{
API api = new API();
using (SysDbContext context = api.CreateDbContext())
{
context.Menus.Add(menu);
return(context.SaveChanges());
}
}
/// <summary>
/// 删除模块权限
/// </summary>
/// <param name="ml"></param>
/// <returns></returns>
public static int DeleteModelLicense(ModelLicenses ml)
{
API api = new API();
using (SysDbContext context = api.CreateDbContext())
{
context.Entry(ml).State = System.Data.EntityState.Deleted;
return(context.SaveChanges());
}
}
/// <summary>
/// 添加组
/// </summary>
/// <param name="group"></param>
/// <returns></returns>
public static int AddGroup(Group group)
{
API api = new API();
using (SysDbContext context = api.CreateDbContext())
{
context.Groups.Add(group);
return(context.SaveChanges());
}
}
/// <summary>
/// 添加用户到组
/// </summary>
/// <param name="userGuid"></param>
/// <param name="groupGuid"></param>
/// <returns></returns>
public static int AddGroupUser(string userGuid, string groupGuid)
{
API api = new API();
using (SysDbContext context = api.CreateDbContext())
{
return(context.Database.ExecuteSqlCommand("insert into Sys_UserAndGroup (UserGuid,UserGroupGuid) values(@UserGuid,@UserGroupGuid)", new SqlParameter[] {
new SqlParameter("@UserGuid", userGuid), new SqlParameter("@UserGroupGuid", groupGuid)
}));
}
}
/// <summary>
/// 添加字典
/// </summary>
/// <param name="dic"></param>
/// <returns></returns>
public static int AddMapping(List <Mapping> mapping)
{
API api = new API();
using (SysDbContext context = api.CreateDbContext())
{
foreach (Mapping d in mapping)
{
context.Mapping.Add(d);
}
return(context.SaveChanges());
}
}
/// <summary>
/// 用户添加到组
/// </summary>
/// <param name="roleUser"></param>
/// <returns></returns>
public static int AddRoleUser(List <RoleUser> roleUser)
{
API api = new API();
using (SysDbContext context = api.CreateDbContext())
{
foreach (RoleUser ru in roleUser)
{
context.RoleUsers.Add(ru);
}
return(context.SaveChanges());
}
}
/// <summary>
/// 添加角色
/// </summary>
/// <param name="role"></param>
/// <returns></returns>
public static int AddRole(List <Role> roles)
{
API api = new API();
using (SysDbContext context = api.CreateDbContext())
{
foreach (Role r in roles)
{
context.Roles.Add(r);
}
return(context.SaveChanges());
}
}
/// <summary>
/// 获取组
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public static List <Group> GetGroupByName(string name)
{
API api = new API();
using (SysDbContext context = api.CreateDbContext())
{
var groupList = context.Groups.Where(g => g.Name.Contains(name)).ToList();
if (groupList.Count > 0)
{
return(groupList);
}
return(null);
}
}
/// <summary>
/// 获取角色信息
/// </summary>
/// <param name="roleGuid"></param>
/// <returns></returns>
public static Role GetRoleByGuid(string roleGuid)
{
API api = new API();
using (SysDbContext context = api.CreateDbContext())
{
var roleList = context.Roles.Where(r => r.Guid == roleGuid).ToList();
if (roleList.Count > 0)
{
return(roleList[0]);
}
return(null);
}
}
/// <summary>
/// 根据Guid获取组
/// </summary>
/// <param name="groupGuid"></param>
/// <returns></returns>
public static Group GetGroupByGuid(string groupGuid)
{
API api = new API();
using (SysDbContext context = api.CreateDbContext())
{
var groupList = context.Groups.Where(g => g.Guid == groupGuid).ToList();
if (groupList.Count > 0)
{
return(groupList[0]);
}
return(null);
}
}
/// <summary>
/// 获取角色的用户
/// </summary>
/// <param name="roleGuid">角色主键</param>
/// <returns>用户集合</returns>
public static List <User> GetRoleUser(string roleGuid)
{
API api = new API();
using (SysDbContext context = api.CreateDbContext())
{
var list = (from user in context.Users
where (
from ug in context.RoleUsers where ug.RoleGuid == roleGuid && (from r in context.Roles where r.Guid == roleGuid select r.Guid).Count() > 0 select ug.UserGuid
).Contains(user.UserGuid)
select user).ToList();
return(list);
}
}
/// <summary>
/// 获取角色信息
/// </summary>
/// <param name="roleGuid"></param>
/// <returns></returns>
public static List <Role> GetRoleByName(string name)
{
API api = new API();
using (SysDbContext context = api.CreateDbContext())
{
var roleList = context.Roles.Where(r => r.Name.Contains(name)).ToList();
if (roleList.Count > 0)
{
return(roleList);
}
return(null);
}
}
public static XmlDocument GetGroupAndUserXML()
{
API api = new API();
using (SysDbContext context = api.CreateDbContext())
{
var userInGroup = (from ug in context.UserInGroup
where
(
from g in context.Groups
select g.Guid
).Contains(ug.UserGroupGuid)
select ug).ToList();
var group = GetGroup();
var user = (from u in context.Users
where
(from ug in context.UserInGroup
where
(
from g in context.Groups
select g.Guid
).Contains(ug.UserGroupGuid)
select ug.UserGuid
).Contains(u.UserGuid)
select u).ToList();
XmlDocument document = new XmlDocument();
var gropRoot = group.Where(g => g.TopGuid == "-1").ToList();
XmlElement ele = document.CreateElement("Groups");
document.AppendChild(ele);
for (int i = 0; i < gropRoot.Count; i++)
{
XmlElement child = document.CreateElement("Group");
child.SetAttribute("Guid", gropRoot[i].Guid);
child.SetAttribute("Name", gropRoot[i].Name);
GetRoleUser(userInGroup, user, gropRoot[i].Guid, child, document);
GetChidGroup(group, gropRoot[i].Guid, child, document, userInGroup, user);
ele.AppendChild(child);
}
return(document);
}
}
/// <summary>
///根据用户主键获取用户角色
/// </summary>
/// <param name="userGuid">用户主键</param>
/// <returns>用户集合</returns>
public static List <List <Role> > GetUserRoleTree(string userGuid)
{
API api = new API();
List <List <Role> > roleTree = new List <List <Role> >();
List <Role> roleList = null;
using (SysDbContext context = api.CreateDbContext())
{
var role = from r in context.Roles
where
(
from ru in context.RoleUsers where ru.UserGuid == userGuid select ru.RoleGuid
).Contains(r.Guid)
select r;
roleList = role.ToList();
var allRole = context.Roles.ToList();
List <Role> roleTemp = null;
for (int i = 0; i < roleList.Count; i++)
{
var topguid = roleList[i].TopGuid;
var rolet = new List <Role>();
rolet.Add(roleList[i]);
while (true)
{
roleTemp = allRole.Where(r => r.Guid == topguid).ToList();
if (roleTemp.Count > 0)
{
rolet.Add(roleTemp[0]);
topguid = roleTemp[0].TopGuid;
}
else
{
break;
}
}
rolet.Reverse();
roleTree.Add(rolet);
}
context.Dispose();
}
return(roleTree);
}
/// <summary>
/// 判断用户的角色
/// </summary>
/// <param name="roleGuid"></param>
/// <param name="userGuid"></param>
/// <returns></returns>
public static bool IsHasRole(string roleGuid, string userGuid)
{
API api = new API();
using (SysDbContext context = api.CreateDbContext())
{
var count = context.RoleUsers.Where(ru => ru.RoleGuid == roleGuid && ru.UserGuid == userGuid && context.Roles.Where(r => r.Guid == roleGuid).Count() > 0).Count();
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
}
/// <summary>
/// 获取组的全部用户
/// </summary>
/// <param name="groupGuid"></param>
/// <returns></returns>
public static List <User> GetGroupUser(string groupGuid)
{
API api = new API();
using (SysDbContext context = api.CreateDbContext())
{
if (context.Groups.Where(g => g.Guid == groupGuid).Count() > 0)
{
var userGuid = context.Database.SqlQuery <string>("select userGuid from Sys_UserAndGroup where UserGroupGuid=@UserGroupGuid", new SqlParameter("@UserGroupGuid", groupGuid)).ToArray();
var userList = from u in context.Users
where userGuid.Contains(u.UserGuid)
select u;
return(userList.ToList());
}
return(null);
}
}
