/// <summary>
/// 用户列表
/// </summary>
/// <param name="pagination">分页</param>
/// <param name="queryJson">查询参数</param>
/// <returns></returns>
public DataTable GetPageList(Pagination pagination, string queryJson)
{
DatabaseType dataType = DbHelper.DbType;
if (queryJson.Length > 0)
{
var queryParam = queryJson.ToJObject();
//查询条件
if (!queryParam["condition"].IsEmpty() && !queryParam["keyword"].IsEmpty())
{
string condition = queryParam["condition"].ToString();
string keyord = queryParam["keyword"].ToString();
switch (condition)
{
case "ReserverPlanName": //预案名称
pagination.conditionJson += string.Format(" and ReserverPlanName like '%{0}%'", keyord);
break;
default:
break;
}
}
//公司主键
if (!queryParam["organizeId"].IsEmpty())
{
string organizeId = queryParam["organizeId"].ToString();
pagination.conditionJson += string.Format(" and ORGANIZEID = '{0}'", organizeId);
}
//部门主键
if (!queryParam["departmentId"].IsEmpty())
{
string departmentId = queryParam["departmentId"].ToString();
pagination.conditionJson += string.Format(" and departmentId = '{0}'", departmentId);
}
#region 权限判断
if (!queryParam["code"].IsEmpty() && !queryParam["isOrg"].IsEmpty())
{
pagination = PermissionByCurrent.GetPermissionByCurrent(pagination, queryParam["code"].ToString(), queryParam["isOrg"].ToString());
}
#endregion
}
return(this.BaseRepository().FindTableByProcPager(pagination, dataType));
}
