public IQueryable <YuShang.ERP.Entities.Sale.SaleContract> GetIndexListSaleContract(
ExtendedIdentityDbContext dbContext, int?orderType, DateTime?DateFrom, DateTime?DateTo,
string filterValue, string userName, out int count)
{
try
{
//double temp1 = -1;
//double temp2 = -1;
SaleContractPrivilegeFilter filter = new SaleContractPrivilegeFilter()
{
SerialOrSupplierFilterValue = filterValue,
SaleCreateTimeFrom = DateFrom,
SaleCreateTimeTo = DateTo,
UserName = userName,
};
IQueryable <SaleContract> contractsQuery = this.GetIndexListSaleContract(
dbContext, filter); //out temp1, out temp2);
if (orderType.HasValue)
{
var query = contractsQuery.Where(m => m.OrderType == orderType.GetValueOrDefault() &&
m.ContractStatus != ContractStatus.Closed);
count = query.Count();
return(query);
}
var query2 = contractsQuery.Where(m => m.ContractStatus != ContractStatus.Closed);
count = query2.Count();
return(query2);
}
catch (Exception ee)
{
LogHelper.Error("获取SaleContract列表失败。", ee);
count = -1;
return(null);
}
}
internal IQueryable <SaleContract> GetIndexListSaleContract(Microsoft.Owin.IOwinContext owinContext,
ExtendedIdentityDbContext dbContext, ContractListCondition condition)
{
try
{
SaleContractPrivilegeFilter filter = new SaleContractPrivilegeFilter()
{
SerialOrSupplierFilterValue = condition.SerialOrSupplierFilterValue,
SaleCreateTimeFrom = condition.CTIMEFrom,
SaleCreateTimeTo = condition.CTIMETimeTo,
UserName = GetUserName(condition, owinContext),
OwinContext = owinContext,
};
IQueryable <SaleContract> contractsQuery = this.GetIndexListSaleContract(
dbContext, filter); //out temp1, out temp2);
if (condition.OrderType.HasValue)
{
contractsQuery = contractsQuery.Where(m => m.OrderType == condition.OrderType.Value &&
m.ContractStatus != ContractStatus.Closed);
}
if ((condition.ListInclude & ContractListInclude.WithContractStatusClosed)
!= ContractListInclude.WithContractStatusClosed)
{
contractsQuery = contractsQuery.Where(m => m.ContractStatus
!= ContractStatus.Closed);
}
return(contractsQuery);
}
catch (Exception ee)
{
LogHelper.Error("获取SaleContract列表失败。", ee);
return(null);
}
}
