public void Update()
{
Db_Table1 model = new Db_Table1()
{
Id = 1112, name = "rose1111"
};
Assert.IsTrue(tBLL.Update(model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Db_Table1 model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("UPDATE Table1 set ");
strSql.Append(" Id = @Id , ");
strSql.Append(" name = @name ");
strSql.Append(" WHERE Id=@Id ");
return(DapperHelper.Excute(strSql.ToString(), model) > 0);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Db_Table1 model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("INSERT INTO Table1(");
strSql.Append("Id,name");
strSql.Append(") OUTPUT INSERTED.ID VALUES (");
strSql.Append("@Id,@name");
strSql.Append(") ");
//var newClass = new
//{
// Id = model.Id,
// name = model.name
//};
return((int)DapperHelper.ExecuteScalar(strSql.ToString(), model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Db_Table1 model)
{
return(dal.Update(model));
}
/// <summary>
/// 添加一条数据
/// </summary>
public int Add(Db_Table1 model)
{
return(dal.Add(model));
}
