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