Beispiel #1
0
        /// <summary>
        /// 读取错误日志列表
        /// </summary>
        /// <param name="pageNo"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        public PageOf <Log.ErrorLog> GetErrorLogList(int pageNo, int pageSize)
        {
            var QUERY_SQL = @"(  select Id,CreateTime,Thread,Level,Logger,Message,Exception,Name
                                 from J_ErrorLog 
                                 WHERE DATEDIFF(dd,CreateTime,GETDATE())<=30";

            QUERY_SQL += ") pp ";
            string SQL = string.Format(@" SELECT * FROM (SELECT ROW_NUMBER() OVER(ORDER BY pp.CreateTime DESC) AS RowNum,* FROM {0}
										) as A WHERE A.RowNum BETWEEN (@PageIndex-1)* @PageSize+1 AND @PageIndex*@PageSize ORDER BY RowNum;"                                        ,
                                       QUERY_SQL);

            SQL += string.Format(@" SELECT COUNT(1) FROM {0};", QUERY_SQL);

            object param = new { pageIndex = pageNo, pageSize = pageSize };

            DataSet ds = SQLHelper.FillDataSet(SQL, param);

            return(new PageOf <Log.ErrorLog>()
            {
                PageIndex = pageNo,
                PageSize = pageSize,
                Total = Convert.ToInt32(ds.Tables[1].Rows[0][0]),
                Items = DataMapHelper.DataSetToList <Log.ErrorLog>(ds)
            });
        }
Beispiel #2
0
        /// <summary>
        /// 读取运行日志列表
        /// </summary>
        /// <param name="pageNo"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        public PageOf <Log.RunLog> GetRunLogList(int pageNo, int pageSize)
        {
            var QUERY_SQL = @"( SELECT r.Id,r.Remark,r.Description,r.CreateTime,j.JobName,j.ClassName
                                FROM J_RunningLog r INNER JOIN J_Jobs j on r.JobID = j.JobID 
                                WHERE DATEDIFF(dd,r.CreateTime,GETDATE())<=30";

            QUERY_SQL += ") pp ";
            string SQL = string.Format(@" SELECT * FROM (SELECT ROW_NUMBER() OVER(ORDER BY pp.CreateTime DESC) AS RowNum,* FROM {0}
										) AS A WHERE A.RowNum BETWEEN (@PageIndex-1)* @PageSize+1 AND @PageIndex*@PageSize ORDER BY RowNum;"                                        ,
                                       QUERY_SQL);

            SQL += string.Format(@" SELECT COUNT(1) FROM {0};", QUERY_SQL);

            object param = new { pageIndex = pageNo, pageSize = pageSize };

            DataSet ds = SQLHelper.FillDataSet(SQL, param);

            return(new PageOf <Log.RunLog>()
            {
                PageIndex = pageNo,
                PageSize = pageSize,
                Total = Convert.ToInt32(ds.Tables[1].Rows[0][0]),
                Items = DataMapHelper.DataSetToList <Log.RunLog>(ds)
            });
        }
Beispiel #3
0
        /// <summary>
        /// 获取用户列表
        /// </summary>
        /// <param name="pageNo"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        public PageOf <User> GetUserList(int pageNo, int pageSize)
        {
            var QUERY_SQL = @"( SELECT UserId,UserName,PassWord,RealName,Email,Mobile,IsAdmin,Status,CreateTime,LastLoginTime
                                FROM U_User";

            QUERY_SQL += ") pp ";
            string SQL = string.Format(@" SELECT * FROM (SELECT ROW_NUMBER() OVER(ORDER BY pp.CreateTime desc) AS RowNum,* FROM {0}
										) AS A WHERE A.RowNum BETWEEN (@PageIndex-1)* @PageSize+1 AND @PageIndex*@PageSize ORDER BY RowNum;"                                        ,
                                       QUERY_SQL);

            SQL += string.Format(@" SELECT COUNT(1) FROM {0};", QUERY_SQL);

            object param = new { pageIndex = pageNo, pageSize = pageSize };

            DataSet ds = SQLHelper.FillDataSet(SQL, param);

            return(new PageOf <User>()
            {
                PageIndex = pageNo,
                PageSize = pageSize,
                Total = Convert.ToInt32(ds.Tables[1].Rows[0][0]),
                Items = DataMapHelper.DataSetToList <User>(ds)
            });
        }
Beispiel #4
0
        /// <summary>
        /// 获取任务列表
        /// </summary>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        public PageOf <Job> GetTaskList(int pageIndex, int pageSize)
        {
            var QUERY_SQL = @"( SELECT JobID,JobName,JobParams,CronExpression,AssemblyName,ClassName,Status,CreatedTime,ModifyTime,RecentRunTime,NextFireTime,CronRemark,Remark
	                            FROM J_Jobs WHERE Status <> -1"    ;

            QUERY_SQL += ") pp ";
            string SQL = string.Format(@" SELECT * FROM (SELECT ROW_NUMBER() OVER(ORDER BY pp.ModifyTime desc) AS RowNum,* FROM {0}
										) as A WHERE A.RowNum BETWEEN (@PageIndex-1)* @PageSize+1 AND @PageIndex*@PageSize ORDER BY RowNum;"                                        ,
                                       QUERY_SQL);

            SQL += string.Format(@" SELECT COUNT(1) FROM {0};", QUERY_SQL);

            object param = new { pageIndex = pageIndex, pageSize = pageSize };

            DataSet ds = SQLHelper.FillDataSet(SQL, param);

            return(new PageOf <Job>()
            {
                PageIndex = pageIndex,
                PageSize = pageSize,
                Total = Convert.ToInt32(ds.Tables[1].Rows[0][0]),
                Items = DataMapHelper.DataSetToList <Job>(ds)
            });
        }