Esempio n. 1
0
        /// <summary>
        /// 得到列表信息
        /// </summary>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <param name="status">状态</param>
        /// <param name="startlevel">开始重要性</param>
        /// <param name="endlevel">结束重要性</param>
        /// <param name="source">来源</param>
        /// <returns></returns>
        public static Dictionary <string, object> GetList(int pageIndex, int pageSize, int status, int startlevel = 0, int endlevel = 0, string source = "")
        {
            Dictionary <string, object> list         = new Dictionary <string, object>();
            List <DapperWhere>          dapperWheres = new List <DapperWhere>();

            dapperWheres.Add(new DapperWhere("dt_Status", status));
            if (startlevel > 0)
            {
                dapperWheres.Add(new DapperWhere("startLevel", startlevel, " dt_Level<@startLevel "));
            }
            if (endlevel > 0)
            {
                dapperWheres.Add(new DapperWhere("endLevel", endlevel, " dt_Level>=@endLevel "));
            }
            if (source.Length > 0)
            {
                dapperWheres.Add(new DapperWhere("dt_Source", source));
            }

            if (pageSize < 1)
            {
                pageSize = 20;
            }

            int rowCount = 0;

            if (pageIndex == 1)
            {
                rowCount = BLL.Base.Sys_TaskDailyBaseBLL.GetCount(dapperWheres);
            }
            int maxPage = 0;

            if (rowCount > 0)
            {
                maxPage = Convert.ToInt32(Math.Ceiling(Convert.ToDouble(rowCount) / pageSize));
            }

            List <Sys_TaskDailyInfo> data = Sys_TaskDailyBLL.GetList(pageIndex, pageSize, dapperWheres,
                                                                     " dt_Level asc,id desc");

            foreach (var item in data)
            {
                if (item.dt_remark.IndexOf('@') == 0)
                {
                    item.forumUrl = item.dt_remark.Substring(item.dt_remark.IndexOf('(') + 1,
                                                             item.dt_remark.IndexOf(')') - item.dt_remark.IndexOf('(') - 1);
                }
            }

            list["rowCount"]  = rowCount;
            list["maxPage"]   = maxPage;
            list["pageIndex"] = pageIndex;
            list["listData"]  = data;

            return(list);
        }
Esempio n. 2
0
        /// <summary>
        /// 获取首页显示的五条回访数据
        /// </summary>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <param name="status"></param>
        /// <param name="startlevel">小于 30 为非常紧急</param>
        /// <returns></returns>
        public static List <Sys_TaskDailyInfo> IndexDailyTaskInfo(int pageIndex = 1, int pageSize = 5, int status = 0, int startlevel = 30)
        {
            List <DapperWhere> dapperWheres = new List <DapperWhere>();

            dapperWheres.Add(new DapperWhere("dt_Status", status));
            if (startlevel > 0)
            {
                dapperWheres.Add(new DapperWhere("startLevel", startlevel, " dt_Level<@startLevel "));
            }

            List <Sys_TaskDailyInfo> list = Sys_TaskDailyBLL.GetList(pageIndex, pageSize, dapperWheres, " inertTime desc");

            foreach (var item in list)
            {
                if (item.dt_remark.IndexOf('@') == 0)
                {
                    item.forumUrl = item.dt_remark.Substring(item.dt_remark.IndexOf('(') + 1,
                                                             item.dt_remark.IndexOf(')') - item.dt_remark.IndexOf('(') - 1);
                }
            }

            return(list);
        }