C# (CSharp) System.Data.SqlTypes.SqlCompareOptions примеры использования

Пример #1

        public static CompareOptions CompareOptionsFromSqlCompareOptions(System.Data.SqlTypes.SqlCompareOptions compareOptions)
        {
            CompareOptions none = CompareOptions.None;

            ValidateSqlCompareOptions(compareOptions);
            if ((compareOptions & (System.Data.SqlTypes.SqlCompareOptions.BinarySort | System.Data.SqlTypes.SqlCompareOptions.BinarySort2)) != System.Data.SqlTypes.SqlCompareOptions.None)
            {
                throw ADP.ArgumentOutOfRange("compareOptions");
            }
            if ((compareOptions & System.Data.SqlTypes.SqlCompareOptions.IgnoreCase) != System.Data.SqlTypes.SqlCompareOptions.None)
            {
                none |= CompareOptions.IgnoreCase;
            }
            if ((compareOptions & System.Data.SqlTypes.SqlCompareOptions.IgnoreNonSpace) != System.Data.SqlTypes.SqlCompareOptions.None)
            {
                none |= CompareOptions.IgnoreNonSpace;
            }
            if ((compareOptions & System.Data.SqlTypes.SqlCompareOptions.IgnoreKanaType) != System.Data.SqlTypes.SqlCompareOptions.None)
            {
                none |= CompareOptions.IgnoreKanaType;
            }
            if ((compareOptions & System.Data.SqlTypes.SqlCompareOptions.IgnoreWidth) != System.Data.SqlTypes.SqlCompareOptions.None)
            {
                none |= CompareOptions.IgnoreWidth;
            }
            return(none);
        }

Пример #2

 public SqlString(int lcid, System.Data.SqlTypes.SqlCompareOptions compareOptions, byte[] data, int index, int count, bool fUnicode)
 {
     this.m_lcid = lcid;
     ValidateSqlCompareOptions(compareOptions);
     this.m_flag = compareOptions;
     if (data == null)
     {
         this.m_fNotNull = false;
         this.m_value    = null;
         this.m_cmpInfo  = null;
     }
     else
     {
         this.m_fNotNull = true;
         this.m_cmpInfo  = null;
         if (fUnicode)
         {
             this.m_value = x_UnicodeEncoding.GetString(data, index, count);
         }
         else
         {
             System.Globalization.CultureInfo info = new System.Globalization.CultureInfo(this.m_lcid);
             this.m_value = Encoding.GetEncoding(info.TextInfo.ANSICodePage).GetString(data, index, count);
         }
     }
 }

Пример #3

 private static void ValidateSqlCompareOptions(System.Data.SqlTypes.SqlCompareOptions compareOptions)
 {
     if ((compareOptions & x_iValidSqlCompareOptionMask) != compareOptions)
     {
         throw new ArgumentOutOfRangeException("compareOptions");
     }
 }

Пример #4

Файл: SqlString.cs Проект: pritesh-mandowara-sp/DecompliedDotNetLibraries

 public SqlString(int lcid, System.Data.SqlTypes.SqlCompareOptions compareOptions, byte[] data, int index, int count, bool fUnicode)
 {
     this.m_lcid = lcid;
     ValidateSqlCompareOptions(compareOptions);
     this.m_flag = compareOptions;
     if (data == null)
     {
         this.m_fNotNull = false;
         this.m_value = null;
         this.m_cmpInfo = null;
     }
     else
     {
         this.m_fNotNull = true;
         this.m_cmpInfo = null;
         if (fUnicode)
         {
             this.m_value = x_UnicodeEncoding.GetString(data, index, count);
         }
         else
         {
             System.Globalization.CultureInfo info = new System.Globalization.CultureInfo(this.m_lcid);
             this.m_value = Encoding.GetEncoding(info.TextInfo.ANSICodePage).GetString(data, index, count);
         }
     }
 }

Пример #5

 private SqlString(bool fNull)
 {
     this.m_value    = null;
     this.m_cmpInfo  = null;
     this.m_lcid     = 0;
     this.m_flag     = System.Data.SqlTypes.SqlCompareOptions.None;
     this.m_fNotNull = false;
 }

Пример #6

Файл: SqlString.cs Проект: pritesh-mandowara-sp/DecompliedDotNetLibraries

 private SqlString(bool fNull)
 {
     this.m_value = null;
     this.m_cmpInfo = null;
     this.m_lcid = 0;
     this.m_flag = System.Data.SqlTypes.SqlCompareOptions.None;
     this.m_fNotNull = false;
 }

Пример #7

 static SqlString()
 {
     Null = new SqlString(true);
     x_UnicodeEncoding            = new UnicodeEncoding();
     IgnoreCase                   = 1;
     IgnoreWidth                  = 0x10;
     IgnoreNonSpace               = 2;
     IgnoreKanaType               = 8;
     BinarySort                   = 0x8000;
     BinarySort2                  = 0x4000;
     x_iDefaultFlag               = System.Data.SqlTypes.SqlCompareOptions.IgnoreWidth | System.Data.SqlTypes.SqlCompareOptions.IgnoreKanaType | System.Data.SqlTypes.SqlCompareOptions.IgnoreCase;
     x_iValidCompareOptionMask    = CompareOptions.IgnoreWidth | CompareOptions.IgnoreKanaType | CompareOptions.IgnoreNonSpace | CompareOptions.IgnoreCase;
     x_iValidSqlCompareOptionMask = System.Data.SqlTypes.SqlCompareOptions.BinarySort | System.Data.SqlTypes.SqlCompareOptions.BinarySort2 | System.Data.SqlTypes.SqlCompareOptions.IgnoreWidth | System.Data.SqlTypes.SqlCompareOptions.IgnoreKanaType | System.Data.SqlTypes.SqlCompareOptions.IgnoreNonSpace | System.Data.SqlTypes.SqlCompareOptions.IgnoreCase;
     x_lcidUSEnglish              = 0x409;
     x_lcidBinary                 = 0x8200;
 }

Пример #8

 public SqlString(string data, int lcid, System.Data.SqlTypes.SqlCompareOptions compareOptions)
 {
     this.m_lcid = lcid;
     ValidateSqlCompareOptions(compareOptions);
     this.m_flag    = compareOptions;
     this.m_cmpInfo = null;
     if (data == null)
     {
         this.m_fNotNull = false;
         this.m_value    = null;
     }
     else
     {
         this.m_fNotNull = true;
         this.m_value    = data;
     }
 }

Пример #9

Файл: SqlString.cs Проект: pritesh-mandowara-sp/DecompliedDotNetLibraries

 public SqlString(string data, int lcid, System.Data.SqlTypes.SqlCompareOptions compareOptions)
 {
     this.m_lcid = lcid;
     ValidateSqlCompareOptions(compareOptions);
     this.m_flag = compareOptions;
     this.m_cmpInfo = null;
     if (data == null)
     {
         this.m_fNotNull = false;
         this.m_value = null;
     }
     else
     {
         this.m_fNotNull = true;
         this.m_value = data;
     }
 }

Пример #10

 private SqlString(int lcid, System.Data.SqlTypes.SqlCompareOptions compareOptions, string data, System.Globalization.CompareInfo cmpInfo)
 {
     this.m_lcid = lcid;
     ValidateSqlCompareOptions(compareOptions);
     this.m_flag = compareOptions;
     if (data == null)
     {
         this.m_fNotNull = false;
         this.m_value    = null;
         this.m_cmpInfo  = null;
     }
     else
     {
         this.m_value    = data;
         this.m_cmpInfo  = cmpInfo;
         this.m_fNotNull = true;
     }
 }

Пример #11

 public SqlString(int lcid, System.Data.SqlTypes.SqlCompareOptions compareOptions, byte[] data) : this(lcid, compareOptions, data, 0, data.Length, true)
 {
 }

Пример #12

 public SqlString(int lcid, System.Data.SqlTypes.SqlCompareOptions compareOptions, byte[] data, int index, int count) : this(lcid, compareOptions, data, index, count, true)
 {
 }

Пример #13

Файл: SqlString.cs Проект: pritesh-mandowara-sp/DecompliedDotNetLibraries

 static SqlString()
 {
     Null = new SqlString(true);
     x_UnicodeEncoding = new UnicodeEncoding();
     IgnoreCase = 1;
     IgnoreWidth = 0x10;
     IgnoreNonSpace = 2;
     IgnoreKanaType = 8;
     BinarySort = 0x8000;
     BinarySort2 = 0x4000;
     x_iDefaultFlag = System.Data.SqlTypes.SqlCompareOptions.IgnoreWidth | System.Data.SqlTypes.SqlCompareOptions.IgnoreKanaType | System.Data.SqlTypes.SqlCompareOptions.IgnoreCase;
     x_iValidCompareOptionMask = CompareOptions.IgnoreWidth | CompareOptions.IgnoreKanaType | CompareOptions.IgnoreNonSpace | CompareOptions.IgnoreCase;
     x_iValidSqlCompareOptionMask = System.Data.SqlTypes.SqlCompareOptions.BinarySort | System.Data.SqlTypes.SqlCompareOptions.BinarySort2 | System.Data.SqlTypes.SqlCompareOptions.IgnoreWidth | System.Data.SqlTypes.SqlCompareOptions.IgnoreKanaType | System.Data.SqlTypes.SqlCompareOptions.IgnoreNonSpace | System.Data.SqlTypes.SqlCompareOptions.IgnoreCase;
     x_lcidUSEnglish = 0x409;
     x_lcidBinary = 0x8200;
 }

Пример #14

Файл: SqlString.cs Проект: pritesh-mandowara-sp/DecompliedDotNetLibraries

 private SqlString(int lcid, System.Data.SqlTypes.SqlCompareOptions compareOptions, string data, System.Globalization.CompareInfo cmpInfo)
 {
     this.m_lcid = lcid;
     ValidateSqlCompareOptions(compareOptions);
     this.m_flag = compareOptions;
     if (data == null)
     {
         this.m_fNotNull = false;
         this.m_value = null;
         this.m_cmpInfo = null;
     }
     else
     {
         this.m_value = data;
         this.m_cmpInfo = cmpInfo;
         this.m_fNotNull = true;
     }
 }