Esempio n. 1
0
        public IActionResult LoadData()
        {
            try
            {
                var parms = DatatableHelper.GetDatatableParms(Request.Form);

                int recordsTotal = 0;

                var data = _depManageBll.Find(z =>
                                              string.IsNullOrEmpty(parms.searchValue) ||
                                              z.Name.Contains(parms.searchValue) ||
                                              z.Address.Contains(parms.searchValue));

                recordsTotal = data.Count();

                var list = data
                           .Skip(parms.skip)
                           .Take(parms.pageSize)
                           .ToList();

                if (!string.IsNullOrEmpty(parms.sortColumn))
                {
                    bool isDesc = parms.sortColumnDirection == "desc";

                    list = OrderDynamicaly.OrderByDynamic <DepartmentMangers>(list.AsQueryable(), parms.sortColumn, isDesc).ToList();
                }

                return(Json(new { parms.draw, recordsFiltered = recordsTotal, recordsTotal, data = list }));
            }
            catch (Exception x)
            {
                return(Json(new { draw = 0, recordsFiltered = 0, recordsTotal = 0, data = string.Empty }));
            }
        }
Esempio n. 2
0
        /// <summary>
        /// 获取房间信息
        /// </summary>
        private void Getroominfo()
        {
            List <Roomtype> lst_roomtype = new List <Roomtype>();
            List <Room>     lst_room     = new List <Room>();

            // 获取房间类型
            lst_roomtype = (List <Roomtype>)DatatableHelper.ConvertTo <Roomtype>(bll_room.Getroomtype());
            for (int i = 0; i < lst_roomtype.Count; i++)
            {
                //每一种房间类型作为一个tab添加至tabcontrol
                tab_roomtype.TabPages.Add(lst_roomtype[i].dmsm1);
                //每一个tab中的房间自动排列
                FlowLayoutPanel flp = new FlowLayoutPanel();
                flp.Name = "flp" + i;
                tab_roomtype.TabPages[i].Controls.Add(flp);
                //在这一个tab中添加此种类型的所有房间
                lst_room = (List <Room>)DatatableHelper.ConvertTo <Room>(bll_room.Getroom(lst_roomtype[i].dmz));
                for (int j = 0; j < lst_room.Count; j++)
                {
                    Button btn = new Button();
                    btn.Name = lst_room[j].kfbh;
                    //不同状态的房间设置不同的背景图片
                    switch (lst_room[j].zt)
                    {
                    case "0":
                        btn.Image = Properties.Resources.room0;
                        break;

                    case "1":
                        btn.Image = Properties.Resources.room1;
                        break;

                    case "2":
                        btn.Image = Properties.Resources.room2;
                        break;

                    case "3":
                        btn.Image = Properties.Resources.room3;
                        break;

                    case "4":
                        btn.Image = Properties.Resources.room0;
                        break;
                    }
                    //btn.Image = Properties.Resources.room0;
                    btn.Height    = 70;
                    btn.Width     = 70;
                    btn.Text      = lst_room[j].kfbh;
                    btn.TextAlign = ContentAlignment.BottomCenter;
                    flp.Controls.Add(btn);
                    btn.Click += new EventHandler(aBtn_Click);
                }
            }
        }
Esempio n. 3
0
        public JsonResult Datatable(RoleRequest request)
        {
            #region 自定义动作
            if (!string.IsNullOrEmpty(request.customActionType))
            {
                List <int> ids = DatatableHelper.ArrayStringToListInt(Request.Params.GetValues("id[]"));

                switch (request.customActionType)
                {
                case "group_action":

                    switch (request.customActionName)
                    {
                    case "delete":
                        this.AccountService.DeleteRole(ids);
                        break;
                    }
                    break;

                case "delete":
                    this.AccountService.DeleteRole(ids);
                    break;
                }
            }
            #endregion

            var allRoles = this.AccountService.GetRoleList(null);

            IEnumerable <Role> filterRoles = allRoles;

            #region 搜索
            if (!string.IsNullOrEmpty(request.search))
            {
                var isNameSearchable = Convert.ToBoolean(Request["columns[0][searchable]"]);
            }
            else if (request.action == "filter")
            {
                var NameFilter = Convert.ToString(Request["name"]);


                var isNameSearchable = string.IsNullOrEmpty(Request["columns[1][searchable]"].ToString()) ? false : true;



                if (isNameSearchable)
                {
                    filterRoles = filterRoles.Where(c => c.Name.ToLower().Contains(NameFilter));
                }
            }
            else if (request.action == "filter_cancel")
            {
                filterRoles = allRoles;
            }
            else
            {
                filterRoles = allRoles;
            }
            #endregion

            #region 排序
            var isNameSortable = Convert.ToBoolean(Request["columns[1][orderable]"]);



            var sortColumnIndex = Convert.ToInt32(Request["order[0][column]"]);

            Func <Role, string> orderingFunction = (c =>
                                                    sortColumnIndex == 1 && isNameSortable ? c.Name :
                                                    "");
            var sortDirection = Request["order[0][dir]"]; // asc or desc

            if (sortDirection == "asc")
            {
                filterRoles = filterRoles.OrderBy(orderingFunction);
            }

            if (sortDirection == "desc")
            {
                filterRoles = filterRoles.OrderByDescending(orderingFunction);
            }
            #endregion

            var displayedRoles = filterRoles.Skip(request.start).Take(request.length);
            var result         = from c in displayedRoles
                                 select new[] {
                Convert.ToString(c.ID)
                , c.Name
                , c.Info
                , StringUtil.CutString(string.Join(",", c.BusinessPermissionList.Select(r => Evisou.Framework.Utility.EnumHelper.GetEnumTitle(r))), 40)
                , Convert.ToString(c.ID)
            };
            return(Json(new
            {
                draw = request.draw,             //param.sEcho,
                recordsTotal = allRoles.Count(), //alltransactions.Count(),
                recordsFiltered = filterRoles.Count(),
                data = result
            },
                        JsonRequestBehavior.AllowGet));
        }