/// <summary>
/// Поставить все составы прибывшие на АМКР по системе КИС (перечень составов берется из таблицы учета прибытия составов на АМКР системы RailWay)
/// </summary>
/// <returns></returns>
public int PutCarsToStations(int mode)
{
IQueryable <Oracle_ArrivalSostav> list_noClose = oas.Get_ArrivalSostavNoClose();
if (list_noClose == null | list_noClose.Count() == 0)
{
return(0);
}
foreach (Oracle_ArrivalSostav or_as in list_noClose.ToList())
{
Oracle_ArrivalSostav kis_sostav = new Oracle_ArrivalSostav();
kis_sostav = or_as;
// Поставим состав на станции АМКР системы RailCars
int res_put = transfer_rc.PutCarsToStation(ref kis_sostav, mode);
//TODO: ВКЛЮЧИТЬ КОД: Обновление составов на станции АМКР системы RailCars
int res_upd = transfer_rc.UpdateCarsToStation(ref kis_sostav, mode);
//TODO: ВЫПОЛНИТЬ КОД: Поставим состав на станции АМКР системы RailWay
//.............................
//Закрыть состав
if (kis_sostav.CountWagons != null & kis_sostav.CountNatHIist != null & kis_sostav.CountSetWagons != null & kis_sostav.CountSetNatHIist != null
& kis_sostav.CountWagons == kis_sostav.CountNatHIist & kis_sostav.CountWagons == kis_sostav.CountSetWagons & kis_sostav.CountWagons == kis_sostav.CountSetNatHIist)
{
kis_sostav.Close = DateTime.Now;
int res_close = oas.SaveOracle_ArrivalSostav(kis_sostav);
if (mode == 0)
{
int res_del_arr = transfer_rc.DeleteInArrival(kis_sostav.NaturNum, kis_sostav.DateTime);
//TODO: ВЫПОЛНИТЬ КОД: Убрать с прибытия с УЗ на станции АМКР в системе RailWay
}
}
}
return(0); // TODO: исправить возврат
}
/// <summary>
/// Закрыть строку
/// </summary>
/// <param name="IDOrcSostav"></param>
/// <returns></returns>
public int CloseArrivalSostav(int IDOrcSostav)
{
Oracle_ArrivalSostav ors = Get_ArrivalSostav(IDOrcSostav);
ors.Close = DateTime.Now;
return(SaveOracle_ArrivalSostav(ors));
}
/// <summary>
/// Вернуть последнее время по которому перенесли состав
/// </summary>
/// <returns></returns>
public DateTime?GetLastDateTime()
{
Oracle_ArrivalSostav oas = Get_ArrivalSostav().OrderByDescending(a => a.DateTime).FirstOrDefault();
if (oas != null)
{
return(oas.DateTime);
}
return(null);
}
public void Test_KIS_RC_Transfer_PutCarsToStation_UpdateCarsToStation()
{
KIS_RC_Transfer transfer_rc = new KIS_RC_Transfer();
Oracle_ArrivalSostav oras = oas.Get_ArrivalSostav(4777);
//52928280
int res_put = transfer_rc.PutCarsToStation(ref oras, 1);
//TODO: ВКЛЮЧИТЬ КОД: Обновление составов на станции АМКР системы RailCars
int res_upd = transfer_rc.UpdateCarsToStation(ref oras, 1);
//Console.WriteLine("Обновлено {0},{1}", res_put, res_upd);
}
public void Test_KIS_RC_Transfer_SetListWagon()
{
Oracle_ArrivalSostav oras = oas.Get_ArrivalSostav(1364);
List <PromVagon> list_pv = pc.GetVagon(oras.NaturNum, oras.IDOrcStation, oras.Day, oras.Month, oras.Year, oras.Napr == 2 ? true : false).ToList();
List <PromNatHist> list_nh = pc.GetNatHist(oras.NaturNum, oras.IDOrcStation, oras.Day, oras.Month, oras.Year, oras.Napr == 2 ? true : false).ToList();
KIS_RC_Transfer kisrs = new KIS_RC_Transfer();
int res = kisrs.SetListWagon(ref oras, list_pv, list_nh);
Console.WriteLine("Обновлено {0}", res);
}
/// <summary>
/// Удалить
/// </summary>
/// <param name="IDOrcSostav"></param>
/// <returns></returns>
public Oracle_ArrivalSostav DeleteOracle_ArrivalSostav(int IDOrcSostav)
{
Oracle_ArrivalSostav dbEntry = context.Oracle_ArrivalSostav.Find(IDOrcSostav);
if (dbEntry != null)
{
context.Oracle_ArrivalSostav.Remove(dbEntry);
try
{
context.SaveChanges();
}
catch (Exception e)
{
LogRW.LogError(e, "DeleteOracle_ArrivalSostav", eventID);
return(null);
}
}
return(dbEntry);
}
/// <summary>
/// Добавить или править
/// </summary>
/// <param name="TypeValue"></param>
/// <returns></returns>
public int SaveOracle_ArrivalSostav(Oracle_ArrivalSostav oracle_ArrivalSostav)
{
Oracle_ArrivalSostav dbEntry;
if (oracle_ArrivalSostav.IDOrcSostav == 0)
{
dbEntry = new Oracle_ArrivalSostav()
{
IDOrcSostav = oracle_ArrivalSostav.IDOrcSostav,
DateTime = oracle_ArrivalSostav.DateTime,
Day = oracle_ArrivalSostav.Day,
Month = oracle_ArrivalSostav.Month,
Year = oracle_ArrivalSostav.Year,
Hour = oracle_ArrivalSostav.Hour,
Minute = oracle_ArrivalSostav.Minute,
NaturNum = oracle_ArrivalSostav.NaturNum,
IDOrcStation = oracle_ArrivalSostav.IDOrcStation,
WayNum = oracle_ArrivalSostav.WayNum,
Napr = oracle_ArrivalSostav.Napr,
CountWagons = oracle_ArrivalSostav.CountWagons,
CountNatHIist = oracle_ArrivalSostav.CountNatHIist,
CountSetWagons = oracle_ArrivalSostav.CountSetWagons,
CountSetNatHIist = oracle_ArrivalSostav.CountSetNatHIist,
Close = oracle_ArrivalSostav.Close,
Status = oracle_ArrivalSostav.Status,
ListWagons = oracle_ArrivalSostav.ListWagons,
ListNoSetWagons = oracle_ArrivalSostav.ListNoSetWagons,
ListNoUpdateWagons = oracle_ArrivalSostav.ListNoUpdateWagons,
Message = oracle_ArrivalSostav.Message
};
context.Oracle_ArrivalSostav.Add(dbEntry);
}
else
{
dbEntry = context.Oracle_ArrivalSostav.Find(oracle_ArrivalSostav.IDOrcSostav);
if (dbEntry != null)
{
//dbEntry.IDOrcSostav = oracle_ArrivalSostav.IDOrcSostav;
dbEntry.DateTime = oracle_ArrivalSostav.DateTime;
dbEntry.Day = oracle_ArrivalSostav.Day;
dbEntry.Month = oracle_ArrivalSostav.Month;
dbEntry.Year = oracle_ArrivalSostav.Year;
dbEntry.Hour = oracle_ArrivalSostav.Hour;
dbEntry.Minute = oracle_ArrivalSostav.Minute;
dbEntry.NaturNum = oracle_ArrivalSostav.NaturNum;
dbEntry.IDOrcStation = oracle_ArrivalSostav.IDOrcStation;
dbEntry.WayNum = oracle_ArrivalSostav.WayNum;
dbEntry.Napr = oracle_ArrivalSostav.Napr;
dbEntry.CountWagons = oracle_ArrivalSostav.CountWagons;
dbEntry.CountNatHIist = oracle_ArrivalSostav.CountNatHIist;
dbEntry.CountSetWagons = oracle_ArrivalSostav.CountSetWagons;
dbEntry.CountSetNatHIist = oracle_ArrivalSostav.CountSetNatHIist;
dbEntry.Close = oracle_ArrivalSostav.Close;
dbEntry.Status = oracle_ArrivalSostav.Status;
dbEntry.ListWagons = oracle_ArrivalSostav.ListWagons;
dbEntry.ListNoSetWagons = oracle_ArrivalSostav.ListNoSetWagons;
dbEntry.ListNoUpdateWagons = oracle_ArrivalSostav.ListNoUpdateWagons;
dbEntry.Message = oracle_ArrivalSostav.Message;
}
}
try
{
context.SaveChanges();
}
catch (Exception e)
{
LogRW.LogError(e, "SaveOracle_ArrivalSostav", eventID);
//LogRW.LogError(String.Format("SaveOracle_ArrivalSostav IDOrcSostav:{0},NaturNum:{1},DateTime:{2},CountWagons:{3},CountSetWagons:{4},ListWagons:{5},ListNoSetWagons:{6},ListNoUpdateWagons:{7},WayNum:{8},Napr;{9}",
// oracle_ArrivalSostav.IDOrcSostav,
// oracle_ArrivalSostav.NaturNum,
// oracle_ArrivalSostav.DateTime,
// oracle_ArrivalSostav.CountWagons,
// oracle_ArrivalSostav.CountSetWagons,
// oracle_ArrivalSostav.ListWagons,
// oracle_ArrivalSostav.ListNoSetWagons,
// oracle_ArrivalSostav.ListNoUpdateWagons,
// oracle_ArrivalSostav.WayNum,
// oracle_ArrivalSostav.Napr)
//, eventID);
return(-1);
}
return(dbEntry.IDOrcSostav);
}
/// <summary>
/// Сохранить добавить состав
/// </summary>
/// <param name="Oracle_ArrivalSostav"></param>
/// <returns></returns>
public int SaveOracle_ArrivalSostav(Oracle_ArrivalSostav Oracle_ArrivalSostav)
{
return(rep_as.SaveOracle_ArrivalSostav(Oracle_ArrivalSostav));
}
