private static void buildParameters(object dto, SqlCommand cmd) { if (null == dto) { return; } foreach (var p in dto.GetType().GetProperties()) { var param = new SqlParameter(); param.ParameterName = p.Name; param.Value = p.GetValue(dto); param.SqlDbType = TypeConvertor.ToSqlDbType(p.PropertyType); param.Direction = ParameterDirection.Input; cmd.Parameters.Add(param); } }
private static SqlParameter GetParam(string key, object valor) { if (valor != null) { Type type = valor.GetType(); bool isNullable = type.IsGenericType && type.GetGenericTypeDefinition() == typeof(Nullable <>); return(new SqlParameter() { ParameterName = key, Value = valor,//isNullable ? ((Nullable)valor).GetValueOrDefault() : valor, SqlDbType = TypeConvertor.ToSqlDbType(type) }); } else { return(new SqlParameter() { ParameterName = key, Value = DBNull.Value //SqlDbType = TypeConvertor.ToSqlDbType(type) }); } }