public List <SPAdReportEntity> GetList_By_SPPackID_SPAdPackEntity(SPAdPackEntity fkentity)
{
NHibernateDynamicQueryGenerator <SPAdReportEntity> dynamicQueryGenerator = this.GetNewQueryBuilder();
dynamicQueryGenerator.AddWhereClause(PROPERTY_SPPACKID.Eq(fkentity));
return(this.FindListByQueryBuilder(dynamicQueryGenerator));
}
public SPAdAssignedHistortyEntity FindAssignedHistortybyAdPack(SPAdPackEntity spAdPackEntity)
{
NHibernateDynamicQueryGenerator <SPAdAssignedHistortyEntity> query = this.GetNewQueryBuilder();
query.AddWhereClause(PROPERTY_ENDDATE.IsNull());
query.AddWhereClause(PROPERTY_SPADPACKID.Eq(spAdPackEntity));
return(FindSingleEntityByQueryBuilder(query));
}
public SPSClientEntity GetAdPackAssignedClient(SPAdPackEntity spAdPackEntity)
{
SPAdAssignedHistortyEntity spAdAssignedHistorty = this.SelfDataObj.FindAssignedHistortybyAdPack(spAdPackEntity);
if (spAdAssignedHistorty != null)
{
return(spAdAssignedHistorty.SPClientID);
}
return(null);
}
public void RemoveAdAssigned(SPAdPackEntity spAdPackEntity, SPSClientEntity spsClientEntity)
{
SPAdAssignedHistortyEntity spAdAssignedHistorty = this.SelfDataObj.FindAssignedHistortybyAdPack(spAdPackEntity);
if (spAdAssignedHistorty != null)
{
spAdAssignedHistorty.EndDate = System.DateTime.Now;
this.SelfDataObj.Update(spAdAssignedHistorty);
}
}
internal static SPAdPackWrapper ConvertEntityToWrapper(SPAdPackEntity entity)
{
if (entity == null)
{
return(null);
}
if (entity.Id == 0)
{
return(null);
}
return(new SPAdPackWrapper(entity));
}
public SPAdReportEntity FindByCilentIDAdPackIDAndReportDate(int?spadId, SPAdPackEntity spPackId, SPSClientEntity spClientId, DateTime?reportDate)
{
NHibernateDynamicQueryGenerator <SPAdReportEntity> query = this.GetNewQueryBuilder();
//指定查询条件
query.AddWhereClause(PROPERTY_REPORTDATE.Eq(reportDate.Value));
query.AddWhereClause(PROPERTY_SPCLIENTID.Eq(spClientId));
query.AddWhereClause(PROPERTY_SPADID.Eq(spadId.Value));
query.AddWhereClause(PROPERTY_SPPACKID.Eq(spPackId));
return(this.FindSingleEntityByQueryBuilder(query));
}
public void ClientAssignedAdPack(SPSClientEntity spsClientEntity, SPAdPackEntity spAdPackEntity, decimal clientPrice)
{
SPAdAssignedHistortyEntity spAdAssignedHistorty = this.SelfDataObj.FindAssignedHistortybyAdPack(spAdPackEntity);
if (spAdAssignedHistorty != null)
{
spAdAssignedHistorty.EndDate = System.DateTime.Now;
this.SelfDataObj.Update(spAdAssignedHistorty);
}
SPAdAssignedHistortyEntity newspAdAssignedHistorty = new SPAdAssignedHistortyEntity();
newspAdAssignedHistorty.SPAdID = spAdPackEntity.SPAdID.Id;
newspAdAssignedHistorty.SPAdPackID = spAdPackEntity;
newspAdAssignedHistorty.SPClientID = spsClientEntity;
newspAdAssignedHistorty.ClientPrice = clientPrice;
newspAdAssignedHistorty.StartDate = System.DateTime.Now;
newspAdAssignedHistorty.CreateAt = System.DateTime.Now;
this.SelfDataObj.Save(newspAdAssignedHistorty);
}
public List <SPAdAssignedHistortyEntity> GetPageList_By_SPAdPackID_SPAdPackEntity(string orderByColumnName, bool isDesc, SPAdPackEntity fkentity, PageQueryParams pageQueryParams)
{
NHibernateDynamicQueryGenerator <SPAdAssignedHistortyEntity> dynamicQueryGenerator = this.GetNewQueryBuilder();
dynamicQueryGenerator.AddWhereClause(PROPERTY_SPADPACKID.Eq(fkentity));
AddDefaultOrderByToQueryGenerator(orderByColumnName, isDesc, dynamicQueryGenerator);
return(FindListByPageByQueryBuilder(dynamicQueryGenerator, pageQueryParams));
}
public List <SPAdAssignedHistortyEntity> FindAllBySPAdPackID(SPAdPackEntity _sPAdPackID)
{
return(this.SelfDataObj.GetList_By_SPAdPackID_SPAdPackEntity(_sPAdPackID));
}
public List <SPAdAssignedHistortyEntity> FindAllByOrderByAndFilterAndSPAdPackID(string orderByColumnName, bool isDesc, SPAdPackEntity _sPAdPackID, PageQueryParams pageQueryParams)
{
return(this.SelfDataObj.GetPageList_By_SPAdPackID_SPAdPackEntity(orderByColumnName, isDesc, _sPAdPackID, pageQueryParams));
}
internal SPAdPackWrapper(SPAdPackEntity entityObj)
: base(entityObj)
{
}
public List <SPAdReportEntity> FindAllBySPPackID(SPAdPackEntity _sPPackID)
{
return(this.SelfDataObj.GetList_By_SPPackID_SPAdPackEntity(_sPPackID));
}
