/// <summary>
/// 功能： 执行一条计算查询结果语句，返回查询结果（object）。
/// </summary>
/// <param name="QueryString"></param>
/// <returns></returns>
//public abstract string exeSqlForString(string QueryString, string[] strParams, object[] objValues);
public override object exeSqlForObject(string QueryString, DBParameter[] Params)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = this.conn;
if (inTransaction)
{
cmd.Transaction = trans;
}
cmd.CommandText = CommonLib.ChangeQueryString(QueryString);
if (Params != null)
{
SqlParameter oledbparam;
for (int i = 0; i < Params.Length; i++)
{
oledbparam = getSqlParam(Params[i]);
cmd.Parameters.Add(oledbparam);
}
}
object obj = cmd.ExecuteScalar();
if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
{
return(null);
}
else
{
return(obj);
}
}
/// <summary>
/// 获取DataSet结果
/// </summary>
/// <param name="QueryString"></param>
/// <returns></returns>
//public override DataTable exeSqlForDataTable(string strSql, string[] strParams, object[] objValues)
//{
// SqlCommand cmd = new SqlCommand();
// cmd.Connection = this.conn;
// if (inTransaction)
// {
// cmd.Transaction = trans;
// }
// if ((strParams != null) && (strParams.Length != objValues.Length))
// {
// throw new DB.Exception.ParamValueNotMatchException();
// }
// cmd.CommandText = strSql;
// if (strParams != null)
// {
// for (int i = 0; i < strParams.Length; i++)
// {
// cmd.Parameters.AddWithValue(strParams[i], objValues[i]);
// }
// }
// DataTable dt = new DataTable();
// SqlDataAdapter ad = new SqlDataAdapter();
// ad.SelectCommand = cmd;
// ad.Fill(dt);
// return dt;
//}
public override DataTable exeSqlForDataTable(string strSql, DBParameter[] Params)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = this.conn;
if (inTransaction)
{
cmd.Transaction = trans;
}
cmd.CommandText = CommonLib.ChangeQueryString(strSql);
if (Params != null)
{
SqlParameter sqlparam;
for (int i = 0; i < Params.Length; i++)
{
sqlparam = getSqlParam(Params[i]);
cmd.Parameters.Add(sqlparam);
}
}
DataTable dt = new DataTable();
SqlDataAdapter ad = new SqlDataAdapter();
ad.SelectCommand = cmd;
ad.Fill(dt);
return(dt);
}
///// <summary>
///// 执行sql语句
///// </summary>
///// <param name="strSql"></param>
///// <param name="strParams"></param>
///// <param name="objValues"></param>
//public override bool exeSql(string strSql,string[] strParams,object[] objValues)
//{
// SqlCommand cmd = new SqlCommand();
// cmd.Connection = this.conn;
// if(inTransaction)
// {
// cmd.Transaction = trans;
// }
// if((strParams != null)&&(strParams.Length != objValues.Length) )
// {
// throw new DB.Exception.ParamValueNotMatchException();
// }
// cmd.CommandText = strSql;
// if(strParams != null)
// {
// for(int i = 0;i<strParams.Length;i++)
// {
// cmd.Parameters.AddWithValue(strParams[i],objValues[i]);
// }
// }
// if (cmd.ExecuteNonQuery() > 0)
// {
// return true;
// }
// else
// {
// return false;
// }
//}
public override bool exeSql(string strSql, DBParameter[] Params)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = this.conn;
if (inTransaction)
{
cmd.Transaction = trans;
}
cmd.CommandText = CommonLib.ChangeQueryString(strSql);
if (Params != null)
{
SqlParameter sqlparam;
for (int i = 0; i < Params.Length; i++)
{
sqlparam = getSqlParam(Params[i]);
cmd.Parameters.Add(sqlparam);
}
}
if (cmd.ExecuteNonQuery() > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 返回DataSet结果
/// </summary>
/// <param name="QueryString"></param>
/// <returns></returns>
//public override DataSet exeSqlForDataSet(string strSql, string[] strParams, object[] objValues)
//{
// OleDbCommand cmd = new OleDbCommand();
// cmd.Connection = this.conn;
// if (inTransaction)
// {
// cmd.Transaction = trans;
// }
// if ((strParams != null) && (strParams.Length != objValues.Length))
// {
// throw new DB.Exception.ParamValueNotMatchException();
// }
// cmd.CommandText = CommonLib.ChangeQueryString(strSql);
// if (strParams != null)
// {
// for (int i = 0; i < strParams.Length; i++)
// cmd.Parameters.AddWithValue(strParams[i], objValues[i]);
// }
// DataSet ds = new DataSet();
// OleDbDataAdapter ad = new OleDbDataAdapter();
// ad.SelectCommand = cmd;
// ad.Fill(ds);
// return ds;
//}
public override DataSet exeSqlForDataSet(string strSql, DBParameter[] Params)
{
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = this.conn;
if (inTransaction)
{
cmd.Transaction = trans;
}
cmd.CommandText = CommonLib.ChangeQueryString(strSql);
if (Params != null)
{
OleDbParameter oledbparam;
for (int i = 0; i < Params.Length; i++)
{
oledbparam = getOleDbParam(Params[i]);
cmd.Parameters.Add(oledbparam);
}
}
DataSet ds = new DataSet();
OleDbDataAdapter ad = new OleDbDataAdapter();
ad.SelectCommand = cmd;
ad.Fill(ds);
return(ds);
}
public override bool exeSql(string strSql)
{
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = this.conn;
if (inTransaction)
{
cmd.Transaction = trans;
}
cmd.CommandText = CommonLib.ChangeQueryString(strSql);
if (cmd.ExecuteNonQuery() > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 功能： 执行Sql，返回string
/// </summary>
/// <param name="QueryString"></param>
/// <returns></returns>
//public override string exeSqlForString(string QueryString, string[] strParams, object[] objValues)
//{
// SqlCommand cmd = new SqlCommand();
// cmd.Connection = this.conn;
// if (inTransaction)
// {
// cmd.Transaction = trans;
// }
// if ((strParams != null) && (strParams.Length != objValues.Length))
// {
// throw new DB.Exception.ParamValueNotMatchException();
// }
// cmd.CommandText = QueryString;
// if (strParams != null)
// {
// for (int i = 0; i < strParams.Length; i++)
// {
// cmd.Parameters.AddWithValue(strParams[i], objValues[i]);
// }
// }
// string ret = Convert.ToString(cmd.ExecuteScalar());
// return ret;
//}
public override string exeSqlForString(string strSql, DBParameter[] Params)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = this.conn;
if (inTransaction)
{
cmd.Transaction = trans;
}
cmd.CommandText = CommonLib.ChangeQueryString(strSql);
if (Params != null)
{
SqlParameter sqlparam;
for (int i = 0; i < Params.Length; i++)
{
sqlparam = getSqlParam(Params[i]);
cmd.Parameters.Add(sqlparam);
}
}
string ret = Convert.ToString(cmd.ExecuteScalar());
return(ret);
}
