public static long GetUserId(SPUser user) { if (user == null) { return(0); } else { string name = user.LoginName; //检查用户 List <ProjectDll.User> dt = DAL.User.GetUserByAccount(name.Substring(name.LastIndexOf("\\") + 1)); if (dt.Count == 0) { ProjectDll.User dr = new ProjectDll.User(); dr.Account = user.LoginName.Split('\\')[1]; dr.Name = user.Name; dr.Flag = 1; return(DAL.User.InsertUser(dr)); } else { return(dt[0].UserID); } } }
public static ProjectDll.User GetUserByUserID(long userID) { using (ProjectEntities db = new ProjectEntities()) { ProjectDll.User atList = db.User.SingleOrDefault(at => at.UserID == userID); return(atList); } }
/// <summary> /// 获取当前用户ID,如果数据库中没有数据,根据活动目录写入数据库中 /// </summary> /// <returns>mUser.UserID</returns> public static long GetUserId() { string account = GetAccount(); var db = new ProjectEntities();//定义数据库连接接口 ProjectDll.User mUser = db.User.FirstOrDefault(u => u.Account.Equals(account)); if (mUser != null) { return(mUser.UserID); } else { mUser = new ProjectDll.User(); mUser.Account = account; mUser.Created = DateTime.Now; SPSecurity.RunWithElevatedPrivileges(delegate() { DirectoryEntry adUser = AdHelper.GetDirectoryEntryByAccount(account); if (adUser != null) { mUser.Name = adUser.Properties["displayName"][0].ToString(); if (adUser.Properties.Contains("telephoneNumber")) { mUser.Telephone = adUser.Properties["telephoneNumber"][0].ToString(); } if (adUser.Properties.Contains("mail")) { mUser.Email = adUser.Properties["mail"][0].ToString(); } } }); db.User.Add(mUser); db.SaveChanges(); return(mUser.UserID); } }
//public static long InsertWorksExpert(ProjectEntities db,WorksExpert dr) //{ // ProjectDll.WorksExpert at = new WorksExpert(); // at.Comments = dr.Comments; // at.Created = dr.Created; // at.ExpertID = dr.ExpertID; // at.Flag = 1; // at.Score = dr.Score; // at.ScoreState = dr.ScoreState; // at.WorksID = dr.WorksID; // db.WorksExpert.Add(at); // db.SaveChanges(); // return at.WorksExpertID; //} //public static long InsertWorksExpert(WorksExpert dr) //{ // using (ProjectEntities db = new ProjectEntities()) // { // ProjectDll.WorksExpert at = new WorksExpert(); // at.Comments = dr.Comments; // at.Created = dr.Created; // at.ExpertID = dr.ExpertID; // at.Flag = 1; // at.Score = dr.Score; // at.ScoreState = dr.ScoreState; // at.WorksID = dr.WorksID; // db.WorksExpert.Add(at); // db.SaveChanges(); // return at.WorksExpertID; // } //} /// <summary> /// 创建新用户 /// </summary> /// <param name="dr">用户记录</param> /// <returns></returns> public static long InsertUser(ProjectDll.User dr) { using (ProjectEntities db = new ProjectEntities()) { ProjectDll.User at = new ProjectDll.User(); at.Account = dr.Account; at.Department = dr.Department; at.Duty = dr.Duty; at.Email = dr.Email; at.Department = dr.Department; at.Telephone = dr.Telephone; at.IDCard = dr.IDCard; at.Name = dr.Name; at.SchoolID = dr.SchoolID; at.Major = dr.Major; at.RoleID = dr.RoleID; at.Sex = dr.Sex; at.StateID = dr.StateID; at.Created = DateTime.Now; db.User.Add(at); db.SaveChanges(); return(at.UserID); } }