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