Beispiel #1
0
        public static DbQueryResult PagingByRownumber(int pageIndex, int pageSize, string sortBy, SortAction sortOrder, bool isCount, string table, string string_0, string filter, string selectFields, int partitionSize)
        {
            DbQueryResult result;

            if (string.IsNullOrEmpty(table))
            {
                result = null;
            }
            else
            {
                if (string.IsNullOrEmpty(sortBy) && string.IsNullOrEmpty(string_0))
                {
                    result = null;
                }
                else
                {
                    if (string.IsNullOrEmpty(selectFields))
                    {
                        selectFields = "*";
                    }
                    string        text          = DataHelper.BuildRownumberQuery(sortBy, sortOrder, isCount, table, string_0, filter, selectFields, partitionSize);
                    int           num           = (pageIndex - 1) * pageSize + 1;
                    int           num2          = num + pageSize - 1;
                    DbQueryResult dbQueryResult = new DbQueryResult();
                    Database      database      = DatabaseFactory.CreateDatabase();
                    System.Data.Common.DbCommand sqlStringCommand = database.GetSqlStringCommand(text);
                    database.AddInParameter(sqlStringCommand, "StartNumber", System.Data.DbType.Int32, num);
                    database.AddInParameter(sqlStringCommand, "EndNumber", System.Data.DbType.Int32, num2);
                    using (System.Data.IDataReader dataReader = database.ExecuteReader(sqlStringCommand))
                    {
                        dbQueryResult.Data = DataHelper.ConverDataReaderToDataTable(dataReader);
                        if (isCount && partitionSize == 0 && dataReader.NextResult())
                        {
                            dataReader.Read();
                            dbQueryResult.TotalRecords = dataReader.GetInt32(0);
                        }
                    }
                    result = dbQueryResult;
                }
            }
            return(result);
        }
Beispiel #2
0
        public static DbQueryResult PagingByRownumber(int pageIndex, int pageSize, string sortBy, SortAction sortOrder, bool isCount, string table, string pk, string filter, string selectFields, int partitionSize)
        {
            if (string.IsNullOrEmpty(table))
            {
                return(null);
            }
            if (string.IsNullOrEmpty(sortBy) && string.IsNullOrEmpty(pk))
            {
                return(null);
            }
            if (string.IsNullOrEmpty(selectFields))
            {
                selectFields = "*";
            }
            string        query         = DataHelper.BuildRownumberQuery(sortBy, sortOrder, isCount, table, pk, filter, selectFields, partitionSize);
            int           num           = (pageIndex - 1) * pageSize + 1;
            int           num2          = num + pageSize - 1;
            DbQueryResult dbQueryResult = new DbQueryResult();

            try
            {
                Database  database         = DatabaseFactory.CreateDatabase();
                DbCommand sqlStringCommand = database.GetSqlStringCommand(query);
                database.AddInParameter(sqlStringCommand, "StartNumber", DbType.Int32, num);
                database.AddInParameter(sqlStringCommand, "EndNumber", DbType.Int32, num2);
                using (IDataReader dataReader = database.ExecuteReader(sqlStringCommand))
                {
                    dbQueryResult.Data = DataHelper.ConverDataReaderToDataTable(dataReader);
                    if (isCount && partitionSize == 0 && dataReader.NextResult())
                    {
                        dataReader.Read();
                        dbQueryResult.TotalRecords = dataReader.GetInt32(0);
                    }
                }
            }
            catch (Exception ex)
            {
                HttpContext.Current.Response.Write(selectFields + "<br>" + ex.Message);
            }
            return(dbQueryResult);
        }
Beispiel #3
0
        public static DbQueryResult PagingByTopnotin(int pageIndex, int pageSize, string sortBy, SortAction sortOrder, bool isCount, string table, string string_0, string filter, string selectFields)
        {
            DbQueryResult result;

            if (string.IsNullOrEmpty(table))
            {
                result = null;
            }
            else
            {
                if (string.IsNullOrEmpty(string_0))
                {
                    result = null;
                }
                else
                {
                    if (string.IsNullOrEmpty(selectFields))
                    {
                        selectFields = "*";
                    }
                    string        text          = DataHelper.BuildNotinQuery(pageIndex, pageSize, sortBy, sortOrder, isCount, table, string_0, filter, selectFields);
                    DbQueryResult dbQueryResult = new DbQueryResult();
                    Database      database      = DatabaseFactory.CreateDatabase();
                    System.Data.Common.DbCommand sqlStringCommand = database.GetSqlStringCommand(text);
                    using (System.Data.IDataReader dataReader = database.ExecuteReader(sqlStringCommand))
                    {
                        dbQueryResult.Data = DataHelper.ConverDataReaderToDataTable(dataReader);
                        if (isCount && dataReader.NextResult())
                        {
                            dataReader.Read();
                            dbQueryResult.TotalRecords = dataReader.GetInt32(0);
                        }
                    }
                    result = dbQueryResult;
                }
            }
            return(result);
        }