public IList<Restaurant> GetAllRestaurant(Restaurant obj) { //string command = @"SELECT * FROM Restaurant "; StringBuilder command = SqlBuilder.Query(obj); Restaurant obj1 = new Restaurant(); Restaurant obj2 = new Restaurant(); obj1.Restaurant_ID = "1"; obj1.Restaurant_Name = "王品"; obj2.Restaurant_Name = "王品"; obj2.Restaurant_Parking = "1"; string[] abcd={ "Restaurant_ID","Restaurant_Name" }; StringBuilder abc = SqlBuilder.Query(obj1); StringBuilder abcde = SqlBuilder.Insert(obj2); StringBuilder abcdef = SqlBuilder.Delete(obj2); StringBuilder abcdee = SqlBuilder.Update(obj2); IDbParameters parameters = CreateDbParameters(); SetParameters(abc.ToString(), obj1, ref parameters); IList<Restaurant> restaurant = base.QueryWithRowMapper<Restaurant>(CommandType.Text, Convert.ToString(command), new GenerateRowMapper<Restaurant>()); return restaurant; }
public IList<Restaurant> GetAllRestaurant() { Restaurant obj = new Restaurant(); Restaurant obj2 = new Restaurant(); obj2.Restaurant_ID = "1"; string[] abcd ={ "Restaurant_ID","Restaurant_Name" }; IList<Restaurant> Resta2 = SingleDao.ReadData(obj2, abcd); IList<Restaurant> restaurant = RestaurantDao.GetAllRestaurant(obj); return restaurant; }