/// <summary> /// 增加方法,委托:OperModule类型 /// </summary> /// <param name="module">要新增的层次类型对象</param> /// <param name="yunEntities"></param> /// <returns>信息集对象</returns> private ResultInfo AddOper(HttpRequestBase request, YD_Edu_TeachPlan module, IYunEntities yunEntities) { var yearStr = request["year"]; var majorIdStr = request["majorId"]; var teaPlanTypeStr = request["y_teaPlanType"]; if (string.IsNullOrEmpty(yearStr) || string.IsNullOrEmpty(majorIdStr) || string.IsNullOrEmpty(teaPlanTypeStr)) { return(new ResultInfo { Success = false, Info = PowerInfo.Unknow, Message = "未知错误" }); } var year = Convert.ToInt32(yearStr); var majorId = Convert.ToInt32(majorIdStr); var teaPlanType = Convert.ToInt32(teaPlanTypeStr); var resultInfo = BaseAddEntity(module, "/Edu/TeachPlan", yunEntities); if (resultInfo.Success) { var entity = new YD_Edu_MajorTeachPlan() { y_majorId = majorId, y_teachPlanId = module.id, y_year = year, y_teaPlanType = teaPlanType }; yunEntities.Entry(entity).State = EntityState.Added; yunEntities.SaveChanges(); LogHelper.DbLog(Convert.ToInt32(HttpContext.Current.Session[KeyValue.Admin_id]), HttpContext.Current.Session[KeyValue.Admin_Name].ToString(), (int)LogType.Insert, "添加教学计划,教学计划名为" + module.y_teaPlanName + ",id:" + module.id); } return(resultInfo); }
/// <summary> /// 递归删除栏目并删除与之对应的权限 /// </summary> /// <param name="module">栏目对象</param> /// <param name="yunEntities">EF上下文对象</param> public void DeleteModule(YD_Sys_Module module, IYunEntities yunEntities) { var powerList = yunEntities.YD_Sys_Power.Where(u => u.y_moduleID == module.id); foreach (var ydPower in powerList) { yunEntities.Entry(ydPower).State = EntityState.Deleted; } yunEntities.Entry(module).State = EntityState.Deleted; var moduleSons = yunEntities.YD_Sys_Module.Where(u => u.y_parentID == module.id); foreach (var moduleSon in moduleSons) { DeleteModule(moduleSon, yunEntities); } }
/// <summary> /// 修改栏目排序 /// </summary> /// <param name="request">请求上下文对象</param> /// <param name="yunEntities">EF上下文对象</param> /// <returns></returns> public string ModuleUpdateSort(HttpRequestBase request, IYunEntities yunEntities) { var ids = request["ids"]; var sorts = request["sorts"]; if (string.IsNullOrEmpty(ids) || string.IsNullOrEmpty(sorts)) { return("未知错误"); } var mids = ids.Split(new[] { ',' }, StringSplitOptions.RemoveEmptyEntries); var msorts = sorts.Split(new[] { ',' }, StringSplitOptions.RemoveEmptyEntries); if (mids.Count() != msorts.Count()) { return("未知错误"); } for (var j = 0; j < mids.Count(); j++) { var id = Convert.ToInt32(mids[j]); var module = yunEntities.YD_Sys_Module.FirstOrDefault(u => u.id == id); if (module != null) { module.y_sort = Convert.ToInt32(msorts[j]); } yunEntities.Entry(module).State = EntityState.Modified; if (module != null) { LogHelper.DbLog(Convert.ToInt32(HttpContext.Current.Session[KeyValue.Admin_id]), HttpContext.Current.Session[KeyValue.Admin_Name].ToString(), (int)LogType.Update, "修改栏目排序,栏目名为" + module.y_name + ",级别为" + module.y_level + ",排序修改为:" + module.y_sort + ",id:" + module.id); } } var i = yunEntities.SaveChanges(); return(i > 0 ? "ok" : "保存栏目排序失败"); }
/// <summary> /// 删除课程 /// </summary> /// <param name="id">课程id</param> /// <param name="yunEntities">EF上下文对象</param> /// <returns></returns> public string EntityDelete(int id, IYunEntities yunEntities) { var course = yunEntities.YD_Edu_Course.FirstOrDefault(u => u.id == id); if (course != null) { if (course.YD_Edu_TeachplanDes.Count != 0) { return("该类型不能删除,其已经关联了指定教学计划"); } var adminCourse = yunEntities.YD_Sys_AdminCourseLink.Where(u => u.y_courseId == id).ToList(); for (int j = 0; j < adminCourse.Count; j++) { yunEntities.Entry(adminCourse[j]).State = EntityState.Deleted; } yunEntities.Entry(course).State = EntityState.Deleted; LogHelper.DbLog(Convert.ToInt32(HttpContext.Current.Session[KeyValue.Admin_id]), HttpContext.Current.Session[KeyValue.Admin_Name].ToString(), (int)LogType.Delete, "删除课程,课程名为" + course.y_name + ",id:" + course.id); } var i = yunEntities.SaveChanges(); return(i > 0 ? "ok" : "删除课程失败"); }
/// <summary> /// 删除层次类型 /// </summary> /// <param name="id">层次类型id</param> /// <param name="yunEntities">EF上下文对象</param> /// <returns></returns> public string EntityDelete(int id, IYunEntities yunEntities) { var module = yunEntities.YD_Edu_TeachplanDes.FirstOrDefault(u => u.y_teaPlanId == id); if (module != null) { yunEntities.Entry(module).State = EntityState.Deleted; LogHelper.DbLog(Convert.ToInt32(HttpContext.Current.Session[KeyValue.Admin_id]), HttpContext.Current.Session[KeyValue.Admin_Name].ToString(), (int)LogType.Delete, "删除教学计划课程,id:" + module.id); } var i = yunEntities.SaveChanges(); return(i > 0 ? "ok" : "删除教学计划课程失败"); }
/// <summary> /// 删除课程 /// </summary> /// <param name="id">课程id</param> /// <param name="yunEntities">EF上下文对象</param> /// <returns></returns> public string EntityDelete(int id, IYunEntities yunEntities) { var Course = yunEntities.YD_Edu_Score.FirstOrDefault(u => u.id == id); if (Course != null) { yunEntities.Entry(Course).State = EntityState.Deleted; LogHelper.DbLog(Convert.ToInt32(HttpContext.Current.Session[KeyValue.Admin_id]), HttpContext.Current.Session[KeyValue.Admin_Name].ToString(), (int)LogType.Delete, "删除成绩,学生id为" + Course.y_stuId + ",id:" + Course.id); } var i = yunEntities.SaveChanges(); return(i > 0 ? "ok" : "删除成绩失败"); }
/// <summary> /// 删除用户 /// </summary> /// <returns></returns> public string DeleteStrange(HttpRequestBase request, IYunEntities yunEntities) { var ids = request["ids"]; if (string.IsNullOrEmpty(ids)) { return("数据为空"); } #region “删除”权限验证 var powerInfo = Safe("/Student/StudentInfoChangeAll", PowerFlag.Delete); switch (powerInfo) { case PowerInfo.NoPower: return("无权限"); case PowerInfo.NoLogin: return("未登录"); case PowerInfo.Unknow: return("未知状况"); case PowerInfo.HasPower: break; default: return("未知状况"); } #endregion var idsstr = ids.Split(new[] { ',' }, StringSplitOptions.RemoveEmptyEntries); var idsList = new List <int>(); for (var i = 0; i < idsstr.Count(); i++) { idsList.Add(Convert.ToInt32(idsstr[i])); } var admins = yunEntities.YD_Sts_StuStrange.Where(u => idsList.Contains(u.id)).ToList(); foreach (var admin in admins) { admin.y_isdel = (int)YesOrNo.Yes; yunEntities.Entry(admin).State = EntityState.Modified; LogHelper.DbLog(Convert.ToInt32(HttpContext.Current.Session[KeyValue.Admin_id]), HttpContext.Current.Session[KeyValue.Admin_Name].ToString(), (int)LogType.Delete, "删除学籍异动,id:" + admin.id); } var j = yunEntities.SaveChanges(); return(j > 0 ? "ok" : "删除学籍异动失败"); }
/// <summary> /// 删除层次类型 /// </summary> /// <param name="id">层次类型id</param> /// <param name="yunEntities">EF上下文对象</param> /// <returns></returns> public string EntityDelete(int id, IYunEntities yunEntities) { var module = yunEntities.YD_Edu_TeachPlan.FirstOrDefault(u => u.id == id); if (module != null) { var majorTeachPlanList = module.YD_Edu_MajorTeachPlan.ToList(); for (var j = 0; j < majorTeachPlanList.Count; j++) { yunEntities.Entry(majorTeachPlanList[j]).State = EntityState.Deleted; } var teachPlanDesList = module.YD_Edu_TeachplanDes.ToList(); for (var j = 0; j < teachPlanDesList.Count; j++) { yunEntities.Entry(teachPlanDesList[j]).State = EntityState.Deleted; } yunEntities.Entry(module).State = EntityState.Deleted; LogHelper.DbLog(Convert.ToInt32(HttpContext.Current.Session[KeyValue.Admin_id]), HttpContext.Current.Session[KeyValue.Admin_Name].ToString(), (int)LogType.Delete, "删除教学计划,教学计划名为" + module.y_teaPlanName + ",id:" + module.id); } var i = yunEntities.SaveChanges(); return(i > 0 ? "ok" : "删除教学计划失败"); }
/// <summary> /// 开启栏目 /// </summary> /// <param name="id">栏目id</param> /// <param name="yunEntities">EF上下文对象</param> /// <returns></returns> public string ModuleOpen(int id, IYunEntities yunEntities) { var module = yunEntities.YD_Sys_Module.FirstOrDefault(u => u.id == id); if (module != null) { module.y_vaild = (Int32)DataState.Able; yunEntities.Entry(module).State = EntityState.Modified; LogHelper.DbLog(Convert.ToInt32(HttpContext.Current.Session[KeyValue.Admin_id]), HttpContext.Current.Session[KeyValue.Admin_Name].ToString(), (int)LogType.Update, "开启栏目,栏目名为" + module.y_name + ",级别为" + module.y_level + ",id:" + module.id); } var i = yunEntities.SaveChanges(); return(i > 0 ? "ok" : "开启栏目失败"); }
/// <summary> /// 删除角色 /// </summary> /// <returns></returns> public string DeleteRole(HttpRequestBase request, IYunEntities yunEntities) { var ids = request["ids"]; if (string.IsNullOrEmpty(ids)) { return("数据为空"); } #region “删除”权限验证 var powerInfo = Safe("/SysAdmin/Role", PowerFlag.Delete); switch (powerInfo) { case PowerInfo.NoPower: return("无权限"); case PowerInfo.NoLogin: return("未登录"); case PowerInfo.Unknow: return("未知状况"); case PowerInfo.HasPower: break; default: return("未知状况"); } #endregion var idsstr = ids.Split(new[] { ',' }, StringSplitOptions.RemoveEmptyEntries); var idsList = new List <int>(); for (var i = 0; i < idsstr.Count(); i++) { idsList.Add(Convert.ToInt32(idsstr[i])); } var roles = yunEntities.YD_Sys_Role.Where(u => idsList.Contains(u.id)).ToList(); foreach (var role in roles) { if (yunEntities.YD_Sys_Admin.FirstOrDefault(u => u.y_roleID == role.id) != null) { return("删除角色失败,因为该角色下已经存在用户"); } yunEntities.Entry(role).State = EntityState.Deleted; LogHelper.DbLog(Convert.ToInt32(HttpContext.Current.Session[KeyValue.Admin_id]), HttpContext.Current.Session[KeyValue.Admin_Name].ToString(), (int)LogType.Delete, "删除角色,角色名为" + role.y_name + ",id:" + role.id); } var j = yunEntities.SaveChanges(); return(j > 0 ? "ok" : "删除角色失败"); }
/// <summary> /// 修改用户密码 /// </summary> /// <returns></returns> public ResultInfo UpdatePwd(HttpRequestBase request, IYunEntities yunEntities) { var nowPwd = request["nowPwd"]; var newPwd = request["newPwd"]; var rePwd = request["rePwd"]; var resultInfo = new ResultInfo(); if (!IsLogin()) { resultInfo.Success = false; resultInfo.Message = "未登录"; return(resultInfo); } var admin = yunEntities.YD_Sys_Admin.Find(YdAdminId); if (string.IsNullOrEmpty(newPwd) || string.IsNullOrEmpty(nowPwd) || string.IsNullOrEmpty(rePwd)) { resultInfo.Success = false; resultInfo.Message = "还有未填项"; return(resultInfo); } if (rePwd != newPwd) { resultInfo.Success = false; resultInfo.Message = "两次密码不一致"; return(resultInfo); } if (PageValidate.GetMd5StrT(nowPwd).ToUpper() != admin.y_password.ToUpper()) { resultInfo.Success = false; resultInfo.Message = "原始密码不正确"; return(resultInfo); } admin.y_password = PageValidate.GetMd5StrL(newPwd); admin.y_realpassword = newPwd; yunEntities.Entry(admin).State = EntityState.Modified; var t = yunEntities.SaveChanges(); if (t > 0) { resultInfo.Success = true; return(resultInfo); } resultInfo.Success = false; resultInfo.Message = "未知错误"; return(resultInfo); }
/// <summary> /// 记录数据库日志 /// </summary> /// <param name="userId">操作员id</param> /// <param name="userName">操作员当前名</param> /// <param name="logTypeId">操作类型</param> /// <param name="remark">备注</param> public static void DbLog(int userId, string userName, int logTypeId, string remark) { var yunEntities = new IYunEntities(); var dbLog = new YD_Sys_DbLog() { y_userID = userId, y_remark = remark, y_time = DateTime.Now, Y_userName = userName, Y_logTypeID = logTypeId, }; yunEntities.Entry(dbLog).State = EntityState.Added; yunEntities.SaveChanges(); yunEntities.Dispose(); }
/// <summary> /// 删除层次类型 /// </summary> /// <param name="id">层次类型id</param> /// <param name="yunEntities">EF上下文对象</param> /// <returns></returns> public string EntityDelete(int id, IYunEntities yunEntities) { var module = yunEntities.YD_Edu_EduType.FirstOrDefault(u => u.id == id); if (module != null) { if (module.YD_Edu_Major.Count != 0) { return("该类型不能删除,其已经关联了指定专业"); } yunEntities.Entry(module).State = EntityState.Deleted; LogHelper.DbLog(Convert.ToInt32(HttpContext.Current.Session[KeyValue.Admin_id]), HttpContext.Current.Session[KeyValue.Admin_Name].ToString(), (int)LogType.Delete, "删除层次类型,层次名为" + module.y_name + ",id:" + module.id); } var i = yunEntities.SaveChanges(); return(i > 0 ? "ok" : "删除层次类型失败"); }
/// <summary> /// 删除课程类型类型 /// </summary> /// <param name="id">课程类型类型id</param> /// <param name="yunEntities">EF上下文对象</param> /// <returns></returns> public string EntityDelete(int id, IYunEntities yunEntities) { var courseType = yunEntities.YD_Edu_CourseType.FirstOrDefault(u => u.id == id); if (courseType != null) { if (courseType.YD_Edu_TeachplanDes.Count != 0) { return("该类型不能删除,其已经关联了教学计划"); } yunEntities.Entry(courseType).State = EntityState.Deleted; LogHelper.DbLog(Convert.ToInt32(HttpContext.Current.Session[KeyValue.Admin_id]), HttpContext.Current.Session[KeyValue.Admin_Name].ToString(), (int)LogType.Delete, "删除课程类型类型,课程类型名为" + courseType.y_name + ",id:" + courseType.id); } var i = yunEntities.SaveChanges(); return(i > 0 ? "ok" : "删除课程类型类型失败"); }
/// <summary> /// 学生信息编辑AJAX /// </summary> /// <param name="stu">学生信息对象</param> /// <returns>处理结果json</returns> public string EditStudentInfo(YD_Sts_StuInfo stu) { #region 权限验证 if (!IsLogin()) { Redirect("/AdminBase/Index"); } #endregion using (var yunEntities = new IYunEntities()) { yunEntities.Configuration.ValidateOnSaveEnabled = false; var stus = yunEntities.YD_Sts_StuInfo.FirstOrDefault(u => u.id == stu.id); var re = new Hashtable(); //var msg = _stuInfoDal.EditStuInfoExtended(stu, Request, yunEntities); stus.y_sex = stu.y_sex; stus.y_birthday = stu.y_birthday; stus.y_tel = stu.y_tel; stus.y_mail = stu.y_mail; stus.y_address = stu.y_address; stus.y_img = stu.y_img; yunEntities.Entry(stus).State = EntityState.Modified; int r = yunEntities.SaveChanges(); if (r > 0) { // LogHelper.DbLog(Convert.ToInt32(Session[KeyValue.Admin_id]), //Session[KeyValue.Admin_Name].ToString(), (int)LogType.Update, // "修改学生," + ",id:" + stu.id + "姓名,入学年份,身份证号,出生日期,学号,考生号,学籍状态" + stu.y_name + "," + stu.y_inYear + "," + stu.y_cardId + "," + stu.y_birthday + "," + stu.y_stuNum + "," + stu.y_examNum + "," + stu.y_stuStateId); re["msg"] = "修改成功"; re["isok"] = true; } else { re["msg"] = "修改失败"; re["isok"] = false; } return(JsonConvert.SerializeObject(re)); } }
/// <summary> /// 删除函授站类型 /// </summary> /// <param name="id">函授站类型id</param> /// <param name="yunEntities">EF上下文对象</param> /// <returns></returns> public string EntityDelete(int id, IYunEntities yunEntities) { var module = yunEntities.YD_Sys_SubSchool.FirstOrDefault(u => u.id == id); if (module != null) { if (yunEntities.YD_Sts_StuInfo.Any(u => u.y_subSchoolId == module.id)) { return("该类型不能删除,其已经关联了指定学生"); } yunEntities.Entry(module).State = EntityState.Deleted; LogHelper.DbLog(Convert.ToInt32(HttpContext.Current.Session[KeyValue.Admin_id]), HttpContext.Current.Session[KeyValue.Admin_Name].ToString(), (int)LogType.Delete, "删除函授站,函授站名为" + module.y_name + ",id:" + module.id); } var i = yunEntities.SaveChanges(); return(i > 0 ? "ok" : "删除函授站失败"); }
/// <summary> /// 学生毕业申请 /// </summary> /// <returns></returns> public string StuGradInfoSome() { using (var yunEntities = new IYunEntities()) { var stu = yunEntities.YD_Sts_StuInfo.Include(x => x.YD_Edu_Major).FirstOrDefault(x => x.id == LoginId); stu.y_isgraduate = true; yunEntities.Entry(stu).State = EntityState.Modified; int r = yunEntities.SaveChanges(); if (r > 0) { return("ok"); } else { return("设置失败"); } } }
/// <summary> /// 递归移动栏目 /// </summary> /// <param name="module">要移动的栏目对象</param> /// <param name="yunEntities"></param> private static void MoveOperChildrenModule(YD_Sys_Module module, IYunEntities yunEntities) { var parentModule = yunEntities.YD_Sys_Module.FirstOrDefault(u => u.id == module.y_parentID); if (parentModule != null) { module.y_level = parentModule.y_level + 1; } if (parentModule == null && module.y_parentID == 0) { module.y_level = 1; } yunEntities.Entry(module).State = EntityState.Modified; var childrenModule = yunEntities.YD_Sys_Module.Where(u => u.y_parentID == module.id).ToList(); for (var i = 0; i < childrenModule.Count(); i++) { MoveOperChildrenModule(childrenModule[i], yunEntities); } }
/// <summary> /// 批量删除对象集合 /// </summary> /// <param name="list">要删除的对象集合</param> /// <param name="moduleUrl">操作该方法的栏目url(例:/SysAdmin/Site)</param> /// <param name="yunEntities"></param> /// <returns>信息集对象</returns> public ResultInfo BaseDeleteEntities(List <T> list, string moduleUrl, IYunEntities yunEntities) { var resultInfo = new ResultInfo { Info = Safe(moduleUrl, PowerFlag.Delete) }; switch (resultInfo.Info) { case PowerInfo.NoPower: resultInfo.Success = false; resultInfo.Message = "没有权限"; return(resultInfo); case PowerInfo.NoLogin: resultInfo.Success = false; resultInfo.Message = "没有登录"; return(resultInfo); case PowerInfo.Unknow: resultInfo.Success = false; resultInfo.Message = "未知错误"; return(resultInfo); case PowerInfo.HasPower: break; default: resultInfo.Success = false; resultInfo.Message = "未知错误"; return(resultInfo); } foreach (var entity in list) { yunEntities.Entry(entity).State = EntityState.Deleted; } resultInfo.Success = yunEntities.SaveChanges() > 0; resultInfo.Message = ""; return(resultInfo); }
/// <summary> /// 修改一个实体对象 /// </summary> /// <param name="entity">要修改的实体对象</param> /// <param name="moduleUrl">操作该方法的栏目url(例:/SysAdmin/Site)</param> /// <param name="yunEntities"></param> /// <returns>信息集对象</returns> public ResultInfo BaseEditEntity(T entity, string moduleUrl, IYunEntities yunEntities) { var resultInfo = new ResultInfo { Info = Safe(moduleUrl, PowerFlag.Update) }; switch (resultInfo.Info) { case PowerInfo.NoPower: resultInfo.Success = false; resultInfo.Message = "没有权限"; return(resultInfo); case PowerInfo.NoLogin: resultInfo.Success = false; resultInfo.Message = "没有登录"; return(resultInfo); case PowerInfo.Unknow: resultInfo.Success = false; resultInfo.Message = "未知错误"; return(resultInfo); case PowerInfo.HasPower: break; default: resultInfo.Success = false; resultInfo.Message = "未知错误"; return(resultInfo); } yunEntities.Entry(entity).State = EntityState.Modified; resultInfo.Success = yunEntities.SaveChanges() > 0; resultInfo.Message = ""; return(resultInfo); }
public string AddExtended(YD_Sts_StuStrange stra, IYunEntities yunEntity) { if (!IsLogin()) { return("异动申请失败,登陆信息失效!"); } var stu = yunEntity.YD_Sts_StuInfo.FirstOrDefault(x => x.id == stra.y_stuId); if (stu == null) { return("学生不存在!"); } if (stra.y_strangeType == 1) { if (stra.y_contentA == stu.y_majorId.ToString()) { return("不能申请原先的专业"); } } if (stra.y_strangeType == 2) { if (stra.y_contentA == stu.y_subSchoolId.ToString()) { return("不能申请原先的函授站"); } } stra.y_isdel = (int)YesOrNo.No; stra.y_applyAdmin = YdAdminId; stra.y_applyTime = DateTime.Now; stra.y_approvalStatus = (int)ApprovaState.WaitApprova; stra.y_isExecutive = (int)YesOrNo.No; if (stra.y_strangeType == 1) { if (stra.y_contentA != null) { var majorid = Convert.ToInt32(stra.y_contentA); var major = yunEntity.YD_Edu_Major.FirstOrDefault(u => u.id == majorid); if (major != null) { stra.y_contentA = major.id.ToString(); yunEntity.Entry(stra).State = EntityState.Modified; } else { return("异动申请添加失败,专业编号错误!"); } stra.y_contentB = stu.y_majorId.ToString(); } } else if (stra.y_strangeType == 2) { if (stra.y_contentA != null) { var subschoolid = Convert.ToInt32(stra.y_contentA); var subschool = yunEntity.YD_Sys_SubSchool.FirstOrDefault(u => u.id == subschoolid); if (subschool != null) { stra.y_contentA = subschool.id.ToString(); yunEntity.Entry(stra).State = EntityState.Modified; } else { return("异动申请添加失败,函授站编号错误!"); } stra.y_contentB = stu.y_subSchoolId.ToString(); } } //todo:新添加的异动类型:基本信息修改 else if (stra.y_strangeType == 6) { if (stra.y_contentA != null) { var nationid = Convert.ToInt32(stra.y_contentA); var nation = yunEntity.YD_Sts_Nation.FirstOrDefault(u => u.id == nationid); if (nation != null) { stra.y_contentA = nation.id.ToString(); yunEntity.Entry(stra).State = EntityState.Modified; } else { return("异动申请添加失败,民族编号错误!"); } stra.y_contentB = stu.y_nationId.ToString(); } if (stra.y_contentG != null) { if (stra.y_contentG == stu.y_cardId) { return("已是该申请信息,不需要修改"); } stra.y_contentH = stu.y_cardId; } if (stra.y_contentE != null) { var birthday = Convert.ToDateTime(stra.y_contentE); if (birthday == stu.y_birthday) { return("已是该申请信息,不需要修改"); } stra.y_contentF = stu.y_birthday.ToString(); } if (stra.y_contentC != null) { var sex = Convert.ToInt32(stra.y_contentC); stra.y_contentC = null; if (sex != stu.y_sex) { stra.y_contentC = sex.ToString(); stra.y_contentD = stu.y_sex.ToString(); } } if (stra.y_contentI != null) { if (stra.y_contentI == stu.y_name) { return("已是该申请信息,不需要修改"); } stra.y_contentJ = stu.y_name; } } var oldstra = yunEntity.YD_Sts_StuStrange.FirstOrDefault(u => u.y_stuId == stra.y_stuId && u.y_strangeType == stra.y_strangeType && u.y_approvalStatus == (int)ApprovaState.WaitApprova && u.y_isdel == (int)YesOrNo.No); if (oldstra != null) { return("已申请过相同异动,不能再申请"); } return(AddStrange(stra, yunEntity)); }
/// <summary> /// 修改学生信息 /// </summary> /// <param name="stuInfo">学生对象</param> /// <param name="request">request对象,要包括专业,学习形式,专业层次</param> /// <param name="yunEntities">上下文对象</param> /// <returns>处理结果</returns> public string EditStuInfoExtended(YD_Sts_StuInfo stuInfo, HttpRequestBase request, IYunEntities yunEntities) { //var stu = yunEntities.YD_Sts_StuInfo.Find(stuInfo.id); string ms = ""; if (stuInfo.id == 0) { ms = "学生修改失败:编号错误"; return(ms); } //stu.id = stuInfo.id; //stu.y_address = stuInfo.y_address; //stu.y_name = stuInfo.y_name; //stu.y_sex = stuInfo.y_sex; //stu.y_cardId = stuInfo.y_cardId; //stu.y_birthday = stuInfo.y_birthday; //stu.y_examNum = stuInfo.y_examNum; //stu.y_stuNum = stuInfo.y_stuNum; //stu.y_tel = stuInfo.y_tel; //stu.y_address = stuInfo.y_address; //stu.y_mail = stuInfo.y_mail; //stu.y_img = stuInfo.y_img; var majorli = request["majorhidden"]; int majorliid = 0; if (majorli == "" && stuInfo.y_majorId == 0) { var majorlib = yunEntities.VW_StuInfo.FirstOrDefault(u => u.id == stuInfo.id); if (majorlib != null) { var major = yunEntities.YD_Edu_Major.FirstOrDefault(u => u.id == majorlib.y_majorId); if (major != null) { majorliid = major.y_majorLibId; } } } else { majorliid = Convert.ToInt32(majorli); } if (string.IsNullOrWhiteSpace(stuInfo.y_registerState)) { var majorId = AdminBaseController.GetMajorIds(majorliid, Convert.ToInt32(request.Params["EduType"]), Convert.ToInt32(request.Params["StuType"])); if (majorId == 0) { ms = "学生修改失败:专业生成参数错误"; return(ms); } stuInfo.y_majorId = majorId; //stu.y_majorId = majorId; //stu.y_nationId = stuInfo.y_nationId; //stu.y_politicsId = stuInfo.y_politicsId; //stu.y_subSchoolId = stuInfo.y_subSchoolId; //stu.y_inYear = stuInfo.y_inYear; //stu.y_stuStateId = stuInfo.y_stuStateId; } if (stuInfo.y_nationId == 0) { stuInfo.y_nationId = null; } if (stuInfo.y_politicsId == 0) { stuInfo.y_politicsId = null; } yunEntities.Entry(stuInfo).State = EntityState.Modified; int r = yunEntities.SaveChanges(); if (r > 0) { return("ok"); } else { return(ms); } }
/// <summary> /// 添加专业,调用此方法前确定三个参数都在数据库中存在 /// </summary> /// <param name="majorLib">专业库</param> /// <param name="eduType">专业层次</param> /// <param name="stuType">学习形式</param> /// <returns>专业ID</returns> public static int AddMajor(int majorLib, int eduType, int stuType) { using (var yunEntity = new IYunEntities()) { var major = new YD_Edu_Major(); var edutypename = yunEntity.YD_Edu_EduType.FirstOrDefault(u => u.id == eduType); if (edutypename != null && edutypename.y_name == "高起专") //如果层次是高起专则学制为3 { major = new YD_Edu_Major { y_majorLibId = majorLib, y_stuTypeId = stuType, y_eduTypeId = eduType, y_name = "", y_code = "", y_stuYear = 3 }; } //如果是中医药大学则改变学制 if (ConfigurationManager.AppSettings["SchoolName"].ToString() == ComEnum.SchoolName.ZYYDX.ToString()) { if (edutypename != null && edutypename.y_name == "高起专") //如果层次是高起专则学制为4 { major = new YD_Edu_Major { y_majorLibId = majorLib, y_stuTypeId = stuType, y_eduTypeId = eduType, y_name = "", y_code = "", y_stuYear = 4 }; } } if (edutypename != null && edutypename.y_name == "高起本") //如果层次是高起本则学制为5 { major = new YD_Edu_Major { y_majorLibId = majorLib, y_stuTypeId = stuType, y_eduTypeId = eduType, y_name = "", y_code = "", y_stuYear = 5 }; } if (edutypename != null && edutypename.y_name == "专升本") //如果层次是专升本则学制为3 { major = new YD_Edu_Major { y_majorLibId = majorLib, y_stuTypeId = stuType, y_eduTypeId = eduType, y_name = "", y_code = "", y_stuYear = 3 }; } yunEntity.Entry(major).State = EntityState.Added; yunEntity.SaveChanges(); major.y_code = major.id.ToString(); var ydEduMajorLibrary = yunEntity.YD_Edu_MajorLibrary.Find(majorLib); if (ydEduMajorLibrary != null) { var majorname = ydEduMajorLibrary.y_name; //如果是中医药大学则改变学制 if (ConfigurationManager.AppSettings["SchoolName"].ToString() == ComEnum.SchoolName.ZYYDX.ToString()) { //如果专业为医药营销则学制为3 if (majorname == "医药营销") { major.y_stuYear = 3; yunEntity.Entry(major).State = EntityState.Modified; } } var ydEduEduType = yunEntity.YD_Edu_EduType.Find(eduType); if (ydEduEduType != null) { var eduTypename = ydEduEduType.y_name; var ydEduStuType = yunEntity.YD_Edu_StuType.Find(stuType); if (ydEduStuType != null) { var stuTypename = ydEduStuType.y_name; major.y_name = majorname + " " + eduTypename + " " + stuTypename; } } } yunEntity.SaveChanges(); return(major.id); } }
/// <summary> /// 后台登录验证 /// </summary> /// <returns></returns> public string LoginVerify() { var result = "非法请求"; var code = Request["code"]; if (!string.IsNullOrEmpty(code)) { code = code.Trim(); } else { result = "无效验证码"; return(result); } if (!IsRightCode(code)) { result = "验证码错误"; return(result); } var adminname = Request["adminname"].Trim(); if (string.IsNullOrWhiteSpace(adminname)) { result = "账号不能为空"; return(result); } var password = PageValidate.GetMd5StrL(Request["password"].Trim()); using (var yunEntities = new IYunEntities()) { YD_Sys_Admin admin = yunEntities.YD_Sys_Admin.FirstOrDefault(u => u.y_name == adminname && u.y_password == password); if (admin == null) { adminname = Request["adminname"].Trim(); password = Request["password"].Trim(); YD_Sts_StuInfo admin1; //if(adminname.Split('_')[0] != ConfigurationManager.AppSettings["QinshuKey"].ToString().ToLower()) //{ // result = "账号或密码错误"; // return result; //} //var stunum = adminname.Split('_')[1]; var model = yunEntities.YD_Sts_StuInfo.FirstOrDefault(u => u.y_loginName == adminname && u.y_isdel == 1); if (model == null) { result = "账号或密码错误"; return(result); } admin1 = yunEntities.YD_Sts_StuInfo.FirstOrDefault(u => u.y_loginName == adminname && u.y_password == password); if (admin1 == null) { result = "账号或密码错误"; return(result); } System.Web.HttpContext.Current.Session[KeyValue.Admin_Name] = adminname; System.Web.HttpContext.Current.Session[KeyValue.stu_id] = admin1.id; //新增 System.Web.HttpContext.Current.Session[KeyValue.Admin_Role_id] = yunEntities.YD_Sys_Role.FirstOrDefault(x => x.y_name == "学生").id; System.Web.HttpContext.Current.Session[KeyValue.Admin_id] = yunEntities.YD_Sys_AdminSubLink.FirstOrDefault(x => x.y_subSchoolId == admin1.y_subSchoolId).y_adminId; System.Web.HttpContext.Current.Session[KeyValue.Admin_LoginFlag] = KeyValue.Admin_LoginOKFlag; System.Web.HttpContext.Current.Session[KeyValue.AdminRelName] = admin1.y_name; result = "ok_student"; return(result); } //保存不加密的密码 var pass = Request["password"].Trim(); admin.y_realpassword = pass; yunEntities.Entry(admin).State = EntityState.Modified; yunEntities.SaveChanges(); System.Web.HttpContext.Current.Session[KeyValue.Admin_Name] = adminname;//保存一些角色信息 System.Web.HttpContext.Current.Session[KeyValue.Admin_id] = admin.id; //新增 System.Web.HttpContext.Current.Session[KeyValue.Admin_Role_id] = admin.y_roleID; System.Web.HttpContext.Current.Session[KeyValue.Admin_LoginFlag] = KeyValue.Admin_LoginOKFlag; System.Web.HttpContext.Current.Session[KeyValue.AdminRelName] = admin.y_realName; //HttpRuntime.Cache.Insert(KeyValue.AdminObj, admin,); LogHelper.DbLog(admin.id, admin.y_name, (int)LogType.LoginIn, "正常登录。"); } result = "ok"; return(result); }
/// <summary> /// 删除用户 /// </summary> /// <returns></returns> public string DeleteAdmin(HttpRequestBase request, IYunEntities yunEntities) { var ids = request["ids"]; if (string.IsNullOrEmpty(ids)) { return("数据为空"); } #region “删除”权限验证 var powerInfo = Safe("/SysAdmin/Admin", PowerFlag.Delete); switch (powerInfo) { case PowerInfo.NoPower: return("无权限"); case PowerInfo.NoLogin: return("未登录"); case PowerInfo.Unknow: return("未知状况"); case PowerInfo.HasPower: break; default: return("未知状况"); } #endregion var idsstr = ids.Split(new[] { ',' }, StringSplitOptions.RemoveEmptyEntries); var idsList = new List <int>(); for (var i = 0; i < idsstr.Count(); i++) { idsList.Add(Convert.ToInt32(idsstr[i])); } var admins = yunEntities.YD_Sys_Admin.Where(u => idsList.Contains(u.id)).ToList(); foreach (var admin in admins) { if (admin.id == YdAdminId) { return("不能删除当前账号"); } if (yunEntities.YD_Sys_DbLog.Any(u => u.y_userID == admin.id)) { return("当前账号存在关联日志,不能删除"); } var adminCourseList = admin.YD_Sys_AdminCourseLink.ToList(); var adminSubList = admin.YD_Sys_AdminSubLink.ToList(); for (var i = 0; i < adminCourseList.Count; i++) { yunEntities.Entry(adminCourseList[i]).State = EntityState.Deleted; } for (var i = 0; i < adminSubList.Count; i++) { yunEntities.Entry(adminSubList[i]).State = EntityState.Deleted; } yunEntities.Entry(admin).State = EntityState.Deleted; LogHelper.DbLog(Convert.ToInt32(HttpContext.Current.Session[KeyValue.Admin_id]), HttpContext.Current.Session[KeyValue.Admin_Name].ToString(), (int)LogType.Delete, "删除用户,用户名为" + admin.y_name + ",id:" + admin.id); } var j = yunEntities.SaveChanges(); return(j > 0 ? "ok" : "删除角色失败"); }
/// <summary> /// 师范大学的添加课程 /// </summary> /// <param name="request"></param> /// <returns></returns> public string CreateTeachPlanSd(HttpRequestBase request) { using (var yunEntities = new IYunEntities()) { //获取所有提交过来的数据 var year = Convert.ToInt32(request["year"]); var y_term = Convert.ToInt32(request["term"]); var majorId = Convert.ToInt32(request["majorlihidden2"]); var teachplantype = 2; var y_courseId = Convert.ToInt32(request["coursehidden"]); var y_courseTypeId = Convert.ToInt32(request["y_courseTypeId"]); var y_stuTime = Convert.ToInt32(request["y_stuTime"]); var y_score = Convert.ToDecimal(request["y_score"]); //查询出teachPlanID var teachplanid = yunEntities.VW_MajorTeachPlan.FirstOrDefault( u => u.y_teaPlanType == teachplantype && u.y_majorId == majorId && u.y_term == y_term && u.y_year == year); if (teachplanid == null) { var majorlist = yunEntities.YD_Edu_Major.Where(u => u.id == majorId).ToList(); foreach (var m in majorlist) { //添加教学计划 var teachplan = new YD_Edu_TeachPlan() { y_teaPlanName = m.y_name + "第" + y_term + "学期" + teachplantype + "类型" + year + "年" + DateTime.Now.ToString("yyyy/MM/dd"), y_term = y_term }; yunEntities.Entry(teachplan).State = EntityState.Added; yunEntities.SaveChanges(); //添加专业教学计划 var majorthachplan = new YD_Edu_MajorTeachPlan() { y_year = year, y_majorId = majorId, y_teachPlanId = teachplan.id, y_teaPlanType = teachplantype }; yunEntities.Entry(majorthachplan).State = EntityState.Added; yunEntities.SaveChanges(); } //查询专业教学计划视图得到添加的教学计划id teachplanid = yunEntities.VW_MajorTeachPlan.FirstOrDefault( u => u.y_teaPlanType == teachplantype && u.y_majorId == majorId && u.y_term == y_term && u.y_year == year); } //插入数据 var TeachplanDes = new YD_Edu_TeachplanDes() { y_teaPlanId = teachplanid.y_teachPlanId, y_courseId = y_courseId, y_courseTypeId = y_courseTypeId, y_stuTime = y_stuTime, y_score = y_score }; yunEntities.Entry(TeachplanDes).State = EntityState.Added; int r = yunEntities.SaveChanges(); if (r > 0) { return("ok"); } else { return("未知错误"); } } }