private void ConnectDatabase()
{
//
//TODO: 連線到資料庫，產生商品物件。
//
MySqlDataReader reader;
MySqlConnection msc_conn = new MySqlConnection(ConfigurationManager.ConnectionStrings["LocalMySqlServer"].ConnectionString);
String select = "SELECT * FROM petkitchen.item inner join petkitchen.photos ON item.itemimg=photos.photos_id;";
msc_conn.Open();
MySqlCommand cmd = new MySqlCommand(select, msc_conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
DisplayItemView div_item = new DisplayItemView();
div_item.int_gd = 3;
div_item.str_name = reader["itemname"].ToString().Trim();
div_item.int_price = int.Parse(reader["itemprice"].ToString().Trim());
div_item.str_imgurl = reader["itemimg"].ToString().Trim();
div_item.init();
UpdatePanel1.ContentTemplateContainer.Controls.Add(div_item);
}
UpdatePanel1.ID = "sortableo";
reader.Close();
msc_conn.Close();
}
protected void btn_search_Click(object sender, EventArgs e)
{
//
// TODO: 查資料庫指定商品
//
UpdatePanel1.ContentTemplateContainer.Controls.Clear();
MySqlDataReader reader;
MySqlConnection msc_conn = new MySqlConnection(ConfigurationManager.ConnectionStrings["LocalMySqlServer"].ConnectionString);
String select = "SELECT * FROM petkitchen.item inner join petkitchen.photos ON item.itemimg=photos.photos_id where itemname LIKE '%" + tx_autoSearch.Text.Trim() + "%';";
msc_conn.Open();
MySqlCommand cmd = new MySqlCommand(select, msc_conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
DisplayItemView div_item = new DisplayItemView();
div_item.int_gd = 2;
div_item.str_name = reader["itemname"].ToString().Trim();
div_item.int_price = int.Parse(reader["itemprice"].ToString().Trim());
div_item.str_imgurl = reader["itemimg"].ToString().Trim();
div_item.init();
UpdatePanel1.ContentTemplateContainer.Controls.Add(div_item);
}
reader.Close();
msc_conn.Close();
}
private void CreateItemCategoryController <T>(AllItemsModel <T> model, string contentViewName) where T : AbstractItemModel
{
var controllerFactory = new DisplayItemControllerFactory();
var viewFactory = new DisplayItemViewFactory();
var controller = controllerFactory.CreateDisplayItemController(model);
controller.CreateSceneObject += CreateSceneObject;
for (int i = 0; i < controller.ItemModels.Length(); i++)
{
DisplayItemView view = viewFactory.CreateDisplayItemView(controller.ItemModels.Get(i), i, contentViewName);
controller.SubscribeView(view);
}
}