// 获取订单列表
public static List <Models.OrdersModel> GetOrders(string username)
{
SqlParameter[] sqlParameters = new SqlParameter[] {
new SqlParameter("@Username", username)
};
string sql = "select * from orders where username = @Username";
SqlDataReader data = SqlHelper.ExecuteTable(sql, sqlParameters);
if (data == null)
{
return(null);
}
List <Models.OrdersModel> result = new List <Models.OrdersModel>();
while (data.Read())
{
Models.OrdersModel order = new Models.OrdersModel();
order.OrderId = data.GetInt32(0);
order.ItemId = data.GetInt32(1);
order.Username = data.GetString(2);
order.OrderNum = data.GetInt32(3);
order.OrderPrice = data.GetDouble(4);
order.OrderStatus = data.GetString(5);
order.OrderCreateTime = data.GetDateTime(6);
result.Add(order);
}
return(result);
}
// 新建订单, 并且返回订单
public static Models.OrdersModel AddOrders(string username, int item_id, int num, double price)
{
Models.OrdersModel orders = new Models.OrdersModel();
orders.OrderCreateTime = DateTime.Now;
orders.OrderNum = num;
orders.OrderPrice = price;
orders.ItemId = item_id;
orders.OrderStatus = "未支付";
SqlParameter[] sqlParameters = new SqlParameter[] {
new SqlParameter("@Username", username),
new SqlParameter("@ItemId", item_id),
new SqlParameter("@Num", num),
new SqlParameter("@Price", price),
new SqlParameter("@Status", orders.OrderStatus),
new SqlParameter("@Time", orders.OrderCreateTime)
};
string sql = "insert into orders (item_id,username,order_num,order_price,order_status,order_create_time) values(@ItemId,@Username,@Num,@Price,@Status,@Time)\r\n select SCOPE_IDENTITY()\r\n go";
orders.OrderId = Convert.ToInt32(SqlHelper.ExecuteScalar(sql, sqlParameters));
return(orders);
}
public OrderDetailPage(Models.OrdersModel _order)
{
InitializeComponent();
}
