public OnlineSkiPass(string code) { cardCode = code; DataTable dtOrder = DBHelper.GetDataTable(" select [id] from order_online where type='雪票' and code = '" + code.Trim() + "' "); associateOnlineOrder = new OnlineOrder(int.Parse(dtOrder.Rows[0][0].ToString())); associateOnlineOrderDetail = associateOnlineOrder.OrderDetails[0]; productName = associateOnlineOrderDetail.productName.Trim(); count = associateOnlineOrderDetail.count; associateCard = new Card(code); owner = new MiniUsers(associateOnlineOrder._fields["open_id"].ToString()); if (associateCard._fields["type"].Equals("雪票")) { if (!associateCard._fields["used"].ToString().Equals("0")) { used = true; try { useDate = DateTime.Parse(associateCard._fields["use_date"].ToString()); } catch { } } } }
public int PlaceOrder(string customerOpenId) { int productId = 147; int orderId = 0; double amount = double.Parse(_fields["guarantee_cash"].ToString().Trim()); OnlineOrderDetail detail = new OnlineOrderDetail(); Product p = new Product(productId); detail.productId = int.Parse(p._fields["id"].ToString()); detail.productName = p._fields["name"].ToString(); detail.price = double.Parse(p._fields["sale_price"].ToString()); detail.count = (int)(amount / detail.price); OnlineOrder newOrder = new OnlineOrder(); newOrder.Type = "押金"; newOrder.shop = _fields["shop"].ToString().Trim(); newOrder.AddADetail(detail); try { orderId = newOrder.Place(customerOpenId); } catch { } DBHelper.UpdateData("expierence_list", new string[,] { { "guarantee_order_id", "int", orderId.ToString() } }, new string[,] { { "id", "int", _fields["id"].ToString() } }, Util.conStr); return orderId; }
public static int PlaceOrder(int id) { EquipMaintainRequestInshop request = new EquipMaintainRequestInshop(id); if (request.ProductId == 0 && request.AddtionalFee == 0) { return(0); } OnlineOrder newOrder = new OnlineOrder(); if (request.ProductId != 0) { OnlineOrderDetail detail = new OnlineOrderDetail(); Product p = new Product(request.ProductId); detail.productId = int.Parse(p._fields["id"].ToString()); detail.productName = p._fields["name"].ToString(); detail.price = double.Parse(p._fields["sale_price"].ToString()); detail.count = 1; newOrder.Type = p.Type.Trim(); newOrder.shop = request._fields["shop"].ToString().Trim(); newOrder.AddADetail(detail); } if (request.AddtionalFee != 0) { OnlineOrderDetail detail = new OnlineOrderDetail(); Product p = new Product(request.AddtionalFeeProductId); detail.productId = int.Parse(p._fields["id"].ToString()); detail.productName = p._fields["name"].ToString(); detail.price = double.Parse(p._fields["sale_price"].ToString()); detail.count = (int)(request.AddtionalFee / p.SalePrice); newOrder.Type = p.Type.Trim(); newOrder.shop = request._fields["shop"].ToString().Trim(); newOrder.AddADetail(detail); } int orderId = newOrder.Place(request.OwnerOpenId.Trim()); DBHelper.UpdateData("maintain_in_shop_request", new string[, ] { { "order_id", "int", orderId.ToString() } }, new string[, ] { { "id", "int", id.ToString() } }, Util.conStr); return(orderId); }
public static OnlineOrderDetail[] GetOnlineOrderDetails(int orderId) { DataTable dt = DBHelper.GetDataTable(" select * from order_online_detail where order_online_id = " + orderId.ToString()); OnlineOrderDetail[] detailArr = new OnlineOrderDetail[dt.Rows.Count]; for (int i = 0; i < dt.Rows.Count; i++) { detailArr[i] = new OnlineOrderDetail(); detailArr[i].id = int.Parse(dt.Rows[i]["id"].ToString()); detailArr[i].orderId = int.Parse(dt.Rows[i]["order_online_id"].ToString().Trim()); detailArr[i].productId = int.Parse(dt.Rows[i]["product_id"].ToString().Trim()); detailArr[i].productName = dt.Rows[i]["product_name"].ToString().Trim(); detailArr[i].price = double.Parse(dt.Rows[i]["price"].ToString()); detailArr[i].count = int.Parse(dt.Rows[i]["count"].ToString()); } dt.Dispose(); return(detailArr); }
public void AddADetail(OnlineOrderDetail onlineOrderDetail) { if (_fields == null) { OnlineOrderDetail[] newOrderDetails = new OnlineOrderDetail[orderDetails.Length + 1]; for (int i = 0; i < newOrderDetails.Length; i++) { if (i == newOrderDetails.Length - 1) { newOrderDetails[i] = onlineOrderDetail; } else { newOrderDetails[i] = orderDetails[i]; } } orderDetails = newOrderDetails; } }