/// <summary>
/// 移出群組
/// </summary>
/// <param name="list"></param>
public void moveUserRelative(TbUserAuthRelativeData model)
{
string sql = getDeleteSql("TbUserAuthRelativeDataSqlProvider", "deleteTableUserAuth");
object parameterObj = new
{
USER_ID = model.USER_ID,
RELATIVE_USER_ID = model.RELATIVE_USER_ID,
};
ExecuteTableBySql(sql, parameterObj);
}
/// <summary>
/// 移入群組
/// </summary>
/// <param name="model"></param>
public void addUserRelative(TbUserAuthRelativeData model)
{
string sql = getInsertSql("TbUserAuthRelativeDataSqlProvider", "insertTableUserAuth");
object parameterObj = new
{
USER_ID = model.USER_ID,
RELATIVE_USER_ID = model.RELATIVE_USER_ID,
NODE = model.NODE,
CR_IP = model.CR_IP,
CR_USER = model.CR_USER,
UP_IP = model.CR_IP
};
ExecuteTableBySql(sql, parameterObj);
}
public void addUserRelative(TbUserAuthRelativeData model)
{
using (SqlConnection dbConn = new SqlConnection(DbConnection.connString)){
dbConn.Open();
SqlTransaction dbConnTxn = dbConn.BeginTransaction();
try
{
dao.dbConn = dbConn;
dao.dbConnTxn = dbConnTxn;
dao.addUserRelative(model);
dbConnTxn.Commit();
}
catch (Exception e)
{
dbConnTxn.Rollback();
logger.Error(e, e.Message);
}
}
}
