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