Exemple #1
0
        private static string GetValueAsText(NavisionValue value)
        {
            NavisionFieldType fieldType = value.FieldType;
            if (fieldType <= NavisionFieldType.Blob)
            {
                switch (fieldType)
                {
                    case NavisionFieldType.TableFilter:
                    {
                        NavisionTableFilter filter = value;
                        return filter.ToString();
                    }
                    case NavisionFieldType.RecordId:
                    {
                        NavisionRecordId id = value;
                        return id.ToString();
                    }
                    case NavisionFieldType.Text:
                    {
                        NavisionText text = value;
                        return text.ToString();
                    }
                    case NavisionFieldType.Binary:
                    {
                        NavisionBinary binary = value;
                        return binary.ToString();
                    }
                    case ((NavisionFieldType) 0x8401):
                        goto Label_028B;

                    case NavisionFieldType.Blob:
                        return "";

                    case NavisionFieldType.Decimal:
                    {
                        NavisionDecimal num = value;
                        return num.ToString();
                    }
                    case NavisionFieldType.Date:
                    {
                        NavisionDate date = value;
                        return date.ToString();
                    }
                    case NavisionFieldType.Time:
                    {
                        NavisionTime time2 = value;
                        return time2.ToString();
                    }
                    case NavisionFieldType.DateFormula:
                    {
                        NavisionDateFormula formula = value;
                        return formula.ToString();
                    }
                }
            }
            else
            {
                switch (fieldType)
                {
                    case NavisionFieldType.Code:
                    {
                        NavisionCode code = value;
                        return code.ToString();
                    }
                    case NavisionFieldType.Option:
                    {
                        NavisionOption option = value;
                        return option.ToString();
                    }
                    case NavisionFieldType.Boolean:
                    {
                        NavisionBoolean flag = value;
                        return flag.ToString();
                    }
                    case NavisionFieldType.Integer:
                    {
                        NavisionInteger integer2 = value;
                        return integer2.ToString();
                    }
                    case NavisionFieldType.BigInteger:
                    {
                        NavisionBigInteger integer = value;
                        return integer.ToString();
                    }
                    case NavisionFieldType.Duration:
                    {
                        NavisionDuration duration = value;
                        return duration.ToString();
                    }
                    case NavisionFieldType.Guid:
                    {
                        NavisionGuid guid = value;
                        return guid.ToString();
                    }
                    case NavisionFieldType.DateTime:
                    {
                        NavisionDateTime time = value;
                        return time.ToString();
                    }
                }
            }
            Label_028B:
            return "";
        }
Exemple #2
0
        private static object GetValueAsObject(NavisionValue value)
        {
            NavisionDateTime time2;
            NavisionTime time4;
            NavisionDateFormula formula;
            NavisionFieldType fieldType = value.FieldType;
            if (fieldType <= NavisionFieldType.Blob)
            {
                switch (fieldType)
                {
                    case NavisionFieldType.TableFilter:
                    {
                        NavisionTableFilter filter = value;
                        return filter.Value;
                    }
                    case NavisionFieldType.RecordId:
                    {
                        NavisionRecordId id = value;
                        return id.Value;
                    }
                    case NavisionFieldType.Text:
                    {
                        NavisionText text = value;
                        return text.Value;
                    }
                    case NavisionFieldType.Binary:
                    {
                        NavisionBinary binary = value;
                        return binary.ToString();
                    }
                    case ((NavisionFieldType) 0x8401):
                        goto Label_02E6;

                    case NavisionFieldType.Blob:
                        return "";

                    case NavisionFieldType.Decimal:
                    {
                        NavisionDecimal num = value;
                        return Convert.ToDecimal(num.ToDouble());
                    }
                    case NavisionFieldType.Date:
                    {
                        NavisionDate date = value;
                        try
                        {
                            int[] numArray = date.ToYearMonthDayClosing();
                            return new DateTime(numArray[0], numArray[1], numArray[2]);
                        }
                        catch
                        {
                            return DBNull.Value;
                        }
                        goto Label_01E6;
                    }
                    case NavisionFieldType.Time:
                        goto Label_0231;

                    case NavisionFieldType.DateFormula:
                        goto Label_025D;
                }
            }
            else
            {
                switch (fieldType)
                {
                    case NavisionFieldType.Code:
                    {
                        NavisionCode code = value;
                        return code.ToString();
                    }
                    case NavisionFieldType.Option:
                    {
                        NavisionOption option = value;
                        return option.ToString();
                    }
                    case NavisionFieldType.Boolean:
                    {
                        NavisionBoolean flag = value;
                        return flag.Value;
                    }
                    case NavisionFieldType.Integer:
                    {
                        NavisionInteger integer2 = value;
                        return integer2.Value;
                    }
                    case NavisionFieldType.BigInteger:
                    {
                        NavisionBigInteger integer = value;
                        return integer.ToInt64();
                    }
                    case NavisionFieldType.Duration:
                    {
                        NavisionDuration duration = value;
                        return duration.Value;
                    }
                    case NavisionFieldType.Guid:
                    {
                        NavisionGuid guid = value;
                        return guid.Value;
                    }
                    case NavisionFieldType.DateTime:
                        goto Label_01E6;
                }
            }
            goto Label_02E6;
            Label_01E6:
            time2 = value;
            try
            {
                int[] numArray2 = time2.ToYearMonthDayHourMinuteSecondThousandth();
                return new DateTime(numArray2[0], numArray2[1], numArray2[2], numArray2[3], numArray2[4], numArray2[5]);
            }
            catch
            {
                return DBNull.Value;
            }
            Label_0231:
            time4 = value;
            try
            {
                return time4.Value;
            }
            catch
            {
                return DBNull.Value;
            }
            Label_025D:
            formula = value;
            return formula.Value;
            Label_02E6:
            return "";
        }