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