/// <summary>
/// 修改
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateRefundsMoney(RefundsMoneyInfo_Edit model)
{
if (model == null)
{
return(false);
}
const string SQL = @"Update RefundsMoney
Set BankName=@BankName,BankAccountNo=@BankAccountNo,UserName=@UserName,Remark=@Remark,
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,
BankName = model.BankName,
BankAccountNo = model.BankAccountNo,
UserName = model.UserName,
Remark = model.Remark,
Status = (int)RefundsMoneyStatusEnum.PendingCheck,
ModifyTime = DateTime.Now,
ModifyUser = model.ModifyUser,
});
return(result > 0);
}
}
public void TestMethod_Edit()
{
Init();
var model = new RefundsMoneyInfo_Edit()
{
ID = Guid.Parse("05852844-E829-4443-B354-0635076CA98D"),
BankAccountNo = "1",
BankName = "2",
UserName = "******",
Remark = "4",
ModifyUser = "******",
};
var result = _refundsMoneyDal.UpdateRefundsMoney(model);
Assert.IsNotNull(result);
}
