private DataTable GetDatasource() { DataClassesDataContext dc = new DataClassesDataContext(); List <String> userIDs = Global.GetMinUsers(Session); DataTable dt = new DataTable(); dt.Columns.Add("F_ID"); dt.Columns.Add("F_userName"); dt.Columns.Add("F_realName"); dt.Columns.Add("F_belongedUnit"); dt.Columns.Add("F_status"); dt.Columns.Add("F_role"); foreach (String userID in userIDs) { DataRow dr = dt.NewRow(); User user = dc.User.SingleOrDefault(_user => _user.F_ID.Equals(userID)); ApplicantUnit unit = dc.ApplicantUnit.SingleOrDefault(_un => _un.F_ID.Equals(user.F_belongUnitID)); dr[0] = userID; dr[1] = user.F_userName; dr[2] = user.F_realName; if (unit != null) { dr[3] = unit.F_name; } dr[4] = user.F_status; dr[5] = user.F_Role; dt.Rows.Add(dr); } return(dt); }
private string Initial() { context.Response.ContentType = "application/json"; DataClassesDataContext dc = new DataClassesDataContext(); String F_ID = context.Session[SessionMgm.VisitUnitID].ToString(); ApplicantUnit unit = dc.ApplicantUnit.SingleOrDefault(au => au.F_ID.Equals(F_ID)); if (context.Session[SessionMgm.Role].Equals(RoleType.EduAdmin)) { unit.F_status = "未提交"; } else if (context.Session[SessionMgm.Role].ToString().Equals(RoleType.SchoolAdmin) && context.Session[SessionMgm.UnitID].ToString().Equals(context.Session[SessionMgm.VisitUnitID])) { unit.F_status = "未提交"; } else { unit.F_status = "已提交"; } if (unit == null) { unit = new ApplicantUnit(); unit.F_ID = F_ID; unit.F_status = "未提交"; } return(UtilHelper.GetJSON(unit)); }
private string GetStatus() { DataClassesDataContext dc = new DataClassesDataContext(); String userID = Session[SessionMgm.UserID].ToString(); String role = Session[SessionMgm.Role].ToString(); User user = dc.User.SingleOrDefault(_user => _user.F_ID.Equals(userID)); if (String.IsNullOrEmpty(user.F_belongUnitID) == false) { ApplicantUnit unit = dc.ApplicantUnit.SingleOrDefault(_au => _au.F_ID.Equals(user.F_belongUnitID)); if (unit.F_status != RoleType.Authoried) { return(RoleType.Draft); } if (role.Equals(RoleType.DeptAdmin) || role.Equals(RoleType.Expert)) { DeptMent dept = dc.DeptMent.SingleOrDefault(_dm => _dm.F_ID.Equals(user.F_belongDeptID)); if (dept == null || dept.F_status != RoleType.Authoried || user.F_status != RoleType.Authoried) { return(RoleType.Draft); } } } return(RoleType.Authoried); }
private String Commit() { DataClassesDataContext dc = new DataClassesDataContext(); String F_ID = context.Session[SessionMgm.VisitUnitID].ToString(); ApplicantUnit unit = dc.ApplicantUnit.SingleOrDefault(au => au.F_ID.Equals(F_ID)); unit.F_status = RoleType.UnderAudit; dc.SubmitChanges(); return("提交成功"); }
private String CheckName() { String result = ""; context.Response.ContentType = "text/plain"; DataClassesDataContext dc = new DataClassesDataContext(); ApplicantUnit unit = dc.ApplicantUnit.SingleOrDefault(au => au.F_name.Equals(paras["F_name"])); if (unit == null) { result = "单位名称 " + paras["F_name"] + " 可用"; } else { result = "单位名称 " + paras["F_name"] + " 已被注册"; } return(result); }
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 Save() { context.Response.ContentType = "text/plain"; DataClassesDataContext dc = new DataClassesDataContext(); String F_ID = context.Session[SessionMgm.VisitUnitID].ToString(); ApplicantUnit unit = dc.ApplicantUnit.SingleOrDefault(au => au.F_ID.Equals(F_ID)); unit.F_name = paras["F_name"]; unit.F_organizationCode = paras["F_organizationCode"]; unit.F_majorBusiness = paras["F_majorBusiness"]; unit.F_address = paras["F_address"]; unit.F_principalName = paras["F_principalName"]; unit.F_contactName = paras["F_contactName"]; unit.F_principalIDNum = paras["F_principalIDNum"]; unit.F_principalMobile = paras["F_principalMobile"]; unit.F_contactDept = paras["F_contactDept"]; unit.F_principalPhone = paras["F_principalPhone"]; unit.F_contactDuty = paras["F_contactDuty"]; Decimal num = 0; unit.F_zipCode = paras["F_zipCode"]; unit.F_contactPhone1 = paras["F_contactPhone1"]; unit.F_location = paras["F_location"]; unit.F_contactPhone2 = paras["F_contactPhone2"]; unit.F_type = paras["F_type"]; unit.F_contactMobile = paras["F_contactMobile"]; num = 0; Decimal.TryParse(paras["F_registeredAssets"], out num); unit.F_registeredAssets = num; unit.F_contactFax = paras["F_contactFax"]; unit.F_bank = paras["F_bank"]; unit.F_contactEmail = paras["F_contactEmail"]; unit.F_bankAccount = paras["F_bankAccount"]; unit.F_bankAccountName = paras["F_bankAccountName"]; unit.F_description = paras["F_description"]; unit.F_awards = paras["F_awards"]; unit.F_status = RoleType.Authoried; dc.SubmitChanges(); return("保存成功"); }
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(); } } }
partial void DeleteApplicantUnit(ApplicantUnit instance) { ExecuteDynamicDelete(instance); LoggerHelper.Log("单位删除", "项目名:" + instance.F_name + ",ID:" + instance.F_ID); }
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 String AddUnit() { context.Response.ContentType = "text/plain"; DataClassesDataContext dc = new DataClassesDataContext(); ApplicantUnit unit = null; unit = new ApplicantUnit(); unit.F_ID = GetID(); unit.F_seq = GetSeq(); unit.F_name = paras["F_name"]; if (dc.ApplicantUnit.Count(_au => _au.F_name.Equals(unit.F_name)) > 0) { return("单位名: " + unit.F_name + " 已被占用"); } unit.F_organizationCode = paras["F_organizationCode"]; unit.F_majorBusiness = paras["F_majorBusiness"]; unit.F_address = paras["F_address"]; unit.F_principalName = paras["F_principalName"]; unit.F_contactName = paras["F_contactName"]; unit.F_principalIDNum = paras["F_principalIDNum"]; unit.F_principalMobile = paras["F_principalMobile"]; unit.F_contactDept = paras["F_contactDept"]; unit.F_principalPhone = paras["F_principalPhone"]; unit.F_contactDuty = paras["F_contactDuty"]; Decimal num = 0; unit.F_zipCode = paras["F_zipCode"]; unit.F_contactPhone1 = paras["F_contactPhone1"]; unit.F_location = paras["F_location"]; unit.F_contactPhone2 = paras["F_contactPhone2"]; unit.F_type = paras["F_type"]; unit.F_contactMobile = paras["F_contactMobile"]; num = 0; Decimal.TryParse(paras["F_registeredAssets"], out num); unit.F_registeredAssets = num; unit.F_contactFax = paras["F_contactFax"]; unit.F_bank = paras["F_bank"]; unit.F_contactEmail = paras["F_contactEmail"]; unit.F_bankAccount = paras["F_bankAccount"]; unit.F_bankAccountName = paras["F_bankAccountName"]; unit.F_description = paras["F_description"]; unit.F_awards = paras["F_awards"]; unit.F_status = RoleType.Authoried; dc.ApplicantUnit.InsertOnSubmit(unit); User user = new User(); user.F_ID = Guid.NewGuid().ToString(); user.F_status = RoleType.Authoried; user.F_userName = paras["F_userName"].ToString(); if (dc.User.SingleOrDefault(_user => _user.F_userName.Equals(user.F_userName)) != null) { return("用户名" + user.F_userName + "已被占用"); } user.F_realName = paras["F_realName"].ToString(); user.F_belongUnitID = unit.F_ID; user.F_Role = RoleType.SchoolAdmin; user.F_pwd = UtilHelper.MD5Encrypt(paras["F_pwd"].ToString()); dc.User.InsertOnSubmit(user); dc.SubmitChanges(); return("注册成功"); }