public List <Model.HouseModel> queryHouse(String user_id) { List <Model.HouseModel> list = new List <Model.HouseModel>(); try { string sql = "select house_id,city_id,address,limitation,info,state from house where user_id = '" + user_id + "'"; MySqlCommand cmd = new MySqlCommand(sql, sqlCon); MySqlDataReader reader = cmd.ExecuteReader(); Model.HouseModel hm = null; if (reader.HasRows) { while (reader.Read()) { hm = new HouseModel(); hm.house_id = reader[0].ToString(); hm.city_id = reader[1].ToString(); hm.address = reader[2].ToString(); hm.limitation = reader[3].ToString(); hm.info = reader[4].ToString(); hm.state = reader[5].ToString().ElementAt(0); hm.user_id = user_id; list.Add(hm); } } reader.Close(); cmd.Dispose(); } catch (Exception e) { } return(list); }
public bool insertHouse(String user_id, String password, String city, String address, String limitation, String info) { int count = 0; Model.HouseModel hm = new Model.HouseModel(); if (dbOperation.queryExistUser(user_id, password)) { count = dbOperation.countHouse(user_id); if (count != -1) { string id = count.ToString(); while (id.Length < 5) { id = "0" + id; } id = "H" + user_id.Substring(1) + id; hm.user_id = user_id; hm.house_id = id; hm.city_id = city; hm.address = address; hm.limitation = limitation; hm.info = info; if (dbOperation.insertHouse(hm)) { return(true); } } } return(false); }
public bool updateHouse(String user_id, String password, String house_id, String city, String address, String limitation, String info) { if (dbOperation.queryExistUserHouse(user_id, house_id, password)) { Model.HouseModel hm = new Model.HouseModel(); hm.user_id = user_id; hm.house_id = house_id; hm.city_id = city; hm.address = address; hm.limitation = limitation; hm.info = info; return(dbOperation.updateHouse(hm)); } return(false); }