public static void SaveList(List <Route> list)
        {
            BLL.Route bv = new BLL.Route();
            foreach (Route v in list)
            {
                // try to load by primary key
                bv.LoadByPrimaryKey(v.ID.Value);

                // if the entry doesn't exist, create it
                if (bv.RowCount == 0)
                {
                    bv.AddNew();
                }
                // populate the contents of v on the to the database list
                if (v.ID.HasValue)
                {
                    bv.RouteID = v.ID.Value;
                }
                if (v.Name != "" && v.Name != null)
                {
                    bv.Name = v.Name;
                }
                //if( v.HubID.HasValue )
                //     bv.HubID = v.HubID.Value;
                //if( v.IsDeleted.HasValue )
                //     bv.IsDeleted = v.IsDeleted.Value;
                //if( v.UpdateTime.HasValue )
                //     bv.UpdateTime = v.UpdateTime.Value;

                bv.Save();
            }
        }
 public static void DeleteList(List <int> list)
 {
     BLL.Route bv = new BLL.Route();
     foreach (int v in list)
     {
         // try to load by primary key
         bv.LoadByPrimaryKey(v);
         // if the entry doesn't exist, create it
         if (bv.RowCount > 0)
         {
             bv.MarkAsDeleted();
             bv.Save();
         }
         // populate the contents of v on the to the database list
     }
 }
        public static void DeleteList(List<int> list)
        {
            BLL.Route bv = new BLL.Route();
            foreach (int v in list)
            {
                // try to load by primary key
                bv.LoadByPrimaryKey(v);
                // if the entry doesn't exist, create it
                if (bv.RowCount > 0)
                {
                    bv.MarkAsDeleted();
                    bv.Save();
                }
                // populate the contents of v on the to the database list

            }
        }
        public static void SaveList(List<Route> list)
        {
            BLL.Route bv = new BLL.Route();
            foreach (Route v in list)
            {
                // try to load by primary key
                bv.LoadByPrimaryKey(v.ID.Value);

                // if the entry doesn't exist, create it
                if (bv.RowCount == 0)
                {
                    bv.AddNew();
                }
                // populate the contents of v on the to the database list
              if( v.ID.HasValue )
                   bv.RouteID = v.ID.Value;
              if( v.Name != "" && v.Name != null )
                   bv.Name = v.Name;
              //if( v.HubID.HasValue )
              //     bv.HubID = v.HubID.Value;
              //if( v.IsDeleted.HasValue )
              //     bv.IsDeleted = v.IsDeleted.Value;
              //if( v.UpdateTime.HasValue )
              //     bv.UpdateTime = v.UpdateTime.Value;

                bv.Save();
            }
        }