/// <summary>
/// 打款
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool ApprovalPaymentSubsidyPayment(SubsidyPaymentInfo_Payment model)
{
if (model == null)
{
return(false);
}
const string SQL = @"Update SubsidyPayment
Set AccountID=@AccountID,Fees=@Fees,TransactionNumber=@TransactionNumber,RejectReason=@RejectReason,
Status=@Status,ModifyTime=@ModifyTime,ModifyUser=@ModifyUser
where ID=@ID";
using (SqlConnection conn = Databases.GetSqlConnection(GlobalConfig.ERP_DB_NAME, false))
{
int result = conn.Execute(SQL, new
{
ID = model.ID,
AccountID = model.AccountID,
Fees = model.Fees,
TransactionNumber = model.TransactionNumber,
RejectReason = model.RejectReason,
Status = model.IsPayment ? (int)SubsidyPaymentStatusEnum.HadPayment : (int)SubsidyPaymentStatusEnum.Rejected,
ModifyTime = DateTime.Now,
ModifyUser = model.ModifyUser,
});
return(result > 0);
}
}
public void TestMethod_Payment()
{
Init();
var model = new SubsidyPaymentInfo_Payment()
{
ID = Guid.Parse("C03D601C-C007-4706-A4F6-763DE5241940"),
AccountID = Guid.Parse("7175FA90-1214-46E7-8D15-F9053E16928C"),
Fees = 3.33m,
TransactionNumber = "这是交易号",
IsPayment = true,
ModifyUser = "******",
RejectReason = "通过"
};
var result = _SubsidyPaymentDal.ApprovalPaymentSubsidyPayment(model);
Assert.IsNotNull(result);
}
/// <summary>
/// 审核
/// </summary>
private bool SaveData(bool IsPayment)
{
SubsidyPaymentInfo_Payment model = new SubsidyPaymentInfo_Payment()
{
ID = ApplyId,
AccountID = RCB_AccountID.SelectedValue.StrToGuid(),
Fees = txt_Fees.Text.StrToDecimal(),
TransactionNumber = txt_TransactionNumber.Text,
RejectReason = txt_RejectReason.Text,
IsPayment = IsPayment,
ModifyUser = Personnel.RealName,
};
bool result = _subsidyPaymentSerivce.ApprovalPaymentSubsidyPayment(model);
return(result);
}
public bool ApprovalPaymentSubsidyPayment(SubsidyPaymentInfo_Payment model)
{
return(_subsidyPaymentDal.ApprovalPaymentSubsidyPayment(model));
}
