コード例 #1
0
ファイル: Row.cs プロジェクト: nicknystrom/AscendRewards
        internal Row(Worksheet ws, uint index)
            : base(ws, index)
        {

        }
コード例 #2
0
ファイル: Program.cs プロジェクト: divyang4481/REM
        private static void GetDataElements(Worksheet ws2007)
        {
            for (uint r = ws2007.CellMap.FirstRow + 1; r <= ws2007.CellMap.LastRow; r++)
            {
                Row row = ws2007.GetRow(r);

                string moduleName = null;
                string className = null;
                string propertyName = null;
                string propertyType = null;
                string questionNumber = null;

                bool hasValue = false;
                for (uint c = ws2007.CellMap.FirstCol; c <= ws2007.CellMap.LastCol; c++)
                {
                    if (row.GetCell(c).Value == null || string.IsNullOrWhiteSpace(row.GetCell(c).Value.ToString()))
                        continue;

                    switch (c)
                    {
                        case 0:
                            moduleName = (string) row.GetCell(c).Value;
                            hasValue = true;
                            continue;

                        case 1:
                            className = (string) row.GetCell(c).Value;
                            hasValue = true;
                            continue;

                        case 2:
                            propertyName = (string) row.GetCell(c).Value;
                            hasValue = true;
                            continue;

                        case 3:
                            propertyType = (string) row.GetCell(c).Value;
                            hasValue = true;
                            continue;

                        case 4:
                            questionNumber = (string) row.GetCell(c).Value;
                            hasValue = true;
                            continue;
                    }
                }

                if (!hasValue)
                {
                    continue;
                }

                if (string.IsNullOrWhiteSpace(moduleName) || string.IsNullOrWhiteSpace(className) ||
                    string.IsNullOrWhiteSpace(propertyName) || string.IsNullOrWhiteSpace(propertyType))
                {
                    throw new ApplicationException("Incomplete data in Sheet : " + DataElementsSheetName + " Row: " + r);
                }

                string fullyQualifiedClassName = DomainNamespaceNamePrefix + moduleName + "." + className;

                AddTypeDescriptionAndQuestionIdentifiers(propertyName, propertyType, fullyQualifiedClassName, questionNumber, TypeDescriptions, QuestionIdentifiers);
                AddTypeDescriptionAndQuestionIdentifiers(propertyName, propertyType, fullyQualifiedClassName, questionNumber, TypeDescriptionsForAgatha, QuestionIdentifiersForAgatha);
            }
        }
コード例 #3
0
ファイル: Program.cs プロジェクト: divyang4481/REM
        private static void GetLookups(Worksheet ws2007)
        {
            for (uint r = ws2007.CellMap.FirstRow  + 1; r <= ws2007.CellMap.LastRow; r++)
            {
                Row row = ws2007.GetRow(r);
                string moduleName = null, lookupName = null;

                bool hasValue = false;
                for (uint c = ws2007.CellMap.FirstCol; c <= ws2007.CellMap.LastCol; c++)
                {
                    if (row.GetCell(c).Value == null || string.IsNullOrWhiteSpace(row.GetCell(c).Value.ToString()))
                        continue;

                    switch (c)
                    {
                        case 0:
                            moduleName = (string) row.GetCell(c).Value;
                            hasValue = true;
                            continue;

                        case 1:
                            lookupName = (string) row.GetCell(c).Value;
                            hasValue = true;
                            continue;
                    }
                }

                if (!hasValue)
                {
                    continue;
                }

                if (string.IsNullOrWhiteSpace(moduleName) || string.IsNullOrWhiteSpace(lookupName))
                {
                    throw new ApplicationException("Incomplete data in Sheet : " + LookupsSheetName + " Row: " + r);
                }

                string fullyQualifiedClassName = DomainNamespaceNamePrefix + moduleName + "." + lookupName;

                if (!Lookups.Contains(fullyQualifiedClassName))
                {
                    Lookups.Add(fullyQualifiedClassName);
                }
            }
        }
コード例 #4
0
 internal WorksheetChild(Worksheet ws, uint index)
 {
     Worksheet = ws;
     Index = index;
 }