Esempio n. 1
0
 public ActionResult Edit(House house)
 {
     if (houseManager.UpdateHouse(house,house.HouseId))
     {
         return Content("<script>alert('更新成功!');location.href='" + Url.Content("~/House/Index") + "'</script>'");
     }
     return View(house);
 }
Esempio n. 2
0
 public ActionResult Delete(House house,int id)
 {
     if (houseManager.DeleteHouse(id))
     {
         return Content("<script>alert('删除成功!');location.href='" + Url.Content("~/House/Index") + "'</script>'");
     }
     return View(house);
 }
Esempio n. 3
0
        public List<House> GetAllHouse()
        {
            string sql = "SELECT [HouseId],[Title],[TypeId],[Floorage],[Price],[StreetId],[Contract],[Description],[PublishUser],[PublishTime]  FROM [House].[dbo].[House]";
            List<House> list = new List<House>();
            SqlConnection connection = null;
            SqlDataReader dr = null;
            try
            {
                connection = new SqlConnection(connString);
                connection.Open();
                SqlCommand cmd = new SqlCommand(sql, connection);
                dr = cmd.ExecuteReader();
                while (dr.Read())
                {
                    House house = new House();
                    house.HouseId = Convert.ToInt32(dr["houseid"].ToString());
                    house.Title = dr["title"].ToString();
                    house.TypeId = Convert.ToInt32(dr["typeid"].ToString());
                    house.Floorage = Convert.ToDecimal(dr["floorage"].ToString());
                    house.Price = Convert.ToDecimal(dr["price"].ToString());
                    house.StreetId = Convert.ToInt32(dr["streetid"].ToString());
                    house.Contract = dr["constact"].ToString();
                    house.Description = dr["description"].ToString();
                    house.PublishUser = Convert.ToInt32(dr["publishuser"].ToString());
                    house.PublishTime = Convert.ToDateTime(dr["publishtime"].ToString());
                    list.Add(house);
                }

            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                dr.Close();
                connection.Close();
            }
            return list;
        }
Esempio n. 4
0
 public House GetHouseById(int id)
 {
     string sql = string.Format("SELECT [HouseId],[Title],[TypeId],[Floorage],[Price],[StreetId],[Contract],[Description],[PublishUser],[PublishTime]  FROM [House].[dbo].[House] WHERE [HouseId]={0}", id);
     House house = new House();
     SqlConnection connection = null;
     SqlDataReader dr = null;
     try
     {
         connection = new SqlConnection(connString);
         connection.Open();
         SqlCommand cmd = new SqlCommand(sql, connection);
         dr = cmd.ExecuteReader();
         while (dr.Read())
         {
             house.HouseId = Convert.ToInt32(dr["houseid"].ToString());
             house.Title = dr["title"].ToString();
             house.TypeId = Convert.ToInt32(dr["typeid"].ToString());
             house.Floorage = Convert.ToDecimal(dr["floorage"].ToString());
             house.Price = Convert.ToDecimal(dr["price"].ToString());
             house.StreetId = Convert.ToInt32(dr["streetid"].ToString());
             house.Contract = dr["contract"].ToString();
             house.Description = dr["description"].ToString();
             house.PublishUser = Convert.ToInt32(dr["publishuser"].ToString());
             house.PublishTime = Convert.ToDateTime(dr["publishtime"].ToString());
         }
     }
     catch (Exception)
     {
         throw;
     }
     finally
     {
         dr.Close();
         connection.Close();
     }
     return house;
 }
Esempio n. 5
0
 public bool UpdateHouse(House house, int id)
 {
     string sql = string.Format("UPDATE [House].[dbo].[House]   SET [Title] = '{0}',[TypeId] = {1},[Floorage] = '{2}',[Price] = '{3}',[StreetId] = {4},[Contract] = '{5}',[Description] = '{6}',[PublishUser] = {7},[PublishTime] = '{8}' WHERE HouseId={9}", house.Title, house.TypeId, house.Floorage, house.Price, house.StreetId, house.Contract, house.Description, house.PublishUser, house.PublishTime, id);
     bool success = false;
     SqlConnection connection = null;
     try
     {
         connection = new SqlConnection(connString);
         connection.Open();
         SqlCommand cmd = new SqlCommand(sql, connection);
         int i = cmd.ExecuteNonQuery();
         if (i > 0)
         {
             success = true;
         }
     }
     catch (Exception)
     {
         throw;
     }
     finally
     {
         connection.Close();
     }
     return success;
 }
Esempio n. 6
0
 public bool UpdateHouse(House house, int id)
 {
     return houseService.UpdateHouse(house, id);
 }