/// <summary>更新一条数据
///
/// </summary>
public bool Update(WebSite20210103IP登入限制.Model.SYSAA model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update [SYSAA] set ");
strSql.Append("[AA002]=@AA002, [AA003]=@AA003 ");
strSql.Append(" where AA001=@AA001 ");
using (var connection = ConnectionFactory.GetOpenConnection())
{
int i = connection.Execute(strSql.ToString(), model);
return(i > 0);
}
}
/// <summary>得到一个对象实体
///
/// </summary>
public WebSite20210103IP登入限制.Model.SYSAA GetModel(int AA001)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from [SYSAA] ");
strSql.Append(" where AA001=@AA001 ");
WebSite20210103IP登入限制.Model.SYSAA model = null;
using (var connection = ConnectionFactory.GetOpenConnection())
{
model = connection.Query <WebSite20210103IP登入限制.Model.SYSAA>(strSql.ToString(), new { AA001 = AA001 }).SingleOrDefault();
}
return(model);
}
/// <summary>增加一条数据
///
/// </summary>
public int Add(WebSite20210103IP登入限制.Model.SYSAA model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [SYSAA](");
strSql.Append("[AA002], [AA003] )");
strSql.Append(" values (");
strSql.Append("@AA002, @AA003 );select @@identity;");
using (var connection = ConnectionFactory.GetOpenConnection())
{
int i = connection.Query <int>(strSql.ToString(), model).SingleOrDefault();;
return(i);
}
}
/// <summary>根据条件得到一个对象实体
///
/// </summary>
public WebSite20210103IP登入限制.Model.SYSAA GetModelByCond(string cond)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from [SYSAA] ");
if (!string.IsNullOrEmpty(cond))
{
strSql.Append(" where " + cond);
}
WebSite20210103IP登入限制.Model.SYSAA model = null;
using (var connection = ConnectionFactory.GetOpenConnection())
{
model = connection.Query <WebSite20210103IP登入限制.Model.SYSAA>(strSql.ToString()).SingleOrDefault();
}
return(model);
}
