Exemple #1
0
        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"));
            }
        }