C# 根据一个其中的一个值获取到对应的数据列表

public Entity.ResultObj GetCarTakRenl(string Imei, string start, string end, int page,int uid)
        {
            DataSet ds;
            int RecordCount = 0;
            int PageCount = 0;
            int PageSize = 6;
            string sqlwhere;
            start = start.Replace("/", "-");
            end = end.Replace("/", "-");
             Model.Person.pmEquipmentMap m = eqBLL.GetModelList("Imei='" + Imei + "' and uid=" + uid + " and ParentUid=0").FirstOrDefault();
            if (m != null)
            {
                sqlwhere = "l.Imei='" + Imei + "' and l.CarState=2";
                if (start != "" || end != "")
                    sqlwhere += "and CONVERT(varchar(100), l.DateStart, 23)>='" + start + "' and CONVERT(varchar(100), l.DateEnd, 23)<='" + end + "' and TrackState=1";
            }
            else
            {
                sqlwhere = "l.Imei='" + Imei + "'and l.uid=" + uid;
                if (start != "" || end != "")
                    sqlwhere += "and CONVERT(varchar(100), l.DateStart, 23)>='" + start + "' and CONVERT(varchar(100), l.DateEnd, 23)<='" + end + "' and TrackState=1";
            }
            cBLL.GetCarTktaList(page, PageSize, sqlwhere, out ds, out RecordCount, out PageCount);
            Entity.carTrackLog ctk;
            Dictionary<string, List<object>> lists = new Dictionary<string, List<object>>();
            List<object> datas = new List<object>();
            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                List<object> list = new List<object>();
                string key = Convert.ToDateTime(dr["DateStart"]).ToString("yyyy-MM-dd");//关键的kay

                Datas dts = datas.Find(o => ((Datas)o).time == key) as Datas;
                if (dts == null)
                {
                    dts = new Datas();
                    dts.time = key;
                    datas.Add(dts);
                }
                ctk = new Entity.carTrackLog();
                ctk.Id = Convert.ToInt32(dr["id"].ToString());
                ctk.Imei = dr["Imei"].ToString();

                if (!string.IsNullOrEmpty(dr["DateStart"]+""))
                    ctk.DateStart = Convert.ToDateTime(dr["DateStart"]).ToString("yyyy-MM-dd HH:mm:ss");

                if (!string.IsNullOrEmpty(dr["DateEnd"]+""))
                    ctk.DateEnd = Convert.ToDateTime(dr["DateEnd"]).ToString("yyyy-MM-dd HH:mm:ss");

                decimal Mileage;
                if (decimal.TryParse(dr["Mileage"] + "", out Mileage))
                    ctk.Mileage = Mileage;
                else
                    ctk.Mileage = 0;
               

                if (!string.IsNullOrEmpty(dr["Time"]+""))
                    ctk.Time = Convert.ToInt32(dr["Time"]);

                int Speed;
                if (int.TryParse(dr["Speed"] + "", out Speed))
                    ctk.Speed = Speed;
                else
                    ctk.Speed = 0;

                ctk.NickName = dr["NickName"].ToString();

                if (!string.IsNullOrEmpty(dr["DateCreated"]+""))
                    ctk.DateCreated = Convert.ToDateTime(dr["DateCreated"]).ToString("yyyy-MM-dd HH:mm:ss");

                dts.lists.Add(ctk);
            }
            Entity.PageInfo p = new Entity.PageInfo();
            p.content = datas;
            p.totalPages = PageCount;
            p.totalElements = RecordCount;
            return new Entity.ResultObj(true, p);
        }
        public class Datas
        {
            public string time;
            public List<object> lists = new List<object>();
        }

 

posted @ 2019-03-12 09:51  没有狐狸的南墙  阅读(1626)  评论(0编辑  收藏  举报