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