/// <summary>
/// 退款成功后，删除营收数据
/// </summary>
/// <param name="transaction_id">微信流水号</param>
/// <returns></returns>
public bool Delete(string transaction_id)
{
using (var db = SugarDao_AliPaySql.GetInstance())
{
return(db.Delete <ThirdPartyPublicPlatformPayment>(i => i.SerialNumber == transaction_id));
}
}
/// <summary>
/// 插入或者更新营收数据库表中的数据信息
/// </summary>
/// <param name="paymentHistoryInfo">付款信息</param>
/// <param name="personInfo">人员信息</param>
/// <returns>返回cheng</returns>
public bool InsertOrUpdateRevenue(Business_PaymentHistory_Information paymentHistoryInfo, Business_Personnel_Information personInfo, ref int revenueStatus)
{
using (var db = SugarDao_AliPaySql.GetInstance())
{
try
{
bool isExist = db.Queryable <ThirdPartyPublicPlatformPayment>().Any(i => i.SerialNumber == paymentHistoryInfo.TransactionID);
var driverInfo = GetDriverInfo(personInfo); //获取司机信息
revenueStatus = driverInfo.License == null ? 2 : 1;
if (isExist) //存在就更新，不存在则插入
{
db.Update <ThirdPartyPublicPlatformPayment>(new
{
DriverServiceNum = driverInfo.OperationNo,
CarNo = driverInfo.License == null ? null : driverInfo.License.TrimStart('沪'),
UnitCode = driverInfo.UnitCode,
Identifier = driverInfo.License == null ? 2 : 0,
}, i => i.SerialNumber == paymentHistoryInfo.TransactionID);
}
else
{
var id = db.Queryable <ThirdPartyPublicPlatformPayment>().Max(it => it.Id).ObjToInt();
var model = new ThirdPartyPublicPlatformPayment
{
Id = id + 1,
SerialNumber = paymentHistoryInfo.TransactionID,
PaymentDate = paymentHistoryInfo.PayDate,
PaymentAmount = paymentHistoryInfo.PaymentAmount,
PaymentSource = "1", //1-微信企业号
PaymentType = "1", //1-微信
CheckOutDate = paymentHistoryInfo.PayDate.AddHours(24),
Identifier = driverInfo.License == null ? 2 : 0,
DriverName = personInfo.Name,
DriverPhoneNum = personInfo.PhoneNumber,
DriverServiceNum = driverInfo.OperationNo,
CarNo = driverInfo.License == null ? null : driverInfo.License.TrimStart('沪'),
UnitCode = driverInfo.UnitCode
};
db.Insert(model, false);
}
return(true);
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
}
}
/// <summary>
/// 添加支付信息到AliPay表中
/// </summary>
/// <param name="paymentHistoryInfo">支付信息</param>
/// <param name="personInfo">人员信息</param>
/// <param name="revenueStatus"></param>
/// <returns></returns>
public bool AddRevenuePayInfo(Business_PaymentHistory_Information paymentHistoryInfo, Business_Personnel_Information personInfo, ref int revenueStatus)
{
using (var db = SugarDao_AliPaySql.GetInstance())
{
try
{
int id = db.Queryable <ThirdPartyPublicPlatformPayment>().Max(it => it.Id).ObjToInt();
var driverInfo = GetDriverInfo(personInfo);
revenueStatus = driverInfo.License == null ? 2 : 1;
var model = new ThirdPartyPublicPlatformPayment()
{
Id = id + 1,
SerialNumber = paymentHistoryInfo.TransactionID,
PaymentDate = paymentHistoryInfo.PayDate,
PaymentAmount = paymentHistoryInfo.PaymentAmount,
PaymentSource = "1", //1-微信企业号
PaymentType = "1", //1-微信
CheckOutDate = paymentHistoryInfo.PayDate.AddHours(24),
Identifier = driverInfo.License == null ? 2 : 0,
DriverName = personInfo.Name,
DriverPhoneNum = personInfo.PhoneNumber,
DriverServiceNum = driverInfo.OperationNo,
CarNo = driverInfo.License == null ? null : driverInfo.License.TrimStart('沪'),
UnitCode = driverInfo.UnitCode
};
db.Insert(model, false);
return(true);
}
catch (Exception ex)
{
LogHelper.WriteLog(ex.ToString());
return(false);
// throw new Exception(ex.ToString());
}
}
}
