/// <summary>
/// 分页查询问卷信息列表
/// </summary>
/// <param name="searchParam"></param>
/// <param name="para"></param>
/// <returns></returns>
public JsonResultModel <V_Business_Questionnaire> GetQuestionListBySearch(Business_Questionnaire_Search searchParam, GridParams para)
{
using (SqlSugarClient _dbMsSql = SugarDao.SugarDao_MsSql.GetInstance())
{
JsonResultModel <V_Business_Questionnaire> jsonResult = new JsonResultModel <V_Business_Questionnaire>();
var query = _dbMsSql.Queryable <V_Business_Questionnaire>().Where(i => i.Status == "1");
if (!string.IsNullOrEmpty(searchParam.QuestionName))
{
query.Where(i => i.QuestionnaireName.Contains(searchParam.QuestionName));
}
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_Questionnaire> >(jsonResult);
_ll.SaveLog(3, 52, Common.CurrentUser.GetCurrentUser().LoginName, "问卷列表", logData);
return(jsonResult);
}
}
/// <summary>
/// 分页查询问卷信息列表
/// </summary>
/// <param name="searchParam"></param>
/// <param name="para"></param>
/// <returns></returns>
public JsonResult GetQuestionListBySearch(Business_Questionnaire_Search searchParam, GridParams para)
{
if (para.sortdatafield == null)
{
para.sortdatafield = "CreatedDate";
para.sortorder = "desc";
}
para.pagenum = para.pagenum + 1;
var model = _el.GetQuestionListBySearch(searchParam, para);
return(Json(model, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 分页查询问卷信息列表
/// </summary>
/// <param name="searchParam"></param>
/// <param name="para"></param>
/// <returns></returns>
public JsonResultModel <V_Business_Questionnaire> GetQuestionListBySearch(Business_Questionnaire_Search searchParam, GridParams para)
{
return(_cs.GetQuestionListBySearch(searchParam, para));
}
