/// <summary>
/// 添加 Customer
/// </summary>
public bool CustomerInsert(Customer model)
{
string sql = @"
INSERT INTO Customer
(
Id,CustomerName,AddTime,IsDelete,CustomerLevel,
PhoneNo,Token,VipPrice,Remark
)
VALUES
(
@Id,@CustomerName,@AddTime,@IsDelete,@CustomerLevel,
@PhoneNo,@Token,@VipPrice,@Remark
)
";
DynamicParameters param = new DynamicParameters();
param.Add("@Id", model.Id, DbType.Guid);
param.Add("@CustomerName", model.CustomerName, DbType.String);
param.Add("@AddTime", model.AddTime, DbType.DateTime);
param.Add("@IsDelete", model.IsDelete, DbType.Boolean);
param.Add("@CustomerLevel", model.CustomerLevel, DbType.Byte);
param.Add("@PhoneNo", model.PhoneNo, DbType.String);
param.Add("@Token", model.Token, DbType.String);
param.Add("@VipPrice", model.VipPrice, DbType.Double);
param.Add("@Remark", model.Remark, DbType.String);
var result = DataBaseAccessCommand.ExecuteCommand(sql, param);
return result < 0 ? false : true;
}
public void TestMethod_Update()
{
Customer model = new Customer();
model.Id = Guid.Parse("a8097724-fabe-4431-b4ec-56364f207b78");
model.CustomerName = "rose";
model.PhoneNo = "13147306612";
var result = dal.CustomerUpdate(model);
Assert.IsTrue(result);
}
public void TestMethod_Insert()
{
Customer model = new Customer()
{
Id = Guid.NewGuid(),
AddTime = DateTime.Now,
CustomerLevel = 1,
CustomerName = "ROSE",
IsDelete = false,
PhoneNo = "17727510587",
VipPrice = 10.5,
Token = Guid.NewGuid().ToString(),
Remark = "测试"
};
var result = dal.CustomerInsert(model);
Assert.IsTrue(result);
}
/// <summary>
/// 修改 Customer
/// </summary>
public bool CustomerUpdate(Customer model)
{
string sql = @"
UPDATE Customer
SET CustomerName=@CustomerName,PhoneNo=@PhoneNo,AddTime=@AddTime,Remark=@Remark
WHERE Id=@Id
";
DynamicParameters param = new DynamicParameters();
param.Add("@Id", model.Id, DbType.Guid);
param.Add("@CustomerName", model.CustomerName, DbType.String);
param.Add("@PhoneNo", model.PhoneNo, DbType.String);
param.Add("@AddTime", DateTime.Now, DbType.DateTime);
param.Add("@Remark", "测试修改", DbType.String);
var result = DataBaseAccessCommand.ExecuteCommand(sql, param);
return result < 0 ? false : true;
}