public static DataTable GetAssociated(PlanRecordKeeper planRecordKeeper) { string sql = @"SELECT * FROM " + _tableName + " WHERE PlanRecordKeeperId = '" + planRecordKeeper.Id + "'"; return(Access.VspDbAccess.ExecuteSqlQuery(sql)); }
public static DataTable GetAssociatedInactive(PlanRecordKeeper planRK) { string sql = @"SELECT * FROM " + _tableName + " WHERE StateCode = 1 AND PlanId = \'" + planRK.PlanId.ToString() + "\' AND RecordKeeperId = \'" + planRK.RecordKeeperId + "\'"; return(Access.VspDbAccess.ExecuteSqlQuery(sql)); }