예제 #1
0
        public ActionResult TableServerSideGetData(int pageIndex, int pageSize, int SessionStaffID = 0, string filter = "")
        {
            var db            = new EmployeeRelationshipsDAL();
            int?total         = 0;
            var baseListParam = new BaseListParam()
            {
                FilterField  = filter,
                OrderByField = "",
                UserType     = Global.CurrentUser.RoleId,
                UserId       = Global.CurrentUser.LoginUserId,
                DeptId       = Global.CurrentUser.OrganizationUnitID,
                PageIndex    = pageIndex,
                PageSize     = pageSize,
                LanguageCode = Global.CurrentUser.CurrentLanguageID.ToString()
            };
            int staffID = 0;

            int.TryParse(Session["StaffID"].ToString(), out staffID);
            var result   = db.GetEmployeeRelationships(baseListParam, out total, SessionStaffID);
            var lstTotal = new TableColumnsTotalModel();

            lstTotal.Total1 = "15";
            lstTotal.Total2 = "25";
            lstTotal.Total3 = "35";
            return(Content(JsonConvert.SerializeObject(new
            {
                employees = result,
                totalCount = total,
                lstTotal = lstTotal
            })));
        }
예제 #2
0
        public ActionResult TableServerSideGetData2(int pageIndex, int pageSize, string filter = "")
        {
            var db            = new EmployeeRelationshipsDAL();
            int?total         = 0;
            var baseListParam = new BaseListParam()
            {
                FilterField  = filter,
                OrderByField = "",
                UserType     = Global.CurrentUser.RoleId,
                UserId       = Global.CurrentUser.LoginUserId,
                DeptId       = Global.CurrentUser.OrganizationUnitID,
                PageIndex    = pageIndex,
                PageSize     = pageSize,
                LanguageCode = Global.CurrentUser.CurrentLanguageID.ToString()
            };
            int staffID = 0;
            var result  = db.GetEmployeeRelationships(baseListParam, out total, staffID);

            return(Content(JsonConvert.SerializeObject(new
            {
                employees = result,
                totalCount = total
            })));
        }