/// <summary> /// 执行SQL,返回datatable /// </summary> /// <param name="cmd"></param> /// <returns></returns> internal DataTable ExecuteDataTable(DbCommand cmd) { using (cmd.Connection = DbCommandMng.CreateConnection()) { DbDataAdapter dbDataAdapter = DbCommandMng.CreateDataAdapter(); dbDataAdapter.SelectCommand = cmd; DataTable dataTable = new DataTable(); dbDataAdapter.Fill(dataTable); return(dataTable); } }
/// <summary> /// 执行SQL,返回dataSet /// </summary> /// <param name="cmd"></param> /// <returns></returns> internal DataSet ExecuteDataSet(DbCommand cmd) { using (cmd.Connection = DbCommandMng.CreateConnection()) { DbDataAdapter dbDataAdapter = DbCommandMng.CreateDataAdapter(); dbDataAdapter.SelectCommand = cmd; DataSet dataset = new DataSet(); dbDataAdapter.Fill(dataset); return(dataset); } }
/// <summary> /// 执行SQL,返回dataSet /// </summary> /// <param name="cmd"></param> /// <returns></returns> internal DataSet ExecuteDataSet(DbCommand cmd, Trans trans) { cmd.Connection = trans.DbConnection; cmd.Transaction = trans.DbTrans; DbDataAdapter dbDataAdapter = DbCommandMng.CreateDataAdapter(); dbDataAdapter.SelectCommand = cmd; DataSet dataset = new DataSet(); dbDataAdapter.Fill(dataset); return(dataset); }