/// <summary> /// 根据成员的ID实现项目成员的增删 /// </summary> /// <param name="request"></param> /// <param name="database"></param> /// <param name="project"></param> /// <param name="projectMemberIDs"></param> public static void SaveComOpeProjectMembers(this HttpRequest request, IDatabase database, Project project, string projectMemberIDs) { var memberID = projectMemberIDs.Split(','); var projectMembers = database.ProjectMembers.Where(d => d.ProjectID == project.ID); foreach (var item in projectMembers) { item.Delete(database); } foreach (var item in memberID) { if (item != string.Empty) { var intItem = Convert.ToInt32(item); var user = database.Users.SingleOrDefault(d => d.ID == intItem); var expert = database.Experts.SingleOrDefault(d => d.UserID == user.ID); var projectMember = new ProjectMember(); projectMember.Member = user; projectMember.Project = project; projectMember.College = expert.College; projectMember.Save(database); } } /*if (projectMemberIDs.Split(',').Count() > 0) { //存项目成员 for (var j = 0; j < projectMemberIDs.Split(',').Count() - 1; j++) { var projectMember = new ProjectMember(); projectMember.Project = project; var mId = projectMemberIDs.Split(',')[j]; int idm = Convert.ToInt32(mId); var member = database.Users.GetByID(idm);//应该是Expert? var ifProjectMember = database.ProjectMembers.SingleOrDefault(pm => pm.Project == project && pm.Member == member); if (ifProjectMember == null) { projectMember.Member = member; projectMember.Save(database); } } }*/ }
/// <summary> /// 根据成员的ID存储项目成员 /// </summary> /// <param name="request"></param> /// <param name="database"></param> /// <param name="project"></param> /// <param name="projectMemberIDs"></param> public static void SaveProjectMembers(this HttpRequest request, IDatabase database, Project project, string projectMemberIDs) { if (projectMemberIDs.Split(',').Count() > 0) { //存项目成员 for (var j = 0; j < projectMemberIDs.Split(',').Count() - 1; j++) { var projectMember = new ProjectMember(); projectMember.Project = project; var mId = projectMemberIDs.Split(',')[j]; int idm = Convert.ToInt32(mId); var member = database.Users.GetByID(idm);//应该是Expert? var ifProjectMember = database.ProjectMembers.SingleOrDefault(pm => pm.Project == project && pm.Member == member); if (ifProjectMember == null) { projectMember.Member = member; projectMember.Save(database); } } } }
/// <summary> /// 显示项目成员 /// </summary> /// <param name="projectMember"></param> /// <param name="response"></param> /// <param name="database"></param> public static void ShowProjectMember(ProjectMember projectMember, HttpResponse response, IDatabase database) { response.WriteTagWithValue("ID", projectMember.ID); response.WriteTagWithValue("ExpertName", projectMember.Member.Name); var expert = database.Experts.SingleOrDefault(c => c.User == projectMember.Member); if (expert.College != null) response.WriteTagWithValue("CollegeName", expert.College.Name); if(expert.College2!=null) response.WriteTagWithValue("College2Name", expert.College2.Name); response.WriteTagWithValue("Phone", expert.MobilePhone); response.WriteTagWithValue("Mail", expert.Email); response.WriteTagWithValue("UserID", expert.UserID); }
/// <summary> /// 显示项目成员及项目书 /// </summary> /// <param name="projectMember"></param> /// <param name="response"></param> /// <param name="database"></param> public static void ShowMemberApplyFilesMember(ProjectMember projectMember, HttpResponse response, IDatabase database) { response.WriteTagWithValue("ID", projectMember.ID); response.WriteTagWithValue("ExpertName", projectMember.Member.Name); response.WriteTagWithValue("ProjectFileName", projectMember.Member.Name + "-项目申报书" ); response.WriteTagWithValue("ProjectDeclarePath", projectMember.MemberDocPath); var path = projectMember.MemberDocPath; if(path!=null&&path!="") response.WriteTagWithValue("ProjectFileState", "可以下载"); else response.WriteTagWithValue("ProjectFileState", "不可下载,成员未提交申报书"); }