protected void btnAdd_Click(object sender, EventArgs e)
{
DataClassesDataContext dc = new DataClassesDataContext();
User user = dc.User.SingleOrDefault(_user => _user.F_userName.Equals(txtName.Text));
if (user != null)
{
Response.Write("<script>alert('该用户名已被使用');</script>");
return;
}
user = new EducationV2.User();
user.F_ID = Guid.NewGuid().ToString();
user.F_status = ddlType.SelectedValue;
user.F_belongUnitID = ddlBelongUnit.SelectedValue;
user.F_Role = ddlRole.SelectedValue;
user.F_realName = txtRealName.Text;
user.F_pwd = UtilHelper.MD5Encrypt(txtPwd.Text);
user.F_userName = txtName.Text;
dc.User.InsertOnSubmit(user);
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 schoolBtn_Click(object sender, EventArgs e)
{
if (Session[SessionMgm.Role].Equals(RoleType.SchoolAdmin) == false)
{
UtilHelper.AlertInUpdatePanel(UpdatePanel1, this.GetType(), "没有权限");
return;
}
DataClassesDataContext dc = new DataClassesDataContext();
DateTime dt = DateTime.Now;
RemoveHistoricalOpinion(F_ID, RoleType.SchoolAdmin);
EducationV2.ScienceProject socialProject = dc.ScienceProject.Single(c => c.F_ID.Equals(F_ID));
AuditOpinion opinion = new AuditOpinion();
opinion.F_projectID = F_ID;
opinion.F_ID = Guid.NewGuid().ToString();
opinion.F_content = schoolContent.Text;
DateTime.TryParse(schoolDate.Text, out dt);
opinion.F_date = dt;
opinion.F_type = RoleType.SchoolAdmin;
if (schoolResult.SelectedValue == "审核通过")
{
if (EducationV2.Services.AssignProjectService.AvailToApply(socialProject) == false)
{
UtilHelper.AlertInUpdatePanel(UpdatePanel1, this.GetType(), "可用额度不足，请检查贵单位的授权限额");
return;
}
socialProject.F_status = ProjectStatus.UnderEducationAudit;
}
else
{
socialProject.F_status = ProjectStatus.Deny;
}
opinion.F_result = schoolResult.SelectedValue;
dc.AuditOpinion.InsertOnSubmit(opinion);
dc.SubmitChanges();
Response.Redirect("frmSciProject.aspx?tabNum=10&id=" + F_ID);
}
protected void btnUnitConfirm_Click(object sender, EventArgs e)
{
DataClassesDataContext dc = new DataClassesDataContext();
ExecuteStatus es = dc.ExecuteStatus.SingleOrDefault(ess => ess.F_projectID.Equals(projectID));
if (radScho.SelectedValue.Equals("审核不通过"))
{
es.F_status = ProjectStatus.Deny;
}
else
{
es.F_status = ProjectStatus.UnderEducationAudit;
}
es.F_unitComment = txtUnitComment.Text;
if (String.IsNullOrEmpty(txtUnitCheckDate.Text) == false)
{
es.F_unitCheckDate = DateTime.Parse(txtUnitCheckDate.Text);
}
AuditOperation.SetAudit(projectID, RoleType.SchoolAdmin, radScho.SelectedValue, es.F_unitCheckDate.Value);
dc.SubmitChanges();
Response.Redirect("frmExecute.aspx?tabNum=4");
}
protected void btnDel_Click(object sender, EventArgs e)
{
DataClassesDataContext dc = new DataClassesDataContext();
List <String> ids = GetSelectedIDs();
IEnumerable <PosApplicant> records = null;
if (Session[SessionMgm.Role].ToString().Equals(RoleType.Applicant) == false)
{
records = dc.PosApplicant.Where(_apl => ids.Contains(_apl.F_ID));
}
else
{
records = dc.PosApplicant.Where(_apl => ids.Contains(_apl.F_ID) &&
!_apl.F_statusEnum.Equals((short)ProjectStatus.EStatus.ApplicantComplete));
}
dc.PosApplicant.DeleteAllOnSubmit(records);
dc.SubmitChanges();
GridView1.PageIndex = 0;
Response.Redirect("frmPosApplicantList.aspx");
}
protected void Button1_Click(object sender, EventArgs e)
{
String[] units = txtUnitName.Text.Trim().Split(new char[] { '\n' });
String[] admins = txtAdminName.Text.Trim().Split(new char[] { '\n' });
if (units.Length != admins.Length)
{
UtilHelper.AlertMsg("error");
}
else
{
DataClassesDataContext dc = new DataClassesDataContext();
for (int i = 0; i < units.Length; i++)
{
ApplicantUnit unit = new ApplicantUnit();
unit.F_ID = UnitService.GetID();
unit.F_name = units[i];
unit.F_status = RoleType.Authoried;
unit.F_seq = UnitService.GetSeq();
admins[i] = admins[i].Trim();
EducationV2.User user = new EducationV2.User();
user.F_ID = Guid.NewGuid().ToString();
user.F_userName = admins[i];
if (dc.User.SingleOrDefault(_user => _user.F_userName.Equals(admins[i])) != null)
{
Response.Write("重复");
return;
}
user.F_realName = admins[i];
user.F_pwd = UtilHelper.MD5Encrypt("000000");
user.F_status = RoleType.Authoried;
user.F_Role = RoleType.SchoolAdmin;
user.F_belongUnitID = unit.F_ID;
dc.ApplicantUnit.InsertOnSubmit(unit);
dc.User.InsertOnSubmit(user);
dc.SubmitChanges();
}
}
}
protected void btnConfirm_Click(object sender, EventArgs e)
{
DataClassesDataContext dc = new DataClassesDataContext();
bool isNew = true;
CompleteStatus cs;
if (Request["id"] != null)
{
cs = dc.CompleteStatus.SingleOrDefault(ccs => ccs.F_ID.Equals(Request["id"]));
isNew = false;
}
else
{
cs = new CompleteStatus();
cs.F_ID = Guid.NewGuid().ToString();
}
if (String.IsNullOrEmpty(txtMoney.Text) == false)
{
cs.F_money = decimal.Parse(txtMoney.Text);
}
cs.F_projectID = Session["projectID"].ToString();
cs.F_task = txtTask.Text;
cs.F_completeStatus = ddlCompleteStatus.SelectedValue;
if (String.IsNullOrEmpty(txtFinishDate.Text) == false)
{
cs.F_finishDate = DateTime.Parse(txtFinishDate.Text);
}
if (String.IsNullOrEmpty(txtStartDate.Text) == false)
{
cs.F_startDate = DateTime.Parse(txtStartDate.Text);
}
if (isNew)
{
dc.CompleteStatus.InsertOnSubmit(cs);
}
dc.SubmitChanges();
}
protected void btnDel_Click(object sender, EventArgs e)
{
List <String> unitIDs = GetSelectedIDs();
if (unitIDs.Contains(UnitService.EDUID))
{
UtilHelper.AlertMsg("教育厅不可删除");
return;
}
DataClassesDataContext dc = new DataClassesDataContext();
var units = dc.ApplicantUnit.Where(_unit => unitIDs.Contains(_unit.F_ID));
dc.ApplicantUnit.DeleteAllOnSubmit(units);
foreach (String unitID in unitIDs)
{
var users = dc.User.Where(_user => _user.F_belongUnitID.Equals(unitID));
dc.User.DeleteAllOnSubmit(users);
var depts = dc.DeptMent.Where(_dept => _dept.F_unitID.Equals(unitID));
dc.DeptMent.DeleteAllOnSubmit(depts);
}
dc.SubmitChanges();
BindData();
}
protected void EduBtn_Click(object sender, EventArgs e)
{
if (Session[SessionMgm.Role].Equals(RoleType.EduAdmin) == false)
{
UtilHelper.AlertInUpdatePanel(UpdatePanel1, this.GetType(), "没有权限");
return;
}
DataClassesDataContext dc = new DataClassesDataContext();
DateTime dt = DateTime.Now;
RemoveHistoricalOpinion(F_ID, RoleType.EduAdmin);
EducationV2.SocialProject socialProject = dc.SocialProject.Single(c => c.F_ID.Equals(F_ID));
socialProject.F_status = ProjectStatus.Approval;
AuditOpinion opinion = new AuditOpinion();
opinion.F_projectID = F_ID;
opinion.F_ID = Guid.NewGuid().ToString();
opinion.F_content = EduContent.Text;
DateTime.TryParse(EduDate.Text, out dt);
opinion.F_date = dt;
opinion.F_type = RoleType.EduAdmin;
opinion.F_result = EduResult.SelectedValue;
dc.AuditOpinion.InsertOnSubmit(opinion);
if (opinion.F_result.Equals("审核不通过"))
{
socialProject.F_status = ProjectStatus.Deny;
}
else
{
socialProject.F_status = ProjectStatus.Pass;
}
//if(socialProject.F_applicantDate != null )
// socialProject.F_code = Services.SocialProject.GetCode(socialProject.F_type, socialProject.F_applicantDate.Value.Year.ToString());
dc.SubmitChanges();
Response.Redirect("frmSocialProject.aspx?tabNum=6&id=" + F_ID);
}
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 GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "ret")
{
String role = Session[SessionMgm.Role].ToString();
String id = e.CommandArgument.ToString();
DataClassesDataContext dc = new DataClassesDataContext();
SocialProject project = dc.SocialProject.SingleOrDefault(_sp => _sp.F_ID.Equals(id));
if (project.F_status.Equals(ProjectStatus.UnderEducationAudit) && role.Equals(RoleType.SchoolAdmin))
{
project.F_status = ProjectStatus.UnderSchoolAudit;
}
else if (project.F_status.Equals(ProjectStatus.UnderSchoolAudit) && role.Equals(RoleType.DeptAdmin))
{
project.F_status = ProjectStatus.UnderDeptAudit;
}
else if (project.F_status.Equals(ProjectStatus.UnderDeptAudit) && role.Equals(RoleType.Expert))
{
project.F_status = ProjectStatus.Draft;
}
dc.SubmitChanges();
Response.Redirect("frmSocialProjectList.aspx");
}
}
protected void btnUpload_Click(object sender, EventArgs e)
{
if (FileUpload1.HasFile)
{
String id = Guid.NewGuid().ToString();
String filename = id + Path.GetExtension(FileUpload1.FileName);
String file = Server.MapPath("/uploadFiles/" + filename);
FileUpload1.SaveAs(file);
DataClassesDataContext dc = new DataClassesDataContext();
Attachment attachment = new Attachment();
attachment.F_date = DateTime.Now;
attachment.F_name = FileUpload1.FileName;
attachment.F_ID = filename;
attachment.F_projectID = Session[SessionMgm.AttachmentProjectID].ToString();
attachment.F_size = FileUpload1.PostedFile.ContentLength / 1024;
attachment.F_fileType = FileUpload1.PostedFile.ContentType;
attachment.F_attachmenttype = Int32.Parse(Request["type"].ToString());
dc.Attachment.InsertOnSubmit(attachment);
dc.SubmitChanges();
Response.Write("<script>alert('上传成功')</script>");
gvAttachment.DataBind();
}
}
protected void btnDeny_Click(object sender, EventArgs e)
{
DataClassesDataContext dc = new DataClassesDataContext();
List <String> ids = GetSelectedIDs();
foreach (String id in ids)
{
ScienceProject sciProject = dc.ScienceProject.SingleOrDefault(_sp => _sp.F_ID.Equals(id));
if (sciProject != null)
{
sciProject.F_status = ProjectStatus.Deny;
}
else
{
SocialProject socialProject = dc.SocialProject.SingleOrDefault(_sp => _sp.F_ID.Equals(id));
if (socialProject != null)
{
socialProject.F_status = ProjectStatus.Deny;
}
}
dc.SubmitChanges();
}
GridView1.DataBind();
}
private String saveBaseInfo()
{
String F_ID = context.Session[SessionMgm.VisitUserID].ToString();
context.Response.ContentType = "text/plain";
DataClassesDataContext dc = new DataClassesDataContext();
bool insert = false;
User newUser = dc.User.SingleOrDefault(user => user.F_ID.Equals(F_ID /*paras["F_ID"]*/));
if (newUser == null)
{
newUser = new User();
newUser.F_Role = RoleType.Applicant;
newUser.F_ID = paras["F_ID"];
insert = true;
}
// newUser.F_userName = paras["F_userName"];
newUser.F_realName = paras["F_realName"];
newUser.F_sexual = paras["F_sexual"];
if (String.IsNullOrEmpty(paras["F_birthday"]) == false)
{
newUser.F_birthday = DateTime.Parse(paras["F_birthday"]);
}
newUser.F_bornplace = paras["F_bornplace"];
newUser.F_nativeplace = paras["F_nativeplace"];
newUser.F_nationality = paras["F_nationality"];
newUser.F_party = paras["F_party"];
if (String.IsNullOrEmpty(paras["F_partyEntryDate"]) == false)
{
newUser.F_partyEntryDate = DateTime.Parse(paras["F_partyEntryDate"]);
}
newUser.F_highestDegree = paras["F_highestDegree"];
newUser.F_highestEducation = paras["F_highestEducation"];
newUser.F_highestGrduateSch = paras["F_highestGrduateSch"];
if (String.IsNullOrEmpty(paras["F_workBeginDate"]) == false)
{
newUser.F_workBeginDate = DateTime.Parse(paras["F_workBeginDate"]);
}
newUser.F_workDept = paras["F_workDeptText"];
newUser.F_belongDeptID = paras["F_workDept"];
newUser.F_position = paras["F_position"];
newUser.F_title = paras["F_title"];
if (String.IsNullOrEmpty(paras["F_posBeginDate"]) == false)
{
newUser.F_posBeginDate = DateTime.Parse(paras["F_posBeginDate"]);
}
newUser.F_adminRanking = paras["F_adminRanking"];
if (String.IsNullOrEmpty(paras["F_adminRkBeginDate"]) == false)
{
newUser.F_adminRkBeginDate = DateTime.Parse(paras["F_adminRkBeginDate"]);
}
newUser.F_idType = paras["F_idType"];
newUser.F_idNumber = paras["F_idNumber"];
if (String.IsNullOrWhiteSpace(newUser.F_idNumber) == false)
{
User t = dc.User.SingleOrDefault(_user => _user.F_idType.Equals(newUser.F_idType) && _user.F_idNumber.Equals(newUser.F_idNumber));
if (t != null && t.F_ID.Equals(newUser.F_ID) == false)
{
return("系统中已存在相同的证件号和证件名");
}
}
newUser.F_mobile = paras["F_mobile"];
newUser.F_phone = paras["F_phone"];
newUser.F_phone2 = paras["F_phone2"];
newUser.F_email = paras["F_email"];
newUser.F_freeAddress = paras["F_freeAddress"];
newUser.F_fax = paras["F_fax"];
newUser.F_lastModifyTime = DateTime.Now;
if (insert)
{
dc.User.InsertOnSubmit(newUser);
}
dc.SubmitChanges();
return("保存成功");
}
private void SavePage2()
{
String F_ID = context.Session[SessionMgm.VisitUserID].ToString();
DataClassesDataContext dc = new DataClassesDataContext();
bool insert = false;
User newUser = dc.User.SingleOrDefault(user => user.F_ID.Equals(F_ID));
if (newUser == null)
{
newUser = new User();
newUser.F_ID = F_ID;
newUser.F_Role = RoleType.Expert;
insert = true;
}
Decimal num = 0;
Decimal.TryParse(paras["F_appliedCivInvPatent"], out num);
newUser.F_appliedCivInvPatent = num;
num = 0;
Decimal.TryParse(paras["F_authedCivInvPatent"], out num);
newUser.F_authedCivInvPatent = num;
num = 0;
Decimal.TryParse(paras["F_appliedForeInvPatent"], out num);
newUser.F_appliedForeInvPatent = num;
num = 0;
Decimal.TryParse(paras["F_authedForeInvPatent"], out num);
newUser.F_authedForeInvPatent = num;
num = 0;
Decimal.TryParse(paras["F_appliedCivUtiPatent"], out num);
newUser.F_appliedCivUtiPatent = num;
num = 0;
Decimal.TryParse(paras["F_authedCivUtilPatent"], out num);
newUser.F_authedCivUtilPatent = num;
num = 0;
Decimal.TryParse(paras["F_appliedForUtiPatent"], out num);
newUser.F_appliedForUtiPatent = num;
num = 0;
Decimal.TryParse(paras["F_authedForUtiPatent"], out num);
newUser.F_authedForUtiPatent = num;
num = 0;
Decimal.TryParse(paras["F_publishCivPaper"], out num);
newUser.F_publishCivPaper = num;
num = 0;
Decimal.TryParse(paras["F_publishForPaper"], out num);
newUser.F_publishForPaper = num;
num = 0;
Decimal.TryParse(paras["F_publishMonograph"], out num);
newUser.F_publishMonograph = num;
DateTime dt = DateTime.Now;
var workexperiences = dc.WorkExperience.Where(we => we.F_userID.Equals(F_ID));
dc.WorkExperience.DeleteAllOnSubmit(workexperiences);
if (!String.IsNullOrWhiteSpace(paras["F_workspace"]))
{
String[] F_workspaces = paras["F_workspace"].Split(new char[] { ',' });
String[] F_beginDates = paras["F_beginDate"].Split(new char[] { ',' });
String[] F_endDates = paras["F_endDate"].Split(new char[] { ',' });
String[] F_contents = paras["F_content"].Split(new char[] { ',' });
for (int i = 0; i < F_workspaces.Length; i++)
{
WorkExperience eb = new WorkExperience();
eb.F_userID = newUser.F_ID;
eb.F_workspace = F_workspaces[i];
eb.F_ID = Guid.NewGuid().ToString();
if (F_beginDates[i].Trim().Length > 0)
{
dt = DateTime.Now;
DateTime.TryParse(F_beginDates[i], out dt);
eb.F_beginDate = dt;
}
if (F_endDates[i].Trim().Length > 0)
{
dt = DateTime.Now;
DateTime.TryParse(F_endDates[i], out dt);
eb.F_endDate = dt;
}
eb.F_content = F_contents[i];
dc.WorkExperience.InsertOnSubmit(eb);
}
}
var patents = dc.Patent.Where(pa => pa.F_userID.Equals(F_ID));
dc.Patent.DeleteAllOnSubmit(patents);
if (!String.IsNullOrWhiteSpace(paras["F_patentName"]))
{
String[] F_patentNames = paras["F_patentName"].Split(new char[] { ',' });
String[] F_patentCodes = paras["F_patentCode"].Split(new char[] { ',' });
String[] F_patentTypes = paras["F_patentType"].Split(new char[] { ',' });
String[] F_patentDeclareDates = paras["F_patentDeclareDate"].Split(new char[] { ',' });
for (int i = 0; i < F_patentNames.Length; i++)
{
Patent eb = new Patent();
eb.F_userID = newUser.F_ID;
eb.F_ID = Guid.NewGuid().ToString();
if (F_patentDeclareDates[i].Trim().Length > 0)
{
dt = DateTime.Now;
DateTime.TryParse(F_patentDeclareDates[i], out dt);
eb.F_declareDate = dt;
}
eb.F_name = F_patentNames[i];
eb.F_type = F_patentTypes[i];
eb.F_code = F_patentCodes[i];
dc.Patent.InsertOnSubmit(eb);
}
}
var papers = dc.PublishedPaper.Where(pp => pp.F_USERID.Equals(F_ID));
dc.PublishedPaper.DeleteAllOnSubmit(papers);
if (!String.IsNullOrWhiteSpace(paras["F_paperName"]))
{
String[] F_paperNames = paras["F_paperName"].Split(new char[] { ',' });
String[] F_journalNames = paras["F_journalName"].Split(new char[] { ',' });
String[] F_journalCodes = paras["F_journalCode"].Split(new char[] { ',' });
String[] F_volumes = paras["F_volume"].Split(new char[] { ',' });
String[] F_paperRanks = paras["F_paperRank"].Split(new char[] { ',' });
for (int i = 0; i < F_paperNames.Length; i++)
{
PublishedPaper eb = new PublishedPaper();
eb.F_USERID = F_ID;
eb.F_ID = Guid.NewGuid().ToString();
eb.F_journalCode = F_journalCodes[i];
eb.F_journalName = F_journalNames[i];
eb.F_name = F_paperNames[i];
eb.F_rank = F_paperRanks[i];
eb.F_volume = F_volumes[i];
dc.PublishedPaper.InsertOnSubmit(eb);
}
}
var awards = dc.Award.Where(pp => pp.F_userID.Equals(F_ID));
dc.Award.DeleteAllOnSubmit(awards);
if (!String.IsNullOrWhiteSpace(paras["F_awardName"]))
{
String[] F_awardDates = paras["F_awardDate"].Split(new char[] { ',' });
String[] F_awardNames = paras["F_awardName"].Split(new char[] { ',' });
String[] F_awardProjectNames = paras["F_awardProjectName"].Split(new char[] { ',' });
String[] F_awardGrades = paras["F_awardGrade"].Split(new char[] { ',' });
String[] F_awardRanks = paras["F_awardRank"].Split(new char[] { ',' });
String[] F_issuedUnits = paras["F_issuedUnit"].Split(new char[] { ',' });
for (int i = 0; i < F_awardDates.Length; i++)
{
Award eb = new Award();
eb.F_userID = F_ID;
eb.F_ID = Guid.NewGuid().ToString();
dt = DateTime.Now;
DateTime.TryParse(F_awardDates[i], out dt);
eb.F_grantDate = dt;
eb.F_name = F_awardNames[i];
eb.F_projectName = F_awardProjectNames[i];
eb.F_grade = F_awardGrades[i];
eb.F_rank = F_awardRanks[i];
eb.F_issuedUnit = F_issuedUnits[i];
dc.Award.InsertOnSubmit(eb);
}
}
if (insert)
{
dc.User.InsertOnSubmit(newUser);
}
dc.SubmitChanges();
}
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));
}
private String AddExpert()
{
context.Response.ContentType = "text/plain";
DataClassesDataContext dc = new DataClassesDataContext();
bool insert = false;
User newUser = dc.User.SingleOrDefault(user => user.F_ID.Equals(paras["F_ID"]));
if (newUser == null)
{
newUser = new User();
newUser.F_Role = RoleType.Expert;
newUser.F_ID = paras["F_ID"];
insert = true;
}
newUser.F_userName = paras["F_userName"];
newUser.F_realName = paras["F_realName"];
newUser.F_sexual = paras["F_sexual"];
newUser.F_idType = paras["F_idType"];
newUser.F_nationality = paras["F_nationality"];
newUser.F_highestDegree = paras["F_highestDegree"];
newUser.F_highestEducation = paras["F_highestEducation"];
newUser.F_idNumber = paras["F_idNumber"];
if (String.IsNullOrWhiteSpace(newUser.F_idNumber) == false)
{
User t = dc.User.SingleOrDefault(_user => _user.F_idType.Equals(newUser.F_idType) && _user.F_idNumber.Equals(newUser.F_idNumber));
if (t != null && t.F_ID.Equals(newUser.F_ID) == false)
{
return("系统中已存在相同的证件号和证件名");
}
}
DateTime dt = DateTime.Now;
if (String.IsNullOrEmpty(paras["F_birthday"]) == false)
{
newUser.F_birthday = DateTime.Parse(paras["F_birthday"]);
}
newUser.F_workspace = paras["F_workspace"];
newUser.F_phone = paras["F_phone"];
newUser.F_workDept = paras["F_workDept"];
newUser.F_legalCode = paras["F_legalCode"];
newUser.F_phone2 = paras["F_phone2"];
newUser.F_position = paras["F_position"];
newUser.F_title = paras["F_title"];
newUser.F_email = paras["F_email"];
newUser.F_mobile = paras["F_mobile"];
newUser.F_adminUnit = paras["F_adminUnit"];
newUser.F_email2 = paras["F_email2"];
newUser.F_fax = paras["F_fax"];
newUser.F_freeAddress = paras["F_freeAddress"];
newUser.F_freeZipCode = paras["F_freeZipCode"];
newUser.F_mostFamiliarSubject = paras["F_mostFamiliarSubject"];
newUser.F_academicDuty = paras["F_academicDuty"];
if (!String.IsNullOrWhiteSpace(paras["F_familiarSubject"]))
{
String[] subjects = paras["F_familiarSubject"].Split(new char[] { ',' });
if (subjects.Length >= 1)
{
newUser.F_familiarSubject1 = subjects[0];
}
if (subjects.Length == 2)
{
newUser.F_familiarSubject2 = subjects[1];
}
}
var educationBackgrounds = dc.EducationBackground.Where(eb => eb.F_userID.Equals(newUser.F_ID));
dc.EducationBackground.DeleteAllOnSubmit(educationBackgrounds);
if (!String.IsNullOrWhiteSpace(paras["F_school"]))
{
String[] schools = paras["F_school"].Split(new char[] { ',' });
String[] majors = paras["F_major"].Split(new char[] { ',' });
String[] entryDates = paras["F_entryDate"].Split(new char[] { ',' });
String[] educations = paras["F_education"].Split(new char[] { ',' });
String[] degrees = paras["F_degree"].Split(new char[] { ',' });
String[] graduateDates = paras["F_graduateDate"].Split(new char[] { ',' });
String[] countrys = paras["F_country"].Split(new char[] { ',' });
for (int i = 0; i < schools.Length; i++)
{
EducationBackground eb = new EducationBackground();
eb.F_userID = newUser.F_ID;
eb.F_ID = Guid.NewGuid().ToString();
eb.F_school = schools[i];
eb.F_major = majors[i];
dt = DateTime.Now;
if (entryDates[i].Trim().Length > 0)
{
DateTime.TryParse(entryDates[i], out dt);
eb.F_entryDate = dt;
}
if (graduateDates[i].Trim().Length > 0)
{
DateTime.TryParse(graduateDates[i], out dt);
eb.F_graduateDate = dt;
}
eb.F_education = educations[i];
eb.F_degree = degrees[i];
eb.F_country = countrys[i];
dc.EducationBackground.InsertOnSubmit(eb);
}
}
var certificates = dc.Certificate.Where(cert => cert.F_userID.Equals(newUser.F_ID));
dc.Certificate.DeleteAllOnSubmit(certificates);
if (!String.IsNullOrWhiteSpace(paras["F_name"]))
{
String[] F_names = paras["F_name"].Split(new char[] { ',' });
String[] F_codes = paras["F_code"].Split(new char[] { ',' });
String[] F_grantDates = paras["F_grantDate"].Split(new char[] { ',' });
String[] F_grantOrgs = paras["F_grantOrg"].Split(new char[] { ',' });
for (int i = 0; i < F_names.Length; i++)
{
Certificate cert = new Certificate();
cert.F_ID = Guid.NewGuid().ToString();
cert.F_userID = newUser.F_ID;
cert.F_name = F_names[i];
cert.F_code = F_codes[i];
if (F_grantDates[i].Trim().Length > 0)
{
DateTime.TryParse(F_grantDates[i], out dt);
cert.F_grantDate = dt;
}
cert.F_grantOrg = F_grantOrgs[i];
dc.Certificate.InsertOnSubmit(cert);
}
}
if (insert)
{
dc.User.InsertOnSubmit(newUser);
}
dc.SubmitChanges();
return("保存成功");
}
protected void btnCommit_Click(object sender, EventArgs e)
{
String[] projects = txtName.Text.Trim().Split(new char[] { '\n' });
String[] units = txtUnit.Text.Trim().Split(new char[] { '\n' });
String[] leaders = this.txtLeader.Text.Trim().Split(new char[] { '\n' });
String[] funds = this.txtFund.Text.Trim().Split(new char[] { '\n' });
DateTime startDate = DateTime.Parse(txtStart.Text);
DateTime endDate = DateTime.Parse(txtEnd.Text);
if (projects.Length == units.Length && units.Length == leaders.Length)
{
DataClassesDataContext dc = new DataClassesDataContext();
for (int i = 0; i < projects.Length; i++)
{
try
{
units[i] = units[i].Trim().Replace("\"", "");
units[i] = units[i].Replace("\r", "").Trim();
units[i] = units[i].Replace(" ", "").Trim();
ApplicantUnit unit = dc.ApplicantUnit.SingleOrDefault(_au => _au.F_name.Equals(units[i]));
if (unit == null)
{
unit = new ApplicantUnit();
unit.F_ID = Guid.NewGuid().ToString();
unit.F_name = units[i];
unit.F_status = RoleType.Authoried;
dc.ApplicantUnit.InsertOnSubmit(unit);
}
leaders[i] = leaders[i].Trim().Replace("\"", "");
leaders[i] = leaders[i].Replace(" ", "");
leaders[i] = leaders[i].Replace("\r", "").Trim();
EducationV2.User user = dc.User.SingleOrDefault(_user => _user.F_realName.Equals(leaders[i]) && _user.F_belongUnitID.Equals(unit.F_ID));
if (user == null)
{
user = new EducationV2.User();
user.F_ID = Guid.NewGuid().ToString();
user.F_userName = leaders[i];
user.F_realName = leaders[i];
user.F_Role = RoleType.Expert;
user.F_belongUnitID = unit.F_ID;
dc.User.InsertOnSubmit(user);
dc.SubmitChanges();
}
if (ddlType.SelectedIndex < 4)
{
projects[i] = projects[i].Trim().Replace("\"", "");
projects[i] = projects[i].Replace("\r", "").Trim();
SocialProject project = dc.SocialProject.SingleOrDefault(_sp => _sp.F_name.Equals(projects[i]));
if (project != null)
{
continue;
}
project = new SocialProject();
project.F_unitID = unit.F_ID;
project.F_leader = user.F_realName;
project.F_leaderID = user.F_ID;
project.F_status = ProjectStatus.Approval;
project.F_guideProjectID = ddlGuide.SelectedValue;
project.F_code = EducationV2.Services.SocialProject.GetCode(ddlType.SelectedValue, txtYear.Text);
project.F_status = ProjectStatus.Approval;
if (txtSameFund.Text.Trim().Length > 0)
{
project.F_Fund = decimal.Parse(txtSameFund.Text);
}
else
{
project.F_Fund = decimal.Parse(funds[i]);
}
project.F_applicantDate = startDate;
project.F_completeDate = endDate;
project.F_type = ddlType.SelectedValue;
project.F_name = projects[i];
project.F_ID = Guid.NewGuid().ToString();
CreateAcceptProject(dc, project);
dc.SocialProject.InsertOnSubmit(project);
}
else
{
ScienceProject project = dc.ScienceProject.SingleOrDefault(_sp => _sp.F_name.Equals(projects[i]));
if (project != null)
{
continue;
}
project = new ScienceProject();
project.F_unitID = unit.F_ID;
project.F_leader = user.F_realName;
project.F_leaderID = user.F_ID;
project.F_status = ProjectStatus.Approval;
project.F_guideProjectID = ddlGuide.SelectedValue;
project.F_code = EducationV2.Services.SciProject.GetCode(ddlType.SelectedValue, txtYear.Text);
project.F_status = ProjectStatus.Approval;
if (txtSameFund.Text.Trim().Length > 0)
{
project.F_totalFund = decimal.Parse(txtSameFund.Text);
}
else
{
project.F_totalFund = decimal.Parse(funds[i]);
}
project.F_beginDate = startDate;
project.F_applicantDate = startDate;
project.F_finishDate = endDate;
project.F_type = ddlType.SelectedValue;
project.F_name = projects[i];
project.F_ID = Guid.NewGuid().ToString();
dc.ScienceProject.InsertOnSubmit(project);
CreateAcceptProject(dc, project);
}
dc.SubmitChanges();
}
catch (Exception exp) {
Console.Write(exp.ToString());
}
}
}
else
{
UtilHelper.AlertMsg(Response, "name: " + projects.Length + " unit: " + units.Length + " leader: " + leaders.Length +
" fund: " + funds.Length);
UtilHelper.AlertMsg(Response, "inequal");
}
}
