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)
});
}
}
