public PageResult DVT_searchFilter(int pageNumber, int pageSize, string dvtCode, string dvtName, string record_status = "1")
        {
            var result = procedureHelper.GetData <dynamic>("DVT_searchFilter", new
            {
                PageNumber    = pageNumber,
                PageSize      = pageSize,
                DVT_CODE      = dvtCode,
                DVT_NAME      = dvtName,
                RECORD_STATUS = record_status
            });
            var total_record = procedureHelper.GetData <int>("DVT_GetCountSearchFilter", new
            {
                DVT_CODE = dvtCode,
                DVT_NAME = dvtName,
            }).FirstOrDefault();

            return(PageResult.CreateSuccess(result, total_record));
        }
示例#2
0
        //[AbpAuthorize(Group6PermissionsConst.Pages_Administration_TrangThaiYeuCauSuaChua_SearchFilter)]
        public PageResult TTYCSC_SearchFilter(int pageNumber, int pageSize, string TTYCSCName, string TTYCSCCode, string TTYCSCDesc, string APPROVEStatus)
        {
            var result = procedureHelper.GetData <dynamic>("TTYCSC_SearchFilter", new
            {
                PageNumber     = pageNumber,
                PageSize       = pageSize,
                TTYCSC_NAME    = TTYCSCName,
                TTYCSC_CODE    = TTYCSCCode,
                TTYCSC_DESC    = TTYCSCDesc,
                APPROVE_STATUS = APPROVEStatus
            });
            var total_record = procedureHelper.GetData <int>("TTYCSC_GetCount", new
            {
                TTYCSC_NAME    = TTYCSCName,
                TTYCSC_CODE    = TTYCSCCode,
                TTYCSC_DESC    = TTYCSCDesc,
                APPROVE_STATUS = APPROVEStatus
            }).FirstOrDefault();

            return(PageResult.CreateSuccess(result, total_record));
        }
        public PageResult DUT_SearchFilter(int pageNumber, int pageSize, string dutName, string dutCode, string dutDesc, string record_status, string sort)
        {
            var result = procedureHelper.GetData <dynamic>("DUT_SearchFilter", new
            {
                PageNumber    = pageNumber,
                PageSize      = pageSize,
                DUT_NAME      = dutName,
                DUT_CODE      = dutCode,
                DUT_DESC      = dutDesc,
                RECORD_STATUS = record_status,
                SORT          = sort
            });
            var total_record = procedureHelper.GetData <int>("DUT_GetCount", new
            {
                DUT_NAME      = dutName,
                DUT_CODE      = dutCode,
                DUT_DESC      = dutDesc,
                RECORD_STATUS = record_status
            }).FirstOrDefault();

            return(PageResult.CreateSuccess(result, total_record));
        }