/// <summary> /// 执行带一个存储过程参数的的SQL语句。 /// </summary> /// <param name="strSql">SQL语句</param> /// <param name="content">参数内容,比如一个字段是格式复杂的文章,有特殊符号,可以通过这个方式添加</param> /// <returns>影响的记录数</returns> public override object ExecuteSqlGet(string strSql, string content) { using (var connection = new MySqlConnection(ConStr)) { strSql = GetSql(strSql); var cmd = new MySqlCommand(strSql, connection); cmd.CommandTimeout = Timeout; var myParameter = new QfParameter("@content", MySqlDbType.Text); myParameter.Value = content; cmd.Parameters.Add(myParameter); try { connection.Open(); var obj = cmd.ExecuteScalar(); if ((Equals(obj, null)) || (Equals(obj, DBNull.Value))) { return(null); } else { return(obj); } } finally { cmd.Dispose(); connection.Close(); } } }
/// <summary> /// 执行带一个存储过程参数的的SQL语句。 /// </summary> /// <param name="strSql">SQL语句</param> /// <param name="content">参数内容,比如一个字段是格式复杂的文章,有特殊符号,可以通过这个方式添加</param> /// <returns>影响的记录数</returns> public override int ExecuteSql(string strSql, string content) { using (var connection = new MySqlConnection(ConStr)) { strSql = GetSql(strSql); var cmd = new MySqlCommand(strSql, connection) { CommandTimeout = Timeout }; var myParameter = new QfParameter("@content", MySqlDbType.Text) { Value = content }; cmd.Parameters.Add(myParameter); try { connection.Open(); var rows = cmd.ExecuteNonQuery(); return(rows); } finally { cmd.Dispose(); connection.Close(); } } }
/// <summary> /// 向数据库里插入图像格式的字段(和上面情况类似的另一种实例) /// </summary> /// <param name="strSql">SQL语句</param> /// <param name="fs">图像字节,数据库的字段类型为image的情况</param> /// <returns>影响的记录数</returns> public override int ExecuteSqlInsertImg(string strSql, byte[] fs) { using (var connection = new MySqlConnection(ConStr)) { strSql = GetSql(strSql); var cmd = new MySqlCommand(strSql, connection); cmd.CommandTimeout = Timeout; var myParameter = new QfParameter("@fs", MySqlDbType.Blob); myParameter.Value = fs; cmd.Parameters.Add(myParameter); try { connection.Open(); var rows = cmd.ExecuteNonQuery(); return(rows); } finally { cmd.Dispose(); connection.Close(); } } }