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
}
