Пример #1
0
        /// <summary>
        /// job日志列表
        /// </summary>
        /// <returns></returns>
        public List <Job_Log> GetJobLogList(int pageIndex, int pageSize)
        {
            List <Job_Log> list = null;

            try
            {
                string SqlStr = "select * from job_log";
                SqlStr += string.Format(" limit {0},{1};", (pageIndex - 1) * pageSize, pageSize);
                var ds = MySqlHelper.GetDataSet(SqlStr);
                if (ds != null && ds.Tables[0].Rows.Count > 0)
                {
                    list = new List <Job_Log>();
                    Job_Log info = new Job_Log();
                    foreach (System.Data.DataRow row in ds.Tables[0].Rows)
                    {
                        info = Job_Log.ToEntity <Job_Log>(row, info);
                        if (info != null)
                        {
                            list.Add(info);
                        }
                    }
                }
            }
            finally
            {
            }

            return(list);
        }
Пример #2
0
        /// <summary>
        /// job日志列表
        /// </summary>
        /// <returns></returns>
        public List <Job_Log> GetJobLogList()
        {
            List <Job_Log> list = null;

            try
            {
                string SqlStr = "select * from job_log";
                var    ds     = MySqlHelper.GetDataSet(SqlStr);
                if (ds != null && ds.Tables[0].Rows.Count > 0)
                {
                    list = new List <Job_Log>();
                    Job_Log info = new Job_Log();
                    foreach (System.Data.DataRow row in ds.Tables[0].Rows)
                    {
                        info = Job_Log.ToEntity <Job_Log>(row, info);
                        if (info != null)
                        {
                            list.Add(info);
                        }
                    }
                }
            }
            finally
            {
            }

            return(list);
        }