Пример #1
0
        private static DataSet GetChildren(TaskScheduleDataModel data, RequestProfile requestProfile)
        {
            var sql = "EXEC dbo.TaskScheduleChildrenGet " +
                      " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
                      ", " + ToSQLParameter(data, TaskScheduleDataModel.DataColumns.TaskScheduleId);

            var oDT = new DataAccess.DBDataSet("Get Children", sql, DataStoreKey);

            return(oDT.DBDataset);
        }
Пример #2
0
        private static DataSet GetChildren(ApplicationMonitoredEventProcessingStateDataModel data, RequestProfile requestProfile)
        {
            var sql = "EXEC dbo.ApplicationMonitoredEventProcessingStateChildrenGet " +
                      " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
                      ", " + ToSQLParameter(data, ApplicationMonitoredEventProcessingStateDataModel.DataColumns.ApplicationMonitoredEventProcessingStateId);

            var oDT = new DataAccess.DBDataSet("Get Children", sql, DataStoreKey);

            return(oDT.DBDataset);
        }
Пример #3
0
        private static DataSet GetChildren(Data data, int auditId)
        {
            var sql = "EXEC dbo.UserPreferenceDataTypeChildrenGet " +
                      " " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) +
                      ", " + data.ToSQLParameter(DataColumns.UserPreferenceDataTypeId);

            var oDT = new DataAccess.DBDataSet("Get Children", sql, DataStoreKey);

            return(oDT.DBDataset);
        }