public ActionResult Index()
        {
            XCLCMS.View.AdminWeb.Models.UserInfo.UserInfoListVM viewModel = new XCLCMS.View.AdminWeb.Models.UserInfo.UserInfoListVM();

            #region 初始化查询条件

            viewModel.Search          = new XCLNetSearch.Search();
            viewModel.Search.TypeList = new List <XCLNetSearch.SearchFieldInfo>()
            {
                new XCLNetSearch.SearchFieldInfo("用户ID", "UserInfoID|number|text", ""),
                new XCLNetSearch.SearchFieldInfo("所属商户ID", "FK_MerchantID|number|text", ""),
                new XCLNetSearch.SearchFieldInfo("所属应用ID", "FK_MerchantAppID|number|text", ""),
                new XCLNetSearch.SearchFieldInfo("所属商户名", "MerchantName|string|text", ""),
                new XCLNetSearch.SearchFieldInfo("所属应用名", "MerchantAppName|string|text", ""),
                new XCLNetSearch.SearchFieldInfo("用户名", "UserName|string|text", ""),
                new XCLNetSearch.SearchFieldInfo("真实姓名", "RealName|string|text", ""),
                new XCLNetSearch.SearchFieldInfo("昵称", "NickName|string|text", ""),
                new XCLNetSearch.SearchFieldInfo("年龄", "Age|number|text", ""),
                new XCLNetSearch.SearchFieldInfo("性别", "SexType|string|select", XCLNetTools.Control.HtmlControl.Lib.GetOptions(typeof(XCLCMS.Data.CommonHelper.EnumType.UserSexTypeEnum))),
                new XCLNetSearch.SearchFieldInfo("出生日期", "Birthday|dateTime|text", ""),
                new XCLNetSearch.SearchFieldInfo("手机号", "Tel|string|text", ""),
                new XCLNetSearch.SearchFieldInfo("QQ", "QQ|string|text", ""),
                new XCLNetSearch.SearchFieldInfo("电子邮件", "Email|string|text", ""),
                new XCLNetSearch.SearchFieldInfo("其它联系方式", "OtherContact|string|text", ""),
                new XCLNetSearch.SearchFieldInfo("备注", "Remark|string|text", ""),
                new XCLNetSearch.SearchFieldInfo("角色", "RoleName|string|text", ""),
                new XCLNetSearch.SearchFieldInfo("用户状态", "UserState|string|select", XCLNetTools.Control.HtmlControl.Lib.GetOptions(typeof(XCLCMS.Data.CommonHelper.EnumType.UserStateEnum))),
                new XCLNetSearch.SearchFieldInfo("用户类别", "UserType|string|select", XCLNetTools.Control.HtmlControl.Lib.GetOptions(typeof(XCLCMS.Data.CommonHelper.EnumType.UserTypeEnum))),
                new XCLNetSearch.SearchFieldInfo("记录状态", "RecordState|string|select", XCLNetTools.Control.HtmlControl.Lib.GetOptions(typeof(XCLCMS.Data.CommonHelper.EnumType.RecordStateEnum))),
                new XCLNetSearch.SearchFieldInfo("创建时间", "CreateTime|dateTime|text", ""),
                new XCLNetSearch.SearchFieldInfo("创建者名", "CreaterName|string|text", ""),
                new XCLNetSearch.SearchFieldInfo("更新时间", "UpdateTime|dateTime|text", ""),
                new XCLNetSearch.SearchFieldInfo("更新人名", "UpdaterName|string|text", "")
            };
            string strWhere = viewModel.Search.StrSQL;

            if (!XCLCMS.Lib.Permission.PerHelper.HasPermission(base.UserID, Data.CommonHelper.Function.FunctionEnum.SysFun_DataFilter_ShowAllRecordState))
            {
                strWhere = XCLNetTools.DataBase.SQLLibrary.JoinWithAnd(new List <string>()
                {
                    strWhere,
                    "RecordState='N'"
                });
            }

            #endregion 初始化查询条件

            var request = XCLCMS.Lib.WebAPI.Library.CreateRequest <XCLCMS.Data.WebAPIEntity.RequestEntity.PageListConditionEntity>(base.UserToken);
            request.Body = new Data.WebAPIEntity.RequestEntity.PageListConditionEntity()
            {
                PagerInfoSimple = base.PageParamsInfo.ToPagerInfoSimple(),
                Where           = strWhere
            };
            var response = XCLCMS.Lib.WebAPI.UserInfoAPI.PageList(request).Body;
            viewModel.UserInfoList = response.ResultList;
            viewModel.PagerModel   = response.PagerInfo;

            return(View("~/Views/UserInfo/UserInfoList.cshtml", viewModel));
        }
示例#2
0
        public ActionResult Index()
        {
            XCLCMS.View.AdminWeb.Models.UserInfo.UserInfoListVM viewModel = new XCLCMS.View.AdminWeb.Models.UserInfo.UserInfoListVM();

            #region 初始化查询条件

            viewModel.Search          = new XCLNetSearch.Search();
            viewModel.Search.TypeList = new List <XCLNetSearch.SearchFieldInfo>()
            {
                new XCLNetSearch.SearchFieldInfo("用户ID", "UserInfoID|number|text", ""),
                new XCLNetSearch.SearchFieldInfo("所属商户", "FK_MerchantID|number|text", ""),
                new XCLNetSearch.SearchFieldInfo("所属应用", "FK_MerchantAppID|number|text", ""),
                new XCLNetSearch.SearchFieldInfo("用户名", "UserName|string|text", ""),
                new XCLNetSearch.SearchFieldInfo("真实姓名", "RealName|string|text", ""),
                new XCLNetSearch.SearchFieldInfo("昵称", "NickName|string|text", ""),
                new XCLNetSearch.SearchFieldInfo("年龄", "Age|number|text", ""),
                new XCLNetSearch.SearchFieldInfo("性别", "SexType|string|select", XCLNetTools.Control.HtmlControl.Lib.GetOptions(typeof(XCLCMS.Data.CommonHelper.EnumType.UserSexTypeEnum))),
                new XCLNetSearch.SearchFieldInfo("出生日期", "Birthday|dateTime|text", ""),
                new XCLNetSearch.SearchFieldInfo("手机号", "Tel|string|text", ""),
                new XCLNetSearch.SearchFieldInfo("QQ", "QQ|string|text", ""),
                new XCLNetSearch.SearchFieldInfo("电子邮件", "Email|string|text", ""),
                new XCLNetSearch.SearchFieldInfo("其它联系方式", "OtherContact|string|text", ""),
                new XCLNetSearch.SearchFieldInfo("备注", "Remark|string|text", ""),
                new XCLNetSearch.SearchFieldInfo("角色", "RoleName|string|text", ""),
                new XCLNetSearch.SearchFieldInfo("用户状态", "UserState|string|select", XCLNetTools.Control.HtmlControl.Lib.GetOptions(typeof(XCLCMS.Data.CommonHelper.EnumType.UserStateEnum))),
                new XCLNetSearch.SearchFieldInfo("创建时间", "CreateTime|dateTime|text", ""),
                new XCLNetSearch.SearchFieldInfo("创建者名", "CreaterName|string|text", ""),
                new XCLNetSearch.SearchFieldInfo("更新时间", "UpdateTime|dateTime|text", ""),
                new XCLNetSearch.SearchFieldInfo("更新人名", "UpdaterName|string|text", "")
            };
            string strWhere  = string.Format("RecordState='{0}'", XCLCMS.Data.CommonHelper.EnumType.RecordStateEnum.N.ToString());
            string strSearch = viewModel.Search.StrSQL;
            if (!string.IsNullOrEmpty(strSearch))
            {
                strWhere = string.Format("{0} and ({1})", strWhere, strSearch);
            }

            #endregion 初始化查询条件

            var request = XCLCMS.Lib.WebAPI.Library.CreateRequest <XCLCMS.Data.WebAPIEntity.RequestEntity.PageListConditionEntity>(base.UserToken);
            request.Body = new Data.WebAPIEntity.RequestEntity.PageListConditionEntity()
            {
                PagerInfoSimple = base.PageParamsInfo.ToPagerInfoSimple(),
                Where           = strWhere
            };
            var response = XCLCMS.Lib.WebAPI.UserInfoAPI.PageList(request).Body;
            viewModel.UserInfoList = response.ResultList;
            viewModel.PagerModel   = response.PagerInfo;

            return(View("~/Views/UserInfo/UserInfoList.cshtml", viewModel));
        }