public void GetWarehousePaged() { Query query = new Query(); query.Add(Criterion.Create <Warehouse>(i => i.Id, 0, CriteriaOperator.NotEqual)); ListPaged <Warehouse> a = this._warehouseRsponstroy.PagedFindBy(query, 1, 111); }
/// <summary> /// 根据项目号获取项目视图 /// </summary> /// <returns></returns> public IEnumerable <InOutReasonView> GetInOutReasonViewById(int id) { Query query = new Query(); query.Add(Criterion.Create <InOutReason>(c => c.Id, id, CriteriaOperator.Equal)); return(this._inOutReasonRepository.FindBy(query).ConvertToInOutReasonView()); }
/// <summary> /// 根据库房编号获取货架 /// </summary> /// <param name="id"></param> /// <returns></returns> public IEnumerable <WarehouseShelfView> GetWarehouseShelfViewByWarehoseId(int warehouseid) { Query query = new Query(); query.Add(Criterion.Create <WarehouseShelf>(c => c.WarehouseId, warehouseid, CriteriaOperator.Equal)); return(GetWarehouseShelfView(query)); }
public IEnumerable <OrganizationView> GetOrganizationView(int id) { Query query = new Query(); query.Add(Criterion.Create <Organization>(c => c.Id, id, CriteriaOperator.Equal)); return(this._organizationRepository.FindBy(query).ConvertToOrganizationView()); }
public ListPaged <ArrivalReceiptDetailView> GetArrivalReceiptDetailView(string purchaseId, int pageIndex, int pageSize, string sort) { Query query = new Query(); query.Add(Criterion.Create <ArrivalReceiptDetail>(p => p.Id, purchaseId, CriteriaOperator.GreaterThanOrEqual)); return(this._arrivalReceiptDetailRepository.PagedFindBy(query, pageIndex, pageSize).ConvertToPagedView()); }
/// <summary> /// 通过id获取所有库房视图 /// </summary> /// <returns></returns> public IEnumerable <ArrivalNoticeDetailView> GetArrivalNoticeDetailView(int id) { Query query = new Query(); query.Add(Criterion.Create <ArrivalNoticeDetail>(c => c.ArrivalNotice.Id, id, CriteriaOperator.Equal)); return(this._arrivalNoticeDetailRepository.FindBy(query).ConvertToArrivalNoticeDetailView()); }
public DeleteDataPointHistoryDataResponse DeleteDataPointHistoryData(DeleteDataPointHistoryDataRequst requst) { DeleteDataPointHistoryDataResponse response = new DeleteDataPointHistoryDataResponse(); try { Query query = new Query(); query.AddCriterion(Criterion.Create <DataPointHistoryData>(p => p.DateTime, requst.BeginTime, CriteriaOperator.GreaterThanOrEqual)); query.AddCriterion(Criterion.Create <DataPointHistoryData>(p => p.DateTime, requst.EndTime, CriteriaOperator.LesserThanOrEqual)); query.QueryOperator = QueryOperator.And; dataPointHistoryDataRepository.Remove(query); unitOfWork.Commit(); } catch (Exception ex) { string message = "删除失败!错误信息:/n" + ex.Message; response = new DeleteDataPointHistoryDataResponse() { ResponseSucceed = false, Message = "删除失败" }; LoggingFactory.GetLogger().WriteDebugLogger(message); return(response); } return(response); }
public GetDataPointByModuleResponse GetDataPointInfoByModule(GetDataPointByModuleRequest request) { GetDataPointByModuleResponse response = new GetDataPointByModuleResponse(); try { Query query = new Query(); query.AddCriterion(Criterion.Create <DataPoint>(p => p.ModuleBelongTo.Id, request.ModuleId, CriteriaOperator.Equal)); query.OrderByProperty = OrderByClause.Create <DataPoint>(p => p.Number, false); IEnumerable <DataPoint> dataPoints = _dataPointRepository.FindBy(query); response.DataPointInfoViews = dataPoints.ConverToDataPointInfoViews(); } catch (Exception ex) { string message = "查询失败!错误信息:/n" + ex.Message; response = new GetDataPointByModuleResponse() { ResponseSucceed = false, Message = "查询失败" }; LoggingFactory.GetLogger().WriteDebugLogger(message); return(response); } return(response); }
public static Query CreateQueryFor(GetProductByCategoryRequest request) { Query productQuery = new Query(); Query weightQuery = new Query(); Query manufacturerQuery = new Query(); productQuery.Add(Criterion.Create <Catalog>(p => p.RetailerId, request.RetailerId, CriteriaOperator.Equal)); productQuery.Add(Criterion.Create <Catalog>(p => p.Product.Category.Id, request.CategoryId, CriteriaOperator.Equal, ConditionOperator.And)); weightQuery.QueryOperator = QueryOperator.And; foreach (int id in request.WeightIds) { weightQuery.Add(Criterion.Create <Catalog>(p => p.Product.Weight.Id, id, CriteriaOperator.Equal, ConditionOperator.Or)); } manufacturerQuery.QueryOperator = QueryOperator.And; foreach (int id in request.ManufacturerIds) { manufacturerQuery.Add(Criterion.Create <Catalog>(p => p.Product.Manufacturer.Id, id, CriteriaOperator.Equal, ConditionOperator.Or)); } if (request.WeightIds.Count() > 0) { productQuery.AddSubQuery(weightQuery); } if (request.ManufacturerIds.Count() > 0) { productQuery.AddSubQuery(manufacturerQuery); } return(productQuery); }
public GetDataPiontHistoryDataResponse GetDataPiontHistoryData(GetDataPointHistoryDataRequest request) { GetDataPiontHistoryDataResponse response = new GetDataPiontHistoryDataResponse(); try { Query query = new Query(); query.AddCriterion(Criterion.Create <DataPointHistoryData>(p => p.DataPoint.Id, request.DataPointId, CriteriaOperator.Equal)); query.AddCriterion(Criterion.Create <DataPointHistoryData>(p => p.DateTime, request.BeginTime, CriteriaOperator.GreaterThanOrEqual)); query.AddCriterion(Criterion.Create <DataPointHistoryData>(p => p.DateTime, request.EndTime, CriteriaOperator.LesserThanOrEqual)); query.QueryOperator = QueryOperator.And; query.OrderByProperty = OrderByClause.Create <DataPointHistoryData>(p => p.DateTime, false); IEnumerable <DataPointHistoryData> dataPointHistoryDatas = dataPointHistoryDataRepository.FindBy(query); response.DataPointHistoryDataView = dataPointHistoryDatas.ConvetToDataPointHistoryDataView(); } catch (Exception ex) { string message = "查询失败!错误信息:/n" + ex.Message; response = new GetDataPiontHistoryDataResponse() { ResponseSucceed = false, Message = "查询失败" }; LoggingFactory.GetLogger().WriteDebugLogger(message); return(response); } return(response); }
/// <summary> /// 根据项目号获取项目视图 /// </summary> /// <returns></returns> public IEnumerable <ProjectAttendanceView> GetProjectAttendanceViewById(int id) { Query query = new Query(); query.Add(Criterion.Create <ProjectAttendance>(c => c.Id, id, CriteriaOperator.Equal)); return(this._projectAttendanceRepository.FindBy(query).ConvertToProjectAttendanceView()); }
/// <summary> /// 根据采购单类型号获取采购单类型视图 /// </summary> /// <returns></returns> public IEnumerable <SupplierView> GetSupplierViewById(int id) { Query query = new Query(); query.Add(Criterion.Create <Supplier>(c => c.Id, id, CriteriaOperator.Equal)); return(this._supplierRepository.FindBy(query).ConvertToSupplierView()); }
/// <summary> /// 根据付款类型号获取付款类型视图 /// </summary> /// <returns></returns> public IEnumerable <PaymentView> GetPaymentViewById(int id) { Query query = new Query(); query.Add(Criterion.Create <Payment>(c => c.Id, id, CriteriaOperator.Equal)); return(this._paymentRepository.FindBy(query).ConvertToPaymentView()); }
/// <summary> /// 根据状态获取采购单视图 /// </summary> /// <returns></returns> public ListPaged <ArrivalNoticeView> GetArrivalNoticePageView(GeArrivalNoticeRequest request) { Query query = new Query(); query.Add(Criterion.Create <ArrivalNotice>(c => c.State, 1, CriteriaOperator.Equal)); return(this._arrivalNoticeRepository.PagedFindBy(query, request.PageIndex, request.PageSize).ConvertToArrivalNoticeView()); }
/// <summary> /// 根据项目号获取项目视图 /// </summary> /// <returns></returns> public IEnumerable <PurchaseOrderDetailView> GetPurchaseOrderDetailViewByPurchaseOrderId(string purchaseOrderId) { Query query = new Query(); query.Add(Criterion.Create <PurchaseOrderDetail>(c => c.PurchaseOrder.Id, purchaseOrderId, CriteriaOperator.Equal)); return(GetPurchaseOrderDetailViewBy(query)); }
/// <summary> /// 获取所有历史状态 /// </summary> /// <param name="linkObjectId"></param> /// <returns></returns> public IEnumerable <WorkflowActivityView> GetCurrentActivityHistory(string objectId) { Query query = new Query(); query.Add(Criterion.Create <WorkflowActivity>(a => a.Id, objectId, CriteriaOperator.Equal)); return(this._workflowActivityRepository.FindBy(query).ConvertToWorkflowActivityView()); }
public IEnumerable <OrganizationView> GetOrganization() { Query query = new Query(); query.Add(Criterion.Create <Organization>(c => c.Parent, null, CriteriaOperator.IsNull)); return(this._organizationRepository.FindAll().ConvertToOrganizationView()); }
public void TestCreatQuery() { Query query = new Query(); query.AddCriterion(Criterion.Create <DataPoint>(p => p.Number, 10, CriteriaOperator.LesserThanOrEqual)); query.AddCriterion(Criterion.Create <DataPoint>(p => p.ModuleBelongTo.Id, 2, CriteriaOperator.Equal)); query.OrderByProperty = OrderByClause.Create <DataPoint>(p => p.Name, true); }
/// <summary> /// 根据状态获取采购单视图 /// 用于获取当前状态的采购单,在自己范围所辖范围内的 /// </summary> /// <returns></returns> public ListPaged <PurchaseOrderView> GetPurchaseOrderViewByStatus(GetPurchaseOrderRequest request) { Query query = new Query(); query.Add(Criterion.Create <PurchaseOrder>(c => c.StatuId, request.StatuId, CriteriaOperator.Equal)); query.Add(Criterion.Create <PurchaseOrder>(c => c.IsValid, true, CriteriaOperator.Equal)); return(this._purchaseOrderRepository.PagedFindBy(query, request.PageIndex, request.PageSize).ConvertToPurchaseOrderPagedView()); }
/// <summary> /// 获取所有库房视图 /// </summary> /// <returns></returns> public IEnumerable <WarehouseView> GetWarehouseViewByAll() { Query query = new Query(); query.Add(Criterion.Create <Warehouse>(p => p.IsValid, true, CriteriaOperator.Equal)); return(this._warehouseRepository.FindBy(query).ConvertToWarehouseView()); }
/// <summary> /// 根据操作人获取今天的到货单 /// </summary> /// <returns></returns> public ArrivalReceipt GetArrivalReceipt(string createUserId) { Query query = new Query(); query.Add(Criterion.Create <ArrivalReceipt>(c => c.CreateUserId, createUserId, CriteriaOperator.Equal)); query.Add(Criterion.Create <ArrivalReceipt>(c => c.CreateDate, DateTime.Now.ToShortDateString(), CriteriaOperator.GreaterThanOrEqual)); return(this._arrivalReceiptRepository.FindBy(query).First()); }
public IEnumerable <DataTreeView> GetRightsTreeView() { Query query = new Query(); query.Add(Criterion.Create <Rights>(c => c.Parent, null, CriteriaOperator.IsNull)); IEnumerable <Rights> rights = _rightsRepository.FindBy(query); return(rights.ConvertToDataTreeView()); }
public IEnumerable <SupplierView> GetSupplierView(string infromition) { Query query = new Query(); query.Add(Criterion.Create <Supplier>(c => c.Name, infromition + "%", CriteriaOperator.Like)); query.Add(Criterion.Create <Supplier>(c => c.MobilePhone, infromition, CriteriaOperator.Equal)); query.QueryOperator = QueryOperator.Or; return(this.GetSupplierView(query)); }
/// <summary> /// 获取所有的权限视图 /// </summary> /// <returns></returns> public IList <DataTree> GetRoleTreeView(int roleId) { Query query = new Query(); query.Add(Criterion.Create <Role>(c => c.Id, roleId, CriteriaOperator.Equal)); IEnumerable <Role> role = _roleRepository.FindBy(query); return(role.ConvertToDataTreeView()); }
/// <summary> /// 根据名称获取产品 /// </summary> /// <returns></returns> public IEnumerable <ProductView> GetProductViewByName(string name) { Query query = new Query(); query.Add(Criterion.Create <Product>(c => c.EnglishName, name + "%", CriteriaOperator.Like)); query.Add(Criterion.Create <Product>(c => c.ChineseName, name + "%", CriteriaOperator.Like)); query.QueryOperator = QueryOperator.Or; return(this._productRepository.FindAll().ConvertToProductView()); }
/// <summary> /// 获取用户的功能 /// </summary> /// <returns></returns> public IList <Menu> GetMenuView(string userid) { Users user = this._usersRepository.FindBy(userid); Query query = new Query(); query.Add(Criterion.Create <Rights>(c => c.Parent, null, CriteriaOperator.IsNull)); IEnumerable <Rights> rights = _rightsRepository.FindBy(query); return(rights.ConvertToDataMenuView(user)); }
public IList <int> GetOrganizationChildNode(int id) { IList <int> result = new List <int>(); Query query = new Query(); query.Add(Criterion.Create <Organization>(c => c.Id, id, CriteriaOperator.Equal)); IEnumerable <Organization> org = this._organizationRepository.FindBy(query); return(GetOrganizationNode(org)); }
/// <summary> /// 用户登录时查询 /// </summary> /// <param name="username">用户名</param> /// <param name="pass">密码</param> /// <returns></returns> public UsersView FindUsersBy(string username, string pass) { Query query = new Query(); query.Add(Criterion.Create <Users>(c => c.UserName, username, CriteriaOperator.Equal)); query.Add(Criterion.Create <Users>(c => c.UserPwd, pass, CriteriaOperator.Equal)); query.QueryOperator = QueryOperator.And; var users = _usersRepository.FindBy(query).ConvertToUsersView(); return(users.FirstOrDefault()); }
public GetCategoryResponse GetAllCategories(GetCategoryRequest request) { GetCategoryResponse response = new GetCategoryResponse(); Query categoryQuery = new Query(); categoryQuery.Add(Criterion.Create <CategoryAccess>(r => r.RetailerId, request.RetailerId, CriteriaOperator.Equal)); IEnumerable <CategoryAccess> categories = _categoryAccessRepository.FindBy(categoryQuery); response.Categories = categories.convertToCategoryViews(); return(response); }
/// <summary> /// 获取当前状态 /// </summary> /// <param name="linkObjectId"></param> /// <returns></returns> public WorkflowActivity GetCurrentActivity(string objectId) { WorkflowActivity activity = null; Query query = new Query(); query.Add(Criterion.Create <WorkflowActivity>(a => a.Id, objectId, CriteriaOperator.Equal)); query.Add(Criterion.Create <WorkflowActivity>(a => a.EndTime, null, CriteriaOperator.IsNull)); activity = this._workflowActivityRepository.FindBy(query).FirstOrDefault(); return(activity); }