public TradeAreaModels GetById(int id) { string sqlString = "select * from m_tradeArea where t_tradeAreaId = " + id; System.Data.SqlClient.SqlDataReader reader = SqlSeverProvider.ExecuteReader(sqlString); TradeAreaModels trade = null; if (reader.Read()) { trade = TradeAreaManager.GetTradeAreaByReader(reader); } return(trade); }
public void Add(TradeAreaModels trade) { string sqlString = string.Format("insert into m_tradeArea values({0},{1},{2},{3},{4},{5},{6},{7}", trade.TradeAreaProvince, trade.TradeAreaCity, "'" + trade.TradeAreaCityName + "'", "'" + trade.TradeAreaName + "'", "'" + trade.TradeAreaAddress + "'", trade.FloorCount, trade.FirstFloor, "'" + trade.TradeAreaLogo + "')"); SqlSeverProvider.ExecuteNonQuery(sqlString); }
public static TradeAreaModels GetTradeAreaByRow(DataRow row) { TradeAreaModels trade = new TradeAreaModels(); trade.TradeAreaID = (int)row["t_tradeAreaId"]; trade.TradeAreaProvince = (int)row["t_tradeAreaProvince"]; trade.TradeAreaCity = (int)row["t_tradeAreaCity"]; trade.TradeAreaCityName = row["t_tradeAreaCityName"].ToString(); trade.TradeAreaAddress = row["t_tradeAreaAddress"].ToString(); trade.FloorCount = (int)row["t_floorCount"]; trade.FirstFloor = (int)row["t_firstFloor"]; trade.TradeAreaLogo = row["t_tradeAreaLogo"].ToString(); return(trade); }
public void Update(int id, TradeAreaModels trade) { string sqlString = string.Format("update m_tradeArea set t_tradeAreaProvince={0}, t_tradeAreaCity={1}, t_tradeAreaCityName={2}, " + "t_tradeAreaName={3}, t_tradeAreaAddress={4}, t_floorCount={5}, t_firstFloor={6}, t_tradeAreaLogo={7} where t_tradeAreaId={8}", trade.TradeAreaProvince, trade.TradeAreaCity, "'" + trade.TradeAreaCityName + "'", "'" + trade.TradeAreaName + "'", "'" + trade.TradeAreaAddress + "'", trade.FloorCount, trade.FirstFloor, "'" + trade.TradeAreaLogo + "'", id); SqlSeverProvider.ExecuteNonQuery(sqlString); }