protected void btnKeySearch_Click(object sender, EventArgs e) { DataClassesDataContext dc = new DataClassesDataContext(); // linq动态组合可参见http://www.cnblogs.com/whitewolf/archive/2010/08/02/1790166.html //>这里就简单做一下咯 User user = null; if (ddlField.SelectedValue == "F_userName") { user = dc.User.SingleOrDefault(_user => _user.F_userName.Equals(txtKeyword.Text.Trim())); } else if (ddlField.SelectedValue == "F_ID") { user = dc.User.SingleOrDefault(_user => _user.F_ID.Equals(txtKeyword.Text.Trim())); } if (user != null) { // 这样获取的result字符串有很多\/之类的玩意,会传不到前端哦 //> TODO User p_user = new User(); p_user.F_ID = user.F_ID; p_user.F_userName = user.F_userName; String result = UtilHelper.GetJSON(p_user); Response.Write("<script> window.opener.addUser('" + result + "'); window.close();</script>"); } else { UtilHelper.AlertMsg("找不到指定用户"); } }
private String savePage2() { context.Response.ContentType = "text/plain"; DataClassesDataContext dc = new DataClassesDataContext(); string id; Staff newStaff = null; if (getStaffID(out id)) { newStaff = dc.Staff.SingleOrDefault(staff => staff.F_StaffID.Equals(id /*paras["F_ID"]*/)); } if (newStaff == null) { return("系统中不存在该职工信息,请先保存职工基本资料!"); } var members = dc.StaffFamilyMember.Where(we => we.F_StaffID.Equals(id)); dc.StaffFamilyMember.DeleteAllOnSubmit(members); if (!String.IsNullOrWhiteSpace(paras["F_familyMemAppelation"])) { //String[] F_familyMemIDs = paras["F_familyMemID"].Split(new char[] { ',' }); String[] F_familyMemAppelations = paras["F_familyMemAppelation"].Split(new char[] { ',' }); String[] F_familyMemNames = paras["F_familyMemName"].Split(new char[] { ',' }); String[] F_familyMemBirthdays = paras["F_familyMemBirthday"].Split(new char[] { ',' }); String[] F_familyMemPartys = paras["F_familyMemParty"].Split(new char[] { ',' }); String[] F_familyMemWorkInfos = paras["F_familyMemWorkInfo"].Split(new char[] { ',' }); DateTime dt = DateTime.Now; for (int i = 0; i < F_familyMemAppelations.Length; i++) { StaffFamilyMember eb = new StaffFamilyMember(); eb.F_StaffID = newStaff.F_StaffID; eb.F_MemID = Guid.NewGuid().ToString(); eb.F_familyMemAppelation = F_familyMemAppelations[i]; eb.F_familyMemName = F_familyMemNames[i]; if (F_familyMemBirthdays[i].Trim().Length > 0) { DateTime.TryParse(F_familyMemBirthdays[i], out dt); eb.F_familyMemBirthday = dt; } eb.F_familyMemParty = F_familyMemPartys[i]; eb.F_familyMemWorkInfo = F_familyMemWorkInfos[i]; dc.StaffFamilyMember.InsertOnSubmit(eb); } } dc.SubmitChanges(); return(UtilHelper.GetJSON(newStaff)); }
private string GetFamilyMember() { context.Response.ContentType = "application/json"; DataClassesDataContext dc = new DataClassesDataContext(); String F_ID = context.Session[SessionMgm.VisitUserID].ToString(); var members = dc.FamilyMember.Where(pp => pp.F_userID.Equals(F_ID)); List <FamilyMember> pps = new List <FamilyMember>(); foreach (var member in members) { pps.Add(member); } return(UtilHelper.GetJSON(pps)); }
private string GetWorkExperience() { context.Response.ContentType = "application/json"; DataClassesDataContext dc = new DataClassesDataContext(); String F_ID = context.Session[SessionMgm.VisitUserID].ToString(); var workexperiences = dc.WorkExperience.Where(we => we.F_userID.Equals(F_ID)); List <WorkExperience> wes = new List <WorkExperience>(); foreach (var workexperience in workexperiences) { wes.Add(workexperience); } return(UtilHelper.GetJSON(wes)); }
private string GetPatent() { context.Response.ContentType = "application/json"; DataClassesDataContext dc = new DataClassesDataContext(); String F_ID = context.Session[SessionMgm.VisitUserID].ToString(); var patents = dc.Patent.Where(pt => pt.F_userID.Equals(F_ID)); List <Patent> pts = new List <Patent>(); foreach (var patent in patents) { pts.Add(patent); } return(UtilHelper.GetJSON(pts)); }
private string GetAward() { context.Response.ContentType = "application/json"; DataClassesDataContext dc = new DataClassesDataContext(); String F_ID = context.Session[SessionMgm.VisitUserID].ToString(); var awards = dc.Award.Where(pp => pp.F_userID.Equals(F_ID)); List <Award> pps = new List <Award>(); foreach (var award in awards) { pps.Add(award); } return(UtilHelper.GetJSON(pps)); }
private string FindUser() { String result = ""; context.Response.ContentType = "application/json"; DataClassesDataContext dc = new DataClassesDataContext(); String F_idType = paras["F_idType"]; String F_idNo = paras["F_idNo"]; User user = dc.User.SingleOrDefault(u => u.F_idType.Equals(F_idType) && u.F_idNumber.Equals(F_idNo)); if (user != null) { result = UtilHelper.GetJSON(user); } return(result); }
protected void btnSearch_Click(object sender, EventArgs e) { DataClassesDataContext dc = new DataClassesDataContext(); // 如果user是RoleType.ProjectMember类型的,也会查找到 by cy [20140919] User user = dc.User.SingleOrDefault(_user => _user.F_idType.Equals(ddlType.SelectedValue) && _user.F_idNumber.Equals(txtNo.Text)); if (user != null) { String result = UtilHelper.GetJSON(user); Response.Write("<script> window.opener.addUser('" + result + "'); window.close();</script>"); } else { UtilHelper.AlertMsg("找不到指定用户"); } }
private string FillUnitInfo() { context.Response.ContentType = "application/json"; DataClassesDataContext dc = new DataClassesDataContext(); if (context.Session[SessionMgm.VisitUserID] != null) { String F_ID = context.Session[SessionMgm.VisitUserID].ToString(); User user = dc.User.SingleOrDefault(_user => _user.F_ID.Equals(F_ID)); if (user != null && String.IsNullOrEmpty(user.F_belongUnitID) == false) { ApplicantUnit unit = dc.ApplicantUnit.SingleOrDefault(_unit => _unit.F_ID.Equals(user.F_belongUnitID)); return(UtilHelper.GetJSON(unit)); } } return(""); }
private string GetBaseInfo() { context.Response.ContentType = "application/json"; String id; if (!getStaffID(out id)) { return(JSON_NULL); // todo } String result = String.Empty; DataClassesDataContext dc = new DataClassesDataContext(); Staff newStaff = dc.Staff.SingleOrDefault(staff => staff.F_StaffID.Equals(id)); if (newStaff != null) { result = UtilHelper.GetJSON(newStaff); } return(result); }
private string GetFamilyMember() { context.Response.ContentType = "application/json"; DataClassesDataContext dc = new DataClassesDataContext(); String id; if (!getStaffID(out id)) { return(JSON_NULL); // todo } var members = dc.StaffFamilyMember.Where(pp => pp.F_StaffID.Equals(id)); List <StaffFamilyMember> pps = new List <StaffFamilyMember>(); foreach (var member in members) { pps.Add(member); } return(UtilHelper.GetJSON(pps)); }
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>"); }
private String savePage3() { context.Response.ContentType = "text/plain"; DataClassesDataContext dc = new DataClassesDataContext(); string id; Staff newStaff = null; if (getStaffID(out id)) { newStaff = dc.Staff.SingleOrDefault(staff => staff.F_StaffID.Equals(id /*paras["F_ID"]*/)); } if (newStaff == null) { return("系统中不存在该职工信息,请先保存职工基本资料!"); } newStaff.F_resume = paras["F_resume"]; newStaff.F_rwdandpunishmt = paras["F_rwdandpunishmt"]; newStaff.F_lastModifyTime = DateTime.Now; dc.SubmitChanges(); return(UtilHelper.GetJSON(newStaff)); }
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 LoadMenu() { String role = context.Session[SessionMgm.Role].ToString(); String status = GetStatus(); List <ExtjsComponent> components = new List <ExtjsComponent>(); //单位管理,非专家都是管理员 if (!role.Equals(RoleType.Applicant)) { ExtjsComponent component = new ExtjsComponent(); component.xtype = "panel"; component.height = 200; component.width = 200; component.title = "单位管理"; StringBuilder sb = new StringBuilder(); if (role.Equals(RoleType.OrgDeptAdmin)) //单位管理员可以管部门,修改单位信息 { sb.Append("<a target='rightFrame' href='frmModifyScho.aspx'>单位信息管理</a> <p />"); sb.Append("<a target='rightFrame' href='frmDeptManage.aspx'>部门管理</a> <p />"); } if (role.Equals(RoleType.EduAdmin)) //教育厅管理人员可以审核 { sb.Append("<a target='rightFrame' href='frmSchoMgm.aspx'>单位管理</a> <p />"); sb.Append("<a target='rightFrame' href='frmAdminManag.aspx'>人员管理</a> <p />"); } else { sb.Append("<a target='rightFrame' href='frmUserManage.aspx'>人员管理</a> <p />"); } component.html = sb.ToString(); components.Add(component); } //申报管理,只要经过审核就可以申报 if (status.Equals(InfoStatus.Authoried)) { ExtjsComponent component = new ExtjsComponent(); component.xtype = "panel"; component.height = 200; component.width = 200; component.title = "申报管理"; StringBuilder sb = new StringBuilder(); if (role.Equals(RoleType.EduAdmin) || role.Equals(RoleType.OrgDeptAdmin)) { sb.Append("<a target='rightFrame' href='frmProjectManage.aspx'>计划管理</a> <p />"); } sb.Append("<a target='rightFrame' href='frmSciProjectList.aspx'>科技项目申报管理</a> <p />"); sb.Append("<a target='rightFrame' href='frmSocialProjectList.aspx'>社科项目申报管理</a> <p />"); component.html = sb.ToString(); components.Add(component); } ExtjsComponent comp = new ExtjsComponent(); comp.xtype = "panel"; comp.height = 200; comp.width = 200; comp.title = "立项管理"; comp.html = " <a target='rightFrame' href='frmApprovalList.aspx'>立项项目管理</a>"; components.Add(comp); comp = new ExtjsComponent(); comp.xtype = "panel"; comp.height = 200; comp.width = 200; comp.title = "综合查询"; comp.html = " <a target='rightFrame' href='frmAdvanceSearch.aspx'>项目查询</a>"; components.Add(comp); comp = new ExtjsComponent(); comp.xtype = "panel"; comp.height = 200; comp.width = 200; comp.title = "执行和验收"; comp.html = "<a target='rightFrame' href='frmExecuteList.aspx'> 项目执行情况表</a> <p />" + " <a target='rightFrame' href='frmAcceptApplicantList.aspx'> 验收申请书 </a>"; components.Add(comp); comp = new ExtjsComponent(); comp.xtype = "panel"; comp.height = 200; comp.width = 200; comp.title = "个人信息维护"; comp.html = " <a target='rightFrame' href='frmUserDetail.aspx?type=self'> 个人信息 </a> <p />" + " <a target='rightFrame' href='frmModifyPWD.aspx'> 密码修改 </a>"; components.Add(comp); return(UtilHelper.GetJSON(components)); }
private String saveBaseInfo() { context.Response.ContentType = "text/plain"; DataClassesDataContext dc = new DataClassesDataContext(); bool insert = false; string id; Staff newStaff; if (getStaffID(out id)) { newStaff = dc.Staff.SingleOrDefault(staff => staff.F_StaffID.Equals(id /*paras["F_ID"]*/)); } else { newStaff = new Staff(); newStaff.F_StaffID = Guid.NewGuid().ToString(); insert = true; } newStaff.F_empno = paras["F_empno"]; if (String.IsNullOrWhiteSpace(newStaff.F_empno) == false) { Staff t = dc.Staff.SingleOrDefault(_staff => _staff.F_empno.Equals(newStaff.F_empno)); if (t != null && t.F_StaffID.Equals(newStaff.F_StaffID) == false) { return("档案库中已存在相同的教工号"); } } if (String.IsNullOrEmpty(paras["F_UserID"]) == false) { newStaff.F_UserID = paras["F_UserID"].ToString().Trim(); newStaff.F_userName = paras["F_userName"]; } else { newStaff.F_UserID = createNewUser(dc); newStaff.F_userName = paras["F_empno"]; } newStaff.F_realName = paras["F_realName"]; newStaff.F_sexual = paras["F_sexual"]; if (String.IsNullOrEmpty(paras["F_birthday"]) == false) { newStaff.F_birthday = DateTime.Parse(paras["F_birthday"]); } newStaff.F_bornplace = paras["F_bornplace"]; newStaff.F_nativeplace = paras["F_nativeplace"]; newStaff.F_nationality = paras["F_nationality"]; newStaff.F_party = paras["F_party"]; if (String.IsNullOrEmpty(paras["F_partyEntryDate"]) == false) { newStaff.F_partyEntryDate = DateTime.Parse(paras["F_partyEntryDate"]); } newStaff.F_highestDegree = paras["F_highestDegree"]; newStaff.F_highestEducation = paras["F_highestEducation"]; newStaff.F_highestGrduateSch = paras["F_highestGrduateSch"]; if (String.IsNullOrEmpty(paras["F_workBeginDate"]) == false) { newStaff.F_workBeginDate = DateTime.Parse(paras["F_workBeginDate"]); } newStaff.F_workDept = paras["F_workDeptText"]; newStaff.F_belongDeptID = paras["F_workDept"]; newStaff.F_position = paras["F_position"]; newStaff.F_title = paras["F_title"]; if (String.IsNullOrEmpty(paras["F_posBeginDate"]) == false) { newStaff.F_posBeginDate = DateTime.Parse(paras["F_posBeginDate"]); } newStaff.F_adminRanking = paras["F_adminRanking"]; if (String.IsNullOrEmpty(paras["F_adminRkBeginDate"]) == false) { newStaff.F_adminRkBeginDate = DateTime.Parse(paras["F_adminRkBeginDate"]); } newStaff.F_idType = paras["F_idType"]; newStaff.F_idNumber = paras["F_idNumber"]; if (String.IsNullOrWhiteSpace(newStaff.F_idNumber) == false) { Staff t = dc.Staff.SingleOrDefault(_staff => _staff.F_idType.Equals(newStaff.F_idType) && _staff.F_idNumber.Equals(newStaff.F_idNumber)); if (t != null && t.F_StaffID.Equals(newStaff.F_StaffID) == false) { return("档案库中已存在相同的证件号和证件名"); } } newStaff.F_mobile = paras["F_mobile"]; newStaff.F_phone = paras["F_phone"]; newStaff.F_phone2 = paras["F_phone2"]; newStaff.F_email = paras["F_email"]; newStaff.F_freeAddress = paras["F_freeAddress"]; newStaff.F_fax = paras["F_fax"]; newStaff.F_status = paras["F_status"]; newStaff.F_lastModifyTime = DateTime.Now; if (insert) { dc.Staff.InsertOnSubmit(newStaff); } dc.SubmitChanges(); return(UtilHelper.GetJSON(newStaff)); }