/// <summary>
/// 分页查询正式习题信息列表
/// </summary>
/// <param name="searchParam"></param>
/// <param name="para"></param>
/// <returns></returns>
public JsonResult GetCheckedExerciseListBySearch(Business_Exercises_Infomation_Search searchParam, GridParams para)
{
if (para.sortdatafield == null)
{
para.sortdatafield = "CreatedDate";
para.sortorder = "desc";
}
para.pagenum = para.pagenum + 1;
var model = _checkedLogic.GetCheckedExerciseListBySearch(searchParam, para);
return(Json(model, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 分页查询习题信息列表
/// </summary>
/// <param name="searchParam"></param>
/// <param name="para"></param>
/// <returns></returns>
public JsonResultModel <v_Business_ExercisesLibrary_Infomation> GetCheckedExerciseListBySearch(Business_Exercises_Infomation_Search searchParam, GridParams para)
{
return(_checkedExerciseLibraryServer.GetCheckedExerciseListBySearch(searchParam, para));
}
/// <summary>
/// 分页查询习题信息列表
/// </summary>
/// <param name="searchParam"></param>
/// <param name="para"></param>
/// <returns></returns>
public JsonResultModel <V_Business_Exercises_Infomation> GetExerciseListBySearch(Business_Exercises_Infomation_Search searchParam, GridParams para)
{
return(_cs.GetExerciseListBySearch(searchParam, para));
}
/// <summary>
/// 分页查询习题信息列表
/// </summary>
/// <param name="searchParam"></param>
/// <param name="para"></param>
/// <returns></returns>
public JsonResultModel <V_Business_Exercises_Infomation> GetExerciseListBySearch(Business_Exercises_Infomation_Search searchParam, GridParams para)
{
using (SqlSugarClient _dbMsSql = SugarDao.SugarDao_MsSql.GetInstance())
{
JsonResultModel <V_Business_Exercises_Infomation> jsonResult = new JsonResultModel <V_Business_Exercises_Infomation>();
var query = _dbMsSql.Queryable <V_Business_Exercises_Infomation>().Where(i => i.Status == 1);
if (!string.IsNullOrEmpty(searchParam.ExercisesName))
{
query.Where(i => i.ExercisesName.Contains(searchParam.ExercisesName));
}
//if (!string.IsNullOrEmpty(searchParam.Status))
//{
// int status = int.Parse(searchParam.Status);
// query.Where(i => i.Status == status);
//}
if (!string.IsNullOrEmpty(searchParam.InputType))
{
int inputType = int.Parse(searchParam.InputType);
query.Where(i => i.InputType == inputType);
}
if (!string.IsNullOrEmpty(searchParam.EffectiveDate))
{
DateTime effectiveDate = DateTime.Parse(searchParam.EffectiveDate);
query.Where(i => i.EffectiveDate < effectiveDate);
}
query.OrderBy(para.sortdatafield + " " + para.sortorder);
jsonResult.TotalRows = query.Count();
jsonResult.Rows = query.ToPageList(para.pagenum, para.pagesize);
//存入操作日志表
string logData = JsonHelper.ModelToJson <JsonResultModel <V_Business_Exercises_Infomation> >(jsonResult);
_ll.SaveLog(3, 7, Common.CurrentUser.GetCurrentUser().LoginName, "习题列表", logData);
return(jsonResult);
}
}
public JsonResultModel <v_Business_ExercisesLibrary_Infomation> GetCheckedExerciseListBySearch(Business_Exercises_Infomation_Search searchParam, GridParams para)
{
using (SqlSugarClient db = SugarDao_MsSql.GetInstance())
{
JsonResultModel <v_Business_ExercisesLibrary_Infomation> jsonResult = new JsonResultModel <v_Business_ExercisesLibrary_Infomation>();
var query = db.Queryable <v_Business_ExercisesLibrary_Infomation>().Where(i => i.Status == 2);
if (!string.IsNullOrEmpty(searchParam.ExerciseName))
{
query.Where(i => i.ExerciseName.Contains(searchParam.ExerciseName));
}
if (!string.IsNullOrEmpty(searchParam.InputType))
{
int inputType = int.Parse(searchParam.InputType);
query.Where(i => i.InputType == inputType);
}
if (!string.IsNullOrEmpty(searchParam.ExerciseType))
{
int exerciseType = int.Parse(searchParam.ExerciseType);
query.Where(i => i.ExerciseType == exerciseType);
}
if (!string.IsNullOrEmpty(searchParam.CreatedTimeStart) && !string.IsNullOrEmpty(searchParam.CreatedTimeEnd))
{
DateTime createdTimeStart = DateTime.Parse(searchParam.CreatedTimeStart);
DateTime createdTimeEnd = DateTime.Parse(searchParam.CreatedTimeEnd);
query.Where(i => i.CreatedDate > createdTimeStart && i.CreatedDate < createdTimeEnd);
}
else
{
if (!string.IsNullOrEmpty(searchParam.CreatedTimeStart))
{
DateTime createdTimeStart = DateTime.Parse(searchParam.CreatedTimeStart);
query.Where(i => i.CreatedDate > createdTimeStart);
}
if (!string.IsNullOrEmpty(searchParam.CreatedTimeEnd))
{
DateTime createdTimeEnd = DateTime.Parse(searchParam.CreatedTimeEnd);
query.Where(i => i.CreatedDate < createdTimeEnd);
}
}
query.OrderBy(para.sortdatafield + " " + para.sortorder);
var pageCount = 0;
jsonResult.Rows = query.ToPageList(para.pagenum, para.pagesize, ref pageCount);
jsonResult.TotalRows = pageCount;
//存入操作日志表
string logData = JsonHelper.ModelToJson(jsonResult);
_LogLogic.SaveLog(3, 39, CurrentUser.GetCurrentUser().LoginName, "正式习题列表", logData);
return(jsonResult);
}
}
/// <summary>
/// 分页查询已审核习题信息列表
/// </summary>
/// <param name="searchParam"></param>
/// <param name="para"></param>
/// <returns></returns>
public JsonResultModel <V_Business_Exercises_Infomation> GetExerciseListBySearch(Business_Exercises_Infomation_Search searchParam, GridParams para)
{
using (SqlSugarClient _dbMsSql = SugarDao.SugarDao_MsSql.GetInstance())
{
JsonResultModel <V_Business_Exercises_Infomation> jsonResult = new JsonResultModel <V_Business_Exercises_Infomation>();
//只查询三个月内的数据
// DateTime endDate = DateTime.Now.AddMonths(-3);
var query = _dbMsSql.Queryable <V_Business_Exercises_Infomation>().Where(i => i.Status == 2);
if (!string.IsNullOrEmpty(searchParam.ExercisesName))
{
query.Where(i => i.ExercisesName.Contains(searchParam.ExercisesName));
}
if (!string.IsNullOrEmpty(searchParam.InputType))
{
int inputType = int.Parse(searchParam.InputType);
query.Where(i => i.InputType == inputType);
}
if (!string.IsNullOrEmpty(searchParam.EffectiveDate))
{
DateTime effectiveDate = DateTime.Parse(searchParam.EffectiveDate);
query.Where(i => i.EffectiveDate < effectiveDate);
}
//if (string.IsNullOrEmpty(searchParam.CreatedTimeStart) && string.IsNullOrEmpty(searchParam.CreatedTimeEnd))
//{
// query.Where(i => i.CreatedDate > endDate);
//}
if (!string.IsNullOrEmpty(searchParam.CreatedTimeStart) && !string.IsNullOrEmpty(searchParam.CreatedTimeEnd))
{
DateTime createdTimeStart = DateTime.Parse(searchParam.CreatedTimeStart);
DateTime createdTimeEnd = DateTime.Parse(searchParam.CreatedTimeEnd);
query.Where(i => i.CreatedDate > createdTimeStart && i.CreatedDate < createdTimeEnd); // && i.CreatedDate > endDate
}
else
{
if (!string.IsNullOrEmpty(searchParam.CreatedTimeStart))
{
DateTime createdTimeStart = DateTime.Parse(searchParam.CreatedTimeStart);
query.Where(i => i.CreatedDate > createdTimeStart); //&& i.CreatedDate > endDate
}
if (!string.IsNullOrEmpty(searchParam.CreatedTimeEnd))
{
DateTime createdTimeEnd = DateTime.Parse(searchParam.CreatedTimeEnd);
query.Where(i => i.CreatedDate < createdTimeEnd); //&& i.CreatedDate > endDate
}
}
query.OrderBy(para.sortdatafield + " " + para.sortorder);
jsonResult.TotalRows = query.Count();
jsonResult.Rows = query.ToPageList(para.pagenum, para.pagesize);
//存入操作日志表
string logData = JsonHelper.ModelToJson <JsonResultModel <V_Business_Exercises_Infomation> >(jsonResult);
_ll.SaveLog(3, 11, Common.CurrentUser.GetCurrentUser().LoginName, "已审核习题列表", logData);
return(jsonResult);
}
}
