计划订单相关功能

username@email.com

2024-11-15 f47da9571d16108fcab2bf6d55279a08ce2e7cbf

 CY_ECommercePlatform/CY.SQLDAL/Database.cs

@@ -307,6 +307,34 @@
            return command.ExecuteReader(CommandBehavior.CloseConnection);//释放Reader时关闭连接
        }


        /// <summary>
        /// 返回intid
        /// </summary>
        /// <param name="SQLString">Transaction-SQL语句</param>
        /// <param name="param">SQL参数</param>
        /// <returns>返回intid</returns>
        public int InsertDataAndGetId(string SQLString, params SqlParameter[] param)
        {
            int newRecordId = 0;
            
                SqlCommand cmd = new SqlCommand(SQLString + "; SELECT SCOPE_IDENTITY();", this.Connection);
            if (this._Tran != null)
            {
                cmd.Transaction = this._Tran;
            }
            cmd.CommandTimeout = Database.QueryTimeOut;
            cmd.Parameters.Clear();
            if (param != null)
            {
                cmd.Parameters.AddRange(param);

            }
            newRecordId = Convert.ToInt32(cmd.ExecuteScalar());
            
            return newRecordId;
        }

        /// <summary>
        /// 执行SQL语句，返回影响的记录数
        /// </summary>