public JsonResult GetScoreList()
{
var monthParam = Request["month"];
if (string.IsNullOrEmpty(monthParam) || !Regex.IsMatch(monthParam, "\\d{4}-\\d{2}"))
{
return(Json(ErrorModel.InputError));
}
var splits = monthParam.Split('-');
var year = splits[0].ToInt32();
var month = splits[1].ToInt32();
var json = JqueryDataTableAjaxHelper.GetPageListJson(
Request,
(pageIndex, pageSize) =>
{
var scoreBll = new ViewInstructorReviewScoreBll();
var condition = $"Year={year} AND Month={month}";
int totalCount;
var list = scoreBll.QueryPageList(pageIndex, pageSize, condition, null, false, out totalCount);
return(new KeyValuePair <int, object>(totalCount, list));
});
return(Json(json));
}
/// <summary>
/// 获取数据列表的公共方法（通过表名反映获取）
/// </summary>
/// <returns></returns>
public JsonResult GetList()
{
var instructorId = Request["instructorId"].ToInt32();
var month = Request["month"].ToDateTime();
var tableName = Request["target"];
if (string.IsNullOrEmpty(tableName))
{
return(Json(ErrorModel.InputError));
}
var json = JqueryDataTableAjaxHelper.GetPageListJson(
Request,
(pageIndex, pageSize) =>
{
var bllInstance = BllFactory.GetBllInstance(tableName);
if (bllInstance != null)
{
var type = bllInstance.GetType();
try
{
// build condition
var conditionList = new List <string>();
if (instructorId > 0)
{
conditionList.Add("InstructorId=" + instructorId);
}
if (month != default(DateTime))
{
var start = month.AddDays(-1);
var end = month.AddMonths(1);
conditionList.Add($"UploadTime>'{start}' AND UploadTime<'{end}'");
}
var condition = string.Join(" AND ", conditionList);
var orderField = Request["order"] ?? "UploadTime";
var arguments = new object[] { pageIndex, pageSize, condition, orderField, true, 0 };
var list = type.InvokeMember("QueryPageList", BindingFlags.InvokeMethod, null, bllInstance,
arguments);
return(new KeyValuePair <int, object>((int)arguments[5], list));
}
catch (Exception ex)
{
ExceptionLogBll.ExceptionPersistence("InstructorController.cs", "InstructorController", ex);
return(new KeyValuePair <int, object>());
}
}
return(new KeyValuePair <int, object>());
});
return(Json(json));
}
public JsonResult GetFiles()
{
var json = JqueryDataTableAjaxHelper.GetPageListJson(Request,
(pageIndex, pageSize) =>
{
var fileBll = new ViewExamFilesBll();
int totalCount;
var list = fileBll.QueryPageList(pageIndex, pageSize, "AddTime", true, out totalCount);
return(new KeyValuePair <int, object>(totalCount, list));
});
return(Json(json));
}
public JsonResult GetPersons()
{
var json = JqueryDataTableAjaxHelper.GetPageListJson(
Request,
(pageIndex, pageSize) =>
{
var viewBll = new ViewPersonInfoBll();
int totalCount;
var list = viewBll.QueryPageList(pageIndex, pageSize, "UpdateTime", true, out totalCount);
return(new KeyValuePair <int, object>(totalCount, list));
});
return(Json(json));
}
public JsonResult GetQuotaList()
{
var json = JqueryDataTableAjaxHelper.GetPageListJson(
Request,
(pageIndex, pageSize) =>
{
var quotaBll = new InstructorQuotaBll();
int totalCount;
var list = quotaBll.QueryPageList(pageIndex, pageSize, "IsDelete=0", null, false, out totalCount);
return(new KeyValuePair <int, object>(totalCount, list));
});
return(Json(json));
}
public JsonResult GetList()
{
var json = JqueryDataTableAjaxHelper.GetPageListJson(
Request,
(pageIndex, pageSize) =>
{
int totalCount;
var bll = new AnnouncementBll();
var list = bll.QueryPageList(pageIndex, pageSize, "PubTime", true, out totalCount);
return(new KeyValuePair <int, object>(totalCount, list));
}
);
return(Json(json));
}
public JsonResult GetTrainNos()
{
var json = JqueryDataTableAjaxHelper.GetPageListJson(
Request,
(pageIndex, pageSize) =>
{
var stationBll = new TrainNoBll();
int totalCount;
var data = stationBll.QueryPageList(pageIndex, pageSize, "UpdateTime",
true, out totalCount);
return(new KeyValuePair <int, object>(totalCount, data));
}
);
return(Json(json));
}
public JsonResult GetList()
{
var json = JqueryDataTableAjaxHelper.GetPageListJson(
Request,
(pageIndex, pageSize) =>
{
var recordBll = new ViewDriveRecordBll();
int totalCount;
var data = recordBll.QueryPageList(pageIndex, pageSize, "AttendTime",
true, out totalCount);
return(new KeyValuePair <int, object>(totalCount, data));
}
);
return(Json(json));
}
public JsonResult GetResults()
{
var json = JqueryDataTableAjaxHelper.GetPageListJson(
Request,
(pageIndex, pageSize) => {
var conditionList = new List <string>();
var notifyId = Request["notifyId"].ToInt32();
if (notifyId > 0)
{
conditionList.Add("ExamNotifyId=" + notifyId);
}
var departId = Request["departId"].ToInt32();
if (departId > 0)
{
conditionList.Add("DepartmentId=" + departId);
}
var passed = Request["passed"] ?? string.Empty;
if (!string.IsNullOrEmpty(passed))
{
conditionList.Add(string.Format("Passed='{0}'", passed));
}
int totalCount;
var condition = string.Join(" AND ", conditionList);
var resultBll = new ViewExamRecordsBll();
var list = resultBll.QueryPageList(pageIndex, pageSize, condition, "NotifyAddTime", true, out totalCount);
return(new KeyValuePair <int, object>(totalCount, list));
}
);
return(Json(json));
}