示例#1
0
 protected static void AddParameters <X>(X value, SqlParameterCollection collection) where X : class
 {
     foreach (var prop in typeof(X).GetProperties().Where(p => !p.IsMarkedWith <NotAParamAttribute>() && !p.IsMarkedWith <IsOutputParamAttribute>()))
     {
         var propValue = prop.GetValue(value);
         if (prop.PropertyType == typeof(int))
         {
             collection.AddInt(prop.Name, (int)propValue);
         }
         else if (prop.PropertyType == typeof(int?))
         {
             collection.AddNullableInt(prop.Name, (int?)propValue);
         }
         else if (prop.PropertyType == typeof(short))
         {
             collection.AddSmallInt(prop.Name, (short)propValue);
         }
         else if (prop.PropertyType == typeof(short?))
         {
             collection.AddNullableSmallInt(prop.Name, (short?)propValue);
         }
         else if (prop.PropertyType == typeof(DataTable))
         {
             collection.AddTable(prop.Name, (DataTable)propValue);
         }
         else if (prop.PropertyType == typeof(DateTime?))
         {
             collection.AddNullableDateTime(prop.Name, (DateTime?)propValue);
         }
         else if (prop.PropertyType == typeof(DateTime))
         {
             collection.AddNullableDateTime(prop.Name, (DateTime)propValue);
         }
         else if (prop.PropertyType == typeof(TimeSpan?))
         {
             collection.AddNullableTime(prop.Name, (TimeSpan?)propValue);
         }
         else if (prop.PropertyType == typeof(TimeSpan))
         {
             collection.AddNullableTime(prop.Name, (TimeSpan)propValue);
         }
         else if (prop.PropertyType == typeof(decimal?))
         {
             collection.AddNullableMoney(prop.Name, (decimal?)propValue);
         }
         else if (prop.PropertyType == typeof(bool))
         {
             collection.AddBit(prop.Name, (bool)propValue);
         }
         else if (prop.PropertyType == typeof(bool?))
         {
             if (propValue != null)
             {
                 collection.AddBit(prop.Name, (bool)propValue);
             }
             else if (prop.IsMarkedWith <DefaultIfNullAttribute>())
             {
                 bool defaultIfNull = (bool)prop.GetAttributes <DefaultIfNullAttribute>().First().DefaultValue;
                 collection.AddBitWithDefault(prop.Name, (bool?)propValue, defaultIfNull);
             }
             else
             {
                 collection.AddWithValue(prop.Name, DBNull.Value);
             }
         }
         else if (prop.PropertyType == typeof(string))
         {
             if (prop.IsMarkedWith <MaxLengthAttribute>())
             {
                 int maxLength = prop.GetAttributes <MaxLengthAttribute>().First().Length;
                 collection.AddNVarChar(prop.Name, (string)propValue, maxLength);
             }
             else
             {
                 collection.AddNVarCharMax(prop.Name, (string)propValue);
             }
         }
         else
         {
             if (propValue != null)
             {
                 collection.AddWithValue(prop.Name, propValue);
             }
         }
     }
 }