Esempio n. 1
0
        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()));
        }