.NET餐厅管理系统sql数据帮助类C#利用反射获取对象属性值、将sr_readStr数组存入数据库image类型的字段中

  #region  //C#利用反射获取对象属性值
    /// <summary>
    /// C#利用反射获取对象属性值
    /// </summary>
    /// <param name="type"></param>
    /// <param name="baseEntity"></param>
    /// <param name="propertyname">需要更改的值</param>
    /// <returns></returns>
    public static string GetObjectPropertyValue(Type type, BaseEntity baseEntity, string propertyname)
    {

        PropertyInfo property = type.GetProperty(propertyname);//根据变量名得到变量对象

        //if (property == null) return null;//BaseEntity.cs属性名与BaseModel.cs中属性名不相同时,并不进行编辑

        object o = property.GetValue(baseEntity, null);//从实体中获取具体值 重要

        if (o == null) return null;

        return o.ToString();
    }
    #endregion

    #region  //将sr_readStr数组存入数据库image类型的字段中
    /// <summary>
    /// 将sr_readStr数组存入数据库image类型的字段中
    /// </summary>
    /// <param name="sql_"></param>
    public void ExecuteNonQuery_Byte(string sql_, byte[] sr_readStr)
    {
        try
        {
            OpenDb();
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            cmd.CommandText = sql_;
            SqlParameter par = new SqlParameter("@imgfile", SqlDbType.Image);
            par.Value = sr_readStr;
            cmd.Parameters.Add(par);
            cmd.ExecuteNonQuery();
            CloseDb();
        }
        catch (Exception e)
        {
            throw new Exception(e.ToString() + "  " + sql_);
        }
    }
    #endregion