/// <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)); }