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 = ddlStatus.SelectedValue; user.F_belongDeptID = ddlBelongDept.SelectedValue; user.F_workDept = ddlBelongDept.SelectedItem.Text; user.F_Role = ddlRole.SelectedValue; user.F_realName = txtRealName.Text; user.F_pwd = UtilHelper.MD5Encrypt(txtPwd.Text); user.F_userName = txtName.Text; user.F_lastModifyTime = DateTime.Now; //user.F_belongUnitID = Session[SessionMgm.UnitID].ToString(); dc.User.InsertOnSubmit(user); dc.SubmitChanges(); }
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(); } } }
public static void CreateAcceptProject(DataClassesDataContext dc, ScienceProject project) { var aps = dc.AcceptProject.Where(apss => apss.F_projectID.Equals(project.F_ID)); dc.AcceptProject.DeleteAllOnSubmit(aps); AcceptProject acceptProject = new AcceptProject(); EducationV2.User user = dc.User.SingleOrDefault(us => us.F_ID.Equals(project.F_leaderID)); int num = dc.AcceptProject.Count(); acceptProject.F_ID = Guid.NewGuid().ToString(); acceptProject.F_acceptApplicantState = ProjectStatus.Draft; acceptProject.F_acceptedCode = ""; acceptProject.F_acceptNo = DateTime.Now.ToString("yyyyMMddhh") + num.ToString(); acceptProject.F_applicantUnit = user.F_adminUnit; acceptProject.F_appliedDate = project.F_applicantDate; if (project.F_applicantDate != null) { acceptProject.F_appliedYear = project.F_applicantDate.Value.Year.ToString(); } acceptProject.F_executeState = ProjectStatus.Draft; acceptProject.F_leaderName = user.F_userName; acceptProject.F_leaderID = project.F_leaderID; acceptProject.F_projectID = project.F_ID; acceptProject.F_projectName = project.F_name; if (project.F_finishDate != null) { acceptProject.F_finishDate = project.F_finishDate.Value; if (DateTime.Now < project.F_finishDate.Value) { acceptProject.F_projectState = "在研"; } else { acceptProject.F_projectState = "到期未验收"; } } acceptProject.F_projectType = project.F_type; dc.AcceptProject.InsertOnSubmit(acceptProject); var aas = dc.AcceptApplicant.Where(_aa => _aa.F_projectID.Equals(project.F_ID)); dc.AcceptApplicant.DeleteAllOnSubmit(aas); AcceptApplicant aa = new AcceptApplicant(); aa.F_ID = Guid.NewGuid().ToString(); aa.F_type = project.F_type; aa.F_domain = project.F_belongeddomain; aa.F_name = project.F_name; aa.F_acceptNo = acceptProject.F_acceptNo; aa.F_leaderName = user.F_realName; aa.F_projectUnit = user.F_adminUnit; if (project.F_totalFund != null) { aa.F_totalFund = decimal.Parse(project.F_totalFund.Value.ToString()); } aa.F_projectID = project.F_ID; aa.F_projectObject = project.F_finalOutput; aa.F_cooperator = project.F_majorCooperator; aa.F_status = EducationV2.App_Code.ProjectStatus.Draft; if (project.F_applicantDate != null && project.F_finishDate != null) { aa.F_startStopDate = project.F_applicantDate.Value.ToShortDateString() + "-" + project.F_finishDate.Value.ToShortDateString(); } aa.F_leaderID = user.F_ID; dc.AcceptApplicant.InsertOnSubmit(aa); dc.SubmitChanges(); }
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"); } }
private void CreateAcceptProject(DataClassesDataContext dc, ScienceProject project) { var aps = dc.AcceptProject.Where(apss => apss.F_projectID.Equals(project.F_ID)); dc.AcceptProject.DeleteAllOnSubmit(aps); AcceptProject acceptProject = new AcceptProject(); EducationV2.User user = dc.User.SingleOrDefault(us => us.F_ID.Equals(project.F_leaderID)); EducationV2.ApplicantUnit unit = dc.ApplicantUnit.SingleOrDefault(_au => _au.F_ID.Equals(user.F_belongUnitID)); int num = dc.AcceptProject.Count(); acceptProject.F_ID = Guid.NewGuid().ToString(); acceptProject.F_acceptApplicantState = ProjectStatus.Complete; acceptProject.F_acceptedCode = ""; acceptProject.F_applicantUnit = unit.F_name; acceptProject.F_acceptNo = DateTime.Now.ToString("yyyyMMddhh") + num.ToString(); acceptProject.F_applicantUnit = user.F_adminUnit; acceptProject.F_appliedDate = project.F_applicantDate; acceptProject.F_appliedYear = project.F_applicantDate.Value.Year.ToString(); acceptProject.F_executeState = ProjectStatus.Complete; acceptProject.F_leaderName = user.F_userName; acceptProject.F_leaderID = project.F_leaderID; acceptProject.F_projectID = project.F_ID; acceptProject.F_projectName = project.F_name; acceptProject.F_finishDate = project.F_finishDate.Value; acceptProject.F_projectState = ProjectStatus.Complete; acceptProject.F_projectType = project.F_type; dc.AcceptProject.InsertOnSubmit(acceptProject); var ess = dc.ExecuteStatus.Where(_es => _es.F_projectID.Equals(project.F_ID)); dc.ExecuteStatus.DeleteAllOnSubmit(ess); ExecuteStatus es = new ExecuteStatus(); es.F_acceptNo = acceptProject.F_acceptNo; es.F_planMoney = Decimal.ToInt32(project.F_totalFund.Value); es.F_applicantName = project.F_name; es.F_applicantType = project.F_type; es.F_applicantUnit = user.F_adminUnit; es.F_ContactPhone = user.F_phone; es.F_domain = project.F_belongeddomain; es.F_ID = Guid.NewGuid().ToString(); es.F_leaderID = project.F_leaderID; es.F_leaderName = project.F_leader; es.F_leaderNo = user.F_idNumber; es.F_mobile = user.F_mobile; es.F_projectID = project.F_ID; es.F_status = ProjectStatus.Complete; es.F_startAndStopDate = project.F_beginDate.Value.ToShortDateString() + "-" + project.F_finishDate.Value.ToShortDateString(); dc.ExecuteStatus.InsertOnSubmit(es); var aas = dc.AcceptApplicant.Where(_aa => _aa.F_projectID.Equals(project.F_ID)); dc.AcceptApplicant.DeleteAllOnSubmit(aas); AcceptApplicant aa = new AcceptApplicant(); aa.F_ID = Guid.NewGuid().ToString(); aa.F_type = project.F_type; if (String.IsNullOrEmpty(project.F_belongeddomain)) { aa.F_domain = "未定义"; } else { aa.F_domain = project.F_belongeddomain; } aa.F_name = project.F_name; aa.F_acceptNo = acceptProject.F_acceptNo; aa.F_leaderName = user.F_realName; aa.F_projectUnit = user.F_adminUnit; aa.F_projectUnit = unit.F_name; aa.F_startStopDate = es.F_startAndStopDate; aa.F_totalFund = decimal.Parse(project.F_totalFund.Value.ToString()); aa.F_projectID = project.F_ID; aa.F_projectObject = project.F_finalOutput; aa.F_cooperator = project.F_majorCooperator; aa.F_status = EducationV2.App_Code.ProjectStatus.Complete; aa.F_leaderID = user.F_ID; aa.F_appliedDate = project.F_applicantDate; dc.AcceptApplicant.InsertOnSubmit(aa); }