using System.Collections.Generic;
using System.Data;
using SqlSugar;

namespace Mtxfw.Utility.DataAccess
{
    /// <summary>
    /// DataSet类
    /// </summary>
    public partial class Sql : DbHelperSqlSugar
    {
        /// <summary>
        /// 通过SQL语句获取DataSet
        /// </summary>
        /// <param name="sql">sql -> select * from table where id=@id and name=@name</param>
        /// <param name="parameters">参数 -> new {id=1,name="a"}</param>
        /// <returns>返回DataSet数据</returns>
        public DataSet GetDataSet(string sql, object parameters)
        {
            return Db.Ado.GetDataSetAll(sql, parameters);
        }

        /// <summary>
        /// 通过SQL语句获取DataSet
        /// </summary>
        /// <param name="sql">sql -> select * from table where id=@id and name=@name</param>
        /// <param name="parameters">
        /// 参数 -> new SugarParameter("@id",1), 
        /// 多个参数 -> new SugarParameter []{ new SugarParameter("@id",1), new SugarParameter("@name",2)}
        /// </param>
        /// <returns>返回DataSet数据</returns>
        public DataSet GetDataSet(string sql, params SugarParameter[] parameters)
        {
            return Db.Ado.GetDataSetAll(sql, parameters);
        }

        /// <summary>
        /// 通过SQL语句获取DataSet
        /// </summary>
        /// <param name="sql">sql -> select * from table where id=@id and name=@name</param>
        /// <param name="parameters">
        /// 多个参数 -> new List<SugarParameter>(){ new SugarParameter("@id",1), new SugarParameter("@name",2) }
        /// </param>
        /// <returns>返回DataSet数据</returns>
        public DataSet GetDataSet(string sql, List<SugarParameter> parameters)
        {
            return Db.Ado.GetDataSetAll(sql, parameters);
        }
    }
}