/// <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("未知错误");
}
}
}
