public List<Order> GetOrderIn4Hours(int menuId)
{
string sqlCmd =string.Format("select * from [order] where datediff (hh,CreateTime,getdate())<5 order by CreateTime desc",menuId);
List<Order> orderList = new List<Order>();
if (_sqlHelp.TryConnection()) {
DataTable orderResult = _sqlHelp.ExecuteFillDataTable(sqlCmd);
for (var i = 0; i < orderResult.Rows.Count;i++ ) {
DataRow dr = orderResult.Rows[i];
Order order = new Order();
order.Id = Int32.Parse(dr["Id"].ToString());
order.MenuId = menuId;
order.CreateName = dr["CreateName"].ToString();
order.CreateTime = DateTime.Parse(dr["CreateTime"].ToString()).ToString("HH:mm");
orderList.Add(order);
}
} else {
throw new Exception("数据库连接失败");
}
return orderList;
}
public Order GetOrderByOrderId(int orderId)
{
string sqlCmd = "select * from [order] where Id=" + orderId;
if (_sqlHelp.TryConnection()) {
DataTable orderResult = _sqlHelp.ExecuteFillDataTable(sqlCmd);
if(orderResult.Rows.Count!=0 ) {
DataRow dr = orderResult.Rows[0];
Order order= new Order();
order.Id = orderId;
order.MenuId = Int32.Parse(dr["MenuId"].ToString());
order.CreateName = dr["CreateName"].ToString();
order.CreateTime = DateTime.Parse(dr["CreateTime"].ToString()).ToString("HH:mm");
return order;
}
} else {
throw new Exception("数据库连接失败");
}
return null;
}
