/// <summary>
/// 职员分页查询(根据关键字)
/// </summary>
/// <param name="queryModel">查询请求实体</param>
/// <param name="key">关键字</param>
/// <param name="count">数据总数</param>
/// <returns></returns>
public List <EmployeeEntity> Query(RequestQueryModel queryModel, string key, out long count)
{
key = StringHelper.FormatDefault(key);
Expression <Func <EmployeeEntity, bool> > predicate = x => x.Account.ToLower().Contains(key);
return(Query(queryModel, predicate, out count));
}
public void ModelValuesAreNull_ReturnsEmptyString()
{
RequestQueryModel model = new RequestQueryModel();
string result = queryBuilder.BuildQuery(model);
Assert.AreEqual(string.Empty, result);
}
public string BuildQuery(RequestQueryModel model)
{
if (model == null)
{
return(string.Empty);
}
IEnumerable <Tuple <string, string> > nameValueList = this.GetNameValuesOfProperties(model);
return(this.BuildQueryString(nameValueList));
}
/// <summary>
/// 获取集合
/// </summary>
/// <param name="queryModel">查询请求实体</param>
/// <param name="predicate">条件</param>
/// <param name="count">数据总数</param>
/// <returns></returns>
public virtual List<TEntity> Query(RequestQueryModel queryModel, Expression<Func<TEntity, bool>> predicate, out long count)
{
int pageIndex = 0;
int pageSize = 10;
List<KeyValuePair<string, string>> sorting = null;
if (!VerifyHelper.IsNull(queryModel))
{
pageIndex = queryModel.PageIndex;
pageSize = queryModel.PageSize;
sorting = queryModel.Sorting;
}
return Query(pageIndex, pageSize, predicate, sorting, out count);
}
private void GenerateQueryRequestString()
{
RequestQueryModel request = new RequestQueryModel
{
Head = new SH3H.BM.Model.WxLifePay.Generic.BaseHead
{
Version = "1.0.1",
TranCode = "query",
TranSeqNum = "123456",
MerchantId = "123456"
},
Info = new SH3H.BM.Model.WxLifePay.Request.Info.RequestQueryInfo
{
BillKey = "010055392",
CompanyId = "123456",
BeginNum = "1",
QueryNum = "1"
}
};
Console.WriteLine(Sign(request));
}
public object CreateRequest([FromQuery] TokenQueryModel tokenInfo, [FromQuery] GroupIdentityModel groupIdentity, [FromQuery] RequestQueryModel requestInfo)
{
var userContext = tokenRepository.ValidateToken(userRepository, tokenInfo.Token);
if (!groupRepository.IsMember(userContext.user.Uuid, groupIdentity.GroupId))
{
throw new AuthorizationException($"User {userContext.user.Uuid} isn't group member", "not a group member");
}
if (requestInfo.Type == 0 || !Enum.IsDefined(typeof(RequestType), requestInfo.Type))
{
throw new BasicControllerException("Request type not defined.", "invalid request type", statusCode: System.Net.HttpStatusCode.UnprocessableEntity);
}
var type = (RequestType)requestInfo.Type;
var request = default(Request);
switch (type)
{
case RequestType.Lives:
request = new Request()
{
Type = (byte)RequestType.Lives,
Amount = 5,
Filled = 0,
Sender = userContext.user.Uuid
};
break;
default:
throw new BasicControllerException($"Handler for {type} reuqest type not implemented.", "server error", statusCode: System.Net.HttpStatusCode.InternalServerError);
}
requestRepository.Insert(request);
messageRepository.Send(userContext.user.Uuid, groupIdentity.GroupId, String.Empty, (byte)AttachmentType.Request, request.Id);
chatManager.NotifyNewMessageAsync(groupIdentity.GroupId);
return(RequestModel.Create(request));
}
private IEnumerable <Tuple <string, string> > GetNameValuesOfProperties(RequestQueryModel model)
{
return(this.GetAroundParamsProperty(model.RequestAuthParams).Concat(this.GetAroundParamsProperty(model.RequestBodyParams)));
}
public void RequestModelPassed_ReturnsQueryString(RequestQueryModel model, string expectedResult)
{
string result = queryBuilder.BuildQuery(model);
Assert.AreEqual(expectedResult, result);
}
private string BuildQuery(RequestQueryModel requestModel)
{
return(this.QueryBuilder.BuildQuery(requestModel));
}
