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);
}
