/// <summary>
/// 添加修改后的信息
/// </summary>
/// <param name="updateUserAssetRatioInfos"></param>
/// <returns></returns>
private bool InsertAssetUserRatioInfo(UpdateUserAssetRatioInfos updateUserAssetRatioInfos)
{
try
{
//判断是否存在
string sqlQuery = $"select count(*) from UpdateAssetUserRatioInfo where UserAssetRatioId='{updateUserAssetRatioInfos.UserAssetRatioId}'";
object count = SqlHelper.SqlHelper.ExecuteScalar(sqlQuery);
if (count == null)
{
return(false);
}
if ((int)count > 0)
{
return(true);
}
string sql = $"insert into UpdateAssetUserRatioInfo(UserId, DealAmount, AssetId,UserAssetRatioId,Capital,Numerator,OriginalUserAssetRatioId,Denominator)values('{updateUserAssetRatioInfos.UserId}',{updateUserAssetRatioInfos.DealAmount},'{updateUserAssetRatioInfos.AssetId}','{updateUserAssetRatioInfos.UserAssetRatioId}',{updateUserAssetRatioInfos.Capital},{updateUserAssetRatioInfos.Numerator},'{updateUserAssetRatioInfos.OriginalUserAssetRatioId}',{updateUserAssetRatioInfos.Denominator})";
return(SqlHelper.SqlHelper.ExecuteNoneQuery(sql) > 0);
}
catch (Exception e)
{
//记录失败插入的数据
Logger.LoadData(@"UD_UpdateAssetUserRation\UpdateUserAssetInfoError_" + updateUserAssetRatioInfos.UserAssetRatioId + ".txt", updateUserAssetRatioInfos.ToJson());
return(false);
}
}
