public async Task <IEnumerable <IndexModel> > GetChildrenWithName(string connectionString, string indexNode, string name) { string sql = $"SELECT DATANAME FROM pdo_qc_index WHERE IndexNode.IsDescendantOf('{indexNode}') = 1 and DATANAME = '{name}'"; IEnumerable <IndexModel> result = await _dp.ReadData <IndexModel>(sql, connectionString); return(result); }
public Task <IEnumerable <RuleModel> > GetRules(string sql, string connectionString) => _dp.ReadData <RuleModel>(sql, connectionString);