예제 #1
0
 private void Initialize()
 {
     for (var x = _fromCol; x <= _toCol; x++)
     {
         var fieldObj = _dataProvider.GetCellValue(_worksheet, _fieldRow, x);
         var val      = _dataProvider.GetCellValue(_worksheet, _fieldRow + 1, x);
         if (fieldObj != null && val != null)
         {
             if (fieldObj is string)
             {
                 var field = new ExcelDatabaseCriteriaField(fieldObj.ToString().ToLower(CultureInfo.InvariantCulture));
                 _criterias.Add(field, val);
             }
             else if (ConvertUtil.IsNumeric(fieldObj))
             {
                 var field = new ExcelDatabaseCriteriaField((int)fieldObj);
                 _criterias.Add(field, val);
             }
         }
     }
 }
예제 #2
0
        private void Initialize()
        {
            for (var x = _fromCol; x <= _toCol; x++)
            {
                var fieldObj = _dataProvider.GetCellValue(_worksheet, _fieldRow, x);
                var val = _dataProvider.GetCellValue(_worksheet, _fieldRow + 1, x);
                if (fieldObj != null && val != null)
                {
                    if(fieldObj is string)
                    { 
                        var field = new ExcelDatabaseCriteriaField(fieldObj.ToString().ToLower(CultureInfo.InvariantCulture));
                        _criterias.Add(field, val);
                    }
                    else if (ConvertUtil.IsNumeric(fieldObj))
                    {
                        var field = new ExcelDatabaseCriteriaField((int) fieldObj);
                        _criterias.Add(field, val);
                    }

                }
            }
        }