【Zeyphr】分页查询与修改

分页查询：

return this.GetDynamicListWithPaging(ParamQuery.Instance()
                   .From("P_Resume")
                   .AndWhere("AuditState", query["AuditState"])
                   .Paging(Convert.ToInt32(query["page"]), Convert.ToInt32(query["rows"])).OrderBy("PRID"));

修改：

var p_resume = new P_ResumeService();

return p_resume.Update(ParamUpdate.Instance()
                                   .Update("P_Resume")
                                   .Column("State", "8")
                                   .AndWhere("PRID", PRID));

前提是 model继承自 ServiceBase

 

 

//每一种操作数据库都有两种方式

   1、①RequestWrapper query = new RequestWrapper.InstanceFromRequest();

        ②query.LoadSettingXmlString(@" 
                <settings defaultOrderBy='PRID'>
                <select>
                   *
               </select>
                   <from>P_Resume</from>
                   <where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' >
                      <field name='Username'   cp='like'></field>
                   </where>
               </settings>");

   2、ParamInsert，ParamDelete，ParamUpdate，ParamQuery

 

转载于:https://www.cnblogs.com/oiliu/p/4692433.html