/// <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); } }