Example #1
0
        /// <summary>
        /// 使用一段sql,进行分页查询, 目前只支持sqlserver
        /// </summary>
        /// <param name="sqlText"></param>
        /// <param name="orderbyClause"></param>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <param name="recordCount"></param>
        /// <returns></returns>
        public DataTable Query(string sqlText, string orderbyClause, int pageIndex, int pageSize, ref int recordCount)
        {
            ThrowExceptionUtil.ArgumentNotNullOrEmpty(sqlText, "sql");
            ThrowExceptionUtil.ArgumentNotNullOrEmpty(orderbyClause, "orderbyClause");

            if (pageSize > 0 && pageIndex >= 0)
            {
                if (recordCount <= 0)
                {
                    CmdTextBeeCommand countBeeCommand = new CmdTextBeeCommand(this, "select count(1) as beecount from ( {0} )t".FormatWith(sqlText), null);

                    DataTable countTable = countBeeCommand.Excute <DataTable>();
                    if (countTable != null && countTable.Rows.Count == 1)
                    {
                        int.TryParse(countTable.Rows[0]["beecount"].ToString(), out recordCount);
                    }
                }
            }

            string sql = this.dbDriver.GetPagedSelectCmdText(sqlText, orderbyClause, pageIndex, pageSize);

            CmdTextBeeCommand queryBeeCommand = new CmdTextBeeCommand(this, sql, null);

            return(queryBeeCommand.Excute <DataTable>());
        }
Example #2
0
        /// <summary>
        /// sql文查询
        /// </summary>
        /// <param name="cmdText">sql文</param>
        /// <param name="dataAdapter">数据集</param>
        /// <returns>结果集</returns>
        public DataTable ExecuteCommand(string cmdText, BeeDataAdapter dataAdapter)
        {
            ThrowExceptionUtil.ArgumentNotNullOrEmpty(cmdText, "cmdText");

            CmdTextBeeCommand cmdTextBeeCommand = new CmdTextBeeCommand(this, cmdText, dataAdapter);

            return(cmdTextBeeCommand.Excute <DataTable>());
        }
Example #3
0
        public IEnumerable <T> ExecuteDataReader <T>(string cmdText, BeeDataAdapter dataAdapter)
            where T : class
        {
            ThrowExceptionUtil.ArgumentNotNullOrEmpty(cmdText, "cmdText");

            CmdTextBeeCommand cmdTextBeeCommand = new CmdTextBeeCommand(this, cmdText, dataAdapter);

            return(cmdTextBeeCommand.DataRead <T>());
        }