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