public ResGetUserList GetUserList([FromBody] ReqGetUser user) { ResGetUserList retValue = new ResGetUserList(); try { //获取转化表格 using (var db = DbContext.GetInstance()) { var userList = db.Queryable <UsersBase>() .Where(s => s.isMale == user.isMale) .ToList(); //转化成前端友好的数据 //var list = userList.Select(s => //{ // var model = new UsersBase(); // model = ModelConvert.FromTo<T_USERS, UsersBase>(s, model); // return model; //}).ToList(); retValue.SuccessDefalut(userList, userList.Count); } } catch (Exception ex) { retValue.FailDefalut(ex); } return(retValue); }
/// <summary> /// 获取用户列表 /// </summary> /// <returns></returns> public Stream GetUserList() { ResGetUserList response = new ResGetUserList(); try { //获取数据调用数据库接口 DataTable dt = UserEntity.getUserList4App(); UserListInfo userlist = new UserListInfo(); List <UserInfo> userinfoList = ResGetUserList.Transfer(dt); userlist.count = UserEntity.getUserCount4App(); userlist.list = userinfoList; //组织数据 response.userlist = userlist; //输出成功状态 response.SetSuccess(); } catch (Exception ex) { Console.WriteLine(ex.Message); #region 日志输出 CommonInfo.Error("手机端获取用户列表错误" + ex.Message); #endregion } //将消息序列化为Json格式数据 DataContractJsonSerializer obj2Json = new DataContractJsonSerializer(typeof(ResGetUserList)); MemoryStream ms = new MemoryStream(); obj2Json.WriteObject(ms, response); //注意一定要设置流的位置到开始位置,否则没有消息输出 ms.Position = 0; return(ms); }
public Stream GetUserList(Stream data) { #region 查找数据 ResGetUserList response = new ResGetUserList(); bool success = true; try { DataContractJsonSerializer json = new DataContractJsonSerializer(typeof(ReqGetUserList)); //读取器 StreamReader sr = new StreamReader(data); string dataString = String.Empty; while (!sr.EndOfStream) { dataString = sr.ReadToEnd(); Console.WriteLine(dataString); #region 日志输出 CommonInfo.Log(dataString); #endregion //反序列化json为对象注意顺序很重要 ReqGetUserList request = new ReqGetUserList(); MemoryStream temp = new MemoryStream(Encoding.UTF8.GetBytes(dataString)); request = json.ReadObject(temp) as ReqGetUserList; //关闭临时流 temp.Close(); //调用用户更新密码接口 if (request != null) { //**********(此处加入代码) 根据查询条件 加入业务逻辑代码************* // 身份验证 if (request.account != null && request.account != String.Empty && request.token != null && request.token != String.Empty) { //管理员权限验证 bool isAdmin = PatrolUserInfoRule.AdminCheck(request.account, request.token); if (isAdmin) { // sql查询字符串组织 string queryString = String.Empty; string rangeString = String.Empty; // 按条件查询 if (request.search_info != null) { #region 属性查询对应 if (request.search_info.agency_shop != null && request.search_info.agency_shop != String.Empty) { queryString += " and t.CompanyCD = '" + request.search_info.agency_shop + "' "; } if (request.search_info.filiale != null && request.search_info.filiale != String.Empty) { queryString += " and t.SubCompanyCD = '" + request.search_info.filiale + "' "; } if (request.search_info.user_id != null && request.search_info.user_id != String.Empty) { //用户编号或者名称 queryString += " and (t.StaffCD = '" + request.search_info.user_id + "' or t.StaffNM = '" + request.search_info.user_id + "' ) "; } //分页控制对象范围 int pageIndex = 1; int pageSize = 10; if (request.search_info.Paginator != null) { pageIndex = request.search_info.Paginator.PageIndex; pageIndex = pageIndex > 0 ? pageIndex : 1; pageSize = request.search_info.Paginator.PageSize; pageSize = pageSize > 0 ? pageSize : 10; int rangeStart = (pageIndex - 1) * pageSize + 1; int rangeEnd = pageIndex * pageSize; rangeString += " and orderno between " + rangeStart + " and " + rangeEnd + " "; } else { rangeString += " and orderno between " + pageIndex + " and " + pageSize + " "; } //获取数据调用数据库接口 DataTable dt = UserEntity.getUserList(queryString, rangeString); //转换数据 response.user_list = ResGetUserList.Transfer(dt); response.count = UserEntity.getUserCount(queryString); success = true; #endregion } } } } } sr.Close(); Console.WriteLine(data); } catch (Exception ex) { Console.WriteLine(ex.Message); #region 日志输出 CommonInfo.Error("获取特巡列表数据错误" + ex.Message); #endregion } //返回消息体 if (success) { response.SetSuccess(); } else { ////默认是失败 //response.SetFailed(); } //将消息序列化为Json格式数据 DataContractJsonSerializer obj2Json = new DataContractJsonSerializer(typeof(ResGetUserList)); MemoryStream ms = new MemoryStream(); obj2Json.WriteObject(ms, response); //注意一定要设置流的位置到开始位置,否则没有消息输出 ms.Position = 0; return(ms); #endregion }