public ActionResult GetListJson(Pagination pagination, string queryJson) { string orgcode = OperatorProvider.Provider.Current().OrganizeCode; var watch = CommonHelper.TimerStart(); string cid = ""; var queryParam = queryJson.ToJObject(); pagination.p_kid = "Id"; pagination.p_fields = "createuserid,createdate,examinestatus,platenumber,GetData,outdate,drivername,drivertel,transporttype,producttype,dress,staytime,status,NVL(vnum,0) vnum"; pagination.p_tablename = " ( select Id,createuserid,createdate,examinestatus,platenumber,GetData,outdate,drivername,drivertel,transporttype,producttype,dress,staytime,status, vnum from WL_OPERTICKETMANAGER wl left join (select count(cid) vnum ,cid from BIS_CARVIOLATION group by cid ) cv on wl.id=cv.cid and wl.isdelete=1 ) v1"; pagination.conditionJson = " 1=1 "; Operator user = ERCHTMS.Code.OperatorProvider.Provider.Current(); //if (user.IsSystem) //{ pagination.conditionJson = "1=1"; //} var data = operticketmanagerbll.BackGetPageList(pagination, queryJson); var JsonData = new { rows = data, total = pagination.total, page = pagination.page, records = pagination.records, costtime = CommonHelper.TimerEnd(watch), }; return(Content(JsonData.ToJson())); }