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