Esempio n. 1
0
        /// <summary>
        /// 问题查询
        /// </summary>
        /// <param name="filter">id</param>
        /// <returns></returns>
        public static QueryResult <QusetionView> SearchQuestionPageLists(QusetionFilter filter)
        {
            var cmd = new DataCommand("MockTest.SearchQuestionPageList");

            SetCondition(cmd, filter);
            return(cmd.Query <QusetionView>(filter, "d.NAME ,q.order_num ", null, true));
        }
Esempio n. 2
0
 /// <summary>
 /// 设置条件
 /// </summary>
 /// <param name="command"></param>
 /// <param name="filter"></param>
 private static void SetCondition(DataCommand command, QusetionFilter filter)
 {
     if (filter.mode.HasValue)
     {
         command.QuerySetCondition("q.mode", ConditionOperation.Equal, DbType.Int32, filter.mode.Value);
     }
     if (!string.IsNullOrEmpty(filter.document_name))
     {
         command.QuerySetCondition("d.name", ConditionOperation.Like, DbType.String, filter.document_name);
     }
     if (!string.IsNullOrEmpty(filter.content))
     {
         command.QuerySetCondition("q.content", ConditionOperation.Like, DbType.String, filter.content);
     }
     if (filter.usertag.HasValue)
     {
         command.QuerySetCondition("q.user_tag", ConditionOperation.Equal, DbType.Int32, filter.usertag);
     }
     command.CommandText = command.CommandText.Replace("#STRWHERE#", command.QueryConditionString);
 }
Esempio n. 3
0
        public ActionResult QuestionQuery()
        {
            QusetionFilter filter = BuildQueryFilterEntity <QusetionFilter>();

            return(AjaxGridJson(MockTestBasisService.SearchQuestionPageLists(filter)));
        }
 /// <summary>
 /// 查询问题列表
 /// </summary>
 /// <param name="filter"></param>
 /// <returns></returns>
 public QueryResult <QusetionView> SearchQuestionPageLists(QusetionFilter filter)
 {
     return(MockTestDA.SearchQuestionPageLists(filter));
 }