Пример #1
0
        /// <summary>
        /// 获得数据列表
        /// </summary>
        /// <param name="strWhere">条件</param>
        /// <returns>Routes集合</returns>
        public List <ClassLibrary.Model.Routes> GetModelList(DataTable dt)
        {
            List <ClassLibrary.Model.Routes> modelList = new List <ClassLibrary.Model.Routes>();
            int rowsCount = dt.Rows.Count;

            if (rowsCount > 0)
            {
                ClassLibrary.Model.Routes model;
                for (int n = 0; n < rowsCount; n++)
                {
                    model = new ClassLibrary.Model.Routes();
                    if (dt.Rows[n]["ID"] != DBNull.Value)
                    {
                        model.ID = Convert.ToInt32(dt.Rows[n]["ID"]);
                    }
                    if (dt.Rows[n]["routesClassID"] != DBNull.Value)
                    {
                        model.routesClassID = Convert.ToString(dt.Rows[n]["routesClassID"]);
                    }
                    if (dt.Rows[n]["ThemeID"] != DBNull.Value)
                    {
                        model.ThemeID = Convert.ToString(dt.Rows[n]["ThemeID"]);
                    }
                    if (dt.Rows[n]["routesPrentClassID"] != DBNull.Value)
                    {
                        model.routesPrentClassID = Convert.ToString(dt.Rows[n]["routesPrentClassID"]);
                    }
                    if (dt.Rows[n]["Title"] != DBNull.Value)
                    {
                        model.Title = Convert.ToString(dt.Rows[n]["Title"]);
                    }
                    if (dt.Rows[n]["Price"] != DBNull.Value)
                    {
                        model.Price = Convert.ToDecimal(dt.Rows[n]["Price"]);
                    }
                    if (dt.Rows[n]["Image"] != DBNull.Value)
                    {
                        model.Image = Convert.ToString(dt.Rows[n]["Image"]);
                    }
                    if (dt.Rows[n]["StartPosition"] != DBNull.Value)
                    {
                        model.StartPosition = Convert.ToString(dt.Rows[n]["StartPosition"]);
                    }
                    if (dt.Rows[n]["Destination"] != DBNull.Value)
                    {
                        model.Destination = Convert.ToString(dt.Rows[n]["Destination"]);
                    }
                    if (dt.Rows[n]["RouteTime"] != DBNull.Value)
                    {
                        model.RouteTime = Convert.ToString(dt.Rows[n]["RouteTime"]);
                    }
                    if (dt.Rows[n]["TrafficModel"] != DBNull.Value)
                    {
                        model.TrafficModel = Convert.ToString(dt.Rows[n]["TrafficModel"]);
                    }
                    if (dt.Rows[n]["DescriptionRoute"] != DBNull.Value)
                    {
                        model.DescriptionRoute = Convert.ToString(dt.Rows[n]["DescriptionRoute"]);
                    }
                    if (dt.Rows[n]["DescriptionPrice"] != DBNull.Value)
                    {
                        model.DescriptionPrice = Convert.ToString(dt.Rows[n]["DescriptionPrice"]);
                    }
                    if (dt.Rows[n]["ViewCount"] != DBNull.Value)
                    {
                        model.ViewCount = Convert.ToInt32(dt.Rows[n]["ViewCount"]);
                    }
                    if (dt.Rows[n]["LastUpdateTimeRoute"] != DBNull.Value)
                    {
                        model.LastUpdateTimeRoute = Convert.ToDateTime(dt.Rows[n]["LastUpdateTimeRoute"]);
                    }
                    if (dt.Rows[n]["LastUpdateTimePrice"] != DBNull.Value)
                    {
                        model.LastUpdateTimePrice = Convert.ToDateTime(dt.Rows[n]["LastUpdateTimePrice"]);
                    }
                    if (dt.Rows[n]["RecommendHot"] != DBNull.Value)
                    {
                        model.RecommendHot = Convert.ToBoolean(dt.Rows[n]["RecommendHot"]);
                    }
                    if (dt.Rows[n]["CreatedTime"] != DBNull.Value)
                    {
                        model.CreatedTime = Convert.ToDateTime(dt.Rows[n]["CreatedTime"]);
                    }
                    if (dt.Rows[n]["SeoKeywords"] != DBNull.Value)
                    {
                        model.SeoKeywords = Convert.ToString(dt.Rows[n]["SeoKeywords"]);
                    }
                    if (dt.Rows[n]["SeoDescription"] != DBNull.Value)
                    {
                        model.SeoDescription = Convert.ToString(dt.Rows[n]["SeoDescription"]);
                    }
                    if (dt.Rows[n]["IsDisplay"] != DBNull.Value)
                    {
                        model.Display = Convert.ToBoolean(dt.Rows[n]["IsDisplay"]);
                    }
                    model.FirstTime = dt.Rows[n]["FirstTime"].ToString();

                    if (dt.Rows[n]["DetailType"] != DBNull.Value)
                    {
                        model.DetailType = Convert.ToBoolean(dt.Rows[n]["DetailType"]);
                    }
                    if (dt.Rows[n]["DateType"] != DBNull.Value)
                    {
                        model.DateType = Convert.ToBoolean(dt.Rows[n]["DateType"]);
                    }
                    if (dt.Rows[n]["DatePrice"] != DBNull.Value)
                    {
                        model.DatePrice = Convert.ToString(dt.Rows[n]["DatePrice"]);
                    }
                    if (dt.Rows[n]["ChildPrice"] != DBNull.Value)
                    {
                        model.ChildPrice = Convert.ToDecimal(dt.Rows[n]["ChildPrice"]);
                    }
                    if (dt.Rows[n]["AdvanceDays"] != DBNull.Value)
                    {
                        model.AdvanceDays = Convert.ToInt32(dt.Rows[n]["AdvanceDays"]);
                    }
                    if (dt.Rows[n]["RouteFeature"] != DBNull.Value)
                    {
                        model.RouteFeature = Convert.ToString(dt.Rows[n]["RouteFeature"]);
                    }
                    if (dt.Rows[n]["RouteNotice"] != DBNull.Value)
                    {
                        model.RouteNotice = Convert.ToString(dt.Rows[n]["RouteNotice"]);
                    }
                    if (dt.Rows[n]["RouteOrder"] != DBNull.Value)
                    {
                        model.Order = Convert.ToInt32(dt.Rows[n]["RouteOrder"]);
                    }
                    if (dt.Rows[n]["Supplier"] != DBNull.Value)
                    {
                        model.Supplier = Convert.ToString(dt.Rows[n]["Supplier"]);
                    }
                    if (dt.Rows[n]["seoTitle"] != DBNull.Value)
                    {
                        model.SeoTitle = Convert.ToString(dt.Rows[n]["seoTitle"]);
                    }
                    if (dt.Rows[n]["Bright"] != DBNull.Value)
                    {
                        model.Bright = Convert.ToString(dt.Rows[n]["Bright"]);
                    }
                    if (dt.Rows[n]["BoatName"] != DBNull.Value)
                    {
                        model.BoatName = Convert.ToString(dt.Rows[n]["BoatName"]);
                    }
                    if (dt.Rows[n]["LocationID"] != DBNull.Value)
                    {
                        model.LocationID = Convert.ToInt32(dt.Rows[n]["LocationID"]);
                    }
                    if (dt.Rows[n]["SupplierTel"] != DBNull.Value)
                    {
                        model.SupplierTel = Convert.ToString(dt.Rows[n]["SupplierTel"]);
                    }
                    if (dt.Rows[n]["appImg"] != DBNull.Value)
                    {
                        model.AppImg = Convert.ToString(dt.Rows[n]["appImg"]);
                    }
                    modelList.Add(model);
                }
            }
            return(modelList);
        }
Пример #2
0
 /// <summary>
 /// 增加一条数据
 /// </summary>
 /// <param name="model">model对象</param>
 public int Add(ClassLibrary.Model.Routes model)
 {
     return(dal.Add(model));
 }
Пример #3
0
 /// <summary>
 /// 更新一条数据
 /// </summary>
 /// <param name="model">model对象</param>
 /// <returns>影响行数</returns>
 public int Update(ClassLibrary.Model.Routes model)
 {
     return(dal.Update(model));
 }