| | |
| | | sql.Append(" and exists ( select b.[ProjectId] from [Projectzhongbiao] b where a.[Id]=b.[ProjectId] and (b.[defen]-a.[drhx_defen]) <= " + aaaa + " ) "); |
| | | } |
| | | } |
| | | if (!string.IsNullOrWhiteSpace(searchEntity.Baojiachaxiaoyu)) |
| | | { |
| | | decimal aaaa = 0; |
| | | decimal.TryParse(searchEntity.Baojiachaxiaoyu, out aaaa); |
| | | if (aaaa > 0) |
| | | { |
| | | sql.Append(" and exists ( select b.[ProjectId] from [Projectzhongbiao] b where a.[Id]=b.[ProjectId] and (convert(numeric(10,2),b.[price] )-convert(numeric(10,2),a.[drhx_price] )) <= " + aaaa + " ) "); |
| | | } |
| | | } |
| | | |
| | | |
| | | if (!string.IsNullOrWhiteSpace(searchEntity.Fenchadayu)) |
| | | { |