public override DataTable ExecuteQuery(string cmdText, DBHelperParmCollection parameters)
{
DataTable dtRet = new DataTable();
MySqlCommand _MySqlCommand = (MySqlCommand)CreateCommand(cmdText, CommandType.Text);
_MySqlCommand.Parameters.Clear();
if (parameters != null)
{
foreach (DBHelperParm dbPara in parameters)
{
_MySqlCommand.Parameters.Add(new MySqlParameter("?" + dbPara.Key, dbPara.Value));
}
}
MySqlDataAdapter _MySqlDataAdapter = new MySqlDataAdapter(_MySqlCommand);
try
{
_MySqlDataAdapter.Fill(dtRet);
}
catch (Exception ex)
{
throw ex;
}
return(dtRet);
}
/// <summary>
/// 执行存储过程，返回结果数据
/// </summary>
/// <param name="procedureName">过程名</param>
public override DataTable ExecuteProcedureQuery(string procedureName, DBHelperParmCollection parameters)
{
try
{
DataTable dtbRtn = new DataTable();
string realProcedureName = string.Format("{{CALL {0} (", procedureName);
for (int i = 0; i < parameters.Count; i++)
{
realProcedureName += "?,";
}
realProcedureName = realProcedureName.Substring(0, realProcedureName.Length - 1);
realProcedureName += ")}";
OdbcCommand _OdbcCommand = (OdbcCommand)CreateCommand(realProcedureName, CommandType.StoredProcedure);
if (parameters != null)
{
foreach (DBHelperParm para in parameters)
{
_IDbCommand.Parameters.Add(new OdbcParameter("?" + para.Key, para.Value));
}
}
OdbcDataAdapter _OdbcDataAdapter = new OdbcDataAdapter(_OdbcCommand);
_OdbcDataAdapter.Fill(dtbRtn);
return(dtbRtn);
}
catch (Exception ex)
{
throw ex;
}
}
public override DataTable ExecuteQuery(string cmdText, DBHelperParmCollection parameters)
{
DataTable dtRet = new DataTable();
AseCommand _AseCommand = (AseCommand)CreateCommand(cmdText, CommandType.Text);
_AseCommand.Parameters.Clear();
if (parameters != null)
{
foreach (DBHelperParm para in parameters)
{
_AseCommand.Parameters.Add(new AseParameter("?" + para.Key, EncodingHelper.Default2DB(para.Value, _DBEncodeing)));
}
}
AseDataAdapter _OdbcDataAdapter = new AseDataAdapter(_AseCommand);
try
{
ProcessDataTable(dtRet);
_OdbcDataAdapter.Fill(dtRet);
}
catch (Exception ex)
{
throw ex;
}
return(dtRet);
}
public void Save()
{
DBHelperParmCollection param = new DBHelperParmCollection();
param.Add(new DBHelperParm("@UserName", "UserName"));
param.Add(new DBHelperParm("@Password", "Password"));
StringBuilder sbSql = new StringBuilder("");
try
{
sbSql.Append("INSERT INTO AMP_TEST (UserName,Password) ");
sbSql.Append("VALUES (?,?)");
DBHelper.ExecuteNoQuery(sbSql.ToString(), param);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 执行存储过程
/// </summary>
/// <param name="procedureName">过程名</param>
/// <returns>返回执行正确的行数</returns>
public override int ExecuteProcedureNoQuery(string procedureName, DBHelperParmCollection parameters)
{
int iRtn = -1;
try
{
string realProcedureName = string.Format("{{CALL {0} (", procedureName);
for (int i = 0; i < parameters.Count; i++)
{
realProcedureName += "?,";
}
realProcedureName = realProcedureName.Substring(0, realProcedureName.Length - 1);
realProcedureName += ")}";
OdbcCommand _OdbcCommand = (OdbcCommand)CreateCommand(realProcedureName, CommandType.StoredProcedure);
if (parameters != null)
{
foreach (DBHelperParm para in parameters)
{
_OdbcCommand.Parameters.Add(new OdbcParameter("?" + para.Key, para.Value));
}
}
iRtn = _OdbcCommand.ExecuteNonQuery();
// 设置异常问题
if (iRtn == -1)
{
_ErrorMsg = "查无记录!";
}
}
catch (Exception ex)
{
_ErrorMsg = ex.Message;
}
return(iRtn);
}
public override int ExecuteNoQuery(string cmdText, DBHelperParmCollection parameters)
{
int effectNum;
MySqlCommand _MySqlCommand = (MySqlCommand)CreateCommand(cmdText, CommandType.Text);
_MySqlCommand.Parameters.Clear();
if (parameters != null)
{
foreach (DBHelperParm dbPara in parameters)
{
_MySqlCommand.Parameters.Add(new MySqlParameter("?" + dbPara.Key, dbPara.Value));
}
}
try
{
effectNum = _MySqlCommand.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
return(effectNum);
}
public override int ExecuteNoQuery(string cmdText, DBHelperParmCollection parameters)
{
int effectNum;
AseCommand _AseCommand = (AseCommand)CreateCommand(cmdText, CommandType.Text);
_AseCommand.Parameters.Clear();
if (parameters != null)
{
foreach (DBHelperParm para in parameters)
{
_AseCommand.Parameters.Add(new AseParameter("?" + para.Key, EncodingHelper.Default2DB(para.Value, _DBEncodeing)));
}
}
try
{
effectNum = _AseCommand.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
_AseCommand.Parameters.Clear();
return(effectNum);
}
public override DataTable ExecuteProcedureQuery(string procedureName, DBHelperParmCollection parameters)
{
throw new Exception("The method or operation is not implemented.");
}
