public object GetUserData([FromBody] JObject json)
{
try
{
ERCHTMS.Busines.BaseManage.UserBLL userBll = new ERCHTMS.Busines.BaseManage.UserBLL();
string res = json.Value <string>("json");
dynamic dy = JsonConvert.DeserializeObject <ExpandoObject>(res);
//获取用户Id
string userId = dy.userid;
OperatorProvider.AppUserId = userId; //设置当前用户
Operator curUser = OperatorProvider.Provider.Current();
if (null == curUser)
{
return(new { code = -1, count = 0, info = "请求失败,请登录!" });
}
//获取页数和条数
int page = Convert.ToInt32(dy.data.pageNum), rows = Convert.ToInt32(dy.data.pageSize);
Pagination pagination = new Pagination();
pagination.p_kid = "U.USERID";
pagination.p_fields = "U.REALNAME,U.DEPARTMENTID,D.FULLNAME as DeptName,U.WORKGROUPID,U.MOBILE,U.TELEPHONE,U.ISPRESENCE";
pagination.p_tablename = @"BASE_USER U
LEFT JOIN BASE_DEPARTMENT D ON U.DEPARTMENTID=D.DEPARTMENTID";
pagination.conditionJson = string.Format(" ORGANIZECODE ='{0}'", curUser.OrganizeCode);
//pagination.conditionJson = string.Format(" 1=1");
pagination.page = page; //页数
pagination.rows = rows; //行数
pagination.sidx = "u.createdate"; //排序字段
pagination.sord = "desc"; //排序方式
//查询条件 名称
string RealName = dy.data.RealName;
if (!string.IsNullOrEmpty(RealName))
{
pagination.conditionJson += string.Format(" and U.RealName='{0}'", RealName);
}
//查询条件 登记时间（创建日期）
string CreateDate = dy.data.CreateDate;
if (!string.IsNullOrEmpty(CreateDate))
{
pagination.conditionJson += string.Format(" and to_char(U.CreateDate,'yyyy-mm-dd')='{0}'", CreateDate);
}
DataTable dt = userBll.GetPageList(pagination, null);
var JsonData = new
{
rows = dt,
total = pagination.total,
page = pagination.page,
records = pagination.records,
};
return(new { code = 0, info = "获取数据成功", count = pagination.records, data = JsonData });
}
catch (Exception ex)
{
return(new { code = -1, info = ex.Message, count = 0 });
}
}
