public List <QPS.NEW.Model.Room> GetModelList(string strWhere)
{
List <QPS.NEW.Model.Room> list = new List <NEW.Model.Room>();
QPS.NEW.Model.Room room;
DataTable dt = sqlHelper_.GetDataTable(
"select * from Room where " + strWhere,
CommandType.Text,
null
);
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
room = new NEW.Model.Room();
room.Id = Convert.ToInt32(dt.Rows[i]["Id"]);
room.Name = dt.Rows[i]["Name"].ToString();
room.RoomType = dt.Rows[i]["RoomType"].ToString();
room.RoomPrice = Convert.ToDecimal(dt.Rows[i]["RoomPrice"]);
room.Are = dt.Rows[i]["Are"].ToString();
room.Address = dt.Rows[i]["Address"].ToString();
room.ImagePath = dt.Rows[i]["ImagePath"].ToString();
room.Content = dt.Rows[i]["Content"].ToString();
room.RoomState = Convert.ToInt32(dt.Rows[i]["RoomState"]);
room.OwnerID = Convert.ToInt32(dt.Rows[i]["OwnerID"]);
room.IfRecommend = Convert.ToInt32(dt.Rows[i]["IfRecommend"]);
room.Examine = Convert.ToInt32(dt.Rows[i]["IfExamine"]);
if (dt.Rows[i]["RecommendTime"] == DBNull.Value)
{
room.RecommendTime = null;
}
else
{
room.RecommendTime = dt.Rows[i]["RecommendTime"].ToString();
}
list.Add(room);
}
}
return(list);
}
public List<QPS.NEW.Model.Room> GetModelList(string strWhere)
{
List<QPS.NEW.Model.Room> list = new List<NEW.Model.Room>();
QPS.NEW.Model.Room room;
DataTable dt = sqlHelper_.GetDataTable(
"select * from Room where " + strWhere,
CommandType.Text,
null
);
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
room = new NEW.Model.Room();
room.Id = Convert.ToInt32(dt.Rows[i]["Id"]);
room.Name = dt.Rows[i]["Name"].ToString();
room.RoomType = dt.Rows[i]["RoomType"].ToString();
room.RoomPrice = Convert.ToDecimal(dt.Rows[i]["RoomPrice"]);
room.Are = dt.Rows[i]["Are"].ToString();
room.Address = dt.Rows[i]["Address"].ToString();
room.ImagePath = dt.Rows[i]["ImagePath"].ToString();
room.Content = dt.Rows[i]["Content"].ToString();
room.RoomState = Convert.ToInt32(dt.Rows[i]["RoomState"]);
room.OwnerID = Convert.ToInt32(dt.Rows[i]["OwnerID"]);
room.IfRecommend = Convert.ToInt32(dt.Rows[i]["IfRecommend"]);
room.Examine = Convert.ToInt32(dt.Rows[i]["IfExamine"]);
if (dt.Rows[i]["RecommendTime"] == DBNull.Value)
room.RecommendTime = null;
else
room.RecommendTime = dt.Rows[i]["RecommendTime"].ToString();
list.Add(room);
}
}
return list;
}
