public void TestMethod_Edit() { Init(); var model = new SubsidyPaymentInfo_Edit() { ID = Guid.Parse("C03D601C-C007-4706-A4F6-763DE5241940"), BankAccountNo = "1", BankName = "2", UserName = "******", Remark = "4", OrderNumber = "5", QuestionType = Guid.NewGuid(), QuestionName = "运费补贴", SubsidyAmount = 6.66m, SubsidyType = (int)SubsidyTypeEnum.Compensate, ThirdPartyOrderNumber = "234", ModifyUser = "******", }; var result = _SubsidyPaymentDal.UpdateSubsidyPayment(model); Assert.IsNotNull(result); }
/// <summary> /// 修改 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateSubsidyPayment(SubsidyPaymentInfo_Edit model) { if (model == null) { return(false); } const string SQL = @"Update SubsidyPayment Set OrderNumber=@OrderNumber,ThirdPartyOrderNumber=@ThirdPartyOrderNumber,SubsidyAmount=@SubsidyAmount,SubsidyType=@SubsidyType,QuestionType=@QuestionType,QuestionName=@QuestionName, 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, OrderNumber = model.OrderNumber, ThirdPartyOrderNumber = model.ThirdPartyOrderNumber, SubsidyAmount = model.SubsidyAmount, SubsidyType = model.SubsidyType, QuestionType = model.QuestionType, QuestionName = model.QuestionName, BankName = model.BankName, BankAccountNo = model.BankAccountNo, UserName = model.UserName, Remark = model.Remark, Status = (int)SubsidyPaymentStatusEnum.PendingCheck, ModifyTime = DateTime.Now, ModifyUser = model.ModifyUser, }); return(result > 0); } }