我怎样才能选择一张唱片而不是另一张
本文关键字:一张 唱片 选择 | 更新日期: 2023-09-27 18:26:25
我有一个列表,其中有一些重复项。
Row# Lineid ItemDescItemId RoadTax VehicleId Amount
1 122317 None -1 26.63 -78603 300
2 122317 None -2 17.75 -78603 200
3 122317 None -1 22.19 -78602 250
4 122317 Deli -2 17.75 -78603 200
在这种情况下,行2是行4的副本,因为LineId、RoadTaxy、Amount和VehicleId匹配。但是,我想保留带有项目描述的行,并删除第2行。所以我的输出列表如下:
Row# Lineid ItemDesc ItemId RoadTax VehicleId Amount
1 122317 None -1 26.63 -78603 300
3 122317 None -1 22.19 -78602 250
4 122317 Deli -2 17.75 -78603 200
我根据MSDN上的一个例子编写了一个IEqualityComparer类。类看起来是这样的:
public class RoadTaxComparer : IEqualityComparer<RoadTaxDto>
{
// Items are equal if ItemId / VehicleId / RoadTax are equal.
public bool Equals(RoadTaxDto x, RoadTaxDto y)
{
//Check whether the compared objects reference the same data.
if (Object.ReferenceEquals(x, y)) return true;
//Check whether any of the compared objects is null.
if (Object.ReferenceEquals(x, null) || Object.ReferenceEquals(y, null))
return false;
//Check whether the products' properties are equal.
return x.VehicleId == y.VehicleId && x.ItemId == y.ItemId && x.RoadTax == y.RoadTax && x.Amount == y.Amount;
}
// If Equals() returns true for a pair of objects
// then GetHashCode() must return the same value for these objects.
public int GetHashCode(RoadTaxDto roadTaxDto)
{
//Check whether the object is null
if (Object.ReferenceEquals(roadTaxDto, null)) return 0;
//Get hash code for the VehicleId.
int hashVehicleId = roadTaxDto.VehicleId.GetHashCode();
//Get hash code for the ItemId field.
int hashCodeItemId = roadTaxDto.ItemId.GetHashCode();
//Calculate the hash code for the QuoteTaxDto.
return hashVehicleId ^ hashCodeItemId;
}
}
RoadTaxDto结构如下:
class RoadTaxDto
{
public int LineId {get;set}
public string ItemDesc {get;set;}
public int VehicleId {get;set;}
public decimal RoadTax {get;set;}
public int VehicleId {get;set;}
public decimal Amount {get;set;}
}
我使用以下命令来消除重复。
List<RoadTaxDto> mergedList = RoadTaxes.Union(RoadTaxes, new RoadTaxComparer()).ToList();
当我在上面运行比较器时,我不能保证第2行被消除。那么,我如何确保如果一个记录有重复项,那么写着"无"的记录总是会从列表中删除呢。
我会将GetHashCode()移动到RoadTaxDto,然后执行以下操作:
foreach (var g in list.GroupBy(i => i.GetHashCode()))
list2.Add(
g.FirstOrDefault(i => i.ItemDesc != "None") ??
g.First());
纯"SQLish"方法对您不起作用?
类似这样的东西:
var list = new [] {
new RoadTaxDto {LineId=122317,ItemDesc="None", ItemId=-1,RoadTax =26.63M , VehicleId=-78603 ,Amount=300},
new RoadTaxDto {LineId=122317,ItemDesc="None", ItemId=-2,RoadTax =17.75M , VehicleId=-78603 ,Amount=200},
new RoadTaxDto {LineId=122317,ItemDesc="None", ItemId=-1,RoadTax =22.19M , VehicleId=-78602 ,Amount=250},
new RoadTaxDto {LineId=122317,ItemDesc="Deli", ItemId=-2,RoadTax =17.75M , VehicleId=-78603 ,Amount=200}
};
var query = (from c in list join x in list
on new { c.LineId, c.ItemId , c.VehicleId, c.Amount,c.RoadTax}
equals new {x.LineId, x.ItemId, x.VehicleId,x.Amount,x.RoadTax}
select new RoadTaxDto {
LineId = c.LineId,
ItemDesc = x.ItemDesc!="None"? x.ItemDesc:c.ItemDesc,
VehicleId=c.VehicleId,
Amount=c.Amount,
RoadTax=c.RoadTax,
ItemId=c.ItemId
}
).GroupBy(x => new { x.LineId, x.RoadTax, x.Amount, x.VehicleId} )
.Select(grp => grp.Last());
打印:
LineId ItemDesc VehicleId ItemId RoadTax Amount
122317 None -78603 -1 26.63 300
122317 Deli -78603 -2 17.75 200
122317 None -78602 -1 22.19 250