C#操作MySQL

2024年4月28日发(作者：)

mySql_();

else

mySql_ck();

}

}

///

/// 存储过程名

///

private MySqlCommand GetProcCommand(string procName, MySqlParameter[] paraList)

{

MySqlCommand cmd = new MySqlCommand();

dText = procName;

dType = Procedure;

if (paraList != null)

{

foreach (MySqlParameter para in paraList)

(para);

}

tion = conn;

return cmd;

}

public MySqlCommand GetTextCommand(string sql)

{

MySqlCommand cmd = new MySqlCommand();

dText = sql;

dType = ;

tion = conn;

return cmd;

}

public MySqlDataReader GetDataReader(string sql, CommandBehavior comBehavior = onnection, bool isTran = false)

{

MySqlDataReader dr = null;

try

{

if (!ConnOpen())

return null;

MySqlCommand cmd = GetTextCommand(sql);

dr = eReader(comBehavior);

}

catch (Exception ex)

{

//ionLog(ex, "get datareader", sql);

if (isTran)

TranClose(false);

if ( == )

{

ConnClose();

}

}

return dr;

}

public MySqlCommand Cmd_Proc(string procName, MySqlParameter[] paraList, bool isTran = true)

{

MySqlCommand cmd = null;

try

{

if (!ConnOpen())

return null;

cmd = GetProcCommand(procName, paraList);

if (isTran)

TranOpen(ref cmd);

eNonQuery();

if (isTran)

TranClose(true);

ConnClose();

}

catch (Exception ex)

{

cmd = null;

//ionLog(ex, "exec proc:" + procName);