//修改故障状态：有待商议
public int UptOrdersDisAgree(Orders o)
{
string str = $"Update Orders set Hitch=4 where OrdersID={o.OrdersID}";
return(DBHelper.ExecuteNonQuery(str));
}
public void EditOrders(Orders orders)
{
db.Entry(orders).State = EntityState.Modified;
db.SaveChanges();
}
public void RemoveOrders(Orders orders)
{
db.Orders.Remove(orders);
db.SaveChanges();
}
public Orders GetOrdersById(int?id)
{
Orders orders = db.Orders.Find(id);
return(orders);
}
//预定车辆
public int AddOrders(Orders o)
{
string str = $"insert into Orders values('{o.Oid}',{o.uid},{o.CarInfoid},'{o.Useing}','{o.StartTime}','{o.EndTime}',{o.Driver},{o.Price},ZT,'Hitch') ";
return(DBHelper.ExecuteNonQuery(str));
}
/// <summary>
/// Вывод таблицы заказов
/// </summary>
/// <param name=""></param>
public IEnumerable <Orders> ShowOrders()
{
var order = new List <Orders>();
using (var connection = new SqlConnection(ConnectionString))
{
var command = new SqlCommand(
"SELECT TOP(30) total.OrderID, o.CustomerID, c.ContactName, o.OrderDate," +
" o.RequiredDate, o.ShippedDate, total.Total" +
" FROM Northwind.Customers as c INNER JOIN Northwind.Orders as o" +
" ON c.CustomerID = o.CustomerID INNER JOIN " +
"(SELECT o.OrderID, SUM((UnitPrice * (1 - Discount)) * Quantity) as Total" +
" FROM Northwind.Orders as o FULL OUTER JOIN Northwind.[Order Details] as od" +
" ON o.OrderID = od.OrderID GROUP BY o.OrderID) as total" +
" ON total.OrderID = o.OrderID ORDER BY o.OrderDate DESC", connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
var o = new Orders();
o.OrderID = Convert.ToInt32(reader.GetValue(0));
if (reader.GetValue(1).ToString() != "")
{
o.CustomerID = Convert.ToString(reader.GetValue(1));
}
if (reader.GetValue(2).ToString() != "")
{
o.ContactName = Convert.ToString(reader.GetValue(2));
}
if (reader.GetValue(3).ToString() != "")
{
o.OrderDate = Convert.ToDateTime(reader.GetValue(3));
}
if ((reader.GetValue(5).ToString() == DateTime.MinValue.ToString()) ||
(reader.GetValue(5).ToString() == ""))
{
o.OrderStatus = OrderTypes.Underway;
}
else
{
o.OrderStatus = OrderTypes.Done;
}
if ((o.OrderDate == DateTime.MinValue) || (o.OrderDate.ToString() == ""))
{
o.OrderStatus = OrderTypes.NotShipped;
}
if (reader.GetValue(6).ToString() != "")
{
o.Total = Convert.ToDouble(reader.GetValue(6));
}
Console.WriteLine();
order.Add(o);
}
return(order);
}
}