linq to sql 查询后排序（字符串类型的数字进行排序）

最新推荐文章于 2024-08-09 22:14:30 发布

saxgood

最新推荐文章于 2024-08-09 22:14:30 发布

阅读量1.9k

点赞数

本文链接：https://blog.csdn.net/saxgood/article/details/43668739

版权

#region 根据工作面ID和生命状态标志查询围岩移动传感器
/// <summary>
/// 根据工作面ID和生命状态标志查询围岩移动传感器
/// </summary>
/// <param name="WorkingFaceID"></param>
/// <param name="Livestate"></param>
/// <returns></returns>
public List<SeparationSensor> GetSeparationSensorByWorkingFaceID_Livestate(int WorkingFaceID, decimal Livestate)
{

List<SeparationSensor> list = new List<SeparationSensor>();
List<SeparationSensor> list1 = new List<SeparationSensor>();
list = db.Sensors.OfType<SeparationSensor>().Include("ChannelProperties").Where(p => p.Livestate == Livestate && p.WorkingFaceID == WorkingFaceID && p.SensorType == 2).ToList();
list1=list.OrderByDescending(p => Convert.ToInt32(p.SensorNo)).ToList();
return list1;

}
#endregion

#region 根据工作面ID和生命状态标志查询超前应力传感器
/// <summary>
/// 根据工作面ID和生命状态标志查询超前应力传感器
/// </summary>
/// <param name="WorkingFaceID"></param>
/// <param name="Livestate"></param>
/// <returns></returns>
public List<AdvanceStressSensor> GetAdvanceStressSensorByWorkingFaceID_Livestate(int WorkingFaceID, decimal Livestate)
{

List<AdvanceStressSensor> list = new List<AdvanceStressSensor>();
list = db.Sensors.OfType<AdvanceStressSensor>().Include("ChannelProperties").Where(p => p.Livestate == Livestate && p.WorkingFaceID == WorkingFaceID && p.SensorType == 5).ToList();
list.OrderByDescending(p => Convert.ToInt32(p.SensorNo));
return list;

}

#endregion

第二个方法不能实现排序，第一个方法才行