private StoreWorldDetail FillWorldName(StoreWorldDetail entity) { if (entity != null) { World related = ClientEnvironment.WorldService.GetByStoreToWorldID(entity.StoreWorldId); if (related != null) { entity.WorldName = related.Name; entity.WorldTypeID = related.WorldTypeID; } } return(entity); }
public List <StoreWorldDetail> GetStoreWorldDetail(short year, long storeID, long store_worldID) { List <StoreWorldDetail> storeStructureList = new List <StoreWorldDetail>(); string query = "exec spStore_WorldDetailGet {0}, {1}, {2}"; query = string.Format(query, year, storeID, store_worldID); using (IDbCommand command = CreateCommand()) { command.CommandText = query; using (IDataReader reader = command.ExecuteReader(CommandBehavior.SequentialAccess)) { while (reader.Read()) { //Store_WorldID, StoreID, BufferHoursValue, BenchmarkValue, //AvailableWorkTimeHours, BusinessVolumeHours, TargetedBusinessVolume, NetBusinessVolume1, NetBusinessVolume2 StoreWorldDetail storeWorldDetail = new StoreWorldDetail(); storeWorldDetail.Year = year; storeWorldDetail.StoreWorldId = reader.GetInt64(0); storeWorldDetail.StoreId = reader.GetInt64(1); if (reader.IsDBNull(2)) { storeWorldDetail.AvailableBufferHours = null; } else { storeWorldDetail.AvailableBufferHours = reader.GetDouble(2); } if (reader.IsDBNull(3)) { storeWorldDetail.BenchmarkPerfomance = null; } else { storeWorldDetail.BenchmarkPerfomance = reader.GetDouble(3); } if (reader.IsDBNull(4)) { storeWorldDetail.AvailableWorkTimeHours = null; } else { storeWorldDetail.AvailableWorkTimeHours = reader.GetDecimal(4); } if (reader.IsDBNull(5)) { storeWorldDetail.BusinessVolumeHours = null; } else { storeWorldDetail.BusinessVolumeHours = reader.GetDecimal(5); } if (reader.IsDBNull(6)) { storeWorldDetail.TargetedBusinessVolume = null; } else { storeWorldDetail.TargetedBusinessVolume = reader.GetDecimal(6); } if (reader.IsDBNull(7)) { storeWorldDetail.NetBusinessVolume1 = null; } else { storeWorldDetail.NetBusinessVolume1 = reader.GetDecimal(7); } if (reader.IsDBNull(8)) { storeWorldDetail.NetBusinessVolume2 = null; } else { storeWorldDetail.NetBusinessVolume2 = reader.GetDecimal(8); } storeStructureList.Add(storeWorldDetail); } } } return(storeStructureList); }