Esempio n. 1
0
        /// <summary>
        /// 创建一个SPOut对象
        /// </summary>
        /// <param name="o">对象值</param>
        /// <returns>转换后的SPOut对象</returns>
        public static SPOut Create(object o)
        {
            SPOut parameter = new SPOut();

            parameter.Value = o;
            return(parameter);
        }
Esempio n. 2
0
        //private static IEnumerable<SqlParameter> GetSpParameters(string spName, object parameterObject)
        //{
        //	if( parameterObject == null )
        //		return null;

        //	string connectionString = ConnectionScope.GetDefaultConnectionString();

        //	SqlParameter[] parameters = ParameterCache.GetSpParameters(connectionString, spName);

        //	PropertyInfo[] properties = parameterObject.GetType().GetProperties(BindingFlags.Instance | BindingFlags.Public);

        //	foreach( PropertyInfo property in properties ) {

        //		string name = "@" + property.Name;
        //		SqlParameter para = parameters.Where(p => p.ParameterName == name).FirstOrDefault();
        //		if (para != null)
        //		{
        //			object value = property.FastGetValue(parameterObject);
        //			if (value == null)
        //			{
        //				para.Value = DBNull.Value;
        //			}
        //			else
        //			{
        //				para.Value = value;
        //			}
        //		}
        //	}

        //	return parameters;
        //}

        internal static SqlParameter[] GetSpParameters(object parameterObject)
        {
            if (parameterObject == null)
            {
                return(null);
            }

            PropertyInfo[] properties = parameterObject.GetType().GetProperties(BindingFlags.Instance | BindingFlags.Public);

            SqlParameter[] parameters = new SqlParameter[properties.Length];
            int            index      = 0;

            foreach (PropertyInfo property in properties)
            {
                string       name  = "@" + property.Name;
                object       value = property.FastGetValue(parameterObject);
                SqlParameter para  = null;
                if (value == null || value == DBNull.Value)
                {
                    //throw new ArgumentException("输入参数的属性值不能为空。");
                    para = new SqlParameter(name, DBNull.Value);
                    //para.SqlDbType = SqlDbType.Variant;
                }
                else
                {
                    SPOut spOutParam = value as SPOut;
                    if (spOutParam != null)
                    {
                        value = spOutParam.Value;
                        if (value == null || value == DBNull.Value)
                        {
                            throw new ArgumentException("输出参数的属性值不允许为空。");
                        }
                        else
                        {
                            //对于字符串类型的输出参数,长度需要默认设置为-1.这样避免了ADO.NET做长度推算.
                            if (spOutParam.Value is string)
                            {
                                para      = new SqlParameter(name, spOutParam.Value);
                                para.Size = -1;
                            }
                            else
                            {
                                para = new SqlParameter(name, spOutParam.Value);
                            }

                            if (spOutParam.Size != -1)
                            {
                                para.Size = spOutParam.Size;
                            }
                        }
                        para.Direction = ParameterDirection.Output;
                    }
                    else
                    {
                        //支持匿名对象中直接使用SqlParameter
                        SqlParameter parameter = value as SqlParameter;
                        if (parameter != null)
                        {
                            para = parameter;
                        }
                        else
                        {
                            para = new SqlParameter(name, value);
                        }
                    }
                }
                parameters[index] = para;
                index++;
            }

            return(parameters);
        }