/// <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()); } } }