/// <summary> /// 根据订单号返回订单 /// </summary> /// <param name="OrderID">订单号</param> /// <returns></returns> public static Order GetOrderByOrderID(int OrderID) { var sql = "SELECT * FROM [Order] WHERE oID = @oID"; //查询订单 SqlParameter[] parameter = { new SqlParameter("@oID", OrderID) }; var u = SqlHelper.GetTable(sql, CommandType.Text, parameter); if (u.Rows.Count == 0) { return(null); } var room = RoomManager.GetRoomByID(Convert.ToInt32(u.Rows[0][1])); return(new Order { OrderID = Convert.ToInt32(u.Rows[0][0]), RoomID = room.RoomID, Username = u.Rows[0][2].ToString().Trim(), OrderInfo = u.Rows[0][3].ToString().Trim(), OrderPhone = u.Rows[0][4].ToString().Trim(), InTime = Convert.ToDateTime(u.Rows[0][5]), OutTime = Convert.ToDateTime(u.Rows[0][6]), OrderRemark = u.Rows[0][7].ToString().Trim(), OrderState = Convert.ToChar(u.Rows[0][8]), RoomName = room.RoomName, HotelName = HotelManager.GetHotelByID(room.HotelID).HotelName, OrderTime = Convert.ToDateTime(u.Rows[0][9]) }); }
//Order表 oID|rID|uAccount|oInfo|oPhone|InTime|OutTime|oRemark|oStat|oTime /// <summary> /// 通过用户名返回订单 /// </summary> /// <param name="user">用户</param> /// <returns></returns> public static List <Order> GetOrderByUsername(User user) { var sql = "SELECT * FROM [Order] WHERE uAccount = @username ORDER BY InTime "; //查询订单 SqlParameter[] parameter = { new SqlParameter("@username", user.Username) }; var u = SqlHelper.GetTable(sql, CommandType.Text, parameter); var returnList = new List <Order>(); for (var i = 0; i < u.Rows.Count; i++) //返回订单 { var room = RoomManager.GetRoomByID(Convert.ToInt32(u.Rows[i][1])); returnList.Add(new Order { OrderID = Convert.ToInt32(u.Rows[i][0]), RoomID = room.RoomID, Username = u.Rows[i][2].ToString().Trim(), OrderInfo = u.Rows[i][3].ToString().Trim(), OrderPhone = u.Rows[i][4].ToString().Trim(), InTime = Convert.ToDateTime(u.Rows[i][5]), OutTime = Convert.ToDateTime(u.Rows[i][6]), OrderRemark = u.Rows[i][7].ToString().Trim(), OrderState = Convert.ToChar(u.Rows[i][8]), RoomName = room.RoomName, HotelName = HotelManager.GetHotelByID(room.HotelID).HotelName, OrderTime = Convert.ToDateTime(u.Rows[i][9]) }); } return(returnList); }