/// <summary>
/// 插入一条数据
/// </summary>
/// <returns></returns>
private bool InsertUserAssetRatio(CgYemOrderInfo cgYemOrderInfo, OnSellAssetInfo onSellAssetInfo)
{
string cgOrderId = cgYemOrderInfo.ORDER_NO;
try
{
//DeductedAmount,AddAmount,DiffDays,Comment
long orgAmount = cgYemOrderInfo.ORG_AMOUNT; //本金 Numerator denominator
long numerator = this.GetFenziAmount(cgOrderId, orgAmount, onSellAssetInfo.PresentValue, onSellAssetInfo.CalculatedAmount, onSellAssetInfo.OnSellAssetId); //分子
string userId = cgYemOrderInfo.PAY_USER_OUT_ID;
string originalUserAssetRatioId = cgYemOrderInfo.SOURCE_ORDER_ID;
if (string.IsNullOrEmpty(originalUserAssetRatioId))
{
originalUserAssetRatioId = cgOrderId;
}
int status = 4;
if (originalUserAssetRatioId != cgOrderId)
{
status = 2;
}
YemUserOrderInfo yemUserOrderInfo = this.GetYemUserOrderInfo(userId, cgOrderId, onSellAssetInfo.OnSellAssetId);
if (yemUserOrderInfo == null)
{
return(false);
}
string sql = $"insert into {this.tableName}(UserAssetRatioId,UserId,UserName,AssetId,Numerator,Denominator,UserPresentValue,Status,Reserve,UpdatedBy,UpdatedTime,CreatedBy,CreatedTime,IsDeleted,OrderId,OrderTime,IsReturned,BillDueDate,AssetCategoryCode,Capital,Cellphone,CredentialNo,IsInvestSuccess,IsNotifyTradingSuccess,NotifyTradingRespInfo,NotifyTradingTime,OriginalUserAssetRatioId,PurchaseMoney)values('{cgOrderId}','{yemUserOrderInfo.UserId}','{yemUserOrderInfo.UserName}','{onSellAssetInfo.OnSellAssetId}',{numerator},{onSellAssetInfo.PresentValue},{0},{status},{1},'System','{DateTime.UtcNow.ToChinaStandardTime()}','System','{DateTime.UtcNow.ToChinaStandardTime()}',{0},'{yemUserOrderInfo.OrderId}','{yemUserOrderInfo.OrderTime}',{0},'{onSellAssetInfo.BillDueDate}',{onSellAssetInfo.AssetCategoryCode},{orgAmount},'{yemUserOrderInfo.Cellphone}','{yemUserOrderInfo.CredentialNo}',{1},{1},'与银行同步','{DateTime.UtcNow.ToChinaStandardTime()}','{originalUserAssetRatioId}',{yemUserOrderInfo.PurchaseMoney})";
bool result = SqlHelper.SqlHelper.ExecuteNoneQuery(sql) > 0;
return(result);
}
catch (Exception ex)
{
Logger.LoadData(@"UdpateCgBankOrders\Error_" + onSellAssetInfo.OnSellAssetId + ".txt", $"插入比例信息异常orderId{cgOrderId}-----错误信息：{ex.Message}+--------" + ex.StackTrace);
return(false);
}
}
private YemUserOrderInfo GetYemUserOrderInfo(string userId, string orderid, string bidid)
{
try
{
YemUserOrderInfo yemUserOrderInfo = this.yemUserOrderInfos.FirstOrDefault(x => x.UserId == userId);
if (yemUserOrderInfo != null)
{
return(yemUserOrderInfo);
}
string sql = $"select top 1 UserId,UserName,CellPhone,PurchaseMoney,OrderId,OrderTime,SequenceNo,CredentialNo from YEMUserProducts where UserId ='{userId}'";
DataTable yemuserOrder = SqlHelper.SqlHelper.Query(sql, null, false);
if (yemuserOrder.Rows.Count == 0)
{
return(null);
}
DataRow dr = yemuserOrder.Rows[0];
yemUserOrderInfo = new YemUserOrderInfo
{
Cellphone = dr["Cellphone"].ToString(),
CredentialNo = dr["CredentialNo"].ToString(),
OrderId = dr["OrderId"].ToString(),
OrderTime = Convert.ToDateTime(dr["OrderTime"]),
PurchaseMoney = Convert.ToInt64(dr["PurchaseMoney"]),
SequenceNo = dr["SequenceNo"].ToString(),
UserId = dr["UserId"].ToString(),
UserName = dr["UserName"].ToString()
};
this.yemUserOrderInfos.Add(yemUserOrderInfo);
return(yemUserOrderInfo);
}
catch (Exception ex)
{
Logger.LoadData(@"UdpateCgBankOrders\Error_" + bidid + ".txt", $"orderId{orderid}: 获取用户订单信息异常userId{userId}-----错误信息：{ex.Message}+--------" + ex.StackTrace);
return(null);
}
}
