VS SQL关键字查询出对应的题目

根据关键字查询出对应的信息是一种很常用的方法。在我们忘记据体信息的时候，只记得期中的一些信息，然而我们就可以根据这信息把数据查询出来
先把数据从数据库里查询出来，题目类型表的题目类型ID、知识点ID、使用单位ID和（stem）题目信息查询

//要先把表查询连接起来
        public ActionResult SelectTitles(LayuiTablePage layuiTablePage, int TitleTypeID, int PointID, int UnitID, string stem)
        {
            var listTitles = (from tbTitle in myModel.PW_Title
                              join tbTitleType in myModel.SYS_TitleType on tbTitle.TitleTypeID equals tbTitleType.TitleTypeID
                              join tbDofd in myModel.SYS_Dofd on tbTitle.DofdID equals tbDofd.DofdID
                              join tbSubject in myModel.SYS_Subject on tbTitle.SubjectID equals tbSubject.SubjectID
                              join tbPoint in myModel.SYS_Point on tbTitle.PointID equals tbPoint.PointID
                              join tbUnit in myModel.SYS_Unit on tbTitle.UnitID equals tbUnit.UnitID
                              select new TitlesInfor
//之后数据查询出来
       {
           TitleID = tbTitle.TitleID,//题目ID
           TitleType = tbTitleType.TitleType,//题目类型
           Dofd = tbDofd.Dofd,//难度
           Subject = tbSubject.Subject,//科目
           Point = tbPoint.PointName,//知识点
           Unit = tbUnit.Unit,//使用单位
           Stem = tbTitle.Stem,//题目信息
           RightKey = tbTitle.RightKey,//正确答案
           Remarks = tbTitle.Remarks,//备注
           ToVoidNo = tbTitle.ToVoidNo,//是否作废
           TitleTypeID = tbTitle.TitleTypeID,//题目类型ID
           PointID = tbTitle.PointID,//知识点ID
            UnitID = tbTitle.UnitID//使用单位ID
         }).ToList();
//判断数据
     if (TitleTypeID > 0)
     { listTitles = listTitles.Where(m => m.TitleTypeID == TitleTypeID).ToList();}
     if (PointID > 0)
     { listTitles = listTitles.Where(m => m.PointID == PointID).ToList();}
     if (UnitID > 0)
     { listTitles = listTitles.Where(m => m.UnitID == UnitID).ToList();}
     if (!string.IsNullOrEmpty(stem))
     { listTitles = listTitles.Where(m => m.Stem.Contains(stem)).ToList();}
//获取查询出来的数据，数据重载
    int totals = listTitles.Count();
    List<TitlesInfor> listTitlesInfor = listTitles.OrderByDescending(m => m.ToVoidNo == false)
        .Skip(layuiTablePage.GetStartIndex()).Take(layuiTablePage.limit).ToList();
    LayuiTableData<TitlesInfor> layuiTableData = new LayuiTableData<TitlesInfor>()
    {
        count = totals,
        data = listTitlesInfor
    };
        return Json(layuiTableData, JsonRequestBehavior.AllowGet);
    }

//在视图上绑定查询出来的信息
   function tabTitleInforSearch() {
        var stem = $("#txtSearch").val();
        if (stem == null || undefined) {
              stem == "";
        }
        abTitles = layuiTable.reload("tabTitles", {
             url: "/TitleBaseInfor/SelectTitles",
             where: {
                  TitleTypeID: 0,
                  PointID: 0,
                  UnitID: 0,
                  stem: stem.trim()
             }
         });
    }

作者：吴炳耀