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