internal static void SetPrincipal(string F_ID, User user) { DataClassesDataContext dc = new DataClassesDataContext(); ApplicantMember member = new ApplicantMember(); if (dc.ApplicantMember.Count(_am => _am.F_applicantID.Equals(F_ID) && _am.F_userID.Equals(user.F_ID)) > 0) { return; } member.F_applicantID = F_ID; member.F_ID = Guid.NewGuid().ToString(); member.F_userID = user.F_ID; member.F_sexual = user.F_sexual; member.F_degree = user.F_highestDegree; member.F_education = user.F_highestEducation; member.F_birthday = user.F_birthday; member.F_expert = ""; member.F_seq = 0; member.F_duty = "项目负责人"; member.F_realName = user.F_realName; member.F_title = user.F_title; member.F_workspace = user.F_workDept; dc.ApplicantMember.InsertOnSubmit(member); dc.SubmitChanges(); }
private void SavePage9() { DataClassesDataContext dc = new DataClassesDataContext(); ScienceProject sciProject = dc.ScienceProject.SingleOrDefault(c => c.F_ID.Equals(F_ID)); sciProject.F_recommendContent = paras["F_recommendContent"]; sciProject.F_recommendName = paras["F_recommendName"]; sciProject.F_recommendTitle = paras["F_recommendTitle"]; sciProject.F_recommendExpert = paras["F_recommendExpert"]; sciProject.F_recommendWorkspace = paras["F_recommendWorkspace"]; var existMembers = dc.ApplicantMember.Where(am => am.F_applicantID.Equals(F_ID)); dc.ApplicantMember.DeleteAllOnSubmit(existMembers); foreach (ApplicantMember member in existMembers) { User user = dc.User.SingleOrDefault(_user => _user.F_ID.Equals(member.F_userID)); if (user != null && user.F_Role.Equals(RoleType.ProjectMember)) { dc.User.DeleteOnSubmit(user); } } if (!String.IsNullOrWhiteSpace(paras["F_userID"])) { String[] F_userIDs = paras["F_userID"].Split(new char[] { ',' }); String[] F_memberDutys = paras["F_memberDuty"].Split(new char[] { ',' }); String[] F_memberExperts = paras["F_memberExpert"].Split(new char[] { ',' }); String[] F_memberNames = paras["F_memberName"].Split(new char[] { ',' }); String[] F_memberTitles = paras["F_memberTitle"].Split(new char[] { ',' }); String[] F_memberWorkspaces = paras["F_memberWorkspace"].Split(new char[] { ',' }); String[] F_seqs = paras["F_seq"].Split(new char[] { ',' }); for (int i = 0; i < F_userIDs.Length; i++) { if (F_userIDs[i].Trim().Length == 0) { continue; } ApplicantMember member = new ApplicantMember(); member.F_applicantID = F_ID; member.F_ID = Guid.NewGuid().ToString(); member.F_userID = F_userIDs[i]; member.F_expert = F_memberExperts[i]; member.F_duty = F_memberDutys[i]; member.F_realName = F_memberNames[i]; member.F_title = F_memberTitles[i]; member.F_workspace = F_memberWorkspaces[i]; member.F_seq = UtilHelper.ParseInt(F_seqs[i]); dc.ApplicantMember.InsertOnSubmit(member); } } dc.SubmitChanges(); }
protected void btnAdd_Click(object sender, EventArgs e) { DataClassesDataContext dc = new DataClassesDataContext(); User user = new User(); user.F_ID = Guid.NewGuid().ToString(); user.F_realName = txtRealName.Text; user.F_Role = RoleType.ProjectMember; user.F_sexual = ddlSexual.SelectedValue; user.F_highestDegree = ddlDegree.SelectedValue; user.F_highestEducation = ddlEducation.SelectedValue; if (String.IsNullOrWhiteSpace(F_birthday.Value) == false) { user.F_birthday = DateTime.Parse(F_birthday.Value); } user.F_workspace = F_workspace.Value; user.F_phone = F_phone.Value; user.F_position = F_position.Value; user.F_title = ddlTitle.SelectedValue; user.F_email = F_email.Value; dc.User.InsertOnSubmit(user); dc.SubmitChanges(); ApplicantMember member = new ApplicantMember(); member.F_userID = user.F_ID; member.F_realName = user.F_realName; member.F_title = user.F_title; member.F_expert = F_expert.Value; member.F_workspace = user.F_workspace; member.F_birthday = user.F_birthday; member.F_sexual = user.F_sexual; member.F_education = user.F_highestEducation; member.F_degree = user.F_highestDegree; String result = UtilHelper.GetJSON(member); Response.Write("<script> window.opener.addUser('" + result + "'); window.close();</script>"); }
protected void btnSearch_Click(object sender, EventArgs e) { DataClassesDataContext dc = new DataClassesDataContext(); User user = dc.User.SingleOrDefault(_user => _user.F_idType.Equals(ddlType.SelectedValue) && _user.F_idNumber.Equals(txtNo.Text)); if (user != null) { ApplicantMember member = new ApplicantMember(); member.F_userID = user.F_ID; member.F_realName = user.F_realName; member.F_title = user.F_title; member.F_workspace = user.F_workspace; member.F_birthday = user.F_birthday; member.F_sexual = user.F_sexual; member.F_education = user.F_highestEducation; member.F_degree = user.F_highestDegree; String result = UtilHelper.GetJSON(member); Response.Write("<script> window.opener.addUser('" + result + "'); window.close();</script>"); } else { UtilHelper.AlertMsg("找不到指定用户"); } }
private string SavePage3() { DataClassesDataContext dc = new DataClassesDataContext(); EducationV2.SocialProject socialProject = dc.SocialProject.Single(c => c.F_ID.Equals(F_ID)); socialProject.F_keywords = paras["F_keywords"]; socialProject.F_researchType = paras["F_researchType"]; socialProject.F_sexual = paras["F_sexual"]; socialProject.F_nationality = paras["F_nationality"]; socialProject.F_IDNumber = paras["F_IDNumber"]; socialProject.F_duty = paras["F_duty"]; socialProject.F_subjectDuty = paras["F_subjectDuty"]; socialProject.F_expertise = paras["F_expertise"]; socialProject.F_education = paras["F_education"]; socialProject.F_degree = paras["F_degree"]; socialProject.F_mentor = paras["F_mentor"]; socialProject.F_workspace = paras["F_workspace"]; socialProject.F_phone = paras["F_phone"]; socialProject.F_teamName = paras["F_teamName"]; socialProject.F_recommendName = paras["F_recommendName"]; socialProject.F_recommendTitle = paras["F_recommendTitle"]; socialProject.F_recommendWorkspace = paras["F_recommendWorkspace"]; socialProject.F_achievement = paras["F_achievement"]; decimal number = 0; Decimal.TryParse(paras["F_wordCount"], out number); socialProject.F_wordCount = number; number = 0; Decimal.TryParse(paras["F_Fund"], out number); socialProject.F_Fund = number; if (String.IsNullOrWhiteSpace(paras["F_completeDate"]) == false) { socialProject.F_completeDate = DateTime.Parse(paras["F_completeDate"]); } var members = dc.ApplicantMember.Where(st => st.F_applicantID.Equals(F_ID)); dc.ApplicantMember.DeleteAllOnSubmit(members); foreach (ApplicantMember member in members) { User user = dc.User.SingleOrDefault(_user => _user.F_ID.Equals(member.F_userID)); if (user != null && user.F_Role.Equals(RoleType.ProjectMember)) { dc.User.DeleteOnSubmit(user); } } if (!String.IsNullOrWhiteSpace(paras["F_userID"])) { String[] F_memberIDs = paras["F_userID"].Split(new char[] { ',' }); String[] F_seqs = paras["F_seq"].Split(new char[] { ',' }); String[] F_memberNames = paras["F_memberName"].Split(new char[] { ',' }); String[] F_memberSexuals = paras["F_memberSexual"].Split(new char[] { ',' }); String[] F_memberBirthdays = paras["F_memberBirthday"].Split(new char[] { ',' }); String[] F_memberTitles = paras["F_memberTitle"].Split(new char[] { ',' }); String[] F_memberExperts = paras["F_memberExpert"].Split(new char[] { ',' }); String[] F_memberEducations = paras["F_memberEducation0"].Split(new char[] { ',' }); String[] F_memberDegrees = paras["F_memberDegree0"].Split(new char[] { ',' }); String[] F_memberWorkspaces = paras["F_memberWorkspace"].Split(new char[] { ',' }); for (int i = 0; i < F_memberIDs.Length; i++) { ApplicantMember member = new ApplicantMember(); member.F_applicantID = F_ID; member.F_ID = Guid.NewGuid().ToString(); member.F_userID = F_memberIDs[i]; member.F_seq = UtilHelper.ParseInt(F_seqs[i]); member.F_realName = F_memberNames[i]; member.F_sexual = F_memberSexuals[i]; if (String.IsNullOrWhiteSpace(F_memberBirthdays[i]) == false) { member.F_birthday = DateTime.Parse(F_memberBirthdays[i]); } member.F_title = F_memberTitles[i]; member.F_expert = F_memberExperts[i]; member.F_education = F_memberEducations[i]; member.F_degree = F_memberDegrees[i]; member.F_workspace = F_memberWorkspaces[i]; dc.ApplicantMember.InsertOnSubmit(member); } } dc.SubmitChanges(); return("保存成功"); }