public int InsertRecord(wy_pay_record record)
{
return(DBAble <int>((db) =>
{
return db.Insertable(record).ExecuteCommand();
}));
}
private bool InsertPayRecord(wy_wx_pay Order)
{
_log.LogInformation($"【InsertPayRecord】准备插入新增支付记录:{Order.ID}");
if (Order.RECORD_ID.Trim() == "0") //自主缴费
{
var record = new wy_pay_record()
{
RECORD_ID = Order.ID,
JFLX = Order.FEE_TYPES.ToString(),
FWID = Order.HOUSE_ID,
JFJE = (Order.TOTAL_FEE / 100.00),
JFZT = 1,
SFTZ = 1,
JFRQ = Order.PAY_TIME,
PAY_WAY = 1,
SURPLUSVALUE = GetSurplus(Order.FEE_TYPES, Order.TYPES_ID, Order.TYPES_ID_ELE_COLL),
CREATE_TIME = Order.CREATE_TIME,
CZ_SHID = Order.USER_ID,
OPEN_ID = Order.OPEN_ID,
CONFIRM_RECIVEMONEY = 0,
JFCS = 0
};
var Res = _order.InsertRecord(record) > 0;
if (Res)
{
_log.LogInformation($"【InsertPayRecord】插入新增支付成功:{Order.ID}");
}
else
{
_log.LogError($"【InsertPayRecord】插入新增支付失败:{Order.ID}");
}
}
return(true);
}
public int UpdateRecoredJFZT(wy_pay_record record)
{
return(DBAble <int>((db) => {
if (record.JFLX == "0") //物业费不更新金额
{
return db.Updateable(record).UpdateColumns(s => new { s.RECORD_ID, s.JFZT, s.JFRQ, s.PAY_WAY })
.WhereColumns(it => new { it.RECORD_ID })
.ExecuteCommand();
}
return db.Updateable(record).UpdateColumns(s => new { s.RECORD_ID, s.JFZT, s.JFRQ, s.PAY_WAY, s.JFJE })
.WhereColumns(it => new { it.RECORD_ID })
.ExecuteCommand();
}));
}
