| | |
|---|
| | | |
|---|
| | | return sysCodeDtls; |
|---|
| | | } |
|---|
| | | public List<SysCodeDtl> GetSYScodeshanchu(string code_table, string code_field) |
|---|
| | | { |
|---|
| | | |
|---|
| | | |
|---|
| | | List<SysCodeDtl> sysCodeDtls = (from e in _context.SysCodes |
|---|
| | | join c in _context.SysCodeDtls |
|---|
| | | on e.Id equals c.CodeId |
|---|
| | | where e.RecStatus == "A" |
|---|
| | | && c.RecStatus == "D" |
|---|
| | | && e.CodeTable == code_table |
|---|
| | | && e.CodeField == code_field |
|---|
| | | select c).OrderBy(x => x.Sort).ToList(); |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | return sysCodeDtls; |
|---|
| | | } |
|---|
| | | |
|---|
| | | public ResultDataEntity<LiaotianDTO> SearchByPaging(LiaotianDTOSearch searchEntity) |
|---|
| | | { |
|---|
| | | ResultDataEntity<LiaotianDTO> data = new ResultDataEntity<LiaotianDTO>(); |
|---|
| | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | if (searchEntity.totalrows == 0) |
|---|
| | | //if (searchEntity.totalrows == 0) |
|---|
| | | searchEntity.totalrows = query.Count(); |
|---|
| | | var lianlist = query.Skip((searchEntity.page - 1) * searchEntity.rows).Take(searchEntity.rows).ToList(); |
|---|
| | | //list = _mapper.Map<List<LiaotianDTO>>(lianlist); |
|---|
