包含数字和字母的排序字段

Question

我有一个numbers和number-letter列表，number-letter和letter-number.The类型的列是string .My数据如下所示：

1
14
3
S-34
2
36-1/E
26
S-14
20
S-2
19
36-1
30
35
S-1
34

但我想这样分类：

1
2
3
14
20
25
30
35
36-1
36-1/E
S-1
S-2
S-14
S-34

但是我的代码对数据进行了如下排序：

1
14
19
2
20
25
3
30
35
36-1
36-1/E
S-1
S-14
S-2
S-34

我的代码是：

List<ViewTestPackageHistorySheet> lstTestPackageHistorySheets = _reportTestPackageHistorySheetRepository.ShowReport(Id).OrderBy(i => i.JointNumber).ToList();

我更改了下面的代码，但失败了。

List<ViewTestPackageHistorySheet> lstTestPackageHistorySheets = _reportTestPackageHistorySheetRepository.ShowReport(Id).OrderBy(i => Convert.ToInt32(i.JointNumber)).ToList();

错误是：

LINQ to Entities does not recognize the method 'Int32 ToInt32(System.String)' method, and this method cannot be translated into a store expression.

Answer 1

使用下面的字母数字排序器，它在内部使用PInvoke

public class AlphaNumericSorter : IComparer<string>
{
    public int Compare(string x, string y)
    {
        return SafeNativeMethods.StrCmpLogicalW(x, y);
    }
}

[SuppressUnmanagedCodeSecurity]
internal static class SafeNativeMethods
{
    [DllImport("shlwapi.dll", CharSet = CharSet.Unicode)]
    public static extern int StrCmpLogicalW(string psz1, string psz2);
}

用法：

List<string> testList = // Your input list;

testList.Sort(new AlphaNumericSorter());

现在，testList按照问题中的预期包含排序的数据。

Answer 2

创建一个自定义Comparer<string>并实现您想要的逻辑(当然，对于大列表来说它效率很低，您应该对其进行调优)：

 var data = list.OrderBy(x => x, new SpecialComparer());

SpecialComparer

   public class SpecialComparer : IComparer<string>
        {
            public int Compare(string x, string y)
            {
                if (x.Equals(y))
                    return 0;

                int yn;
                int xn;
                bool isXNumber = int.TryParse(x, out xn);
                bool isYNumber = int.TryParse(y, out yn);

                if (isXNumber && isYNumber)
                {
                    return xn.CompareTo(yn);
                }
                else if (isXNumber && !isYNumber)
                {
                    return -1;
                }
                else if (!isXNumber && isYNumber)
                {
                    return 1;
                }
                else if(x.Any(c => c == '/' || c == '-' ) || y.Any(c => c == '/' || c == '-'))
                {
                    var xParts = x.Split("/-".ToCharArray(),  StringSplitOptions.RemoveEmptyEntries);
                    var yParts = y.Split("/-".ToCharArray(), StringSplitOptions.RemoveEmptyEntries);

                    var minLen = Math.Min(xParts.Length, yParts.Length);

                    var result = 0;
                    for (int i = 0; i < minLen; i++)
                        if ((result = Compare(xParts[i], yParts[i])) != 0)
                            return result;

                    return x.Length < y.Length ? -1 : 1;
                }
                else
                {
                    return x.CompareTo(y);
                }
            }
        }

Answer 3

对实体的Linq不支持Convert.ToInt32，这就是在您的情况下导致错误的原因，我建议将查询具体化，然后应用您的排序。

List<ViewTestPackageHistorySheet> lstTestPackageHistorySheets = _reportTestPackageHistorySheetRepository.ShowReport(Id).ToList();

// Now order the list. 
lstTestPackageHistorySheets = lstTestPackageHistorySheets.Select(x=> 
             new 
             {   // split number and string
                 number =  Regex.IsMatch(x.Split('-')[0],@"^\d+$")? int.Parse(x.Split('-')[0]): int.MaxValue, 
                 item =x
             })
    .OrderBy(x=>x.number)    // first order by number
    .ThenBy(x=>x.item)       // then order by string. 
    .Select(x=>x.item)
    .ToList();

检查这个Demo