Ejemplo n.º 1
0
        public List <TravelVm> GetMyTravels(int page, int count, int userid)
        {
            var list = new List <TravelVm>();
            var ds   = dal.GetMyTravels(page, count, userid);

            if (ds == null || ds.Tables[0] == null || ds.Tables[0].Rows.Count <= 0)
            {
                return(list);
            }
            foreach (DataRow dataRow in ds.Tables[0].Rows)
            {
                var partId   = Int32.Parse(dataRow["id"].ToString());
                var travelId = 0;
                if (dataRow["TravelId"] != DBNull.Value && !string.IsNullOrEmpty(dataRow["TravelId"].ToString()))
                {
                    travelId = Int32.Parse(dataRow["TravelId"].ToString());
                }
                var partType    = Int32.Parse(dataRow["PartType"].ToString());
                var description = dataRow["Description"].ToString();
                var partUrl     = dataRow["PartUrl"] != DBNull.Value?dataRow["PartUrl"].ToString():"";
                var longitude   = dataRow["Longitude"] != DBNull.Value
                    ? Decimal.Parse(dataRow["Longitude"].ToString())
                    : 0;
                var latitude = dataRow["Latitude"] != DBNull.Value
                    ? Decimal.Parse(dataRow["Latitude"].ToString())
                    : 0;
                var height = dataRow["Height"] != DBNull.Value
                    ? Decimal.Parse(dataRow["Height"].ToString())
                    : 0;
                var area = dataRow["Area"] != DBNull.Value
                    ? dataRow["Area"].ToString()
                    : "";
                var createtime = DateTime.Parse(dataRow["CreateTime"].ToString());
                var travel     = new Travels();
                if (travelId > 0)
                {
                    travel = GetModelByCache(travelId);
                }

                var vm = new TravelVm()
                {
                    TravelName  = travel != null ? travel.TravelName : "",
                    CoverImage  = travel != null ? travel.CoverImage : "",
                    Id          = partId,
                    TravelId    = travelId,
                    PartType    = partType,
                    PartUrl     = partUrl,
                    Description = description,
                    Longitude   = longitude,
                    Latitude    = latitude,
                    Height      = height,
                    Area        = area,
                    CreateTime  = createtime,
                };
                list.Add(vm);
            }
            return(list);
        }
Ejemplo n.º 2
0
        public List<TravelVm> GetMyTravels(int page, int count, int userid)
        {
            var list=new List<TravelVm>();
            var ds = dal.GetMyTravels(page,count,userid);
            if (ds == null || ds.Tables[0] == null || ds.Tables[0].Rows.Count <= 0) return list;
            foreach (DataRow dataRow in ds.Tables[0].Rows)
            {
                var partId = Int32.Parse(dataRow["id"].ToString());
                var travelId = 0;
                if (dataRow["TravelId"] != DBNull.Value && !string.IsNullOrEmpty(dataRow["TravelId"].ToString()))
                {
                    travelId = Int32.Parse(dataRow["TravelId"].ToString());
                }
                var partType = Int32.Parse(dataRow["PartType"].ToString());
                var description = dataRow["Description"].ToString();
                var partUrl = dataRow["PartUrl"]!=DBNull.Value?dataRow["PartUrl"].ToString():"";
                var longitude = dataRow["Longitude"] != DBNull.Value
                    ? Decimal.Parse(dataRow["Longitude"].ToString())
                    : 0;
                var latitude = dataRow["Latitude"] != DBNull.Value
                    ? Decimal.Parse(dataRow["Latitude"].ToString())
                    : 0;
                var height = dataRow["Height"] != DBNull.Value
                    ? Decimal.Parse(dataRow["Height"].ToString())
                    : 0;
                var area = dataRow["Area"] != DBNull.Value
                    ? dataRow["Area"].ToString()
                    : "";
                var createtime = DateTime.Parse(dataRow["CreateTime"].ToString());
                var travel=new Travels();
                if (travelId>0)
                {
                    travel = GetModelByCache(travelId);
                }

                var vm = new TravelVm()
                {
                    TravelName = travel != null ? travel.TravelName : "",
                    CoverImage = travel != null ? travel.CoverImage : "",
                    Id = partId,
                    TravelId = travelId,
                    PartType = partType,
                    PartUrl = partUrl,
                    Description = description,
                    Longitude = longitude,
                    Latitude = latitude,
                    Height = height,
                    Area = area,
                    CreateTime = createtime,
                };
                list.Add(vm);
            }
            return list;
        }