public object Update(int id, OrderReq req) { using (var tran = context.Database.BeginTransaction()) { try { var result = context.Orders.FirstOrDefault(value => value.OrderID == id); if (result != null) { result.Name = req.Name; result.CreatedDate = req.CreatedDate; result.PhoneNumberOfOrder = req.PhoneNumberOfOrder; result.Address = req.Address; result.Status = req.Status; result.Note = req.Note; result.EmpId = req.EmpId; result.CusId = req.CusId; context.Orders.Update(result); context.SaveChanges(); tran.Commit(); return(result); } else { return("Unable to update: not found ID."); } } catch (Exception ex) { tran.Rollback(); return(ex.StackTrace); } } }
public SingleRsp Createordduct(OrderReq ord) { var res = new SingleRsp(); Orders order = new Orders(); order.OrderId = ord.OrderId; order.CustomerId = ord.CustomerId; order.EmployeeId = ord.EmployeeId; order.OrderDate = ord.OrderDate; order.RequiredDate = ord.RequiredDate; order.ShippedDate = ord.ShippedDate; order.ShipAddress = ord.ShipAddress; order.ShipCity = ord.ShipCity; order.ShipCountry = ord.ShipCountry; order.ShipName = ord.ShipName; order.ShippedDate = ord.ShippedDate; order.ShipPostalCode = ord.ShipPostalCode; order.ShipRegion = ord.ShipRegion; order.ShipVia = ord.ShipVia; order.Freight = ord.Freight; res = _rep.CreateOrder(order); res.Data = order; return(res); }
private void btn_add_Click(object sender, EventArgs e) { OrderReq req = new OrderReq(); req.CurrencyPair = this.tb_cointype.Text.Trim(); if (req.CurrencyPair.Contains('/')) { req.CurrencyPair = req.CurrencyPair.Replace('/', '_'); } req.Amount = decimal.Parse(tb_count.Text); req.Rate = decimal.Parse(tb_price.Text); string sql = @"insert into torder_info ('cointype','count','buyrate','nowrate','amount','status','yingli','profit','remark') values ('" + req.CurrencyPair + "','" + req.Amount + "','" + req.Rate + "','0','" + req.Amount * req.Rate + "','0','0','0','')"; int i = SQLiteHelper.Instance.ExecuteNonQuery(sql); if (i > 0) { MessageBox.Show("添加成功!"); this.tb_cointype.Text = "0"; tb_count.Text = "0"; tb_price.Text = "0"; } }
/// <summary> /// 统一下单 /// </summary> /// <returns></returns> public OrderResp unifiedOrder(OrderReq req) { //todo:微信登录 const string reqUrl = "https://api.mch.weixin.qq.com/pay/unifiedorder"; string openId = Session["openId"].ToString(); if (string.IsNullOrEmpty(openId)) { throw new XException("用户没有登录微信"); } if (string.IsNullOrEmpty(req.out_trade_no)) { throw new XException("商家订单号(out_trade_no)必须提供"); } if (req.total_fee < 1) { throw new XException("订单金额(total_fee)必须提供"); } req.appid = WxConfigFile.config().AppID; req.mch_id = WxConfigFile.config().MchId; req.trade_type = TradeType.JSAPI.ToString(); req.nonce_str = PayUtil.GetNoncestr(); req.notify_url = WxConfigFile.config().Domain + "/WxPay.orderNotify.call"; req.openid = openId; req.sign = WeiXinUtils.getSign(req, WxConfigFile.config().SignKey); return(req.send <OrderResp>(reqUrl)); // return WeiXinUtils.Post<OrderResp>(req, reqUrl); // req.sign = ""; }
/// <summary> /// 一键卖币 /// </summary> private async Task SellAll() { var blance = await gateio.api.API.GetBalancesAsync(); blance.Available.Remove("USDT"); if (blance.Available.Count != 0) { foreach (var item in blance.Available) { var model = await gateio.api.API.GetTickerAsync(item.Key, "usdt"); decimal price = model.HighestBid; //拿到买方最高价 if (price * item.Value < 1) //小余1美金的残余币则不操作 { continue; } OrderReq orderReqSell = new OrderReq(); orderReqSell.Amount = item.Value; orderReqSell.Rate = price; orderReqSell.CurrencyPair = item.Key + "_usdt"; await gateio.api.API.SellAsync(orderReqSell); DeleteDB(null); } } }
public ActionResult <DataRes <List <SingleProductSell> > > GetList(OrderReq req) { var res = new DataRes <List <SingleProductSell> >() { code = ResCode.Success }; if (req != null) { using (var uow = _uowProvider.CreateUnitOfWork()) { string sql = "select x.Plateform,x.UserAccount,x.SaleOrderCode," + "x.ShippingMethodPlatform, x.ShippingMethod, x.WarehouseCode," + "x.DatePaidPlatform, x.PlatformShipTime, x.DateLatestShip, x.Currency," + "x.CountryCode, ProductCount,a.ProductSku, a.Qty,c.pcrProductSku SubProductSku," + " a.Qty * c.PcrQuantity SubQty, b.WarehouseId " + "from EC_SalesOrder x join EC_SalesOrderDetail a on x.OrderId = a.OrderId " + "join EC_SkuRelation b on a.ProductSku = b.ProductSku " + "join EC_SkuRelationItems c on b.relationid = c.relationid " + "order by x.SaleOrderCode"; var repository = uow.GetRepository <SingleProductSell>(); string orderStr = req.order + (req.order.reverse ? " desc" : ""); res.data = repository.ListFromSql(sql, FilterNode.ListToString(req.query), orderStr).ToList(); } } else { res.code = ResCode.NoValidate; res.msg = ResMsg.ParameterIsNull; } return(res); }
/// <summary> /// 盈亏操作 /// </summary> /// <param name="uplow"></param> /// <param name="count"></param> /// <param name="CurrencyPair"></param> /// <param name="nowrate"></param> private async static void Opear(decimal uplow, decimal count, string CurrencyPair, decimal nowrate, Form form) { TextBox strying = form.Controls.Find("tb_yingli", true)[0] as TextBox; TextBox strkui = form.Controls.Find("tb_kuisun", true)[0] as TextBox; int ying = 5; int.TryParse(strying.Text, out ying); int kui = -2; int.TryParse(strkui.Text, out kui); uplow = uplow * 100; if (uplow > ying || uplow < kui) //涨5% 或 跌2% 就抛 { OrderReq req = new OrderReq(); req.Amount = count; req.CurrencyPair = CurrencyPair; req.Rate = nowrate; if (req.Amount * req.Rate < 1) { return; } await gateio.api.API.SellAsync(req); DeleteDB("cointype='" + CurrencyPair + "'"); } }
/// <summary> /// 插入数据库 /// </summary> /// <param name="req"></param> /// <param name="res"></param> /// <param name="price"></param> private void InsertDataBase(OrderReq req, string res) { string sql = @"insert into torder_info ('cointype','count','buyrate','nowrate','amount','status','yingli','profit','remark') values ('" + req.CurrencyPair + "','" + req.Amount + "','" + req.Rate + "','0','" + req.Amount * req.Rate + "','0','0','0','" + res + "')"; SQLiteHelper.Instance.ExecuteNonQuery(sql); }
public IActionResult CreateOrder([FromBody] OrderReq req) { var res = new SingleRsp(); res = _svc.CreateOrder(req); return(Ok(res)); }
/// <summary> /// 下单 /// </summary> /// <param name="IP"></param> /// <param name="req"></param> /// <returns></returns> public OrderRes SubmitOrder(string IP, OrderReq req) { DateTime startTime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 00:00:00")); DateTime endTime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 23:59:59")); if (req.ShopId <= 0) { throw new Exception($"参数错误,{nameof(req.ShopId)}"); } if (req.MaterialId <= 0) { throw new Exception($"参数错误,{nameof(req.ShopId)}"); } if (string.IsNullOrEmpty(req.Name) || string.IsNullOrEmpty(req.IDCardNumber)) { throw new Exception("参数错误,姓名和身份证号码不能为空"); } var canPreNum = CanSubmitOrder(IP , req.ShopId, req.MaterialId , req.IDCardNumber , startTime, endTime, out string err); if (canPreNum <= 0) { throw new Exception($"预定失败,{err}"); } #region order code string codeTime = DateTime.Now.ToString("yyyyMMddHHmmssfff"); int IDCardNumLen = req.IDCardNumber.Length; int IDCARD_SUB_LEN = 6; string codeIDCardNum = req.IDCardNumber.Substring(IDCardNumLen - IDCARD_SUB_LEN, IDCARD_SUB_LEN); string code = $"{codeTime}_{codeIDCardNum}_{req.ShopId}_{req.MaterialId}"; #endregion using (var db = DBFactory.nCoVMS()) { var order = new Torder { Code = code, CreateTime = DateTime.Now, IdcardNumber = req.IDCardNumber ?? "", MaterialId = req.MaterialId, Name = req.Name ?? "", Num = canPreNum, ShopId = req.ShopId, Status = (int)EOrderStatus.PRE, }; db.Torder.Add(order); db.SaveChanges(); return(MapperHelper.MapperTo <Torder, OrderRes>(order)); } }
public bool Save(OrderReqExtend items) { XmlChange xml = new XmlChange(); var order = new OrderReqExtend(); var detail = new OrderReqDetailExtend(); bool isUpdated = true; try { //delete Order OrderReq ordertoDelete = context.OrderReqs.FirstOrDefault(a => a.Code == items.Code); context.Entry(ordertoDelete).State = EntityState.Deleted; context.SaveChanges(); //delete OrderDetail List <OrderReqDetail> listOrderDetailToDelete = context.OrderReqDetails.Where(a => a.OrderReqCode == items.Code).ToList(); context.OrderReqDetails.RemoveRange(listOrderDetailToDelete); context.SaveChanges(); //Update status OrderReqDetailProduct var detailforUpdate = context.OrderReqDetailProducts.Where(a => a.OrderReqCode == items.Code && a.Status == 0).ToList(); detailforUpdate.ForEach(a => { a.Status = 1; }); context.SaveChanges(); bool resultCreatexml = xml.Create(items.Code); //Crea XML //if (result) //{ // var detailforUpdate = context.OrderReqDetailProducts.Where(a=> a.OrderReqCode == items.Code && a.Status == 0).ToList(); // detailforUpdate.ForEach(a => // { // a.Status = 1; // }); // foreach (OrderReqDetailProduct row in detailforUpdate) // { // row.Status = 1; // context.Entry(row).State = EntityState.Modified; // context.SaveChanges(); // } // // context.SaveChanges(); // bool resultCreatexml = xml.Create(items.Code); //Crea XML //} } catch (Exception) { isUpdated = false; throw; } return(isUpdated); }
public Order CreateOrder(OrderReq ord) { Order o = new Order(); o.UserId = ord.UserId; o.Address = ord.Address; o.Country = ord.Country; return(_rep.CreateOrder(o)); }
public static string getOrderReq() { OrderReq op = new OrderReq(); op.spbill_create_ip = "192.168.111"; op.notify_url = "http://"; op.out_trade_no = "aaa"; string s = XmlConvert.getXml(op); return(s); }
/// <summary> /// 发单! /// </summary> /// <param name="order"></param> public void SendOrder(OrderReq order) { ThostFtdcInputOrderField req = new ThostFtdcInputOrderField(); ///经纪公司代码 req.BrokerID = this.BrokerID; ///投资者代码 req.InvestorID = this.UserID; ///合约代码 req.InstrumentID = order.symbol; ///报单本地委托号,待处理 //req.OrderRef = ORDER_REF; ///用户代码 // TThostFtdcUserIDType UserID; ///报单价格条件: 限价 req.OrderPriceType = CTP.EnumOrderPriceTypeType.LimitPrice; ///买卖方向: req.Direction = (EnumDirectionType)order.direction; ///组合开平标志: 开仓 req.CombOffsetFlag_0 = CTP.EnumOffsetFlagType.Open; ///组合投机套保标志 req.CombHedgeFlag_0 = CTP.EnumHedgeFlagType.Speculation; ///价格 req.LimitPrice = order.price; ///数量: 1 req.VolumeTotalOriginal = order.volume; ///有效期类型: 当日有效 req.TimeCondition = CTP.EnumTimeConditionType.GFD; ///GTD日期 // TThostFtdcDateType GTDDate; ///成交量类型: 任何数量 req.VolumeCondition = CTP.EnumVolumeConditionType.AV; ///最小成交量: 1 req.MinVolume = 1; ///触发条件: 立即 req.ContingentCondition = CTP.EnumContingentConditionType.Immediately; ///止损价 // TThostFtdcPriceType StopPrice; ///强平原因: 非强平 req.ForceCloseReason = CTP.EnumForceCloseReasonType.NotForceClose; ///自动挂起标志: 否 req.IsAutoSuspend = 0; ///业务单元 // TThostFtdcBusinessUnitType BusinessUnit; ///请求编号 // TThostFtdcRequestIDType RequestID; ///用户强评标志: 否 req.UserForceClose = 0; int iResult = this.ReqOrderInsert(req, ++this.reqID); Console.WriteLine("--->>> 报单请求: " + ((iResult == 0) ? "成功" : "失败")); }
public SingleRsp CreateOrderTest(OrderReq order) { var res = new SingleRsp(); Orders orders = new Orders(); orders.OrderId = order.OrderId; orders.CustomerId = order.CustomerId; orders.OrderDate = order.OrderDate; res = _rep.CreateOrderTest(orders); res.Data = orders; return(res); }
public static string getSign() { OrderReq op = new OrderReq(); op.spbill_create_ip = "192.168.111"; op.notify_url = "http://"; op.out_trade_no = "aaa"; op.total_fee = 33; op.openid = "asdfasdf"; op.appid = "xxxxxxx"; return(WeiXinUtils.getSign(op, "abcd3dafasdfadf")); }
public SingleRsp UpdateOrder(OrderReq ts) { var res = new SingleRsp(); Orders orders = new Orders(); orders.OrderId = ts.OrderId; orders.UserName = ts.UserName; orders.OrderDate = ts.OrderDate; orders.DiscountId = ts.DiscountId; orders.ShipAddress = ts.ShipAddress; res = _rep.UpdateOrder(orders); res.Data = orders; return(res); }
public object CreateOrder(OrderReq req) { Orders orders = new Orders(); orders.Name = req.Name; orders.CreatedDate = req.CreatedDate; orders.PhoneNumberOfOrder = req.PhoneNumberOfOrder; orders.Address = req.Address; orders.TotalPrice = req.TotalPrice; orders.Status = req.Status; orders.Note = req.Note; orders.EmpId = req.EmpId; orders.CusId = req.CusId; return(orderRep.Create(orders)); }
//Sửa public object Update(int id, OrderReq req) { using (var tran = _context.Database.BeginTransaction()) { try { //Khởi tạo đối tượng tìm id trong bảng //Tìm id //Đây là row dữ liệu trả về theo ID var searchResult = _context.Orders.FirstOrDefault(value => value.OrderId == id); //Tìm thấy if (searchResult != null) { //Gán giá trị qua search result //Không gán mã searchResult.Name = req.Name; searchResult.CreatedDate = req.CreatedDate; searchResult.PhoneNumbOfOrder = req.PhoneNumbOfOrder; searchResult.Address = req.Address; searchResult.Ward = req.Ward; searchResult.District = req.District; searchResult.City = req.City; searchResult.OrderStatus = req.OrderStatus; searchResult.Note = req.Note; searchResult.CusId = req.CusId; searchResult.EmpId = req.EmpId; //Thay đổi theo search result. Không thay đổi theo tham số truyền vào vì sẽ bị duplicate _context.Orders.Update(searchResult); _context.SaveChanges(); tran.Commit(); return(searchResult); } //Không tìm thấy else { return("Unable to update: not found ID."); } } catch (Exception ex) { tran.Rollback(); return(ex.StackTrace); //Xuất ra lỗi } } }
public SingleRsp UpdateOrder(OrderReq ord) { var res = new SingleRsp(); Order ords = new Order(); ords.OrderId = ord.OrderId; ords.CustomerId = ord.CustomerId; ords.StatusId = ord.StatusId; ords.DelivererId = ord.DelivererId; ords.CreateDate = ord.CreateDate; ords.TotalPrice = ord.TotalPrice; ords.DeliveryAddress = ord.DeliveryAddress; ords.Note = ord.Note; res = _rep.UpdateOrder(ords); return(res); }
public SingleRsp CreateOrder(OrderReq order) { DateTime now = DateTime.Now; order.OrderDate = now; var res = new SingleRsp(); Orders orders = new Orders(); orders.OrderId = order.OrderId; orders.UserId = order.UserId; orders.OrderDate = order.OrderDate; orders.ShipName = order.ShipName; orders.ShipAddress = order.ShipAddress; orders.ShipPhoneNumber = order.ShipPhoneNumber; orders.Status = order.Status; res = _rep.CreateOrder(orders); return(res); }
void X(OrderReq orderReq, Order order, OrderInfo orderInfo, string orderNo) { DateTime dateField; bool isValidRequestedProcessDate = DateTime.TryParseExact(orderReq.RequestedProcessDate, "yyyy-MM-dd", CultureInfo.InvariantCulture, DateTimeStyles.None, out dateField); bool isGoodDate = true; string problemArea = string.Empty; if (!isValidRequestedProcessDate) { isGoodDate = false; problemArea = "Could not parse requested process date."; } else if (dateField < DateTime.Today) { isGoodDate = false; problemArea = "Requested process date is before today."; } else if (dateField > order.PODate) { isGoodDate = false; problemArea = "Requested process date is after PO date."; } if (isGoodDate) { orderInfo.Status = OrderInfoStatus.Success; orderInfo.OrderNumber = orderNo; order.ProcessDate = DateTime.Now; } else { orderInfo.Status = OrderInfoStatus.Failure; orderInfo.OrderNumber = orderNo; orderInfo.Notes = "Invalid Request Delivery Date: " + orderReq.RequestedProcessDate + " (yyyy-MM-dd) - " + problemArea + Environment.NewLine; order.ProcessReqDate = DateTime.Today; //orderFailed = true; /* use orderInfo.Status for this instead */ } }
public HttpResponseMessage GetNotice(OrderReq req) { var list = CacheHelper.GetByCondition <ArticleInfo>("ArticleInfo", " isdeleted = 0 and isarticle=0 and status=1 "); if (list.Count < 1) { return(ControllerHelper.Instance.JsonEmptyArr(200, "暂无公告")); } //return ControllerHelper.Instance.JsonResult(500, "暂无公告"); var listR = new List <ArticleName_url>(); foreach (var item in list.OrderByDescending(p => p.id)) { ArticleName_url temp = new ArticleName_url(item, apiHost); listR.Add(temp); } return(ControllerHelper.Instance.JsonResult(200, JsonConvert.SerializeObject(listR), "")); }
public object CreateOrder(OrderReq req) { //Tạo đối tượng Orders orders = new Orders(); //Gán giá trị orders.Name = req.Name; orders.CreatedDate = req.CreatedDate; orders.PhoneNumbOfOrder = req.PhoneNumbOfOrder; orders.Address = req.Address; orders.Ward = req.Ward; orders.District = req.District; orders.City = req.City; orders.OrderStatus = req.OrderStatus; orders.Note = req.Note; orders.CusId = req.CusId; orders.EmpId = req.EmpId; //Trả về kết quả return(_rep.Create(orders)); }
/// <summary> /// 一键买币 /// </summary> /// <returns></returns> private async Task BuyAll() { var blancelist = await gateio.api.API.GetBalancesAsync(); decimal usdtcount = blancelist.Available["USDT"]; if (marketlist.Count == 0) { await GetTop(); } int coincount = 5; int.TryParse(this.tb_coincount.Text, out coincount); marketlist = marketlist.Skip(2).Take(coincount).ToList(); foreach (var item in marketlist) { OrderReq orderReqbuy = new OrderReq(); var coinmodel = await gateio.api.API.GetTickerAsync(item.CurrA, "usdt"); decimal usdt = usdtcount / 10; //十分之一的资金 decimal amount = decimal.Parse(Math.Floor(Convert.ToDouble(usdt / coinmodel.LowestAsk)).ToString()); //能买多少个 if (amount <= 0 || usdt <= 1) { continue; } orderReqbuy.Amount = amount; orderReqbuy.CurrencyPair = item.CurrA.ToLower() + "_" + item.CurrB.ToLower(); orderReqbuy.Rate = coinmodel.LowestAsk; string res = await gateio.api.API.BuyAsync(orderReqbuy); InsertDataBase(orderReqbuy, res); } }
/// <summary> /// 下单交易卖出 /// </summary> /// <param name="order"></param> /// <returns></returns> public static async Task <string> SellAsync(OrderReq order) { try { //TODO 验证传过来的数据是否有效 var requestUrl = TRADE_URL + SELL_URL; var form = new Dictionary <string, string>(); form.Add("currencyPair", order.CurrencyPair); form.Add("rate", order.Rate.ToString()); form.Add("amount", order.Amount.ToString()); var json = await PostReqAsync(requestUrl, form); var parse = JToken.Parse(json) as dynamic; if (parse.result == "true") { //返回的结果里只有orderNumber return(parse.orderNumber.ToString()); } else { var code = parse.code.ToString(); var message = parse.message.ToString(); throw new BotException(code, message); } } catch (JsonSerializationException) { throw new BotException("1002"); } catch (Exception ex) { throw new BotException("1000", ex.Message); } }
public SingleRsp CreateOrder(OrderReq req) { var res = new SingleRsp(); try { Order c = new Order(); c.OrderId = req.OrderId; c.OrderDate = req.OrderDate; c.OrderNumber = req.OrderNumber; c.CustomerId = req.CustomerId; c.OrderDescription = req.OrderDescription; // res = base.Create(c); res.Data = c; } catch (Exception ex) { res.SetError(ex.StackTrace); } return(res); }
public IActionResult UpdateBrandPatch(int id, OrderReq req) { var result = _svc.UpdateOrder(id, req); return(Ok(result)); }
public IActionResult CreateBrand(OrderReq req) { var result = _svc.CreateOrder(req); return(Ok(result)); }
public override void SendOrder(OrderReq req) { this.td.SendOrder(req); }