Asp.Net 通用数据操作类 (附通用数据基类)第1/2页

        /// <summary>
        /// ExecuteNonQuery
        /// </summary>
        /// <param name="sqlString">SQL语句</param>
        /// <returns>返回影响行数</returns>
        public int ExecuteNonQuery(string sqlString)
        {
            int ret = 0;
            com.CommandText = sqlString;
            com.CommandType = CommandType.Text;
            try
            {
                ret = com.ExecuteNonQuery();
            }
            catch (Exception ee)
            {
                throw new Exception("SQL:" + sqlString + "<br />" + ee.Message.ToString());
            }
            finally
            {
                com.Cancel();
            }
            return ret;
        }
        /// <summary>
        /// 执行插入语句返回IDENTITY
        /// </summary>
        /// <param name="sqlString">SQL语句</param>
        /// <returns>@@IDENTITY</returns>
        public int ExecInsert(string sqlString)
        {
            int identity = 0;