internal List <MaterialPriceListDataView> GetAllMaterialPriceList(ICollection <AbstractSearch> searchCriteria,
DateTime?dateActiveTo,
string sortExpression, string sortDirection)
{
List <MaterialPriceListDataView> listView = new List <MaterialPriceListDataView>();
listView = (from mpl in this.dbContext.MaterialPriceLists
orderby mpl.DateFrom ascending
where (dateActiveTo.HasValue ?
((!mpl.DateTo.HasValue && mpl.DateFrom <= dateActiveTo.Value) ||
(mpl.DateTo.HasValue && mpl.DateFrom <= dateActiveTo.Value && mpl.DateTo >= dateActiveTo.Value)) :
1 == 1)
select new MaterialPriceListDataView
{
idMaterialPriceList = mpl.idMaterialPriceList,
LME = mpl.LME,
Premium = mpl.Premium,
DateFrom = mpl.DateFrom,
DateTo = mpl.DateTo
}).ApplySearchCriterias(searchCriteria).ToList();
if (string.IsNullOrEmpty(sortExpression) || sortExpression == Constants.INVALID_ID_STRING)
{
sortDirection = string.Empty;
sortExpression = "DateFrom";
}
listView = OrderByHelper.OrderBy <MaterialPriceListDataView>(listView, sortExpression, sortDirection).ToList <MaterialPriceListDataView>();
return(listView);
}
internal List <ProductivityAndScrapDataView> GetAllProductivityAndScrapList(ICollection <AbstractSearch> searchCriteria,
DateTime?dateActiveTo,
string sortExpression, string sortDirection)
{
List <ProductivityAndScrapDataView> listView = new List <ProductivityAndScrapDataView>();
listView = (from ps in this.dbContext.ProductivityAndScraps
orderby ps.DateFrom ascending
where (dateActiveTo.HasValue ?
((!ps.DateTo.HasValue && ps.DateFrom <= dateActiveTo.Value) ||
(ps.DateTo.HasValue && ps.DateFrom <= dateActiveTo.Value && ps.DateTo >= dateActiveTo.Value)) :
1 == 1)
select new ProductivityAndScrapDataView
{
idProductivityAndScrap = ps.idProductivityAndScrap,
DateFrom = ps.DateFrom,
DateTo = ps.DateTo
}).ApplySearchCriterias(searchCriteria).ToList();
if (string.IsNullOrEmpty(sortExpression) || sortExpression == Constants.INVALID_ID_STRING)
{
sortDirection = string.Empty;
sortExpression = "DateFrom";
}
listView = OrderByHelper.OrderBy <ProductivityAndScrapDataView>(listView, sortExpression, sortDirection).ToList <ProductivityAndScrapDataView>();
return(listView);
}
public ActionResult List(Guid webApplicationId, int pageIndex = 1, int pageSize = 10)
{
try
{
if (webApplicationId == Guid.Empty)
{
throw new BaseException("webApplicationId不能为空");
}
var orderBys = OrderByHelper.Create().Desc("OpenId");
var where = Where.Create().Eq("WebApplicationId", webApplicationId);
var listResult = this.IWeiXinQRCodePromotionActivityAccountService.Page(orderBys, where, pageIndex, pageSize);
foreach (var item in listResult.Data)
{
item.LoadWeiXinAccount();
}
return(this.JsonSuccessGenericPageExecResult(listResult));
}
catch (BaseException ex)
{
return(this.JsonFailureGenericPageExecResult(ex));
}
catch (Exception ex)
{
throw;
}
}
internal List <DiePriceListDataView> GetAllDiePriceList(ICollection <AbstractSearch> searchCriteria,
DateTime?dateActiveTo,
string sortExpression, string sortDirection)
{
List <DiePriceListDataView> listView = new List <DiePriceListDataView>();
listView = (from dpl in this.dbContext.DiePriceLists
join kvV in this.dbContext.KeyValues on dpl.idVendor equals kvV.idKeyValue
where (dateActiveTo.HasValue ?
((!dpl.DateTo.HasValue && dpl.DateFrom <= dateActiveTo.Value) ||
(dpl.DateTo.HasValue && dpl.DateFrom <= dateActiveTo.Value && dpl.DateTo >= dateActiveTo.Value)) :
1 == 1)
orderby kvV.Name ascending, dpl.DateFrom ascending
select new DiePriceListDataView
{
idDiePriceList = dpl.idDiePriceList,
VendorName = kvV.Name,
idVendor = dpl.idVendor,
DateFrom = dpl.DateFrom,
DateTo = dpl.DateTo
}).ApplySearchCriterias(searchCriteria).ToList <DiePriceListDataView>();
if (string.IsNullOrEmpty(sortExpression) || sortExpression == Constants.INVALID_ID_STRING)
{
sortDirection = string.Empty;
sortExpression = "VendorName, DateFrom";
}
listView = OrderByHelper.OrderBy <DiePriceListDataView>(listView, sortExpression, sortDirection).ToList <DiePriceListDataView>();
return(listView);
}
internal List <SAPDataDataView> GetAllSAPData(ICollection <AbstractSearch> searchCriteria,
DateTime?dateActiveTo,
string sortExpression, string sortDirection)
{
List <SAPDataDataView> listView = new List <SAPDataDataView>();
listView = (from sd in this.dbContext.SAPDatas
where (dateActiveTo.HasValue ?
((!sd.DateTo.HasValue && sd.DateFrom <= dateActiveTo.Value) ||
(sd.DateTo.HasValue && sd.DateFrom <= dateActiveTo.Value && sd.DateTo >= dateActiveTo.Value)) :
1 == 1)
orderby sd.DateFrom ascending
select new SAPDataDataView
{
idSAPData = sd.idSAPData,
DateFrom = sd.DateFrom,
DateTo = sd.DateTo
}).ApplySearchCriterias(searchCriteria).ToList <SAPDataDataView>();
if (string.IsNullOrEmpty(sortExpression) || sortExpression == Constants.INVALID_ID_STRING)
{
sortDirection = string.Empty;
sortExpression = "DateFrom";
}
listView = OrderByHelper.OrderBy <SAPDataDataView>(listView, sortExpression, sortDirection).ToList <SAPDataDataView>();
return(listView);
}
internal List <AverageOutturnOverTimeDataView> GetAllAverageOutturnOverTimeDataView(ICollection <AbstractSearch> searchCriteria,
DateTime?dateActiveTo,
string sortExpression, string sortDirection)
{
List <AverageOutturnOverTimeDataView> listView = new List <AverageOutturnOverTimeDataView>();
listView = (from mpl in this.dbContext.AverageOutturnOverTimes
orderby mpl.DateFrom ascending
where (dateActiveTo.HasValue ?
((!mpl.DateTo.HasValue && mpl.DateFrom <= dateActiveTo.Value) ||
(mpl.DateTo.HasValue && mpl.DateFrom <= dateActiveTo.Value && mpl.DateTo >= dateActiveTo.Value)) :
1 == 1)
select new AverageOutturnOverTimeDataView
{
idAverageOutturnOverTime = mpl.idAverageOutturnOverTime,
ValueOfPressSMS1 = mpl.ValueOfPressSMS1,
ValueOfPressSMS2 = mpl.ValueOfPressSMS2,
ValueOfPressBREDA = mpl.ValueOfPressBREDA,
ValueOfPressFARREL = mpl.ValueOfPressFARREL,
DateFrom = mpl.DateFrom,
DateTo = mpl.DateTo
}).ApplySearchCriterias(searchCriteria).ToList();
if (string.IsNullOrEmpty(sortExpression) || sortExpression == Constants.INVALID_ID_STRING)
{
sortDirection = string.Empty;
sortExpression = "DateFrom";
}
listView = OrderByHelper.OrderBy <AverageOutturnOverTimeDataView>(listView, sortExpression, sortDirection).ToList <AverageOutturnOverTimeDataView>();
return(listView);
}
private void HandleOrderByClause(SelectStatement selectStatement)
{
if (selectStatement.OrderByClause != null)
{
_stages.Add(OrderByHelper.GetOrderByStage(LastStage, selectStatement.OrderByClause, _visitorMetadata, _usedProperties));
}
}
public IEnumerable <TEntity> Buscar(Expression <Func <TEntity, bool> > condition, string orderBy = "", string sortDirection = "", int take = 0, int skip = 0)
{
var query = _contexto.Set <TEntity>().Where(condition);//
if (!string.IsNullOrEmpty(orderBy))
{
if (!string.IsNullOrEmpty(sortDirection))
{
if (sortDirection == "asc")
{
query = OrderByHelper.OrderBy(query, orderBy);
}
else
{
query = OrderByHelper.OrderByDescending(query, orderBy);
}
if (take > 0)
{
query = query.Take(take);
}
if (skip > 0)
{
query = query.Skip(skip);
}
}
}
return(query.AsNoTracking().ToList());
}
public List <LACK2> GetCompletedByParam(Lack2GetByParamInput input)
{
Expression <Func <LACK2, bool> > queryFilter = c => c.STATUS == Enums.DocumentStatus.Completed;
if (!string.IsNullOrEmpty((input.PlantId)))
{
queryFilter = queryFilter.And(c => c.LEVEL_PLANT_ID == input.PlantId);
}
if (!string.IsNullOrEmpty((input.Creator)))
{
queryFilter = queryFilter.And(c => c.CREATED_BY == input.Creator);
}
if (!string.IsNullOrEmpty((input.Poa)))
{
queryFilter = queryFilter.And(c => c.APPROVED_BY == input.Poa);
}
if (input.UserRole != Enums.UserRole.Administrator && input.UserRole != Enums.UserRole.Controller)
{
queryFilter = queryFilter.And(c => input.PlantList.Contains(c.LEVEL_PLANT_ID));
}
Func <IQueryable <LACK2>, IOrderedQueryable <LACK2> > orderBy = null;
if (!string.IsNullOrEmpty(input.SortOrderColumn))
{
orderBy = c => c.OrderBy(OrderByHelper.GetOrderByFunction <LACK2>(input.SortOrderColumn));
}
var dbData = _repository.Get(queryFilter, orderBy, includeTables);
return(dbData == null ? null : dbData.ToList());
}
public SearchResult <ItemMonitoramentoDTO> Buscar(Expression <Func <ItemMonitoramentoDTO, bool> > condition, string orderBy = "", string sortDirection = "", int take = 0, int skip = 0)
{
var query = QueryBase().Where(condition);
int totalRecords = query.Count();
if (!string.IsNullOrEmpty(orderBy))
{
if (sortDirection == "asc")
{
query = OrderByHelper.OrderBy(query, orderBy);
}
else
{
query = OrderByHelper.OrderByDescending(query, orderBy);
}
if (take > 0)
{
query = query.Take(take);
}
if (skip > 0)
{
query = query.Skip(skip);
}
}
return(new SearchResult <ItemMonitoramentoDTO>
{
Itens = query.ToList(),
TotalRecords = totalRecords,
RecordsPerPage = take
});
}
public void ValidateKeyValueListWithOrderByTermIsTrue_GivenValidDesiredOrderByElements()
{
string commaSeparatedOrderBy = "testTerm1,testTerm2_desc,testTerm3_asc";
List <string> desiredOrderByTerms = new List <string>
{
"testTerm1",
"testTerm2",
"testTerm3"
};
var orderByHelper = new OrderByHelper();
var convertedList = orderByHelper.ConvertCommaSeparateOrderByStringToKeyValuePairList(commaSeparatedOrderBy);
try
{
orderByHelper.ValidateOrderByListOnlyContainsCertainElements(convertedList, desiredOrderByTerms);
}
catch (InvalidFormatException invalidFormatException)
{
Assert.True(false, $"Expected no Exception but an invalid formate exception was thrown with message '{invalidFormatException.Message}'");
}
Assert.True(true);
}
internal List <CommissionsByAgentDataView> GetAllCommissionsByAgentsList(ICollection <AbstractSearch> searchCriteria,
DateTime?dateActiveTo,
string sortExpression, string sortDirection)
{
List <CommissionsByAgentDataView> listView = new List <CommissionsByAgentDataView>();
listView = (from ca in this.dbContext.CommissionsByAgents
join kvA in this.dbContext.KeyValues on ca.idAgent equals kvA.idKeyValue
where (dateActiveTo.HasValue ?
((!ca.DateTo.HasValue && ca.DateFrom <= dateActiveTo.Value) ||
(ca.DateTo.HasValue && ca.DateFrom <= dateActiveTo.Value && ca.DateTo >= dateActiveTo.Value)) :
1 == 1)
orderby kvA.Name ascending, ca.DateFrom ascending
select new CommissionsByAgentDataView
{
idCommissionsByAgent = ca.idCommissionsByAgent,
idAgent = ca.idAgent,
AgentName = kvA.Name,
FixedCommission = ca.FixedCommission,
CommissionPercent = ca.CommissionPercent,
DateFrom = ca.DateFrom,
DateTo = ca.DateTo
}).ApplySearchCriterias(searchCriteria).ToList <CommissionsByAgentDataView>();
if (string.IsNullOrEmpty(sortExpression) || sortExpression == Constants.INVALID_ID_STRING)
{
sortDirection = string.Empty;
sortExpression = "AgentName, DateFrom";
}
listView = OrderByHelper.OrderBy <CommissionsByAgentDataView>(listView, sortExpression, sortDirection).ToList <CommissionsByAgentDataView>();
return(listView);
}
internal List <AttachmentDataView> GetAccountingAttachmentList(ICollection <AbstractSearch> searchCriteria, string sortExpression, string sortDirection)
{
List <AttachmentDataView> list = (from a in dbContext.Attachments
join kvAttachmentType in dbContext.KeyValues on a.idAttachmentType equals kvAttachmentType.idKeyValue
join u in dbContext.Users on a.idUser equals u.idUser
join p in dbContext.Persons on u.idPerson equals p.idPerson
select new AttachmentDataView
{
idAttachment = a.idAttachment,
idAttachmentType = a.idAttachmentType,
idModule = a.idModule,
Description = a.Description,
AttachmentDate = a.AttachmentDate,
idUser = a.idUser,
Title = p.Title,
FirstName = p.FirstName,
LastName = p.LastName,
AttachmentTypeName = kvAttachmentType.Name,
idAttachmentTypeKeyType = kvAttachmentType.idKeyType
}).ApplySearchCriterias(searchCriteria).ToList();
list = OrderByHelper.OrderBy <AttachmentDataView>(list, sortExpression, sortDirection).ToList <AttachmentDataView>();
return(list);
}
public void GetKeyValueListWithOrderByTerm_ExpectInvalidaFormatException_GivenErroneousDirectionalCommaSeparatedOrderByString()
{
string commaSeparatedOrderBy = "testTerm1_rubbish";
var orderByHelper = new OrderByHelper();
Assert.Throws <InvalidFormatException>(() => orderByHelper.ConvertCommaSeparateOrderByStringToKeyValuePairList(commaSeparatedOrderBy));
}
internal List <DiePriceListDetailDataView> GetAllDiePriceListDetails(ICollection <AbstractSearch> searchCriteria,
DateTime?dateActiveTo,
string sortExpression, string sortDirection)
{
List <DiePriceListDetailDataView> listView = new List <DiePriceListDetailDataView>();
listView = (from dpld in this.dbContext.DiePriceListDetails
join dpl in this.dbContext.DiePriceLists on dpld.idDiePriceList equals dpl.idDiePriceList
join kvV in this.dbContext.KeyValues on dpl.idVendor equals kvV.idKeyValue into grV
from subV in grV.DefaultIfEmpty()
join kvNmCav in this.dbContext.KeyValues on dpld.idNumberOfCavities equals kvNmCav.idKeyValue into grNmCav
from subNmCav in grNmCav.DefaultIfEmpty()
join kvPrCat in this.dbContext.KeyValues on dpld.idProfileCategory equals kvPrCat.idKeyValue into grPrCat
from subPrCat in grPrCat.DefaultIfEmpty()
join kvPrCompl in this.dbContext.KeyValues on dpld.idProfileComplexity equals kvPrCompl.idKeyValue into grPrCompl
from subPrCompl in grPrCompl.DefaultIfEmpty()
where (dateActiveTo.HasValue ?
((!dpl.DateTo.HasValue && dpl.DateFrom <= dateActiveTo.Value) ||
(dpl.DateTo.HasValue && dpl.DateFrom <= dateActiveTo.Value && dpl.DateTo >= dateActiveTo.Value)) :
1 == 1)
orderby dpl.DateFrom ascending
select new DiePriceListDetailDataView
{
idDiePriceListDetail = dpld.idDiePriceListDetail,
idDiePriceList = dpl.idDiePriceList,
VendorName = (subV != null ? subV.Name : string.Empty),
idVendor = dpl.idVendor,
DateFrom = dpl.DateFrom,
DateTo = dpl.DateTo,
idNumberOfCavities = dpld.idNumberOfCavities,
NumberOfCavitiesName = (subNmCav != null ? subNmCav.Name : string.Empty),
idProfileCategory = dpld.idProfileCategory,
ProfileCategoryName = (subPrCat != null ? subPrCat.Name : string.Empty),
idProfileComplexity = dpld.idProfileComplexity,
ProfileComplexityName = (subPrCompl != null ? subPrCompl.Name : string.Empty),
DimensionA = dpld.DimensionA,
DimensionB = dpld.DimensionB,
Price = dpld.Price,
Lifespan = dpld.Lifespan
}).ApplySearchCriterias(searchCriteria).ToList <DiePriceListDetailDataView>();
if (string.IsNullOrEmpty(sortExpression) || sortExpression == Constants.INVALID_ID_STRING)
{
sortDirection = string.Empty;
sortExpression = "VendorName, DimensionA, DimensionB, ProfileComplexityName, ProfileCategoryName, NumberOfCavitiesName";
}
listView = OrderByHelper.OrderBy <DiePriceListDetailDataView>(listView, sortExpression, sortDirection).ToList <DiePriceListDetailDataView>();
return(listView);
}
private ICypherQuery <TResult> CreateCypherQuery(IQuery <TAggregate> query)
{
var session = CreateFluentQuery();
var cypher = GetDataset(session, (TQuery)query);
cypher = OrderByHelper <TResult, TAggregate> .OrderBy(cypher, query);
cypher = cypher.Skip(query.Skip).Limit(query.Take);
Log(cypher);
return(cypher);
}
private List <REVERSAL> GetReversalData(Expression <Func <REVERSAL, bool> > queryFilter, string orderColumn)
{
Func <IQueryable <REVERSAL>, IOrderedQueryable <REVERSAL> > orderBy = null;
if (!string.IsNullOrEmpty(orderColumn))
{
orderBy = c => c.OrderBy(OrderByHelper.GetOrderByFunction <REVERSAL>(orderColumn));
}
var dbData = _repository.Get(queryFilter);
return(dbData.ToList());
}
public List <PRODUCTION> GetFactAllByParam(ProductionGetByParamInput input)
{
Expression <Func <PRODUCTION, bool> > queryFilter = PredicateHelper.True <PRODUCTION>();
if (!string.IsNullOrEmpty(input.Company))
{
queryFilter = queryFilter.And(c => c.COMPANY_CODE == input.Company);
}
if (!string.IsNullOrEmpty(input.Plant))
{
queryFilter = queryFilter.And(c => c.WERKS == input.Plant);
}
if (!string.IsNullOrEmpty(input.ProoductionDate))
{
var dt = Convert.ToDateTime(input.ProoductionDate);
queryFilter = queryFilter.And(c => c.PRODUCTION_DATE == dt);
}
if (input.Month > 0)
{
queryFilter = queryFilter.And(c => c.PRODUCTION_DATE.Month == input.Month);
}
if (input.Year > 0)
{
queryFilter = queryFilter.And(c => c.PRODUCTION_DATE.Year == input.Year);
}
if (!string.IsNullOrEmpty(input.UserId))
{
var listUserPlant = _userPlantBll.GetPlantByUserId(input.UserId);
var listPoaPlant = _poaMapBll.GetPlantByPoaId(input.UserId);
queryFilter = queryFilter.And(c => listUserPlant.Contains(c.WERKS) || listPoaPlant.Contains(c.WERKS));
}
Func <IQueryable <PRODUCTION>, IOrderedQueryable <PRODUCTION> > orderBy = null;
{
if (!string.IsNullOrEmpty(input.ShortOrderColumn))
{
orderBy = c => c.OrderBy(OrderByHelper.GetOrderByFunction <PRODUCTION>(input.ShortOrderColumn));
}
var dbData = _repository.Get(queryFilter, orderBy);
if (dbData == null)
{
throw new BLLException(ExceptionCodes.BLLExceptions.DataNotFound);
}
var mapResult = dbData.ToList();
return(mapResult);
}
}
public void TestTransInsertAndQuery()
{
for (var i = 0; i < 200; i++)
{
var rnd = new Random();
ServiceContext.IComClickService.Insert(new Entities.ComClickDto()
{
ID = Guid.NewGuid(),
Category = "t",
ClickCount = rnd.Next(1, 200)
});
}
var list = ServiceContext.IComClickService.Top(10, 50, OrderByHelper.Create().Desc("ClickCount"));
var kk = 0;
}
public void ValidateKeyValueListWithOrderByTermThrowsException_GivenInValidDesiredOrderByElements()
{
string commaSeparatedOrderBy = "testTerm1,testTerm2_desc,testTerm5_asc";
List <string> desiredOrderByTerms = new List <string>
{
"testTerm1",
"testTerm2",
"testTerm3"
};
var orderByHelper = new OrderByHelper();
var convertedList = orderByHelper.ConvertCommaSeparateOrderByStringToKeyValuePairList(commaSeparatedOrderBy);
Assert.Throws <InvalidFormatException>(() => orderByHelper.ValidateOrderByListOnlyContainsCertainElements(convertedList, desiredOrderByTerms));
}
public GenericPageResult <WeiXinQRCodePromotionActivityAccountPointsHistoryDto> Find(Guid webApplicationId, string openId, int pageIndex = 1, int pageSize = 10)
{
if (this.IValidatorTool.IsEmpty(openId))
{
throw new BaseException("openId不能为空");
}
if (webApplicationId == Guid.Empty)
{
throw new BaseException("webApplicationId不能为空");
}
var where = Where.Create().Eq("WebApplicationId", webApplicationId).Eq("OpenId", openId);
var orderBy = OrderByHelper.Create().Desc("CreatedDate");
var list = this.Page(orderBy, where, pageIndex, pageSize);
return(list);
}
public void GetKeyValueListWithOrderByTermAndOrderDirection_GivenSingleCommaSeparatedOrderByString()
{
string commaSeparatedOrderBy = "testTerm1,testTerm2_desc,testTerm3_asc";
var orderByHelper = new OrderByHelper();
var convertedKeyValuePairList = orderByHelper.ConvertCommaSeparateOrderByStringToKeyValuePairList(commaSeparatedOrderBy);
Assert.True(convertedKeyValuePairList[0].Key == "testTerm1", $"Expected first converted orderBy term key to be 'testTerm1' but actual value is {convertedKeyValuePairList[0].Key}");
Assert.True(convertedKeyValuePairList[0].Value == "asc", $"Expected first covnerted orderBy term value to be 'asc' but actual value is {convertedKeyValuePairList[0].Key}");
Assert.True(convertedKeyValuePairList[1].Key == "testTerm2", $"Expected second converted orderBy term key to be 'testTerm2' but actual value is {convertedKeyValuePairList[1].Key}");
Assert.True(convertedKeyValuePairList[1].Value == "desc", $"Expected second covnerted orderBy term value to be 'desc' but actual value is {convertedKeyValuePairList[1].Key}");
Assert.True(convertedKeyValuePairList[2].Key == "testTerm3", $"Expected third converted orderBy term key to be 'testTerm3' but actual value is {convertedKeyValuePairList[2].Key}");
Assert.True(convertedKeyValuePairList[2].Value == "asc", $"Expected third covnerted orderBy term value to be 'asc' but actual value is {convertedKeyValuePairList[2].Key}");
}
internal List <ProfileSettingDataView> GetProfilesList(ICollection <AbstractSearch> searchCriteria, string sortExpression, string sortDirection)
{
List <ProfileSettingDataView> listView = new List <ProfileSettingDataView>();
listView = (from ps in this.dbContext.ProfileSettings
//Profile Complexity
join kvPrCom in this.dbContext.KeyValues on ps.idProfileComplexity equals kvPrCom.idKeyValue into grPrCom
from subPrCom in grPrCom.DefaultIfEmpty()
//Profile type
join kvPT in this.dbContext.KeyValues on ps.idProfileType equals kvPT.idKeyValue into grPT
from subPT in grPT.DefaultIfEmpty()
//Profile category
join kvPC in this.dbContext.KeyValues on ps.idProfileCategory equals kvPC.idKeyValue into grPC
from subPC in grPC.DefaultIfEmpty()
select new ProfileSettingDataView
{
idProfileSetting = ps.idProfileSetting,
ProfileName = ps.ProfileName,
idProfileType = ps.idProfileType,
idProfileCategory = ps.idProfileCategory,
idProfileComplexity = ps.idProfileComplexity,
hasA = ps.hasA,
hasB = ps.hasB,
hasC = ps.hasC,
hasD = ps.hasD,
hasS = ps.hasS,
DiameterFormula = ps.DiameterFormula,
idCreateUser = ps.idCreateUser,
dCreate = ps.dCreate,
idModifyUser = ps.idModifyUser,
dModify = ps.dModify,
ImagePath = ps.ImagePath,
//NumberOfCavitiesName = (subNC != null ? subNC.Name : string.Empty),
ProfileCategoryName = (subPC != null ? subPC.Name : string.Empty),
ProfileTypeName = (subPT != null ? subPT.Name : string.Empty),
ProfileComplexityName = (subPrCom != null ? subPrCom.Name : string.Empty),
}
).ApplySearchCriterias(searchCriteria).OrderBy(z => z.ProfileTypeName).ThenBy(z => z.ProfileCategoryName).ThenBy(z => z.ProfileComplexityName).ToList <ProfileSettingDataView>();
listView = OrderByHelper.OrderBy <ProfileSettingDataView>(listView, sortExpression, sortDirection).ToList <ProfileSettingDataView>();
return(listView);
}
internal List <ProductivityAndScrapDetailDataView> GetAllProductivityAndScrapDetailList(ICollection <AbstractSearch> searchCriteria,
DateTime?dateActiveTo,
string sortExpression, string sortDirection)
{
List <ProductivityAndScrapDetailDataView> listView = new List <ProductivityAndScrapDetailDataView>();
listView = (from psd in this.dbContext.ProductivityAndScrapDetails
join ps in this.dbContext.ProductivityAndScraps on psd.idProductivityAndScrap equals ps.idProductivityAndScrap
join kvCc in this.dbContext.KeyValues on psd.idCostCenter equals kvCc.idKeyValue
join pfs in this.dbContext.ProfileSettings on psd.idProfileSetting equals pfs.idProfileSetting into grPfs
from subPfs in grPfs.DefaultIfEmpty()
orderby ps.DateFrom ascending
where (dateActiveTo.HasValue ?
((!ps.DateTo.HasValue && ps.DateFrom <= dateActiveTo.Value) ||
(ps.DateTo.HasValue && ps.DateFrom <= dateActiveTo.Value && ps.DateTo >= dateActiveTo.Value)) :
1 == 1)
select new ProductivityAndScrapDetailDataView
{
idProductivityAndScrapDetail = psd.idProductivityAndScrapDetail,
idProductivityAndScrap = psd.idProductivityAndScrap,
DateFrom = ps.DateFrom,
DateTo = ps.DateTo,
idCostCenter = psd.idCostCenter,
CostCenterName = kvCc.DefaultValue4,
idProfileSetting = psd.idProfileSetting,
ProfileSettingName = (subPfs != null ? subPfs.ProfileName : string.Empty),
SumOfHours = psd.SumOfHours,
SumOfConsumption = psd.SumOfConsumption,
SumOfProduction = psd.SumOfProduction,
ProductivityKGh = psd.ProductivityKGh,
ScrapRate = psd.ScrapRate
}).ApplySearchCriterias(searchCriteria).ToList();
if (string.IsNullOrEmpty(sortExpression) || sortExpression == Constants.INVALID_ID_STRING)
{
sortDirection = string.Empty;
sortExpression = "DateFrom";
}
listView = OrderByHelper.OrderBy <ProductivityAndScrapDetailDataView>(listView, sortExpression, sortDirection).ToList <ProductivityAndScrapDetailDataView>();
return(listView);
}
public List <Pbck1QuotaDto> GetByParam(Pbck1QuotaGetByParamInput input)
{
Expression <Func <PBCK1_QUOTA, bool> > queryFilter = PredicateHelper.True <PBCK1_QUOTA>();
if (!string.IsNullOrEmpty(input.CompanyCode))
{
queryFilter = queryFilter.And(c => c.PBCK1 != null && c.PBCK1.NPPBKC_BUKRS == input.CompanyCode);
}
if (input.YearFrom.HasValue)
{
queryFilter =
queryFilter.And(
c =>
c.PBCK1 != null && c.PBCK1.PERIOD_FROM.HasValue &&
c.PBCK1.PERIOD_FROM.Value.Year >= input.YearFrom.Value);
}
if (input.YearTo.HasValue)
{
queryFilter =
queryFilter.And(
c =>
c.PBCK1 != null && c.PBCK1.PERIOD_TO.HasValue &&
c.PBCK1.PERIOD_TO.Value.Year >= input.YearTo.Value);
}
if (!string.IsNullOrEmpty(input.NppbkcId))
{
queryFilter = queryFilter.And(c => c.PBCK1 != null && c.PBCK1.NPPBKC_ID == input.NppbkcId);
}
Func <IQueryable <PBCK1_QUOTA>, IOrderedQueryable <PBCK1_QUOTA> > orderBy = null;
if (!string.IsNullOrEmpty(input.SortOrderColumn))
{
orderBy = c => c.OrderBy(OrderByHelper.GetOrderByFunction <PBCK1_QUOTA>(input.SortOrderColumn));
}
var dbData = _quotaRepository.Get(queryFilter, orderBy, includeTables);
return(Mapper.Map <List <Pbck1QuotaDto> >(dbData.ToList()));
}
/// <summary>
/// 用于渲染订单页面
/// </summary>
/// <param name="queryParams"></param>
/// <returns></returns>
public JsonResult GetOrder(queryParam queryParams)
{
OrderManageDbContext db = new OrderManageDbContext();
DbSet <Order> data = db.Orders;
List <Order> dataRows = null;
if (queryParams.sortName != null && queryParams.sortOrder != null)
{
dataRows = OrderByHelper <Order> .OrderBy(data, queryParams.sortName, queryParams.sortOrder).ToList();
}
else
{
dataRows = data.ToList();
}
var total = dataRows.Count;
var rows = dataRows.Skip(queryParams.offset).Take(queryParams.limit).ToList();
return(Json(new { total = total, rows = rows }, JsonRequestBehavior.AllowGet));
}
public ActionResult List(Guid weiXinQRCodePromotionActivityAccountId, int pageIndex = 1, int pageSize = 10)
{
try
{
if (weiXinQRCodePromotionActivityAccountId == Guid.Empty)
{
throw new BaseException("WeiXinQRCodePromotionActivityAccountId不能为空");
}
var orderBys = OrderByHelper.Create().Desc("CreatedDate");
var where = Where.Create().Eq("WeiXinQRCodePromotionActivityAccountId", weiXinQRCodePromotionActivityAccountId);
var listResult = this.IWeiXinQRCodePromotionActivityAccountPointsHistoryService
.Page(orderBys, where, pageIndex, pageSize);
return(this.JsonSuccessGenericPageExecResult(listResult));
}
catch (Exception ex)
{
return(this.JsonFailureGenericPageExecResult(ex));
}
}
public SearchResult <TEntity> BuscaAvancada(Expression <Func <TEntity, bool> > condition, string orderBy = "", string sortDirection = "", int take = 0, int skip = 0)
{
var query = _contexto.Set <TEntity>().AsQueryable();
if (condition != null)
{
query = query.Where(condition);
}
int totalRecords = query.Count();
if (!string.IsNullOrEmpty(orderBy))
{
if (!string.IsNullOrEmpty(sortDirection))
{
if (sortDirection == "asc")
{
query = OrderByHelper.OrderBy(query, orderBy);
}
else
{
query = OrderByHelper.OrderByDescending(query, orderBy);
}
if (take > 0)
{
query = query.Take(take);
}
if (skip > 0)
{
query = query.Skip(skip);
}
}
}
return(new SearchResult <TEntity>
{
Itens = query.ToList(),
TotalRecords = totalRecords,
RecordsPerPage = take
});
}
public List <LACK1> GetCompletedDocumentByParam(Lack1GetByParamInput input)
{
includeTables += ", LACK1_PLANT";
Expression <Func <LACK1, bool> > queryFilter = c => (int)c.STATUS >= (int)Core.Enums.DocumentStatus.Completed;
queryFilter = queryFilter.And(ProcessQueryFilter(input));
Func <IQueryable <LACK1>, IOrderedQueryable <LACK1> > orderBy = null;
if (!string.IsNullOrEmpty(input.SortOrderColumn))
{
orderBy = c => c.OrderBy(OrderByHelper.GetOrderByFunction <LACK1>(input.SortOrderColumn));
}
if (input.UserRole == Enums.UserRole.POA)
{
queryFilter = queryFilter.And(c => input.ListNppbkc.Contains(c.NPPBKC_ID));
}
else if (input.UserRole == Enums.UserRole.Administrator)
{
queryFilter = queryFilter.And(c => c.LACK1_LEVEL != null);
}
else if (input.UserRole == Enums.UserRole.Controller)
{
queryFilter = queryFilter.And(c => c.STATUS == Enums.DocumentStatus.Completed);
}
else
{
queryFilter = queryFilter.And(c => (input.ListUserPlant.Contains(c.LACK1_PLANT.FirstOrDefault().PLANT_ID) && c.LACK1_LEVEL == Enums.Lack1Level.Plant) ||
(input.ListNppbkc.Contains(c.NPPBKC_ID) && c.LACK1_LEVEL == Enums.Lack1Level.Nppbkc));
}
var dbData = _repository.Get(queryFilter, orderBy, includeTables);
if (dbData == null)
{
throw new BLLException(ExceptionCodes.BLLExceptions.DataNotFound);
}
return(dbData.ToList());
}
public List <LACK1> GetAllByParam(Lack1GetByParamInput input)
{
includeTables += ", LACK1_PLANT";
Expression <Func <LACK1, bool> > queryFilter = c => c.LACK1_LEVEL == input.Lack1Level;
queryFilter = queryFilter.And(ProcessQueryFilter(input));
Func <IQueryable <LACK1>, IOrderedQueryable <LACK1> > orderBy = c => c.OrderByDescending(l => l.LACK1_ID);
if (!string.IsNullOrEmpty(input.SortOrderColumn))
{
orderBy = c => c.OrderBy(OrderByHelper.GetOrderByFunction <LACK1>(input.SortOrderColumn));
}
var dbData = _repository.Get(queryFilter, orderBy, includeTables);
if (dbData == null)
{
throw new BLLException(ExceptionCodes.BLLExceptions.DataNotFound);
}
return(dbData.ToList());
}
