public List <OPC_Sale> GetListByNos(List <string> salesOrderNos, SaleOrderFilter filter)
{
var query = Filler(filter);
query = PredicateBuilder.And(query, v => salesOrderNos.Contains(v.SaleOrderNo));
return(Func(db => EFHelper.Get(db, query).ToList()));
}
/// <summary>
/// Order 筛选
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
private static Expression <Func <Order, bool> > OrderFilter(RmaQueryRequest filter)
{
var query = PredicateBuilder.True <Order>();
if (filter != null)
{
if (filter.OrderProductType != null)
{
query = PredicateBuilder.And(query, v => v.OrderProductType == filter.OrderProductType);
}
//购买时间
if (filter.BuyStartDate != null)
{
query = PredicateBuilder.And(query, v => v.CreateDate >= filter.BuyStartDate.Value);
}
if (filter.BuyEndDate != null)
{
query = PredicateBuilder.And(query, v => v.CreateDate < filter.BuyEndDate.Value);
}
if (!String.IsNullOrEmpty(filter.PayType))
{
query = PredicateBuilder.And(query, v => v.PaymentMethodCode == filter.PayType);
}
}
return(query);
}
/// <summary>
/// 订单 筛选
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
private static Expression <Func <Order, bool> > OrderFiller(OrderQueryRequest filter)
{
var query = PredicateBuilder.True <Order>();
if (filter != null)
{
if (filter.Status != null)
{
query = PredicateBuilder.And(query, v => v.Status == filter.Status.Value);
}
if (!String.IsNullOrWhiteSpace(filter.OrderNo))
{
query = PredicateBuilder.And(query, v => v.OrderNo == filter.OrderNo);
return(query);
}
if (!String.IsNullOrWhiteSpace(filter.ExpressDeliveryCode))
{
query = PredicateBuilder.And(query, v => v.ShippingNo == filter.ExpressDeliveryCode);
return(query);
}
if (!String.IsNullOrWhiteSpace(filter.ShippingNo))
{
query = PredicateBuilder.And(query, v => v.ShippingNo == filter.ShippingNo);
return(query);
}
if (!String.IsNullOrWhiteSpace(filter.OrderSource))
{
query = PredicateBuilder.And(query, v => v.OrderSource == filter.OrderSource);
}
if (!String.IsNullOrWhiteSpace(filter.ShippingContactPhone))
{
query = PredicateBuilder.And(query, v => v.ShippingContactPhone == filter.ShippingContactPhone);
}
if (filter.ExpressDeliveryCompany != null)
{
query = PredicateBuilder.And(query, v => v.ShippingVia == filter.ExpressDeliveryCompany);
}
if (filter.StartCreateDate != null)
{
query = PredicateBuilder.And(query, v => v.CreateDate >= filter.StartCreateDate);
}
if (filter.EndCreateDate != null)
{
query = PredicateBuilder.And(query, v => v.CreateDate < filter.EndCreateDate);
}
}
return(query);
}
/// <summary>
/// OrderTransactionFiller
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
private static Expression <Func <OrderTransaction, bool> > OrderTransactionFiller(SearchStatRequest filter)
{
var query = PredicateBuilder.True <OrderTransaction>();
if (filter == null)
{
return(query);
}
if (!String.IsNullOrWhiteSpace(filter.OrderChannelNo))
{
query = PredicateBuilder.And(query, v => v.TransNo == filter.OrderChannelNo);
}
var c = filter as SearchCashierRequest;
if (c != null)
{
//TODO: 确认下 客户端传来的是 code 还是name
if (!String.IsNullOrWhiteSpace(c.PayType))
{
query = PredicateBuilder.And(query, v => v.PaymentCode == c.PayType);
}
}
return(query);
}
/// <summary>
/// Order
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
private static Expression <Func <Order, bool> > OrderFiller(SearchStatRequest filter)
{
var query = PredicateBuilder.True <Order>();
if (filter == null)
{
return(query);
}
//订单号与时间互斥
if (!String.IsNullOrWhiteSpace(filter.OrderNo))
{
query = PredicateBuilder.And(query, v => v.OrderNo == filter.OrderNo);
return(query);
}
if (filter.StartDate != null)
{
query = PredicateBuilder.And(query, v => v.CreateDate >= filter.StartDate);
}
if (filter.EndDate != null)
{
query = PredicateBuilder.And(query, v => v.CreateDate < filter.EndDate);
}
return(query);
}
private static Expression <Func <Section, bool> > Filter4Section(BrandFilter filter)
{
var query = PredicateBuilder.True <Section>();
if (filter != null)
{
if (filter.CounterId != null)
{
//return v => v.SectionId == filter.CounterId;
query = PredicateBuilder.And(query, v => v.Id == filter.CounterId);
}
if (filter.Status != null)
{
query = PredicateBuilder.And(query, v => v.Status == filter.Status.Value);
}
else
{
query = PredicateBuilder.And(query, v => v.Status > 0);
}
}
return(query);
//return v => true;
}
private static Expression <Func <Department, bool> > Filter(DepartmentQueryRequest filter)
{
var query = PredicateBuilder.True <Department>();
if (filter != null)
{
if (!String.IsNullOrWhiteSpace(filter.NamePrefix))
{
query = PredicateBuilder.And(query, v => v.Name.StartsWith(filter.NamePrefix));
}
if (!String.IsNullOrWhiteSpace(filter.Name))
{
query = PredicateBuilder.And(query,
v => v.Name.Equals(filter.Name));
}
if (filter.StoreId != null)
{
query = PredicateBuilder.And(query, v => v.StoreId == filter.StoreId.Value);
}
if (filter.StoreId == null && filter.DataRoleStores != null)
{
query = PredicateBuilder.And(query, v => filter.DataRoleStores.Contains(v.StoreId));
}
}
return(query);
}
private static Expression <Func <OPC_AuthUser, bool> > OPC_AuthUserFiller(bool?incloudSystem, List <string> authdatastartsWith, string name = null, string logonName = null)
{
var query = PredicateBuilder.True <OPC_AuthUser>();
if (authdatastartsWith != null && authdatastartsWith.Count > 0)
{
foreach (var str in authdatastartsWith)
{
var str1 = str;
query = PredicateBuilder.And(query, v => v.DataAuthId.StartsWith(str1));
}
}
if (incloudSystem != null)
{
query = PredicateBuilder.And(query, v => v.IsSystem == incloudSystem);
}
if (!String.IsNullOrEmpty(name))
{
query = PredicateBuilder.And(query, v => v.Name.Contains(name));
}
if (!String.IsNullOrEmpty(logonName))
{
query = PredicateBuilder.And(query, v => v.LogonName.Contains(logonName));
}
return(query);
}
private static Expression <Func <Brand, bool> > Filter(BrandFilter filter)
{
var query = PredicateBuilder.True <Brand>();
if (filter != null)
{
if (!String.IsNullOrWhiteSpace(filter.NamePrefix))
{
query = PredicateBuilder.And(query, v => v.Name.StartsWith(filter.NamePrefix) || v.EnglishName.StartsWith(filter.NamePrefix));
}
if (!String.IsNullOrWhiteSpace(filter.Name))
{
query = PredicateBuilder.And(query,
v => v.Name.Equals(filter.Name) || v.EnglishName.Equals(filter.Name));
}
if (filter.Status != null)
{
query = PredicateBuilder.And(query, v => v.Status == filter.Status.Value);
}
else
{
query = PredicateBuilder.And(query, v => v.Status > 0);
}
}
return(query);
}
/// <summary>
/// 礼品卡表 筛选
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
private static Expression <Func <IMS_AssociateIncomeRequest, bool> > CashAssociateCommissionStatisticsReportFilter(CashAssociateCommissionStatisticsReportRequest filter)
{
var query = PredicateBuilder.True <IMS_AssociateIncomeRequest>();
if (!String.IsNullOrEmpty(filter.BankName))
{
query = PredicateBuilder.And(query, v => v.BankName == filter.BankName);
return(query);
}
if (!String.IsNullOrEmpty(filter.BankCode))
{
query = PredicateBuilder.And(query, v => v.BankCode == filter.BankCode);
return(query);
}
if (filter.PickUpStartDate != null)
{
query = PredicateBuilder.And(query, v => v.CreateDate >= filter.PickUpStartDate);
}
if (filter.PickUpEndDate != null)
{
query = PredicateBuilder.And(query, v => v.CreateDate < filter.PickUpEndDate);
}
return(query);
}
/// <summary>
/// 礼品卡表 筛选
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
private static Expression <Func <IMS_GiftCardOrder, bool> > GiftCardOrderFilter(GiftCardSalesStatisticsReportRequest filter)
{
var query = PredicateBuilder.True <IMS_GiftCardOrder>();
if (!String.IsNullOrEmpty(filter.GiftCardNo))
{
query = PredicateBuilder.And(query, v => v.No == filter.GiftCardNo);
return(query);
}
if (!String.IsNullOrEmpty(filter.TransNo))
{
}
else
{
if (filter.BuyStartDate != null)
{
query = PredicateBuilder.And(query, v => v.CreateDate >= filter.BuyStartDate);
}
if (filter.BuyEndDate != null)
{
query = PredicateBuilder.And(query, v => v.CreateDate < filter.BuyEndDate);
}
}
return(query);
}
private static Expression <Func <OPC_AuthRoleUser, bool> > OPC_AuthRoleUsersFiller(int?roleid)
{
var query = PredicateBuilder.True <OPC_AuthRoleUser>();
if (roleid != null)
{
query = PredicateBuilder.And(query, v => v.OPC_AuthRoleId == roleid);
}
return(query);
}
/// <summary>
/// 渠道订单 筛选
/// </summary>
/// <param name="transNo"></param>
/// <returns></returns>
private static Expression <Func <OrderTransaction, bool> > OrderTransactionFilter(string transNo)
{
var query = PredicateBuilder.True <OrderTransaction>();
if (!String.IsNullOrEmpty(transNo))
{
query = PredicateBuilder.And(query, v => v.TransNo == transNo);
return(query);
}
return(query);
}
/// <summary>
/// 支付方式筛选
/// </summary>
/// <param name="paymentCode"></param>
/// <returns></returns>
private static Expression <Func <PaymentMethod, bool> > PaymentFilter(string paymentCode)
{
var query = PredicateBuilder.True <PaymentMethod>();
if (!String.IsNullOrEmpty(paymentCode))
{
query = PredicateBuilder.And(query, v => v.Code == paymentCode);
return(query);
}
return(query);
}
/// <summary>
/// 专柜表 筛选
/// </summary>
/// <param name="sectoinCode"></param>
/// <returns></returns>
private static Expression <Func <Section, bool> > SectionFilter(string sectoinCode)
{
var query = PredicateBuilder.True <Section>();
if (!String.IsNullOrEmpty(sectoinCode))
{
query = PredicateBuilder.And(query, v => v.SectionCode == sectoinCode);
}
return(query);
}
private static Expression <Func <OPC_ShippingSale, bool> > Filter(ShippingOrderFilter filter)
{
var query = PredicateBuilder.True <OPC_ShippingSale>();
if (filter != null)
{
if (filter.Status != null)
{
query = PredicateBuilder.And(query, v => v.ShippingStatus == (int)filter.Status);
}
if (filter.StoreIds != null)
{
query = PredicateBuilder.And(query, v => filter.StoreIds.Contains(v.StoreId ?? -1));
}
//订单号互斥 时间
if (filter.OrderNo != null)
{
query = PredicateBuilder.And(query, v => v.OrderNo == filter.OrderNo);
return(query);
}
if (!String.IsNullOrWhiteSpace(filter.ExpressNo))
{
query = PredicateBuilder.And(query, v => v.ShippingCode == filter.ExpressNo);
return(query);
}
//发货时间 目前数据库中没这个字段
if (filter.ShipStartDate != null)
{
query = PredicateBuilder.And(query, v => v.CreateDate >= filter.ShipStartDate);
}
if (filter.ShipEndDate != null)
{
query = PredicateBuilder.And(query, v => v.CreateDate < filter.ShipEndDate);
}
if (!String.IsNullOrWhiteSpace(filter.CustomersPhoneNumber))
{
query = PredicateBuilder.And(query, v => v.ShippingContactPhone == filter.CustomersPhoneNumber);
}
}
return(query);
}
/// <summary>
/// oRDER 筛选
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
private static Expression <Func <Order, bool> > Order4Filler(SaleOrderFilter filter)
{
var query = PredicateBuilder.True <Order>();
if (filter != null)
{
if (filter.OrderProductType != null)
{
query = PredicateBuilder.And(query, v => v.OrderProductType == filter.OrderProductType.Value);
}
}
return(query);
}
/// <summary>
/// section_brand filter
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
private static Expression <Func <IMS_SectionBrand, bool> > Filter4SectionBrand(SectionFilter filter)
{
var query = PredicateBuilder.True <IMS_SectionBrand>();
if (filter != null)
{
if (filter.BrandId != null)
{
query = PredicateBuilder.And(query, v => v.BrandId == filter.BrandId);
}
}
return(query);
}
/// <summary>
/// 销售单 筛选
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
private static Expression <Func <OPC_Sale, bool> > SalesOrderFilter(RmaQueryRequest filter)
{
var query = PredicateBuilder.True <OPC_Sale>();
if (filter != null)
{
if (!String.IsNullOrEmpty(filter.SalesOrderNo))
{
query = PredicateBuilder.And(query, v => v.SaleOrderNo == filter.SalesOrderNo);
}
}
return(query);
}
private static Expression <Func <OrderTransaction, bool> > OrderTransactionFiller(OrderQueryRequest filter)
{
var query = PredicateBuilder.True <OrderTransaction>();
if (filter != null)
{
if (!String.IsNullOrWhiteSpace(filter.PaymentType))
{
//TODO: 确认下 客户端传来的是 code 还是 name
query = PredicateBuilder.And(query, v => v.PaymentCode == filter.PaymentType);
}
}
return(query);
}
private static Expression <Func <IMS_SectionBrand, bool> > Filter4SectionBrand(BrandFilter filter)
{
var query = PredicateBuilder.True <IMS_SectionBrand>();
if (filter != null)
{
if (filter.CounterId != null)
{
//return v => v.SectionId == filter.CounterId;
query = PredicateBuilder.And(query, v => v.SectionId == filter.CounterId);
}
}
return(query);
//return v => true;
}
/// <summary>
/// 专柜表 筛选
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
private static Expression <Func <Section, bool> > SectionFilter(AssociateQueryRequest filter)
{
var query = PredicateBuilder.True <Section>();
if (!String.IsNullOrEmpty(filter.SectionCode))
{
query = PredicateBuilder.And(query, v => v.SectionCode == filter.SectionCode);
}
if (filter.Departmentid != null)
{
query = PredicateBuilder.And(query, v => v.DepartmentId == filter.Departmentid.Value);
}
return(query);
}
/// <summary>
/// store 筛选
/// </summary>
/// <param name="storeId"></param>
/// <param name="datarolestores"></param>
/// <returns></returns>
private static Expression <Func <Store, bool> > StoreFilter(int?storeId, ICollection <int> datarolestores)
{
var query = PredicateBuilder.True <Store>();
if (storeId != null)
{
query = PredicateBuilder.And(query, v => v.Id == storeId.Value);
}
if (storeId == null && datarolestores != null)
{
query = PredicateBuilder.And(query, v => datarolestores.Contains(v.Id));
}
return(query);
}
/// <summary>
/// 用户 筛选
/// </summary>
/// <param name="nickname">昵称</param>
/// <param name="contract">联系方式</param>
/// <returns></returns>
private static Expression <Func <User, bool> > UserFilter(string nickname, string contract)
{
var query = PredicateBuilder.True <User>();
if (!String.IsNullOrEmpty(nickname))
{
query = PredicateBuilder.And(query, v => v.Nickname == nickname);
}
if (!String.IsNullOrEmpty(contract))
{
query = PredicateBuilder.And(query, v => v.Mobile == contract);
}
return(query);
}
/// <summary>
/// SaleDetailFiller
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
private static Expression <Func <OPC_SaleDetail, bool> > SaleDetailFiller(SearchStatRequest filter)
{
var query = PredicateBuilder.True <OPC_SaleDetail>();
if (filter == null)
{
return(query);
}
if (!String.IsNullOrWhiteSpace(filter.SalesOrderNo))
{
query = PredicateBuilder.And(query, v => v.SaleOrderNo == filter.SalesOrderNo);
}
return(query);
}
/// <summary>
/// STORE 筛选
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
private static Expression <Func <Store, bool> > Store4Filler(SaleOrderFilter filter)
{
var query = PredicateBuilder.True <Store>();
if (filter != null)
{
if (filter.StoreId != null)
{
query = PredicateBuilder.And(query, v => v.Id == filter.StoreId.Value);
}
if (filter.StoreId == null && filter.DataRoleStores != null && filter.DataRoleStores.Count > 0)
{
query = PredicateBuilder.And(query, v => filter.DataRoleStores.Contains(v.Id));
}
}
return(query);
}
/// <summary>
/// section filter
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
private static Expression <Func <Section, bool> > Filter(SectionFilter filter)
{
var query = PredicateBuilder.True <Section>();
if (filter != null)
{
if (!String.IsNullOrWhiteSpace(filter.NamePrefix))
{
query = PredicateBuilder.And(query, v => v.Name.StartsWith(filter.NamePrefix));
}
if (filter.Status != null)
{
query = PredicateBuilder.And(query, v => v.Status == filter.Status);
}
else
{
query = PredicateBuilder.And(query, v => v.Status >= 0);
}
if (!String.IsNullOrWhiteSpace(filter.Name))
{
query = PredicateBuilder.And(query, v => v.Name == filter.Name);
}
if (filter.StoreId != null)
{
query = PredicateBuilder.And(query, v => v.StoreId == filter.StoreId);
}
if (filter.DataRoleStores != null && filter.StoreId == null)
{
query = PredicateBuilder.And(query, v => filter.DataRoleStores.Contains(v.StoreId.HasValue ? v.StoreId.Value : -1));
}
if (!String.IsNullOrWhiteSpace(filter.SectionCode))
{
query = PredicateBuilder.And(query, v => v.SectionCode == filter.SectionCode);
}
}
return(query);
}
private static Expression <Func <OPC_OrgInfo, bool> > OPC_OrgInfoFiller(List <string> startsWith, EnumOrgType?type)
{
var query = PredicateBuilder.True <OPC_OrgInfo>();
if (type != null)
{
query = PredicateBuilder.And(query, v => v.OrgType == type.AsId());
}
if (startsWith != null && startsWith.Count > 0)
{
foreach (var str in startsWith)
{
var str1 = str;
query = PredicateBuilder.And(query, v => v.OrgID.StartsWith(str1));
}
}
return(query);
}
/// <summary>
/// 用户表筛选
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
private static Expression <Func <User, bool> > UserFilter(AssociateQueryRequest filter)
{
var query = PredicateBuilder.True <User>();
if (!String.IsNullOrEmpty(filter.OperatorName))
{
query = PredicateBuilder.And(query, v => v.Nickname == filter.OperatorName);
}
if (!String.IsNullOrEmpty(filter.MobileNo))
{
query = PredicateBuilder.And(query, v => v.Mobile == filter.MobileNo);
}
if (!String.IsNullOrEmpty(filter.EMail))
{
query = PredicateBuilder.And(query, v => v.EMail == filter.EMail);
}
return(query);
}
/// <summary>
/// StoreFiller 包含了权限判断
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
private static Expression <Func <Store, bool> > StoreFiller(SearchStatRequest filter)
{
var query = PredicateBuilder.True <Store>();
if (filter == null)
{
return(query);
}
if (filter.StoreId != null)
{
query = PredicateBuilder.And(query, v => v.Id == filter.StoreId);
}
if (filter.DataRoleStores != null && filter.StoreId == null)
{
query = PredicateBuilder.And(query, v => filter.DataRoleStores.Contains(v.Id));
}
return(query);
}