/// <summary>
/// web 账户充值(第三方充值成功)
/// </summary>
/// <param name="PaymentOrderID"></param>
/// <returns></returns>
public ResultModel AccountRechargeWeb(string PaymentOrderID, string outOrderId)
{
var result = new ResultModel();
SearchAccountRechargeModel sarmodle = new SearchAccountRechargeModel();
sarmodle.PagedIndex = 0;
sarmodle.PagedSize = 10;
sarmodle.PaymentOrderID = PaymentOrderID;
result = _zjUserBalanceServiceWeb.Select(sarmodle);
List <ZJ_RechargeOrderModel> zjmodel = new List <ZJ_RechargeOrderModel>();
zjmodel = result.Data;
AccountRechargeModel arModel = new AccountRechargeModel();
if (zjmodel != null && zjmodel.Count > 0)
{
arModel.Account = zjmodel[0].Account;
arModel.AddOrCutAmount = zjmodel[0].RechargeAmount;
arModel.AddOrCutType = 1;//充值类型 1充值
arModel.OrderNo = zjmodel[0].OrderNO;
arModel.OrderSource = zjmodel[0].OrderSource;
arModel.PaymentOrderID = zjmodel[0].PaymentOrderID;
arModel.RechargeChannel = zjmodel[0].RechargeChannel;
arModel.UserID = zjmodel[0].UserID;
arModel.outOrderId = outOrderId;
result = AccountRechargeWeb(arModel);
}
return(result);
}
/// <summary>
/// 用户充值订单表查询
/// </summary>
/// <param name="model">输入查询参数对象</param>
/// <returns></returns>
/// <remarks>wuyf 2015-7-22</remarks>
public ResultModel Select(SearchAccountRechargeModel model)
{
var paymentOrder = _database.Db.PaymentOrder;
var paymentOrder_Orders = _database.Db.PaymentOrder_Orders;
var _zjRechargeOrder = _database.Db.ZJ_RechargeOrder;
var user = _database.Db.YH_User;
dynamic po;
dynamic u;
//查询参数条件
var whereParam = new SimpleExpression(1, 1, SimpleExpressionType.Equal);
//订单号
if (model.OrderNo != null && !string.IsNullOrEmpty(model.OrderNo.Trim()))
{
whereParam = new SimpleExpression(whereParam, paymentOrder_Orders.OrderID == model.OrderNo, SimpleExpressionType.And);
}
//支付编号
if (model.PaymentOrderID != null && !string.IsNullOrEmpty(model.PaymentOrderID.Trim()))
{
whereParam = new SimpleExpression(whereParam, paymentOrder_Orders.PaymentOrderID == model.PaymentOrderID, SimpleExpressionType.And);
}
var query = _zjRechargeOrder
.Query()
.LeftJoin(paymentOrder_Orders, out po).On(po.OrderID == _zjRechargeOrder.OrderNo).
LeftJoin(user, out u).On(u.UserID == _zjRechargeOrder.UserID).
Select(
_zjRechargeOrder.OrderNO,
_zjRechargeOrder.UserID,
_zjRechargeOrder.RechargeChannel,
_zjRechargeOrder.RechargeAmount,
_zjRechargeOrder.RechargeDT,
_zjRechargeOrder.RechargeResult,
_zjRechargeOrder.CreateDT,
_zjRechargeOrder.IsDisplay,
_zjRechargeOrder.OrderSource,
po.PaymentOrderID,
u.Account
).Where(whereParam)
.OrderByCreateDT();
var result = new ResultModel()
{
Data = new SimpleDataPagedList <ZJ_RechargeOrderModel>(query,
model.PagedIndex, model.PagedSize)
};
return(result);
}
