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 = "参数错误,传递了不符合规定的参数"
}));
}
}