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