public void TestMethod_Add()
{
Init();
var model = new SubsidyPaymentInfo_Add()
{
ID = Guid.NewGuid(),
CreateUser = "******",
OrderNumber = "订单号111",
SaleFilialeId = Guid.Parse("43609645-97dd-4ae4-989d-f3c867969a99"),
SalePlatformId = Guid.Parse("443a404a-91a2-409e-9b47-10af5489c360"),
ThirdPartyAccountName = "第三方账户222",
ThirdPartyOrderNumber = "ddd",
BankAccountNo = "账户2",
OrderAmount = 33,
SubsidyAmount = 2,
BankName = "aa",
QuestionType = Guid.NewGuid(),
QuestionName = "运费补贴",
Remark = "备注",
SubsidyType = (int)SubsidyTypeEnum.Compensate,
UserName = "******",
};
var result = _SubsidyPaymentDal.AddSubsidyPayment(model);
Assert.IsNotNull(result);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddSubsidyPayment(SubsidyPaymentInfo_Add model)
{
if (model == null)
{
return(false);
}
const string SQL = @"INSERT INTO SubsidyPayment
(ID,OrderNumber,ThirdPartyOrderNumber,ThirdPartyAccountName,SalePlatformId,SaleFilialeId,OrderAmount,SubsidyAmount,SubsidyType,QuestionType,QuestionName,
BankName,BankAccountNo,UserName,Remark,
Status,CreateTime,CreateUser,IsDelete,ModifyTime,ModifyUser)
VALUES(@ID,@OrderNumber,@ThirdPartyOrderNumber,@ThirdPartyAccountName,@SalePlatformId,@SaleFilialeId,@OrderAmount,@SubsidyAmount,@SubsidyType,@QuestionType,@QuestionName,
@BankName,@BankAccountNo,@UserName,@Remark,
@Status,@CreateTime,@CreateUser,@IsDelete,@ModifyTime,@ModifyUser)";
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,
ThirdPartyAccountName = model.ThirdPartyAccountName,
SalePlatformId = model.SalePlatformId,
SaleFilialeId = model.SaleFilialeId,
OrderAmount = model.OrderAmount,
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,
CreateTime = DateTime.Now,
CreateUser = model.CreateUser,
IsDelete = false,
ModifyTime = DateTime.Now,
ModifyUser = model.CreateUser,
});
return(result > 0);
}
}
