コード例 #1
0
        /// <summary>
        /// 更新身份证照片
        /// </summary>
        /// <param name="ac001"></param>
        /// <param name="imgByte"></param>
        /// <returns></returns>
        public static int Update_IDC_Photo(string ic001, Byte[] imgByte)
        {
            string s_sql = "update ic01 set ic020 = :ic020 where ic001 = :ic001";

            OracleParameter op_ic001 = new OracleParameter("ic001", OracleDbType.Varchar2, 10);

            op_ic001.Direction = ParameterDirection.Input;
            op_ic001.Value     = ic001;

            OracleParameter op_ic020 = new OracleParameter("ic020", OracleDbType.Blob);

            op_ic020.Direction = ParameterDirection.Input;
            op_ic020.Value     = imgByte;

            return(SqlAssist.ExecuteNonQuery(s_sql, new OracleParameter[] { op_ic020, op_ic001 }));
        }