linq， List， datatable， Dictionary 模糊匹配速度

最新推荐文章于 2022-04-07 14:21:39 发布

转载最新推荐文章于 2022-04-07 14:21:39 发布 · 161 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/jianjunyue/archive/2011/09/23/2185993.html

本文介绍了一个使用C#进行数据检索的例子，通过DataTable和LINQ来筛选符合特定条件的数据，并展示了如何构建SQL过滤字符串及计算操作时间。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

  public DataTable GetHotledt(string[] arrkey)
        {
            DataTable dt = getHoteldata();
            DataTable dt1 = new DataTable();
            DateTime dts = DateTime.Now;
          //  for (int i = 0; i < 500; i++)
          //  {
                dt.DefaultView.RowFilter = strFilterSQL(arrkey);

                dt1 = dt.DefaultView.ToTable();
           // }
            Console.WriteLine("dt1: " + totalTime(dts, DateTime.Now));
            return dt1;
        }

        public List<SearchData> GetHotel(string[] arrkey)
        {
            //List<SearchData> list = GetDistrictList();

            List<SearchData> rList = new List<SearchData>();
            DateTime dts = DateTime.Now;
         //   for (int i = 0; i < 500; i++)
          //  {
                var linqData = (from c in list
                                where (c.CnName.Contains(arrkey[0])) || (c.EngName.Contains(arrkey[0]))
                                select c)
                                ;

                rList = linqData.ToList<SearchData>();
         //   }
            Console.WriteLine("rList: " + totalTime(dts, DateTime.Now));
            return rList;
        }
        private string strFilterSQL(string[] arrkey)
        {
            StringBuilder sbFilter =new StringBuilder ();
            for (int i = 0; i < arrkey.Length; i++)
            {
                if (arrkey[i].Trim() != "")
                {
                    if (sbFilter.ToString() != "")
                    {
                        sbFilter.Append(" and ");
                    }
                    sbFilter.Append("( CnName like '%" + arrkey[i] + "%' or EngName like '%" + arrkey[i] + "%' )");
                }
            }
            return sbFilter.ToString ();
        }
        private static string totalTime(DateTime start, DateTime end)
        {
            TimeSpan ts = end.Subtract(start).Duration();
            return ts.TotalMilliseconds.ToString();
        }

转载于:https://www.cnblogs.com/jianjunyue/archive/2011/09/23/2185993.html