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