/// <summary>
/// 添加新RoleAuthMapping记录
/// </summary>
/// <param name="model">RoleAuthMapping实体对象</param>
/// <returns>新插入数据的id</returns>
public static int Insert(RoleAuthMapping model, SqlConnection conn = null, SqlTransaction transaction = null)
{
var sql = new StringBuilder();
sql.Append("INSERT INTO [RoleAuthMapping]([RoleId], [MenuId], [CreatedTime])");
sql.Append(" OUTPUT INSERTED.[Id] ");
sql.Append("VALUES(@RoleId, @MenuId, @CreatedTime)");
var ret = 0;
if (conn != null)
{
if (transaction == null)
{
throw new ArgumentNullException("transaction");
}
ret = conn.ExecuteScalar <int>(sql.ToString(), model, transaction);
}
else
{
using (var conn1 = GetOpenConnection())
{
ret = conn1.ExecuteScalar <int>(sql.ToString(), model);
}
}
return(ret);
}
/// <summary>
/// 更新RoleAuthMapping数据记录
/// </summary>
/// <param name="model">RoleAuthMapping实体对象</param>
/// <param name="fields">需要更新的字段名字</param>
/// <param name="reverse">反转给定的更新字段</param>
/// <returns>是否成功，true为成功</returns>
public static bool Update(RoleAuthMapping model, Expression <Func <RoleAuthMapping, bool> > predicate, SqlConnection conn, SqlTransaction transaction, params RoleAuthMappingColumn[] fields)
{
return(Update(
model: model,
predicate: predicate,
reverse: false,
conn: conn,
transaction: transaction,
fields: fields));
}
/// <summary>
/// 更新RoleAuthMapping数据记录
/// </summary>
/// <param name="model">RoleAuthMapping实体对象</param>
/// <param name="fields">需要更新的字段名字</param>
/// <param name="reverse">反转给定的更新字段</param>
/// <returns>是否成功，true为成功</returns>
public static bool Update(RoleAuthMapping model, Expression <Func <RoleAuthMapping, bool> > predicate, bool reverse, params RoleAuthMappingColumn[] fields)
{
return(Update(
model: model,
predicate: predicate,
reverse: reverse,
conn: null,
transaction: null,
fields: fields));
}
/// <summary>
/// 更新RoleAuthMapping数据记录
/// </summary>
/// <param name="model">RoleAuthMapping实体对象</param>
/// <param name="fields">需要更新的字段名字</param>
/// <param name="reverse">反转给定的更新字段</param>
/// <returns>是否成功，true为成功</returns>
public static bool Update(RoleAuthMapping model, bool reverse, SqlConnection conn, SqlTransaction transaction, params RoleAuthMappingColumn[] fields)
{
return(Update(
model: model,
predicate: null,
reverse: reverse,
conn: conn,
transaction: transaction,
fields: fields));
}
/// <summary>
/// 更新RoleAuthMapping数据记录
/// </summary>
/// <param name="model">RoleAuthMapping实体对象</param>
/// <param name="fields">需要更新的字段名字</param>
/// <param name="reverse">反转给定的更新字段</param>
/// <returns>是否成功，true为成功</returns>
public static bool Update(RoleAuthMapping model, params RoleAuthMappingColumn[] fields)
{
return(Update(
model: model,
predicate: null,
reverse: false,
conn: null,
transaction: null,
fields: fields));
}
/// <summary>
/// 获取指定的RoleAuthMapping实体对象
/// </summary>
/// <param name="Id">Id</param>
/// <returns>RoleAuthMapping实体</returns>
public static RoleAuthMapping GetModel(int Id)
{
var sql = new StringBuilder();
sql.Append("SELECT TOP 1 [Id], [RoleId], [MenuId], [CreatedTime] FROM [RoleAuthMapping] ");
sql.Append(" WHERE [Id]=@Id ");
RoleAuthMapping ret = null;
using (var conn = GetOpenConnection())
{
ret = conn.QueryFirstOrDefault <RoleAuthMapping>(sql.ToString(), new { @Id = Id });
}
return(ret);
}
/// <summary>
/// 获取指定的RoleAuthMapping实体对象
/// </summary>
public static RoleAuthMapping GetModel(Expression <Func <RoleAuthMapping, bool> > predicate)
{
var parser = new PredicateParser();
var where_str = parser.Parse(predicate);
var sql = new StringBuilder();
sql.Append("SELECT TOP 1 * FROM [RoleAuthMapping] ");
sql.Append(" WHERE " + where_str);
RoleAuthMapping ret = null;
using (var conn = GetOpenConnection())
{
ret = conn.QueryFirstOrDefault <RoleAuthMapping>(sql.ToString());
}
return(ret);
}
/// <summary>
/// 更新RoleAuthMapping数据记录
/// </summary>
/// <param name="model">RoleAuthMapping实体对象</param>
/// <param name="fields">需要更新的字段名字</param>
/// <param name="reverse">反转给定的更新字段</param>
/// <returns>是否成功，true为成功</returns>
public static bool Update(RoleAuthMapping model, Expression <Func <RoleAuthMapping, bool> > predicate, bool reverse, SqlConnection conn, SqlTransaction transaction, params RoleAuthMappingColumn[] fields)
{
var where_str = string.Empty;
if (predicate != null)
{
var parser = new PredicateParser();
where_str = parser.Parse(predicate);
}
else
{
where_str = "[Id] = @Id";
}
var sql = new StringBuilder();
sql.Append("UPDATE [RoleAuthMapping]");
if (fields == null || fields.Length == 0)
{
sql.Append(" SET [RoleId] = @RoleId, [MenuId] = @MenuId, [CreatedTime] = @CreatedTime");
}
else
{
if (reverse == true)
{
fields = (RoleAuthMappingColumn[])Columns.All.Except(fields);
}
sql.Append(" SET ");
for (int i = 0; i < fields.Length; i++)
{
if (fields[i].IsAddEqual)
{
sql.Append("[" + fields[i].Name + "] += @" + fields[i].Name + "");
fields[i].SetAddEqual();
}
else
{
sql.Append("[" + fields[i].Name + "] = @" + fields[i].Name + "");
}
if (i != fields.Length - 1)
{
sql.Append(",");
}
}
}
sql.Append(" WHERE " + where_str);
var ret = false;
if (conn != null)
{
if (transaction == null)
{
throw new ArgumentNullException("transaction");
}
ret = conn.Execute(sql.ToString(), model, transaction) > 0;
}
else
{
using (var conn1 = GetOpenConnection())
{
ret = conn1.Execute(sql.ToString(), model) > 0;
}
}
return(ret);
}
