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