public IActionResult Page([Required] Int32 index, String id, [Required] int code, [Required] DateTime left, [Required] DateTime right) { if (ModelState.IsValid) { StringBuilder builder = new StringBuilder("select * from LogStudentOperations where LogStudentOperationId > 0"); List <SqlParameter> parameters = new List <SqlParameter>(); if (id != null && id.Trim() != "") { builder.Append(" and StudentId = @Id"); SqlParameter parameter = new SqlParameter { SqlDbType = SqlDbType.NVarChar, ParameterName = "@Id", Value = id.Trim() }; parameters.Add(parameter); } if (code >= 0) { builder.Append($" and StuOperationCode = {code}"); } int pageSize = 12; //每一页的题目数量 // ReSharper disable once CoVariantArrayConversion int dataCount = _context.LogStudentOperations.FromSql(builder.ToString(), parameters.ToArray <SqlParameter>()).Count(); int pageCount = dataCount / pageSize; //有多少页 int lastCount = dataCount % pageSize; //最后一页的题目数量 if (lastCount > 0) { pageCount++; } if (index > pageCount || index <= 0) { return(Json(new { isOk = true, lineCount = 0, pageCount = 1, //总共是多少页 pageNowIndex = 1, //当前是第几页 })); } // ReSharper disable once CoVariantArrayConversion var list = _context.LogStudentOperations .FromSql(builder.ToString(), parameters.ToArray()) .Where(p => p.AddTime >= left && p.AddTime <= right) .OrderByDescending(l => l.AddTime) .Skip((index - 1) * pageSize) .Take(pageSize) .Select(log => new { id = log.LogStudentOperationId, uId = log.StudentId, addTime = _logger.FormatDateLocal(log.AddTime), ip = log.OperationIp, code = log.StuOperationCode.ToString(), target = log.StuOperationName, status = log.StuOperationStatus == StuOperationStatus.Success ? "操作成功" : "操作失败", content = log.StuOperationContent }) .ToList(); return(Json(new { isOk = true, lineCount = dataCount, PageCount = pageCount, //总共是多少页 pageNowIndex = index, //当前是第几页 items = list, size = pageSize })); } else { return(Json(new { isOk = false, error = _analysis.ModelStateDictionaryError(ModelState), title = "错误提示", message = "参数错误,传递了不符合规定的参数" })); } }
public IActionResult Page([Required] int index, [Required] int instituteId, [Required] int grade, [Required] int orderOne) { if (ModelState.IsValid) { StringBuilder builder = new StringBuilder("select * from [ExamResultView] where [InstituteId] > 0"); List <SqlParameter> parameters = new List <SqlParameter>(); if (instituteId > 0) { builder.Append($" and [InstituteId] = {instituteId}"); } if (grade > -1) { builder.Append($" and [Grade] = {grade}"); } int pageSize = 14; //每一页的题目数量 // ReSharper disable once CoVariantArrayConversion int dataCount = _context.VExamResultMaps.FromSql(builder.ToString(), parameters.ToArray <SqlParameter>()).Count(); int pageCount = dataCount / pageSize; //有多少页 int lastCount = dataCount % pageSize; //最后一页的题目数量 if (lastCount > 0) { pageCount++; } if (index > pageCount || index <= 0) { return(Json(new { isOk = true, lineCount = 0, pageCount = 1, //总共是多少页 pageNowIndex = 1, //当前是第几页 })); } if (orderOne == 0) { // ReSharper disable once CoVariantArrayConversion var list = _context.VExamResultMaps .FromSql(builder.ToString(), parameters.ToArray <SqlParameter>()) .OrderByDescending(v => v.TotalPassRate) .Skip((index - 1) * pageSize) .Take(pageSize).Select(v => new { grade = v.Grade, name = v.Name, total = v.Total, passTotal = v.PassTotal, postCount = v.PostCount, underCount = v.UnderCount, postPassCount = v.PostPassCount, postNotPassCount = v.PostNotPassCount, underPassCount = v.UnderPassCount, underNotPassCount = v.UnderNotPassCount, totalPassRate = v.TotalPassRate, postPassRate = v.PostPassRate, underPossRate = v.UnderPassRate }).ToList(); return(Json(new { isOk = true, lineCount = dataCount, PageCount = pageCount, //总共是多少页 pageNowIndex = index, //当前是第几页 items = list, size = pageSize })); } else if (orderOne > 0) { // ReSharper disable once CoVariantArrayConversion var list = _context.VExamResultMaps .FromSql(builder.ToString(), parameters.ToArray <SqlParameter>()) .OrderByDescending(v => v.PostPassRate) .Skip((index - 1) * pageSize) .Take(pageSize).Select(v => new { grade = v.Grade, name = v.Name, total = v.Total, passTotal = v.PassTotal, postCount = v.PostCount, underCount = v.UnderCount, postPassCount = v.PostPassCount, postNotPassCount = v.PostNotPassCount, underPassCount = v.UnderPassCount, underNotPassCount = v.UnderNotPassCount, totalPassRate = v.TotalPassRate, postPassRate = v.PostPassRate, underPossRate = v.UnderPassRate }).ToList(); return(Json(new { isOk = true, lineCount = dataCount, PageCount = pageCount, //总共是多少页 pageNowIndex = index, //当前是第几页 items = list, size = pageSize })); } else { // ReSharper disable once CoVariantArrayConversion var list = _context.VExamResultMaps .FromSql(builder.ToString(), parameters.ToArray <SqlParameter>()) .OrderByDescending(v => v.UnderPassRate) .Skip((index - 1) * pageSize) .Take(pageSize).Select(v => new { grade = v.Grade, name = v.Name, total = v.Total, passTotal = v.PassTotal, postCount = v.PostCount, underCount = v.UnderCount, postPassCount = v.PostPassCount, postNotPassCount = v.PostNotPassCount, underPassCount = v.UnderPassCount, underNotPassCount = v.UnderNotPassCount, totalPassRate = v.TotalPassRate, postPassRate = v.PostPassRate, underPossRate = v.UnderPassRate }).ToList(); return(Json(new { isOk = true, lineCount = dataCount, PageCount = pageCount, //总共是多少页 pageNowIndex = index, //当前是第几页 items = list, size = pageSize })); } } else { return(Json(new { isOk = false, error = _analysis.ModelStateDictionaryError(ModelState), title = "错误提示", message = "参数错误,传递了不符合规定的参数" })); } }
public IActionResult Page([Required] int index, [Required] int iId, [Required] int type, [Required] int pId, [Required] int status, [Required] int grade, String keyName) { if (ModelState.IsValid) { StringBuilder builder = new StringBuilder("select * from ReExamApplicationView where ApplicationExamId > 0"); if (iId > 0) { builder.Append($" and InstituteId = {iId}"); } if (type >= 0) { builder.Append($" and StudentType = {type}"); } if (pId >= 0) { builder.Append($" and ProfessionId = {pId}"); } if (status >= 0) { builder.Append($" and ApplicationStatus = {status}"); } if (grade >= 0) { builder.Append($" and Grade = {grade}"); } List <SqlParameter> parameters = new List <SqlParameter>(); if (keyName != null && keyName.Trim() != "") { builder.Append($" and Name like '%@keyName%'"); SqlParameter parameter = new SqlParameter { SqlDbType = SqlDbType.NVarChar, ParameterName = "@keyName", Value = keyName }; parameters.Add(parameter); builder.Append($" or StudentId like '@id'"); SqlParameter parameterId = new SqlParameter { SqlDbType = SqlDbType.NVarChar, ParameterName = "@id", Value = keyName }; parameters.Add(parameterId); } int pageSize = 14; //每一页的题目数量 // ReSharper disable once CoVariantArrayConversion int dataCount = _context.VReExamApplicationMaps.FromSql(builder.ToString(), parameters.ToArray <SqlParameter>()).Count(); int pageCount = dataCount / pageSize; //有多少页 int lastCount = dataCount % pageSize; //最后一页的题目数量 if (lastCount > 0) { pageCount++; } if (index > pageCount || index <= 0) { return(Json(new { isOk = true, lineCount = 0, pageCount = 1, //总共是多少页 pageNowIndex = 1, //当前是第几页 })); } // ReSharper disable once CoVariantArrayConversion var list = _context.VReExamApplicationMaps .FromSql(builder.ToString(), parameters.ToArray <SqlParameter>()) .OrderBy(item => item.ApplicationStatus) .ThenBy(ap => ap.InstituteId) .ThenBy(ap => ap.AddTime) .Skip((index - 1) * pageSize) .Take(pageSize).Select(v => new { addTime = v.AddTime.ToLocalTime(), type = v.StudentType == StudentType.UnderGraduate? "本科生":"研究生", sex = v.Sex? "男":"女", detail = v, isInspect = v.ApplicationStatus != ApplicationStatus.Submit, status = v.ApplicationStatus == ApplicationStatus.Submit ? "尚未审核" : v.ApplicationStatus == ApplicationStatus.Fail ? "未通过审核" : "已通过审核" }).ToList(); return(Json(new { isOk = true, lineCount = dataCount, PageCount = pageCount, //总共是多少页 pageNowIndex = index, //当前是第几页 items = list, size = pageSize })); } else { return(Json(new { isOk = false, error = _analysis.ModelStateDictionaryError(ModelState), title = "错误提示", message = "参数错误,传递了不符合规定的参数" })); } }
public IActionResult Page([Required] int index, [Required] Int32 cId, [Required] int status, [Required] int type, String content) { if (ModelState.IsValid && index > 0) { String sql = "select * from Resources where ResourceId > 0"; if (cId != -1) { sql += $" and CourceId = {cId}"; } if (content != null && content.Trim() != "") { sql += $" and Name like '%{content.Trim().Replace(";", ".")}%'"; } if (status != -1) { sql += $" and ResourceStatus = {status}"; } if (type != -1) { sql += $" and ResourceType = {type}"; } int pageSize = 10; //每一页的题目数量 int dataCount = _context.Resources.FromSql(sql).Count(); int pageCount = dataCount / pageSize; //有多少页 int lastCount = dataCount % pageSize; //最后一页的题目数量 if (lastCount > 0) { pageCount++; } if (index > pageCount || index <= 0) { return(Json(new { isOk = true, lineCount = 0, pageCount = 1, //总共是多少页 pageNowIndex = 1, //当前是第几页 })); } var list = _context.Resources.FromSql(sql).OrderByDescending(item => item.ResourceStatus).Include("Cource") .Skip((index - 1) * pageSize).Take(pageSize).Select(r => new { resourceId = r.ResourceId, name = r.Name, lengthOfStudy = r.LengthOfStudy, description = r.Description, cource = r.Cource, courceId = r.CourceId, rType = r.ResourceType, type = r.ResourceType == ResourceType.Link?"链接资源":"视频资源", status = r.ResourceStatus == ResourceStatus.Normal ? "未使用" : "使用中" }).ToList(); return(Json(new { isOk = true, lineCount = dataCount, PageCount = pageCount, //总共是多少页 pageNowIndex = index, //当前是第几页 Items = list, size = pageSize })); } else { return(Json(new { isOk = false, error = _analysis.ModelStateDictionaryError(ModelState), message = $"参数错误,传递了不符合规定的参数" })); } }
public IActionResult Create([Required] String name, [Required] int moduleId, [Required] float mark, [Required] String description) { if (ModelState.IsValid) { if (!_analysis.GetLoginUserConfig(HttpContext).Power.CourcesManager) { return(Json(new { isOk = false, title = "错误提示", message = "你并无课程管理操作权限" })); } if (!_context.Modules.Any(m => m.ModuleId == moduleId)) { return(Json(new { isOk = false, title = "错误提示", message = "模块不存在,或者已经被删除" })); } if (_context.Cources.Any(c => c.Name == name)) { return(Json(new { isOk = false, title = "错误提示", message = "此课程已经存在了" })); } else { Cource cource = new Cource { Name = name.Trim(), AddTime = DateTime.Now, CourceStatus = CourceStatus.Normal, Credit = mark, Introduction = description.Trim(), ModuleId = moduleId }; _context.Cources.Add(cource); _context.SaveChanges(); return(Json(new { isOk = false, title = "消息提示", message = "添加成功!" })); } } else { return(Json(new { isOk = false, error = _analysis.ModelStateDictionaryError(ModelState), title = "错误提示", message = "参数错误,传递了不符合规定的参数" })); } }
public IActionResult Page([Required] int index, [Required] int isFinish, [Required] int paperId, String studentId, float leftScore = 0, float rightScore = float.MaxValue) { if (ModelState.IsValid) { StringBuilder builder = new StringBuilder("select * from [ExaminationPapers] where [PaperId] > 0"); List <SqlParameter> parameters = new List <SqlParameter>(); if (studentId != null && studentId.Trim() != "") { builder.Append(" and StudentId = @StudentId"); parameters.Add(new SqlParameter { ParameterName = "@StudentId", Value = studentId.Trim(), SqlDbType = SqlDbType.NVarChar }); } if (paperId > 0) { builder.Append($" and [PaperId] = {paperId}"); } if (isFinish > -1) { if (isFinish == 0) { builder.Append(" and [IsFinish] = 0"); } else { builder.Append(" and [IsFinish] = 1"); } } builder.Append($" and Score > {leftScore} and Score < {rightScore}"); int pageSize = 12; //每一页的题目数量 // ReSharper disable once CoVariantArrayConversion int dataCount = _context.ExaminationPapers.FromSql(builder.ToString(), parameters.ToArray <SqlParameter>()).Count(); int pageCount = dataCount / pageSize; //有多少页 int lastCount = dataCount % pageSize; //最后一页的题目数量 if (lastCount > 0) { pageCount++; } if (index > pageCount || index <= 0) { return(Json(new { isOk = true, lineCount = 0, pageCount = 1, //总共是多少页 pageNowIndex = 1, //当前是第几页 })); } // ReSharper disable once CoVariantArrayConversion var list = _context.ExaminationPapers .FromSql(builder.ToString(), parameters.ToArray <SqlParameter>()) .OrderByDescending(item => item.PassScore) .ThenBy(ap => ap.Score) .ThenBy(ap => ap.TotleScore) .Skip((index - 1) * pageSize) .Take(pageSize).Select(v => new { studentId = v.StudentId, examTime = v.ExamTime, addTime = _logger.FormatDateLocal(v.AddTime), leaveExamTime = v.LeaveExamTime, totleScore = v.TotleScore, score = v.Score, isFinish = v.IsFinish ? "已完成":"未完成", passScore = v.PassScore, paperId = v.PaperId }).ToList(); return(Json(new { isOk = true, lineCount = dataCount, PageCount = pageCount, //总共是多少页 pageNowIndex = index, //当前是第几页 items = list, size = pageSize })); } else { return(Json(new { isOk = false, error = _analysis.ModelStateDictionaryError(ModelState), title = "错误提示", message = "参数错误,传递了不符合规定的参数" })); } }
public IActionResult EPage([Required] int index, String sName, String sId, [Required] int iId, [Required] int pid, Boolean isUnder, Boolean isPost, [Required] int grade, [Required] int isPass, float leftScore = 0, float rightScore = Int32.MinValue) { if (ModelState.IsValid && index > 0) { String sql = "select * from StudentView where InstituteId > 0"; List <SqlParameter> parameters = new List <SqlParameter>(); if (sName != null && sName.Trim() != "") { sql += $" and StudentName like @Name"; parameters.Add(new SqlParameter { ParameterName = "@Name", Value = $"%{sName.Trim()}%", SqlDbType = SqlDbType.NVarChar }); } if (sId != null && sId.Trim() != "") { sql += $" and StudentId = @StudentId"; parameters.Add(new SqlParameter { ParameterName = "@StudentId", Value = sId.Trim(), SqlDbType = SqlDbType.NVarChar }); } if (iId > 0) { sql += $" and InstituteId = @InstituteId"; parameters.Add(new SqlParameter { ParameterName = "@InstituteId", Value = iId, SqlDbType = SqlDbType.Int }); } if (pid > 0) { sql += $" and ProfessionId = @pid"; parameters.Add(new SqlParameter { ParameterName = "@pid", Value = pid, SqlDbType = SqlDbType.Int }); } if (isUnder == !isPost) { if (isPost) { sql += $" and StudentType = @sType"; parameters.Add(new SqlParameter { ParameterName = "@sType", Value = 1, SqlDbType = SqlDbType.Int }); } if (isUnder) { sql += $" and StudentType = @uType"; parameters.Add(new SqlParameter { ParameterName = "@uType", Value = 0, SqlDbType = SqlDbType.Int }); } } if (grade > 2015) { sql += $" and Grade = @grade"; parameters.Add(new SqlParameter { ParameterName = "@grade", Value = grade, SqlDbType = SqlDbType.Int }); } if (isPass >= 0) { sql += $" and IsPassExam = @PassState"; Boolean val = (isPass != 0); parameters.Add(new SqlParameter { ParameterName = "@PassState", Value = val, SqlDbType = SqlDbType.Bit }); } sql += $" and MaxExamScore >= @left and MaxExamScore <= @right"; parameters.Add(new SqlParameter { ParameterName = "@left", Value = leftScore, SqlDbType = SqlDbType.Real }); parameters.Add(new SqlParameter { ParameterName = "@right", Value = rightScore, SqlDbType = SqlDbType.Real }); int pageSize = 12; // ReSharper disable once CoVariantArrayConversion int dataCount = _context.VStudentMaps.FromSql(sql, parameters.ToArray()).Count(); int pageCount = dataCount / pageSize; int lastCount = dataCount % pageSize; if (lastCount > 0) { pageCount++; } if (index > pageCount || index <= 0) { return(Json(new { isOk = true, lineCount = 0, pageCount = 1, //总共是多少页 pageNowIndex = 1, //当前是第几页 size = pageSize })); } // ReSharper disable once CoVariantArrayConversion var items = _context.VStudentMaps.FromSql(sql, parameters.ToArray()) .OrderBy(item => item.InstituteId) .ThenBy(item => item.ProfessionId) .ThenByDescending(item => item.MaxExamScore) .Skip((index - 1) * pageSize).Take(pageSize).Select(val => new { instituteName = val.InstituteName, professionName = $"{val.ProfessionName}" + (val.ProfessionType == ProfessionType.UnderGraduate ? "[本科生]" : "[研究生]"), professionType = val.ProfessionType, studentId = val.StudentId, studentName = val.StudentName, grade = val.Grade, sex = val.Sex == true ? "男" : "女", studentType = val.StudentType == StudentType.UnderGraduate ? "本科生" : "研究生", isPassExam = val.IsPassExam ? "通过" : "未通过", maxExamScore = val.MaxExamScore, }).ToList(); return(Json(new { isOk = true, lineCount = dataCount, PageCount = pageCount, //总共是多少页 pageNowIndex = index, //当前是第几页 Items = items, size = pageSize })); } else { return(Json(new { isOk = false, error = _analysis.ModelStateDictionaryError(ModelState), message = $"参数错误,传递了不符合规定的参数" })); } }
public IActionResult Page([Required] Int32 index, String id, [Required] int terminal, [Required] DateTime left, [Required] DateTime right) { if (ModelState.IsValid) { StringBuilder builder = new StringBuilder("select * from LogUserLogin where LogUserLoginId > 0"); List <SqlParameter> parameters = new List <SqlParameter>(); if (id != null && id.Trim() != "") { builder.Append(" and ID = @Id"); SqlParameter parameter = new SqlParameter { SqlDbType = SqlDbType.NVarChar, ParameterName = "@Id", Value = id.Trim() }; parameters.Add(parameter); } if (terminal >= 0) { builder.Append($" and Terminal = {terminal}"); } int pageSize = 12; //每一页的题目数量 // ReSharper disable once CoVariantArrayConversion int dataCount = _context.LogUserLogin.FromSql(builder.ToString(), parameters.ToArray <SqlParameter>()).Count(); int pageCount = dataCount / pageSize; //有多少页 int lastCount = dataCount % pageSize; //最后一页的题目数量 if (lastCount > 0) { pageCount++; } if (index > pageCount || index <= 0) { return(Json(new { isOk = true, lineCount = 0, pageCount = 1, //总共是多少页 pageNowIndex = 1, //当前是第几页 })); } // ReSharper disable once CoVariantArrayConversion var list = _context.LogUserLogin .FromSql(builder.ToString(), parameters.ToArray()) .Where(p => p.LoginTime >= left && p.LoginTime <= right) .OrderByDescending(l => l.LoginTime) .Skip((index - 1) * pageSize) .Take(pageSize) .Select(log => new { id = log.LogUserLoginId, uid = log.ID, addTime = _logger.FormatDateLocal(log.LoginTime), ip = log.LoginIp, terminal = log.Terminal == Terminal.Pc?"电脑终端":(log.Terminal == Terminal.Phone? "手机终端":"平板终端") }) .ToList(); return(Json(new { isOk = true, lineCount = dataCount, PageCount = pageCount, //总共是多少页 pageNowIndex = index, //当前是第几页 items = list, size = pageSize })); } else { return(Json(new { isOk = false, error = _analysis.ModelStateDictionaryError(ModelState), title = "错误提示", message = "参数错误,传递了不符合规定的参数" })); } }