public async Task <int> AddOrderAsync(Order order)
{
var request = new HttpRequestMessage(HttpMethod.Post, ORDER_URL);
var result = await Invoke <OrderJson>(request, OrderJson.From(order));
return(result.OrderId);
}
public async Task <IActionResult> CreateOrder([FromBody] OrderJson json)
{
Order order = Order.From(json);
DbContext.Orders.Add(order);
DbContext.OrderDetails.AddRange(order.OrderDetails);
await DbContext.SaveChangesAsync();
return(new ObjectResult(OrderJson.From(order)));
}
public async Task <IActionResult> GetOrder([FromQuery] int id)
{
Order order = await DbContext.Orders
.Where(o => o.OrderId == id)
.Include(o => o.OrderDetails)
.FirstOrDefaultAsync();
if (order == null)
{
return(NotFound());
}
var result = OrderJson.From(order);
return(new ObjectResult(result));
}
public List <SuccessOrderOut> GetTakeListEx()
{
OrderJson order = ConfigFactory.GetConfig <OrderJson>() ?? new OrderJson();
List <SuccessOrderOut> so = new List <SuccessOrderOut>();
if (order != null && order.list.Count == 0)
{
return(so);
}
foreach (var item in order.list)
{
so.Add(new SuccessOrderOut()
{
ResponseOrder = item.ResponseOrder
});
}
return(so);
}
public string ToMe()
{
ApiResult result = new ApiResult();
try
{
var pager = new Pager();
var query = new SubSonic.Query.Select(provider).From <Order>().Where <Order>(x => x.Status == Enum_Status.Approved);
var CreateUserNumber = ZNRequest.GetString("CreateUserNumber");
var ToUserNumber = ZNRequest.GetString("ToUserNumber");
if (!string.IsNullOrWhiteSpace(CreateUserNumber))
{
query = query.And("CreateUserNumber").IsEqualTo(CreateUserNumber);
}
if (!string.IsNullOrWhiteSpace(ToUserNumber))
{
query = query.And("ToUserNumber").IsEqualTo(ToUserNumber);
}
var recordCount = query.GetRecordCount();
if (recordCount == 0)
{
result.message = new { records = 0, totalpage = 1 };
return(JsonConvert.SerializeObject(result));
}
var totalPage = recordCount % pager.Size == 0 ? recordCount / pager.Size : recordCount / pager.Size + 1;
var list = query.Paged(pager.Index, pager.Size).OrderDesc("ID").ExecuteTypedList <Order>();
//var fromarray = list.Select(x => x.CreateUserNumber).Distinct().ToList();
//var toarray = list.Select(x => x.ToUserNumber).Distinct().ToList();
//fromarray.AddRange(toarray);
//var allusers = new SubSonic.Query.Select(provider, "ID", "NickName", "Avatar", "Number").From<User>().And("Number").In(fromarray.ToArray()).ExecuteTypedList<User>();
List <OrderJson> newlist = new List <OrderJson>();
list.ForEach(x =>
{
var fromUser = db.Single <User>(y => y.Number == x.CreateUserNumber);
var toUser = db.Single <User>(y => y.Number == x.ToUserNumber);
//var fromUser = allusers.FirstOrDefault(y => y.Number == x.CreateUserNumber);
//var toUser = allusers.FirstOrDefault(y => y.Number == x.ToUserNumber);
OrderJson model = new OrderJson();
model.ID = x.ID;
model.CreateDate = x.CreateDate.ToString("yyyy-MM-dd hh:mm:ss");
model.Price = x.Price;
if (fromUser != null)
{
model.FromUserID = fromUser.ID;
model.FromUserNumber = fromUser.Number;
model.FromUserAvatar = fromUser.Avatar;
model.FromUserName = fromUser.NickName;
}
if (toUser != null)
{
model.ToUserID = toUser.ID;
model.ToUserNumber = toUser.Number;
model.ToUserAvatar = toUser.Avatar;
model.ToUserName = toUser.NickName;
}
newlist.Add(model);
});
result.result = true;
result.message = new
{
currpage = pager.Index,
records = recordCount,
totalpage = totalPage,
list = newlist
};
}
catch (Exception ex)
{
LogHelper.ErrorLoger.Error("Api_Order_All:" + ex.Message);
result.message = ex.Message;
}
return(JsonConvert.SerializeObject(result));
}
public bool UpdateEx(Order input)
{
OrderJson orderjson = ConfigFactory.GetConfig <OrderJson>() ?? new OrderJson();
List <SuccessOrder> list = orderjson.list;
if (list == null || list.Count == 0)
{
return(false);
}
SuccessOrder success = list.FirstOrDefault(r => r.ResponseOrder.out_biz_no == input.Out_trade_no);
var flag = false;
if (success != null)
{
ResponseOrder res = success.ResponseOrder;
TakeList takelist = takelistapp.Repository.GetWhere(r => r.Out_trade_no == res.out_biz_no).FirstOrDefault();
Order order = Repository.Get(res.oid);
if (order == null || order.Out_trade_no != input.Out_trade_no)
{
throw new MsgException("文件信息有误.");
}
if (order.IsSuccess != 0)
{
throw new MsgException("订单已经改写,不能覆盖.");
}
Account account = accountapp.Get(res.aid);
TipsFlow tf = tipsflowapp.Get(res.tfid);
if (tf == null || tf.IsActive == true)
{
throw new MsgException("手续费信息有误");
}
if (account == null)
{
throw new MsgException("找不到该资金账户");
}
using (var tran = new TransactionScope())
{
if (res.point >= 1)
{
UnitWork.RegisterNew(new PointDetail()
{
FromType = order.PayType, Money = order.Total_amount, CreateTime = DateTime.Now, IsActive = true, Point = res.point, StoreId = order.StoreNo, StoreName = takelist.StoreName, BuyerId = takelist.Account
});
}
UnitWork.RegisterDirty(tf, () => new TipsFlow {
IsActive = true
});
UnitWork.RegisterDirty(takelist, () => new TakeList {
State = 1
});
order.Gmt_payment = Convert.ToDateTime(res.pay_date);
order.Trade_status = res.code;
order.IsSuccess = 1;
order.Trade_no = res.order_id;
UnitWork.RegisterDirty <Order>(order);
account.Balance -= order.Total_amount;
account.TakeOut += order.Total_amount;
UnitWork.RegisterDirty <Account>(account);
UnitWork.Commit();
tran.Complete();
}
list.Remove(success);
//订单Json文件修改.
ConfigFactory.SetConfig <OrderJson>(orderjson);
flag = true;
}
else
{
throw new MsgException("未找到该订单信息");
}
return(flag);
}
public bool TiXian(Order order, TipsFlow tf, string accountnm, string storename, decimal balance, int aid, string accountid, decimal tips, decimal point, out string msg)
{
CompanyPay.AliPay ali = new CompanyPay.AliPay();
Aop.Api.Response.AlipayFundTransToaccountTransferResponse response = ali.GetCompanyPay(order.Out_trade_no, accountid, (order.Total_amount - tips).ToString(), storename, accountnm, order.Remark);
CompanyPay.LogHelper.WriteLine(Jayrock.Json.Conversion.JsonConvert.ExportToString(response));
CompanyPay.LogHelper.WriteLine(response.Body);
#region MyRegion
try
{
TakeList takelist = takelistapp.Repository.GetWhere(r => r.Out_trade_no == order.Out_trade_no).FirstOrDefault();
order = Repository.Get(order.Id);
if (response.Code == "10000")
{
Account account = accountapp.Get(aid);
if (account == null)
{
throw new Exception("找不到该资金账户");
}
using (var tran = new TransactionScope())
{
if (point >= 1)
{
UnitWork.RegisterNew(new PointDetail()
{
FromType = order.PayType, Money = order.Total_amount, CreateTime = DateTime.Now.ToLocalTime(), IsActive = true, Point = point, StoreId = order.StoreNo, StoreName = storename, BuyerId = accountid
});
}
UnitWork.RegisterDirty(tf, () => new TipsFlow {
IsActive = true
});
UnitWork.RegisterDirty(takelist, () => new TakeList {
State = 1
});
order.Gmt_payment = Convert.ToDateTime(response.PayDate);
order.Trade_status = response.Code;
order.IsSuccess = 1;
order.Trade_no = response.OrderId;
UnitWork.RegisterDirty <Order>(order);
account.Balance -= order.Total_amount;
account.TakeOut += order.Total_amount;
UnitWork.RegisterDirty <Account>(account);
UnitWork.Commit();
tran.Complete();
}
}
else
{ //失败
using (var tran = new TransactionScope())
{
UnitWork.RegisterDirty(takelist, () => new TakeList {
State = 2
});
UnitWork.RegisterDirty <Order>(order, () => new Order()
{
Gmt_payment = DateTime.Now,
Trade_status = response.Code,
IsSuccess = 2,
Remark = response.SubMsg + "【" + response.SubCode + "】",
});
UnitWork.Commit();
tran.Complete();
}
}
if (response.IsError)
{
msg = response.SubMsg;
return(false);
}
else
{
msg = response.Msg;
return(true);
}
}
catch (Exception)
{
//记录这笔成功订单 写入JSON
if (response.Code == "10000")
{
string orderstr = response.Body;
orderstr = orderstr.Substring(0, orderstr.LastIndexOf("sign") - 3).Replace("alipay_fund_trans_toaccount_transfer_response", "ResponseOrder");
orderstr += ",\"oid\":" + order.Id + ",\"tfid\":" + tf.Id + ",\"aid\":" + aid + ",\"point\":" + point + "}}";
OrderJson orderjson = ConfigFactory.GetConfig <OrderJson>();
SuccessOrder resOrder = Newtonsoft.Json.JsonConvert.DeserializeObject <SuccessOrder>(orderstr);
if (orderjson == null || orderjson.list == null)
{
orderjson = new OrderJson();
orderjson.list = new List <SuccessOrder>();
}
orderjson.list.Add(new SuccessOrder {
ResponseOrder = resOrder.ResponseOrder
});
ConfigFactory.SetConfig <OrderJson>(orderjson);
msg = "支付成功,订单有误";
}
else
{
msg = response.SubMsg;
}
return(false);
}
#endregion
}
