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)); }