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));
}
}
