public void AddAuth(AgentAuthorizeAction auth, IEnumerable<Role> roles)
{
DaAgentAuth.ExecuteWithTransaction(() =>
{
DaAuthInRole.Tandem(DaAgentAuth);
DaAgentAuth.Insert(auth);
foreach (var role in roles)
DaAuthInRole.Insert(auth, role);
});
}
public void Insert(AgentAuthorizeAction auth)
{
string sql = string.Format(@"INSERT INTO {0} ({1},{2},{3},{4},{5}) VALUES(@{1},@{2},@{3},@{4},@{5}) SELECT SCOPE_IDENTITY()",
AgentAuthorizeAction.TableName, AgentAuthorizeAction.NAME, AgentAuthorizeAction.CONTROLLER, AgentAuthorizeAction.ACTION,
AgentAuthorizeAction.METHODSIGN, AgentAuthorizeAction.DEFAULTSTATE);
object id = base.ExecuteScalar(sql, new SqlParameter(AgentAuthorizeAction.NAME, auth.Name),
new SqlParameter(AgentAuthorizeAction.CONTROLLER, auth.Controller),
new SqlParameter(AgentAuthorizeAction.ACTION, auth.Action),
new SqlParameter(AgentAuthorizeAction.METHODSIGN, auth.MethodSign),
new SqlParameter(AgentAuthorizeAction.DEFAULTSTATE, auth.DefaultState));
auth.AuthorizeId = Convert.ToInt32(id);
}
public void Update(AgentAuthorizeAction auth)
{
string sql = string.Format(@"UPDATE {0} SET {1}=@{1},{2}=@{2},{3}=@{3},{4}=@{4},{5}=@{5} WHERE {6}=@{6}",
AgentAuthorizeAction.TableName, AgentAuthorizeAction.NAME, AgentAuthorizeAction.CONTROLLER, AgentAuthorizeAction.ACTION,
AgentAuthorizeAction.METHODSIGN, AgentAuthorizeAction.DEFAULTSTATE, AgentAuthorizeAction.AUTHORIZEID);
base.ExecuteNonQuery(sql, new SqlParameter(AgentAuthorizeAction.NAME, auth.Name),
new SqlParameter(AgentAuthorizeAction.CONTROLLER, auth.Controller),
new SqlParameter(AgentAuthorizeAction.ACTION, auth.Action),
new SqlParameter(AgentAuthorizeAction.METHODSIGN, auth.MethodSign),
new SqlParameter(AgentAuthorizeAction.DEFAULTSTATE, auth.DefaultState),
new SqlParameter(AgentAuthorizeAction.AUTHORIZEID, auth.AuthorizeId));
}
public void Insert(AgentAuthorizeAction authAction, Role role)
{
string sql = string.Format(@"INSERT INTO {0} ({1},{2}) VALUES (@{1},@{2})", AgentAuthorizeInRole.TableName, AgentAuthorizeInRole.AUTHORIZEID, AgentAuthorizeInRole.ROLEID);
base.ExecuteNonQuery(sql, new SqlParameter(AgentAuthorizeInRole.AUTHORIZEID, authAction.AuthorizeId),
new SqlParameter(AgentAuthorizeInRole.ROLEID, (int)role));
}
