public static DataTable GetAssociated(PlanRecordKeeper planRecordKeeper)
        {
            string sql = @"SELECT * FROM " + _tableName + " WHERE PlanRecordKeeperId = '" + planRecordKeeper.Id + "'";

            return(Access.VspDbAccess.ExecuteSqlQuery(sql));
        }
Exemple #2
0
        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));
        }