/// <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)); }