public List <QPS.NEW.Model.Orderform> GetModelList(string strWhere)
{
List <QPS.NEW.Model.Orderform> list = new List <NEW.Model.Orderform>();
QPS.NEW.Model.Orderform orderform;
DataTable dt = sqlHelper_.GetDataTable(
"select * from Orderform where " + strWhere,
CommandType.Text,
null
);
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
orderform = new NEW.Model.Orderform();
orderform.Id = Convert.ToInt32(dt.Rows[i]["Id"]);
orderform.OrderNumber = dt.Rows[i]["OrderNumber"].ToString();
orderform.StartTime = Convert.ToDateTime(dt.Rows[i]["StartTime"]);
orderform.endTime = Convert.ToDateTime(dt.Rows[i]["endTime"]);
orderform.Userid = Convert.ToInt32(dt.Rows[i]["Userid"]);
orderform.Roomid = Convert.ToInt32(dt.Rows[i]["Roomid"]);
orderform.RoomType = Convert.ToInt32(dt.Rows[i]["RoomType"]);
if (dt.Rows[i]["Beveragecost"] == DBNull.Value)
{
orderform.Beveragecost = null;
}
else
{
orderform.Beveragecost = Convert.ToDecimal(dt.Rows[i]["Beveragecost"]);
}
orderform.IsDelete = Convert.ToInt32(dt.Rows[i]["IsDelete"]);
orderform.IsValidity = Convert.ToInt32(dt.Rows[i]["IsValidity"]);
list.Add(orderform);
}
}
return(list);
}
public List<QPS.NEW.Model.Orderform> GetModelList(string strWhere)
{
List<QPS.NEW.Model.Orderform> list = new List<NEW.Model.Orderform>();
QPS.NEW.Model.Orderform orderform;
DataTable dt = sqlHelper_.GetDataTable(
"select * from Orderform where "+strWhere,
CommandType.Text,
null
);
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
orderform = new NEW.Model.Orderform();
orderform.Id = Convert.ToInt32(dt.Rows[i]["Id"]);
orderform.OrderNumber = dt.Rows[i]["OrderNumber"].ToString();
orderform.StartTime = Convert.ToDateTime(dt.Rows[i]["StartTime"]);
orderform.endTime = Convert.ToDateTime(dt.Rows[i]["endTime"]);
orderform.Userid = Convert.ToInt32( dt.Rows[i]["Userid"]);
orderform.Roomid = Convert.ToInt32( dt.Rows[i]["Roomid"]);
orderform.RoomType = Convert.ToInt32(dt.Rows[i]["RoomType"]);
if (dt.Rows[i]["Beveragecost"] == DBNull.Value)
orderform.Beveragecost = null;
else
orderform.Beveragecost = Convert.ToDecimal(dt.Rows[i]["Beveragecost"]);
orderform.IsDelete = Convert.ToInt32(dt.Rows[i]["IsDelete"]);
orderform.IsValidity = Convert.ToInt32(dt.Rows[i]["IsValidity"]);
list.Add(orderform);
}
}
return list;
}
