public object Any(PalletRequest request) { DTOResponseLayUI dtoResponseLayUi = new DTOResponseLayUI(); PalletService service = new PalletService(); DTOResponse response = new DTOResponse(); if (request.ACTION == OPAction.QUERY) { response = service.GetList(request); } else if (request.ACTION == OPAction.QUERYDETAIL1) { response = service.GetDetailList(request); } else if (request.ACTION == OPAction.STAT1) { response = service.GetPalletList(request); } else { dtoResponseLayUi.code = -1; dtoResponseLayUi.msg = "未定义的操作类型:" + request.ACTION.ToString(); return(dtoResponseLayUi); } return(this.ConvertTo(response)); }
public DTOResponse GetList(PalletRequest request) { DTOResponse dtoResponse = new DTOResponse(); try { using (IDbConnection dbConn = HelperConnection.GetConnectionFactory().OpenDbConnection()) { SqlExpression <PalletEntity> expression = dbConn.From <PalletEntity>(); if (!string.IsNullOrEmpty(request.STOCKNO)) { expression.And(x => x.STOCKNO == request.STOCKNO); } if (!string.IsNullOrEmpty(request.GROUPNO)) { expression.And(x => x.GROUPNO == request.GROUPNO); } if (!string.IsNullOrEmpty(request.LOCATIONNO)) { expression.And(x => x.LOCATIONNO == request.LOCATIONNO); } if (!string.IsNullOrEmpty(request.PALLETNO)) { expression.And(x => x.PALLETNO == request.PALLETNO); } if (!string.IsNullOrEmpty(request.STATE)) { expression.And(x => x.STATE == int.Parse(request.STATE)); } if (!string.IsNullOrEmpty(request.PLANNO)) { expression.And(x => x.PLANNO == request.PLANNO); } long count = dbConn.Count <PalletEntity>(expression); List <PalletEntity> entityList = dbConn.Select <PalletEntity>(expression) .OrderBy(x => x.ID) .Skip((request.page - 1) * request.limit) .Take(request.limit) .ToList(); dtoResponse.TotalCount = count; dtoResponse.ResultObject = (object)entityList; dtoResponse.IsSuccess = true; dtoResponse.MessageText = "查询操作成功!"; return(dtoResponse); } } catch (Exception ex) { dtoResponse.IsSuccess = false; dtoResponse.MessageText = ex.Message; logger.Error((object)ex); return(dtoResponse); } }
public DTOResponse GetDetailList(PalletRequest request) { DTOResponse dtoResponse = new DTOResponse(); try { using (IDbConnection dbConn = HelperConnection.GetConnectionFactory().OpenDbConnection()) { SqlExpression <PalletDetailEntity> expression = dbConn.From <PalletDetailEntity>(); if (request.PALLETID > -1) { expression.And(x => x.PALLETID == request.PALLETID); } long count = dbConn.Count <PalletDetailEntity>(expression); List <PalletDetailEntity> entityList = dbConn.Select <PalletDetailEntity>(expression) .OrderBy(x => x.ID) .Skip((request.page - 1) * request.limit) .Take(request.limit) .ToList(); dtoResponse.TotalCount = count; dtoResponse.ResultObject = (object)entityList; dtoResponse.IsSuccess = true; dtoResponse.MessageText = "查询操作成功!"; return(dtoResponse); } } catch (Exception ex) { dtoResponse.IsSuccess = false; dtoResponse.MessageText = ex.Message; logger.Error((object)ex); return(dtoResponse); } }
public DTOResponse GetPalletList(PalletRequest request) { //主从表,获取 DTOResponse dtoResponse = new DTOResponse(); try { using (IDbConnection dbConn = HelperConnection.GetConnectionFactory().OpenDbConnection()) { var expression = dbConn.From <PalletEntity>() .Join <PalletEntity, PalletDetailEntity>((x, y) => x.ID == y.PALLETID); if (!string.IsNullOrEmpty(request.STOCKNO)) { expression.And(x => x.STOCKNO == request.STOCKNO); } if (!string.IsNullOrEmpty(request.GROUPNO)) { expression.And(x => x.GROUPNO == request.GROUPNO); } if (!string.IsNullOrEmpty(request.LOCATIONNO)) { expression.And(x => x.LOCATIONNO == request.LOCATIONNO); } if (!string.IsNullOrEmpty(request.PALLETNO)) { expression.And(x => x.PALLETNO == request.PALLETNO); } if (!string.IsNullOrEmpty(request.STATE)) { expression.And(x => x.STATE == int.Parse(request.STATE)); } if (!string.IsNullOrEmpty(request.PLANNO)) { expression.And(x => x.PLANNO == request.PLANNO); } expression.Select("WM_PALLET.*,WM_PALLET_DETAIL.*"); long count = dbConn.Count <PalletEntity>(expression); List <dynamic> dynamics = dbConn.Select <dynamic>(expression) .OrderByDescending(x => x.ID) .Skip((request.page - 1) * request.limit) .Take(request.limit) .ToList(); foreach (var item in dynamics) { item.CREATEDATETIME = item.CREATEDATE.ToString("yyyy-MM-dd HH:mm:ss"); } dtoResponse.ResultObject = dynamics; dtoResponse.IsSuccess = true; dtoResponse.MessageText = "查询操作成功!"; return(dtoResponse); } } catch (Exception ex) { dtoResponse.IsSuccess = false; dtoResponse.MessageText = ex.Message; logger.Error((object)ex); return(dtoResponse); } }