Ejemplos de VSP.Business.Entities PlanRecordKeeper en C# (CSharp)

Ejemplo n.º 1

Archivo: PlanRecordKeeperService.cs Proyecto: Tymojamama/pci-vendor-services-program-desktop

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

            return(Access.VspDbAccess.ExecuteSqlQuery(sql));
        }

Ejemplo n.º 2

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