/// <summary> /// 根据项目Id删除一个项目用户信息 /// </summary> /// <param name="projectUserId"></param> public static void DeleteProjectUserById(string projectUserId) { Model.SUBHSSEDB db = Funs.DB; Model.Project_ProjectUser delProjectUser = db.Project_ProjectUser.FirstOrDefault(e => e.ProjectUserId == projectUserId); if (delProjectUser != null) { db.Project_ProjectUser.DeleteOnSubmit(delProjectUser); db.SubmitChanges(); } }
/// <summary> ///修改项目用户信息 /// </summary> /// <param name="projectUser"></param> public static void UpdateProjectUser(Model.Project_ProjectUser projectUser) { Model.SUBHSSEDB db = Funs.DB; Model.Project_ProjectUser newProjectUser = db.Project_ProjectUser.FirstOrDefault(e => e.ProjectUserId == projectUser.ProjectUserId); if (newProjectUser != null) { newProjectUser.ProjectId = projectUser.ProjectId; newProjectUser.UserId = projectUser.UserId; newProjectUser.UnitId = projectUser.UnitId; newProjectUser.RoleId = projectUser.RoleId; newProjectUser.IsPost = projectUser.IsPost; //newProjectUser.RoleName = projectUser.RoleName; db.SubmitChanges(); } }
/// <summary> /// 增加项目用户信息 /// </summary> /// <returns></returns> public static void AddProjectUser(Model.Project_ProjectUser projectUser) { Model.SUBHSSEDB db = Funs.DB; Model.Project_ProjectUser newProjectUser = new Model.Project_ProjectUser { ProjectUserId = SQLHelper.GetNewID(typeof(Model.Project_ProjectUser)), ProjectId = projectUser.ProjectId, UserId = projectUser.UserId, UnitId = projectUser.UnitId, RoleId = projectUser.RoleId, IsPost = projectUser.IsPost }; //newProjectUser.RoleName = projectUser.RoleName; db.Project_ProjectUser.InsertOnSubmit(newProjectUser); db.SubmitChanges(); }