public static string UpdateStudentImgnew(string num, string card) { using (var yunEntities = new IYunEntities()) { var stu = yunEntities.YD_Sts_StuInfo.FirstOrDefault(u => u.y_examNum == num && u.y_inYear == 2015); var stucard = yunEntities.YD_Sts_StuInfo.FirstOrDefault(u => u.y_inYear == 2015 && u.y_cardId == card); //师大15级学生使用身份证号匹配 string path = ""; path = "D:/wwwroot/jxsfdx/wwwroot/Content/StudentImg/新15级相片/" + stu.y_cardId + ".jpg"; if (File.Exists(path)) { path = "../../Content/StudentImg/新15级相片/" + stu.y_cardId + ".jpg"; } else { if (num.Substring(0, 2) == "14") { path = "../../Content/StudentImg/2015级相片/" + stu.y_examNum + ".jpg"; } } return(path); } }
/// <summary> /// 增加学籍状态类型 /// </summary> /// <returns></returns> public ActionResult StuStateAdd(YD_Edu_StuState role) { using (var yunEntities = new IYunEntities()) { return(Content(_stuStateDal.AddEntity(role, yunEntities))); } }
/// <summary> /// 获取数据集合 /// </summary> /// <returns></returns> public string AdminList(IYunEntities yunEntities) { #region “查询”权限验证 var powerInfo = Safe("/SysAdmin/Admin", PowerFlag.Select); switch (powerInfo) { case PowerInfo.NoPower: return("没有权限"); case PowerInfo.NoLogin: return("未登录"); case PowerInfo.Unknow: return("未知错误"); case PowerInfo.HasPower: break; default: return("未知错误"); } #endregion var admins = List(u => true, yunEntities); return(JsonConvert.SerializeObject(admins)); }
/// <summary> /// 删除课程类型 /// </summary> /// <returns></returns> public ActionResult NationDelete(int id) { using (var yunEntities = new IYunEntities()) { return(Content(_nationDal.EntityDelete(id, yunEntities))); } }
/// <summary> /// 删除课程类型 /// </summary> /// <returns></returns> public ActionResult CourseTypeDelete(int id) { using (var yunEntities = new IYunEntities()) { return(Content(_courseTypeDal.EntityDelete(id, yunEntities))); } }
/// <summary> /// 获取数据集合 /// </summary> /// <returns></returns> public string RoleList(HttpRequestBase request, IYunEntities yunEntities) { #region “查询”权限验证 var powerInfo = Safe("/SysAdmin/Role", PowerFlag.Select); var info = new Hashtable(); switch (powerInfo) { case PowerInfo.NoPower: info.Add("message", "无权限"); return(JsonConvert.SerializeObject(info)); case PowerInfo.NoLogin: info.Add("message", "未登录"); return(JsonConvert.SerializeObject(info)); case PowerInfo.Unknow: info.Add("message", "未知错误"); return(JsonConvert.SerializeObject(info)); case PowerInfo.HasPower: break; default: info.Add("message", "未知错误"); return(JsonConvert.SerializeObject(info)); } #endregion var roles = List(u => true, yunEntities); return(JsonConvert.SerializeObject(roles)); }
/// <summary> /// 增加政治面貌 /// </summary> /// <returns></returns> public ActionResult PoliticsAdd(YD_Sts_Politics role) { using (var yunEntities = new IYunEntities()) { return(Content(_politicsDal.AddEntity(role, yunEntities))); } }
//专业库 public ActionResult MajorLibrary2(HelperParameterM para) { ViewData["para"] = para; using (var yunEntity = new IYunEntities()) { if (string.IsNullOrWhiteSpace(para.whereSql)) { var list = yunEntity.YD_Edu_MajorLibrary.OrderBy(u => u.y_name).ToList(); ViewData["data"] = list; //if (HttpRuntime.Cache["MajorLibrary"] == null) //如果缓冲不存在 //{ // var list = yunEntity.YD_Edu_MajorLibrary.ToList(); // ViewData["data"] = list; // HttpRuntime.Cache.Insert("MajorLibrary", list, null, DateTime.Now.AddHours(1) // , Cache.NoSlidingExpiration); //} //else //{ // ViewData["data"] = HttpRuntime.Cache["MajorLibrary"] as List<YD_Edu_MajorLibrary>; //} } else { var list = yunEntity.Database.SqlQuery <YD_Edu_MajorLibrary>(para.whereSql).ToList(); ViewData["data"] = list; } } return(PartialView()); }
//通过入学年份,函授站获取班级教学计划中的专业 public string GetMajor_Teaplan(int schoolid, int year) { using (var db = new IYunEntities()) { var list = db.YD_TeaPlan_Class.AsQueryable(); if (year != 0) { list = list.Where(u => u.y_year == year); } if (schoolid != 0) { list = list.Where(u => u.y_subSchoolId == schoolid); } var lists = list.Select( u => new { u.YD_Edu_Major.id, majorName = u.YD_Edu_Major.y_name }).DistinctBy(u => new { u.id }) .OrderBy(u => u.majorName) .ToList(); return(JsonConvert.SerializeObject(lists)); } }
/// <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> /// <returns></returns> public ActionResult MyScore() { #region 权限验证 if (!IsLogin()) { Redirect("/AdminBase/Index"); } #endregion using (var yunEntities = new IYunEntities()) { int term = Convert.ToInt32(Request["term"]); ViewBag.term = term; var list = yunEntities.YD_Edu_Score.Include(x => x.YD_Sts_StuInfo).Include(x => x.YD_Edu_Course).Where(x => x.y_stuId == LoginId).OrderBy(x => x.y_term).Distinct(); list = list.Where(x => x.y_term == term); List <ScoreListDto> model = list.Select(u => new ScoreListDto { StuId = u.y_stuId, StuName = u.YD_Sts_StuInfo.y_name, stunum = u.YD_Sts_StuInfo.y_stuNum, CourseId = u.y_courseId, CourseName = u.YD_Edu_Course.y_name, Team = u.y_term, ScoreId = u.id, NormalScore = u.y_normalScore, TermScore = u.y_termScore, TotalScore = u.y_totalScore, ScoreOk = u.YD_Sts_StuInfo.y_scoreOk == 1 ? "通过" : u.YD_Sts_StuInfo.y_scoreOk == 0 ? "不通过" : "未审核" }).ToList(); return(View(model)); } }
/// <summary> /// 移动栏目,委托:OperModule类型 /// </summary> /// <param name="module">要栏目的栏目对象</param> /// <param name="yunEntities"></param> /// <returns>信息集对象</returns> private ResultInfo MoveOper(YD_Sys_Module module, IYunEntities yunEntities) { var resultInfo = new ResultInfo { Info = Safe("/SysAdmin/Module", PowerFlag.Update) }; if (module.y_parentID == module.id) { resultInfo.Success = false; resultInfo.Message = "自身不能成为自身的子栏目"; return(resultInfo); } var moduleLast = yunEntities.YD_Sys_Module.FirstOrDefault(u => u.id == module.y_parentID); if (IsChildrenModule(module, moduleLast, yunEntities)) { resultInfo.Success = false; resultInfo.Message = "自身不能成为自身子栏目的子栏目"; return(resultInfo); } MoveOperChildrenModule(module, yunEntities); resultInfo.Success = yunEntities.SaveChanges() > 0; resultInfo.Message = ""; if (resultInfo.Success) { 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 + ",移动到parentID:" + module.y_parentID + ",id:" + module.id); } return(resultInfo); }
/// <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="request">请求上下文对象</param> /// <param name="yunEntities">EF上下文对象</param> /// <returns></returns> public string MoveModule(HttpRequestBase request, IYunEntities yunEntities) { var moduleNowStr = request["moduleNow"]; var moduleLastStr = request["moduleLast"]; if (string.IsNullOrEmpty(moduleLastStr) || string.IsNullOrEmpty(moduleNowStr)) { return("请先选择栏目"); } if (moduleLastStr == moduleNowStr) { return("自身不能成为自身的子栏目"); } var moduleNowId = Convert.ToInt32(moduleNowStr); var moduleLastId = Convert.ToInt32(moduleLastStr); var moduleNow = yunEntities.YD_Sys_Module.FirstOrDefault(u => u.id == moduleNowId); var moduleLast = yunEntities.YD_Sys_Module.FirstOrDefault(u => u.id == moduleLastId); if (moduleNow == null) { return("栏目为空"); } if (IsChildrenModule(moduleNow, moduleLast, yunEntities)) { return("自身不能成为自身子栏目的子栏目"); } moduleNow.y_parentID = moduleLastId == 0 ? 0 : moduleLast.id; return(Oper(moduleNow, MoveOper, yunEntities)); }
//public static bool IsAdminMajorLink(int adminId, int majorId) //{ // using (var yunEntities = new IYunEntities()) // { // return yunEntities.YD_Sys_AdminMajorLink.Any(u => u.y_adminId == adminId && u.y_majorId == majorId); // } //} public static bool IsAdminCourseLink(int adminId, int courseId) { using (var yunEntities = new IYunEntities()) { return(yunEntities.YD_Sys_AdminCourseLink.Any(u => u.y_adminId == adminId && u.y_courseId == courseId)); } }
//通过专业,函授站获取课程 public string GetCourse(int majorId, int schoolId, int year, int eduId, int team, int stuTypeId) { using (var db = new IYunEntities()) { var list = db.YD_TeaPlan_ClassCourseDes.Include(u => u.YD_Edu_Course).Include(u => u.YD_TeaPlan_Class).AsQueryable(); list = list.Where(u => u.YD_TeaPlan_Class.y_subSchoolId == schoolId && u.YD_TeaPlan_Class.y_year == year); //函授站年份筛选 list = list.Where( u => u.YD_TeaPlan_Class.YD_Edu_Major.y_majorLibId == majorId && u.YD_TeaPlan_Class.YD_Edu_Major.y_eduTypeId == eduId && u.YD_TeaPlan_Class.YD_Edu_Major.y_stuTypeId == stuTypeId); //专业层次筛选 var teamindex = team; list = list.Where(u => u.y_team == teamindex); var lists = list.Select(u => new { u.YD_Edu_Course.id, u.YD_Edu_Course.y_name }).DistinctBy(u => new { u.id }) .OrderBy(u => u.y_name) .ToList(); return(JsonConvert.SerializeObject(lists)); } }
public ActionResult FileList(int id = 1) { #region “文件列表”权限验证 var power = SafePowerPage("/FileManager/FileList"); if (!IsLogin()) { return(Redirect("/AdminBase/Index")); } if (power == null || power.y_menu == (int)PowerState.Disable) { //var reurl = Request.UrlReferrer.ToString(); var reurl = "/AdminBase/Index"; return(Content("<script>alert('没有权限');window.location.href='" + reurl + "'</script>")); } #endregion var filename = Request["y_name"]; using (var yunEntities = new IYunEntities()) { ViewBag.modulePowers = GetChildModulePower(yunEntities, 112); //根据父栏目ID获取兄弟栏目 ViewBag.adminroleid = YdAdminRoleId; IQueryable <YD_Sys_File> list = yunEntities.YD_Sys_File.Where(x => x.y_role == 0 || x.y_role == YdAdminRoleId). OrderByDescending(x => x.y_time); if (!string.IsNullOrWhiteSpace(filename)) { list = list.Where(x => x.y_name.Contains(filename)); } var pagedList = list.ToPagedList(id, 15); if (Request.IsAjaxRequest()) { return(PartialView("FilePage", pagedList)); } return(View(pagedList)); } }
//通过专业,函授站获取课程 public string GetCourse_S(int majorId, int schoolId, int year, int term) { using (var db = new IYunEntities()) { var list = db.YD_TeaPlan_ClassCourseDes.Include(u => u.YD_Edu_Course).Include(u => u.YD_TeaPlan_Class).AsQueryable(); if (year != 0) { list = list.Where(u => u.YD_TeaPlan_Class.y_year == year); } if (schoolId != 0) { list = list.Where(u => u.YD_TeaPlan_Class.y_subSchoolId == schoolId); } if (majorId != 0) { list = list.Where(u => u.YD_TeaPlan_Class.YD_Edu_Major.id == majorId); } if (term != 0) { list = list.Where(u => u.y_team == term); } var lists = list.Select(u => new { u.YD_Edu_Course.id, u.YD_Edu_Course.y_name }).DistinctBy(u => new { u.id }) .OrderBy(u => u.y_name) .ToList(); return(JsonConvert.SerializeObject(lists)); } }
/// <summary> /// 编辑层次 /// </summary> /// <returns></returns> public ActionResult EduTypeEdit(YD_Edu_EduType role) { using (var yunEntities = new IYunEntities()) { return(Content(_eduEduTypeDal.EditEntity(role, yunEntities))); } }
//通过入学年份,函授站获取学生中的专业 public string GetMajor_Stu(int year, int schoolId) { using (var db = new IYunEntities()) { var list = db.YD_Sts_StuInfo.Where(u => u.y_subSchoolId != null && u.y_isdel == 1); if (year != 0) { list = list.Where(u => u.y_inYear == year); } if (schoolId != 0) { list = list.Where(u => u.y_subSchoolId == schoolId); } var lists = list.Select( u => new { id = u.YD_Edu_Major.id, majorName = u.YD_Edu_Major.y_name }).DistinctBy(u => new { u.id }) .OrderBy(u => u.majorName) .ToList(); return(JsonConvert.SerializeObject(lists)); } }
/// <summary> /// 增加课程类型 /// </summary> /// <returns></returns> public ActionResult NationAdd(YD_Sts_Nation role) { using (var yunEntities = new IYunEntities()) { return(Content(_nationDal.AddEntity(role, yunEntities))); } }
//通过入学年份,函授站,层次获取学生的专业--用于新生注册 public string GetNewFeeMajorLibrary_Stu(int schoolId, int edutypeId, int year) { using (var db = new IYunEntities()) { var list = db.YD_Sts_StuInfo.Where(u => u.y_subSchoolId != null && u.y_isdel == 1); if (schoolId != 0) { list = list.Where(u => u.y_subSchoolId == schoolId); } if (edutypeId != 0) { list = list.Where(u => u.YD_Edu_Major.y_eduTypeId == edutypeId); } if (year != 0) { list = list.Where(u => u.y_inYear == year); } if (schoolId == 0 && YdAdminRoleId == 4) { var subSchoolIds = db.YD_Sys_AdminSubLink.Where(u => u.y_adminId == YdAdminId).Select(u => u.y_subSchoolId); list = list.Where(u => subSchoolIds.Contains(u.y_subSchoolId.Value)); } var lists = list.Select( u => new { u.YD_Edu_Major.y_majorLibId, majorLibraryName = u.YD_Edu_Major.YD_Edu_MajorLibrary.y_name }).DistinctBy(u => new { u.y_majorLibId }) .OrderBy(u => u.majorLibraryName) .ToList(); return(JsonConvert.SerializeObject(lists)); } }
/// <summary> /// 增加课程类型 /// </summary> /// <returns></returns> public ActionResult CourseTypeAdd(YD_Edu_CourseType role) { using (var yunEntities = new IYunEntities()) { return(Content(_courseTypeDal.AddEntity(role, yunEntities))); } }
/// <summary> /// 递归获取子集栏目权限 /// </summary> /// <param name="powerModuleId"></param> /// <param name="yunEntities"></param> /// <returns></returns> public List <ModulePower> GetChildrenModulePower(int powerModuleId, IYunEntities yunEntities) { const int vaild = (int)DataState.Able; const int menu = (int)PowerState.Able; var modulePowerSons = yunEntities.VW_Power.Where( u => u.y_parentID == powerModuleId && u.y_roleID == YdAdminRoleId && u.y_vaild == vaild && u.y_menu == menu).OrderByDescending(u => u.y_sort); var children = new List <ModulePower>(); foreach (var modulePowerSon in modulePowerSons) { var modulePowerChildren = new ModulePower { id = modulePowerSon.id, y_url = modulePowerSon.y_url, y_sort = modulePowerSon.y_sort, y_parentID = modulePowerSon.y_parentID, y_level = modulePowerSon.y_level, y_vaild = modulePowerSon.y_vaild, y_roleID = modulePowerSon.y_roleID, y_moduleID = modulePowerSon.y_moduleID, y_menu = modulePowerSon.y_menu, y_insert = modulePowerSon.y_insert, y_delete = modulePowerSon.y_delete, y_update = modulePowerSon.y_update, y_select = modulePowerSon.y_select, y_roleName = modulePowerSon.y_roleName, y_moudleName = modulePowerSon.y_moudleName, }; children.Add(modulePowerChildren); } return(children); }
public ActionResult StuState(int id = 1) { #region “学籍状态类型管理”权限验证 var power = SafePowerPage("/DicAdmin/StuState"); if (!IsLogin()) { return(Redirect("/AdminBase/Index")); } if (power == null || power.y_menu == (int)PowerState.Disable) { return(Content("没有权限")); } #endregion ViewBag.power = power; using (var yunEntities = new IYunEntities()) { var dbLogList = yunEntities.YD_Edu_StuState.OrderByDescending(u => u.id).ToPagedList(id, 15); //id为pageindex 15 为pagesize; ViewBag.modulePowers = GetChildModulePower(yunEntities, 6); //根据父栏目ID获取兄弟栏目 if (Request.IsAjaxRequest()) { return(PartialView("StuStateList", dbLogList)); } return(View(dbLogList)); } }
/// <summary> /// 根据输入专业库,专业层次,学习形式获取专业ID /// </summary> /// <param name="majorLib">专业库</param> /// <param name="eduType">专业层次</param> /// <param name="stuType">学习形式</param> /// <returns>专业ID</returns> public static int GetMajorId(int majorLib, int eduType, int stuType) { using (var yunEntity = new IYunEntities()) { if (!yunEntity.YD_Edu_MajorLibrary.Any(u => u.id == majorLib)) { return(0); } if (!yunEntity.YD_Edu_EduType.Any(u => u.id == eduType)) { return(0); } if (!yunEntity.YD_Edu_StuType.Any(u => u.id == stuType)) { return(0); } var major = yunEntity.YD_Edu_Major.FirstOrDefault( u => u.y_eduTypeId == eduType && u.y_majorLibId == majorLib && u.y_stuTypeId == stuType); if (major == null) { return(AddMajor(majorLib, eduType, stuType)); //调用添加方法 } else { return(major.id); } } }
/// <summary> /// 删除学籍状态类型 /// </summary> /// <returns></returns> public ActionResult StuStateDelete(int id) { using (var yunEntities = new IYunEntities()) { return(Content(_stuStateDal.EntityDelete(id, yunEntities))); } }
public static bool IsAdminSubLink(int adminId, int subSchId) { using (var yunEntities = new IYunEntities()) { return(yunEntities.YD_Sys_AdminSubLink.Any(u => u.y_adminId == adminId && u.y_subSchoolId == subSchId)); } }
/// <summary> /// 同步学生 /// </summary> /// <returns></returns> public bool TongBuStudent() { string content = "{\"data\":{\"displayName\":\"\",\"gender\":\"\",\"idCard\":\"\",\"phoneNum\":\"\",\"centerId\":0,\"majorId\":0,\"semesterId\":0,\"studentNumber\":\"\",\"studyStatusId\":0,\"pageIndex\":0,\"pageSize\":99999}}"; sen = sing(content); string content1 = "{\"data\":{\"displayName\":\"\",\"gender\":\"\",\"idCard\":\"\",\"phoneNum\":\"\",\"centerId\":0,\"majorId\":0,\"semesterId\":0,\"studentNumber\":\"\",\"studyStatusId\":0,\"pageIndex\":0,\"pageSize\":99999},\"signature\": \"" + sen + "\"}"; html = WebPost("http://www.qingshuxuetang.com/QingShuSchoolWebService/jxsf/v1/student/search", content1, Encoding.UTF8); if (!html.Contains("服务器")) { var results = JsonConvert.DeserializeObject <QingShuStuMessage>(html); if (results.hr == 0) { var list = results.data; using (var yunEntities = new IYunEntities()) { var qingCourses = new List <YD_Edu_QingStuInfo>(); for (var i = 0; i < list.Count; i++) { var qingStu = new YD_Edu_QingStuInfo(); qingStu.y_qingId = list[i].id; qingStu.y_name = list[i].displayName; qingStu.y_stuNum = list[i].studentNumber; qingStu.y_qingSubId = list[i].centerId; qingStu.y_qingMajorId = list[i].majorId; var stuNum = list[i].name.Replace("jxsf_", ""); var obj = yunEntities.YD_Sts_StuInfo.FirstOrDefault(u => u.y_stuNum == stuNum); if (obj == null) { continue; } qingStu.y_nid = obj.id; qingStu.y_cardId = obj.y_cardId; if (!yunEntities.YD_Edu_QingStuInfo.Any(u => u.y_qingId == qingStu.y_qingId))//本地已映射的学生不再映射 { qingCourses.Add(qingStu); } } yunEntities.Configuration.AutoDetectChangesEnabled = false; yunEntities.Configuration.ValidateOnSaveEnabled = false; yunEntities.Set <YD_Edu_QingStuInfo>().AddRange(qingCourses); yunEntities.SaveChanges(); //yunEntities.BulkInsert(qingCourses); //yunEntities.SaveChanges(); return(true); } } else { return(false); } } else { return(false); } }
public ActionResult SupTaxReport() { var subSchool = Request["SubSchool"]; var inYear = Request["inYear"]; using (IYunEntities ctx = new IYunEntities()) { ViewBag.modulePowers = GetChildModulePower(ctx, 36); //根据父栏目ID获取兄弟栏目 ViewBag.adminrole = YdAdminRoleId; string subSchoolSql = "y_subSchoolId is not null"; string inYearSql = "y_inYear is not null"; if (!string.IsNullOrEmpty(subSchool) && subSchool != "0") { ViewBag.subschool = Convert.ToInt32(subSchool); subSchoolSql = $"y_subSchoolId = '{subSchool}'"; } if (YdAdminRoleId == 4) { var subSchoolIds = ctx.YD_Sys_AdminSubLink.Where(u => u.y_adminId == YdAdminId).Select(u => u.y_subSchoolId); subSchoolSql = $"y_subSchoolId = '{subSchoolIds.FirstOrDefault()}'"; ViewBag.subschoolid = subSchoolIds.FirstOrDefault(); } if (!string.IsNullOrEmpty(inYear) && inYear != "0") { ViewBag.year = Convert.ToInt32(inYear); inYearSql = $"y_inYear = '{inYear}'"; } string fullSql = $"SELECT schoolName,y_inYear,count(case when y_IsWorking is null then 1 end) as notSuped,count(case when y_IsWorking is not null then 1 end) as isSuped FROM VW_StuInfo WHERE ({subSchoolSql}) AND ({inYearSql}) AND (y_stuStateId != 6) AND y_isdel = 1 GROUP BY schoolName,y_inyear order by schoolName;"; var Model = ctx.Database.SqlQuery <SubStuSupStuReport>(fullSql).ToList(); ViewBag.substulist = Model; return(View(Model)); } }