private QueryResult <SystemUser> _UserQuery(QF_SystemUser filter) { var data = new List <SystemUser> (); foreach (var user in UserData) { if ( (!filter.SysNo.HasValue || filter.SysNo.Value == user.SysNo) && (!filter.CommonStatus.HasValue || filter.CommonStatus.Value == user.CommonStatus) && (string.IsNullOrWhiteSpace(filter.LoginName) || filter.LoginName == user.LoginName) && (string.IsNullOrWhiteSpace(filter.UserFullName) || filter.UserFullName == user.UserFullName) && (string.IsNullOrWhiteSpace(filter.CellPhone) || filter.CellPhone == user.CellPhone) ) { data.Add(user); } } QueryResult <SystemUser> result = new QueryResult <SystemUser>(); result.PageIndex = filter.PageIndex; result.PageSize = filter.PageSize; result.SortFields = filter.SortFields; result.data = data; result.recordsTotal = data.Count(); return(result); }
public IActionResult UserQuery() { QF_SystemUser filter = BuildQueryFilterEntity <QF_SystemUser>(); var result = _UserQuery(filter); return(AjaxGridJson(result)); }
public JsonResult QueryInstallers() { QF_SystemUser filter = new QF_SystemUser { PageSize = 10000, CommonStatus = CommonStatus.Actived, IsPlatformManager = true }; var result = user_service.QuerySystemUserList(filter); return(Json(new AjaxResult { Success = true, Data = result.data })); }
public ActionResult List(int?companySysNo) { int no = companySysNo.GetValueOrDefault(); if (!companySysNo.HasValue) { if (CurrUser.CompanySysNo > 0) { no = CurrUser.CompanySysNo; } } AddressManagerModel model = new AddressManagerModel { CompanySysNo = no }; var company = CompanyService.LoadCompany(no); if (company != null) { model.AreaSysNo = company.AreaSysNo; model.Address = company.Address; } else { model.HasError = true; model.ErrorMessage = "客户信息不存在可能已经被删除,请刷新页面重试。"; } QF_SystemUser filter = new QF_SystemUser() { PageSize = 10000, PageIndex = 0, MasterSysNo = no, CommonStatus = CommonStatus.Actived }; AddressFilter addFilter = new AddressFilter { PageSize = 5, AddressGrade = AddressGrade.Building, CompanySysNo = no }; QueryResult <Address> addResult = AddressService.QueryAddressList(addFilter); if (addResult != null && addResult.data != null) { var root = addResult.data.Find(a => a.ParentSysNo.GetValueOrDefault() == 0); if (root != null) { model.AreaSysNo = root.AreaSysNo; model.Address = root.PathName; } } SystemUserService user_service = new SystemUserService(); var result = user_service.QuerySystemUserList(filter); model.ManagerList = result.data; return(View(model)); }
public ActionResult QueryCompanyUser() { QF_SystemUser filter = BuildQueryFilterEntity <QF_SystemUser>(); if (CurrUser.MasterSysNo.GetValueOrDefault() > 0) { filter.MasterSysNo = CurrUser.MasterSysNo; } var result = user_service.QuerySystemUserList(filter); return(AjaxGridJson(result)); }
public ActionResult Query() { string json = Request["data"]; if (string.IsNullOrWhiteSpace(json)) { throw new BusinessException("传入数据不能为空"); } QF_SystemUser qf = JsonConvert.DeserializeObject <QF_SystemUser>(json); qf.ApplicationID = ConstValue.ApplicationID; var result = user_service.QuerySystemUserList(qf); return(AjaxJsonTableData(result)); }
/// <summary> /// 分页查询SystemUser信息 /// </summary> public QueryResult <SystemUser> QuerySystemUserList(QF_SystemUser filter) { return(SystemUserDA.QuerySystemUserList(filter)); }
/// <summary> /// 分页查询SystemUser信息 /// </summary> public static QueryResult <SystemUser> QuerySystemUserList(QF_SystemUser filter) { //if (string.IsNullOrEmpty(filter.ApplicationID)) //{ DataCommand cmd = new DataCommand("QuerySystemUserList"); cmd.QuerySetCondition("u.SysNo", ConditionOperation.Equal, DbType.Int32, filter.SysNo); if (!string.IsNullOrEmpty(filter.KeyWords)) { cmd.QuerySetCondition($"And (u.CellPhone like '%{cmd.SetSafeParameter(filter.KeyWords)}%' OR u.UserFullName like '%{cmd.SetSafeParameter(filter.KeyWords)}%' OR u.LoginName like '%{cmd.SetSafeParameter(filter.KeyWords)}%' )"); } //cmd.QuerySetCondition("u.Email", ConditionOperation.Equal, DbType.AnsiString, filter.Email); cmd.QuerySetCondition("u.CommonStatus", ConditionOperation.Equal, DbType.Int32, filter.CommonStatus); if (filter.MasterSysNo.HasValue) { cmd.QuerySetCondition("u.MasterSysNo", ConditionOperation.Equal, DbType.Int32, filter.MasterSysNo); } else if (filter.IsPlatformManager) { cmd.QuerySetCondition("And (u.MasterSysNo is NUll Or u.MasterSysNo=0)"); } QueryResult <SystemUser> result = cmd.Query <SystemUser>(filter, " u.SysNo DESC"); if (result.data != null && result.data.Count > 0) { List <SystemApplication> apps = AuthDA.GetSystemApplicationsByUserSysNo(from s in result.data select s.SysNo); result.data.ForEach(x => { x.Applications = apps.FindAll(y => y.BizSysNo == x.SysNo); }); } return(result); //} //else //{ // DataCommand cmd = new DataCommand("QuerySystemUserListBuyApplication"); // cmd.QuerySetCondition("u.SysNo", ConditionOperation.Equal, DbType.Int32, filter.SysNo); // cmd.QuerySetCondition("u.LoginName", ConditionOperation.Like, DbType.AnsiString, cmd.SetSafeParameter(filter.LoginName)); // cmd.QuerySetCondition("u.UserFullName", ConditionOperation.Like, DbType.String, cmd.SetSafeParameter(filter.UserFullName)); // cmd.QuerySetCondition("u.CellPhone", ConditionOperation.Like, DbType.String, cmd.SetSafeParameter(filter.CellPhone)); // cmd.QuerySetCondition("u.Email", ConditionOperation.Equal, DbType.AnsiString, cmd.SetSafeParameter(filter.Email)); // cmd.QuerySetCondition("u.CommonStatus", ConditionOperation.Equal, DbType.Int32, filter.CommonStatus); // //cmd.QuerySetCondition("u.CommonStatus", ConditionOperation.NotEqual, DbType.Int32, CommonStatus.Deleted); // cmd.QuerySetCondition("ua.ApplicationID", ConditionOperation.Equal, DbType.AnsiString, cmd.SetSafeParameter(filter.ApplicationID)); // if (filter.MasterSysNo.HasValue) // { // cmd.QuerySetCondition("u.MasterSysNo", ConditionOperation.Equal, DbType.Int32, filter.MasterSysNo); // } // else // { // cmd.QuerySetCondition("And (u.MasterSysNo is NUll Or u.MasterSysNo=0)"); // } // QueryResult<SystemUser> result = cmd.Query<SystemUser>(filter, " u.SysNo DESC"); // if (result.data != null && result.data.Count > 0) // { // List<SystemApplication> apps = AuthDA.GetSystemApplicationsByUserSysNo(from s in result.data select s.SysNo); // result.data.ForEach(x => // { // x.Applications = apps.FindAll(y => y.BizSysNo == x.SysNo); // }); // } // return result; //} }