/// <summary>
/// 获取客服列表，用于简单列表显示，应用场景为下拉菜单
/// </summary>
/// <param name="depId">部门Id</param>
/// <param name="callback">数据返回回调函数</param>
public void GetUserInfoByDepartmentId(int depId, EventHandler <RestClientEventArgs <List <UserInfo> > > callback)
{
UserInfoQueryFilter filter = new UserInfoQueryFilter();
filter.DepartmentId = depId;
filter.Status = BizOperationUserStatus.Active;
filter.PagingInfo = new PagingInfo
{
PageIndex = 0,
PageSize = 9999
};
string relativeUrl = "/CommonService/User/GetUserInfoList";
GetRestClient(ConstValue.DomainName_Common).Query <List <UserInfo> >(relativeUrl, filter, callback);
}
/// <summary>
/// 返回系统用户列表
/// </summary>
/// <param name="filter">过滤条件集合</param>
/// <returns></returns>
//[Caching("local", new string[] { "filter" }, ExpiryType = ExpirationType.SlidingTime, ExpireTime = "02:00:00")]
public virtual List <UserInfo> GetUserInfoList(UserInfoQueryFilter filter)
{
CustomDataCommand cmd = DataCommandManager.CreateCustomDataCommandFromConfig("GetUserInfoList");
using (var sb = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, ToPagingInfo(filter.PagingInfo), "[DisplayName] ASC"))
{
//商品ID
sb.ConditionConstructor.AddCondition(
QueryConditionRelationType.AND,
"DepartmentCode",
DbType.Int32,
"@DepartmentCode",
QueryConditionOperatorType.Equal,
filter.DepartmentId
);
//公司编码
sb.ConditionConstructor.AddCondition(
QueryConditionRelationType.AND,
"CompanyCode",
DbType.String,
"@CompanyCode",
QueryConditionOperatorType.Equal,
filter.CompanyCode
);
if (filter.Status.HasValue)
{
sb.ConditionConstructor.AddCondition(
QueryConditionRelationType.AND,
"Status",
DbType.Int32,
"@Status",
QueryConditionOperatorType.Equal,
filter.Status
);
}
cmd.CommandText = sb.BuildQuerySql();
return(cmd.ExecuteEntityList <UserInfo>());
}
}
public List <UserInfo> GetUserInfoList(UserInfoQueryFilter filter)
{
return(ObjectFactory <ICommonDA> .Instance.GetUserInfoList(filter));
}
