public object Get() { var sbCondition = new System.Text.StringBuilder(); sbCondition.AppendFormat("({0}) AND ", string.Format("{0}{1}{2}", "a.CompCode= '", (System.Web.HttpContext.Current.Session["sys_user"] as sys_user).CompCode, "'")); SerachCondition.TextBox(sbCondition, "StepCode", "a.StepCode", "varchar"); SerachCondition.CheckBox(sbCondition, "StepStatus", "a.StepStatus", "varchar"); if (sbCondition.Length > 4) { sbCondition.Length -= 4; } var pageReq = new PageRequest(); using (var db = new LUOLAI1401Context()) { return(pageReq.ToPageList <wq_patrolStepListModel>(db.Database, "a.id ,a.StepCode ,a.StepStatus ", "wq_patrolStep a ", sbCondition.ToString(), "id", "desc")); } }