C# OleDbDataReader.SafeValueToString方法代码示例

        public FinancialDataAdapter(OleDbDataReader dr, List<DateTime> dates, int rowNumber)
        {
            ErrorMessages = new List<string>();
            int issueId;
            string issueIdString = dr.SafeValueToString((int) FinancialColumn.IssueId);
            DateValue = new Dictionary<DateTime, decimal>();

            if (Int32.TryParse(issueIdString, out issueId))
            {
                IssueId = issueId;
            }
            else
            {
                ErrorMessages.Add(string.Format("Could not convert Issue id '{0}' to Int. Rown number '{1}'. Skipping ", issueIdString, rowNumber));
            }

            var financeTypeString = dr.SafeValueToString((int) FinancialColumn.FinanceType).Trim();

            if (financeTypeString == FinanceType.Baseline.ToString()) FinanceType = FinanceType.Baseline;
            else if (financeTypeString == FinanceType.Budget.ToString()) FinanceType = FinanceType.Budget;
            else if (financeTypeString == FinanceType.Forecast.ToString()) FinanceType = FinanceType.Forecast;
            else if (financeTypeString == FinanceType.ForecastV1.ToString()) FinanceType = FinanceType.ForecastV1;
            else if (financeTypeString == FinanceType.ForecastV2.ToString()) FinanceType = FinanceType.ForecastV2;
            else if (financeTypeString == FinanceType.ForecastV3.ToString()) FinanceType = FinanceType.ForecastV3;
            else
            {
                ErrorMessages.Add(string.Format("Could not recognise FinancialType '{0}'. Rown number '{1}'. Skipping ", financeTypeString, rowNumber));
            } //add error msg

            int dateIndex = 0;
            for (int i = (int) FinancialColumn.FinanceType + 1; i < dr.FieldCount; i++)
            {
                DateTime date = dates[dateIndex];
                dateIndex++;
                string dateStringValue = dr.SafeValueToString(i);
                dateStringValue = dateStringValue.Replace("$","");
                if (string.IsNullOrEmpty(dateStringValue)) {continue;} //Import only data that has value

                decimal dateValue;

                if (Decimal.TryParse(dateStringValue, out dateValue))
                {
                    DateValue.Add(date, Math.Round(dateValue,2));
                }
                else
                {
                    ErrorMessages.Add(string.Format("Could not convert value '{0}' for '{1}'. Rown number '{2}'. Skipping ", dateStringValue,date, rowNumber));
                }
            }
        }

        public InstrumentComponentDataAdapter(OleDbDataReader dr, List<InstrumentProperty> existingInstrumentProperties, 
            IList<string> spreadSheetComponentPropertyNames, int rowNumber, bool canCreateProperties, CommonUtils.ImportType importType)
        {
            base.PopulateCommonProperties(dr);
            RowNumber = rowNumber;

            mImportType = importType;
            int k = 0;
            const int StartColumnIndex = (int)BaseComponentColumn.Model + 1;

            for (int i = StartColumnIndex; i < StartColumnIndex + spreadSheetComponentPropertyNames.Count; i++)
            {

                if (string.IsNullOrEmpty(dr.SafeString(i)))
                {
                    continue;
                }

                string propertyName = spreadSheetComponentPropertyNames[k];
                k++;

                InstrumentProperty property = (from x in existingInstrumentProperties where x.Name.ToLower() == propertyName.ToLower() select x).FirstOrDefault();

                if (property != null)
                {
                    PropertyValues.Add(property.Name, dr.SafeValueToString(i));
                }
                else
                {
                    if (canCreateProperties)
                    {
                        if (!PropertyValues.ContainsValue(dr.SafeString(i)))
                        {
                            PropertyValues.Add(propertyName, dr.SafeString(i));
                        }
                    }
                    else
                    {
                        ErrorMessages.Add(RaiseMissingPropertyMessage(ComponentName, rowNumber, propertyName));
                        break;
                    }

                }
            }

            base.Validate(rowNumber, mImportType==CommonUtils.ImportType.CreateInstrumentComponent);
        }

        public Cji5DataAdapter(OleDbDataReader dr, int rowNumber)
        {
            ErrorMessages = new List<string>();
            PoNumber = dr.SafeValueToString((int) PurchaseColumn.RefDocumentNumber);
            ProjectDefinition = dr.SafeValueToString((int)PurchaseColumn.ProjectDefinition);

            if (String.IsNullOrEmpty(ProjectDefinition))
            {
                ErrorMessages.Add(string.Format("{0} returned null, please check the format of this cell in Excel (set to Text). Row number '{1}'. Skipping ", PurchaseColumn.ProjectDefinition,  rowNumber));
            }

            VendorNumber = dr.SafeValueToString((int)PurchaseColumn.Vendor);
            Description = dr.SafeValueToString((int)PurchaseColumn.Name);

            decimal totalAmountValue;
            string totalAmountString = dr.SafeValueToString((int)PurchaseColumn.PlanObjectCur);

            if (Decimal.TryParse(totalAmountString, out totalAmountValue))
            {
                TotalAmount = totalAmountValue;
            }
            else
            {
                ErrorMessages.Add(string.Format("Could not convert {0} '{1}' to decimal. Row number '{2}'. Skipping ", PurchaseColumn.PlanObjectCur, totalAmountString, rowNumber));
            }

            decimal valueInObjCrcyValue;
            string valueInObjCrcyString = dr.SafeValueToString((int)PurchaseColumn.ValueInObjCrcy);

            if (Decimal.TryParse(valueInObjCrcyString, out valueInObjCrcyValue))
            {
                ValueInObjCrcy = valueInObjCrcyValue;
            }
            else
            {
                ErrorMessages.Add(string.Format("Could not convert {0} '{1}' to decimal. Row number '{2}'. Skipping ", PurchaseColumn.ValueInObjCrcy, valueInObjCrcyString, rowNumber));
            }

            WbsElement = dr.SafeValueToString((int)PurchaseColumn.WbsElement);

            if (String.IsNullOrEmpty(WbsElement))
            {
                ErrorMessages.Add(string.Format("{0} returned null, please check the format of this cell in Excel (set to Text). Row number '{1}'. Skipping ", PurchaseColumn.WbsElement, rowNumber));
            }

            int costElementValue;
            string costElementString = dr.SafeValueToString((int)PurchaseColumn.CostElement);

            if (int.TryParse(costElementString, out costElementValue))
            {
                CostElement = costElementValue;
            }
            else
            {
                ErrorMessages.Add(string.Format("Could not convert {0} '{1}' to decimal. Row number '{2}'. Skipping ", PurchaseColumn.CostElement, costElementString, rowNumber));
            }

            int referenceItemValue;
            string referenceItemString = dr.SafeValueToString((int)PurchaseColumn.ReferenceItem);

            if (int.TryParse(referenceItemString, out referenceItemValue))
            {
                ReferenceItem = referenceItemValue;
            }
            else
            {
                ErrorMessages.Add(string.Format("Could not convert {0} '{1}' to decimal. Row number '{2}'. Skipping ", PurchaseColumn.ReferenceItem, referenceItemString, rowNumber));
            }

            ReferenceDocType = dr.SafeValueToString((int)PurchaseColumn.ReferenceDocType);

            DateTime dateValue;
            string dateStringValue = dr.SafeValueToString((int)PurchaseColumn.DocumentDate);
            if (DateTime.TryParse(dateStringValue, out dateValue))
            {
                Date = dateValue;
            }
            else
            {
                ErrorMessages.Add(string.Format("Could not convert {0} '{1}' to Date. Row number '{2}'. Skipping ", PurchaseColumn.DocumentDate, dateStringValue, rowNumber));
            }
        }

        public Cji3DataAdapter(OleDbDataReader dr, int rowNumber)
        {
            ErrorMessages = new List<string>();

            //FiscalYear
            string fiscalYearString = string.Empty;
            fiscalYearString = dr.SafeValueToString((int)Cij3Column.FiscalYear);
            int fiscalYear;

            if (int.TryParse(fiscalYearString, out fiscalYear))
            {
                FiscalYear = fiscalYear;
            }
            else
            {
                ErrorMessages.Add(string.Format("Could not convert {0} '{1}' to integer. Rown number '{2}'. Skipping ", Cij3Column.FiscalYear, fiscalYearString, rowNumber));
            }

            //Period
            string periodString = string.Empty;
            periodString = dr.SafeValueToString((int)Cij3Column.Period);
            int period;

            if (int.TryParse(periodString, out period))
            {
                Period = period;
            }
            else
            {
                ErrorMessages.Add(string.Format("Could not convert {0} '{1}' to decimal. Rown number '{2}'. Skipping ", Cij3Column.Period, periodString, rowNumber));
            }

            //Date
            Date = new DateTime(fiscalYear,period,1);

            //Project Definition
            ProjectDefinition = dr.SafeValueToString((int)Cij3Column.ProjectDefinition);
            if (String.IsNullOrEmpty(ProjectDefinition))
            {
                ErrorMessages.Add(string.Format("{0} returned null, please check the format of this cell in Excel (set to Text). Row number '{1}'. Skipping ", Cij3Column.ProjectDefinition, rowNumber));
            }

            //WBS Element
            WbsElement = dr.SafeValueToString((int)Cij3Column.WbsElement);
            if (String.IsNullOrEmpty(WbsElement))
            {
                ErrorMessages.Add(string.Format("{0} returned null, please check the format of this cell in Excel (set to Text). Row number '{1}'. Skipping ", Cij3Column.WbsElement, rowNumber));
            }

            //Purchasing Document
            PurchasingDocument = dr.SafeValueToString((int)Cij3Column.PurchasingDocument);

            //Purchase Order Text
            PurchaseOrderText = dr.SafeValueToString((int)Cij3Column.PurchaseOrderText);

            //Name
            Name = dr.SafeValueToString((int)Cij3Column.Name);

            //PartnerObject
            PartnerObject = dr.SafeValueToString((int)Cij3Column.PartnerObject);

            //CoPartnerObject
            CoPartnerObjectName = dr.SafeValueToString((int)Cij3Column.CoPartnerObjectName);

            //Posting Date
            DateTime postingDate;
            string postingDateString = dr.SafeValueToString((int)Cij3Column.PostingDate);
            if (DateTime.TryParse(postingDateString, out postingDate))
            {
                PostingDate = postingDate;
            }
            else
            {
                ErrorMessages.Add(string.Format("Could not convert {0} '{1}' to Date. Rown number '{2}'. Skipping ", Cij3Column.PostingDate, postingDateString, rowNumber));
            }

            //Value in Object Currency
            string valueCurrencyString = string.Empty;
            valueCurrencyString = dr.SafeValueToString((int)Cij3Column.ValueInObjCrcy);
            decimal valueCurrency;

            if (decimal.TryParse(valueCurrencyString, out valueCurrency))
            {
                ValueInObjectCurrency = valueCurrency;
            }
            else
            {
                ErrorMessages.Add(string.Format("Could not convert {0} '{1}' to decimal. Rown number '{2}'. Skipping ", Cij3Column.ValueInObjCrcy, valueCurrencyString, rowNumber));
            }
        }