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);
}
