/// <summary>
/// Записать строку с вагоном в справочник САП
/// </summary>
/// <param name="wagon"></param>
/// <param name="idsostav"></param>
/// <returns></returns>
public int SetWagonToSAPSupply(trWagon wagon, int idsostav)
{
SAPIncSupply saps = ConvertWagonToSAPSupply(wagon, idsostav);
if (saps != null)
{
return(sapis.SaveSAPIncSupply(saps));
}
return(0);
}
/// <summary>
/// Получить IDSostav по умолчанию (если в таблицах MT нет данного состава тогда ему присваивается id по умолчанию (отрицательное)
/// </summary>
/// <returns></returns>
public int GetDefaultIDSostav()
{
SAPIncSupply sap_s = sapis.GetSAPIncSupply().Where(s => s.IDMTSostav < 0).OrderBy(s => s.IDMTSostav).FirstOrDefault();
if (sap_s != null)
{
return(sap_s.IDMTSostav - 1);
}
return(-1);
}
/// <summary>
/// Получить строку SAPIncSupply из trWagon
/// </summary>
/// <param name="wagon"></param>
/// <param name="idsostav"></param>
/// <returns></returns>
public SAPIncSupply ConvertWagonToSAPSupply(trWagon wagon, int idsostav)
{
if (wagon == null)
{
return(null);
}
//Определим страну по общему справочнику
int id_country = 0;
if (wagon.CountryCode > 0)
{
int country = 0;
country = int.Parse(wagon.CountryCode.ToString().Substring(0, 2));
id_country = trans_ref.DefinitionIDCountrySNG(country);
}
//Определим груз по общему справочнику
int id_cargo = trans_ref.DefinitionIDCargo(wagon.IDCargo);
SAPIncSupply sap_Supply = new SAPIncSupply()
{
ID = 0,
DateTime = wagon.DateOperation,
CompositionIndex = wagon.CompositionIndex,
IDMTSostav = idsostav,
CarriageNumber = wagon.CarriageNumber,
Position = wagon.Position,
NumNakl = null,
CountryCode = wagon.CountryCode,
IDCountry = id_country,
WeightDoc = (decimal?)wagon.Weight,
DocNumReweighing = null,
DocDataReweighing = null,
WeightReweighing = null,
DateTimeReweighing = null,
PostReweighing = null,
CodeCargo = wagon.IDCargo,
IDCargo = id_cargo,
CodeMaterial = null,
NameMaterial = null,
CodeStationShipment = null,
NameStationShipment = null,
CodeShop = null,
NameShop = null,
CodeNewShop = null,
NameNewShop = null,
PermissionUnload = null,
Step1 = null,
Step2 = null
};
return(sap_Supply);
}
public SAPIncSupply DeleteSAPIncSupply(int id)
{
SAPIncSupply dbEntry = context.SAPIncSupply.Find(id);
if (dbEntry != null)
{
context.SAPIncSupply.Remove(dbEntry);
try
{
context.SaveChanges();
}
catch (Exception e)
{
LogRW.LogError(e, "DeleteSAPIncSupply", eventID);
return(null);
}
}
return(dbEntry);
}
public int SaveSAPIncSupply(SAPIncSupply SAPIncSupply)
{
SAPIncSupply dbEntry;
if (SAPIncSupply.ID == 0)
{
dbEntry = new SAPIncSupply()
{
ID = SAPIncSupply.ID,
DateTime = SAPIncSupply.DateTime,
CompositionIndex = SAPIncSupply.CompositionIndex,
IDMTSostav = SAPIncSupply.IDMTSostav,
CarriageNumber = SAPIncSupply.CarriageNumber,
Position = SAPIncSupply.Position,
NumNakl = SAPIncSupply.NumNakl,
CountryCode = SAPIncSupply.CountryCode,
IDCountry = SAPIncSupply.IDCountry,
WeightDoc = SAPIncSupply.WeightDoc,
DocNumReweighing = SAPIncSupply.DocNumReweighing,
DocDataReweighing = SAPIncSupply.DocDataReweighing,
WeightReweighing = SAPIncSupply.WeightReweighing,
DateTimeReweighing = SAPIncSupply.DateTimeReweighing,
PostReweighing = SAPIncSupply.PostReweighing,
CodeCargo = SAPIncSupply.CodeCargo,
IDCargo = SAPIncSupply.IDCargo,
CodeMaterial = SAPIncSupply.CodeMaterial,
NameMaterial = SAPIncSupply.NameMaterial,
CodeStationShipment = SAPIncSupply.CodeStationShipment,
NameStationShipment = SAPIncSupply.NameStationShipment,
CodeShop = SAPIncSupply.CodeShop,
NameShop = SAPIncSupply.NameShop,
CodeNewShop = SAPIncSupply.CodeNewShop,
NameNewShop = SAPIncSupply.NameNewShop,
PermissionUnload = SAPIncSupply.PermissionUnload,
Step1 = SAPIncSupply.Step1,
Step2 = SAPIncSupply.Step2
};
context.SAPIncSupply.Add(dbEntry);
}
else
{
dbEntry = context.SAPIncSupply.Find(SAPIncSupply.ID);
if (dbEntry != null)
{
dbEntry.DateTime = SAPIncSupply.DateTime;
dbEntry.CompositionIndex = SAPIncSupply.CompositionIndex;
dbEntry.IDMTSostav = SAPIncSupply.IDMTSostav;
dbEntry.CarriageNumber = SAPIncSupply.CarriageNumber;
dbEntry.Position = SAPIncSupply.Position;
dbEntry.NumNakl = SAPIncSupply.NumNakl;
dbEntry.CountryCode = SAPIncSupply.CountryCode;
dbEntry.IDCountry = SAPIncSupply.IDCountry;
dbEntry.WeightDoc = SAPIncSupply.WeightDoc;
dbEntry.DocNumReweighing = SAPIncSupply.DocNumReweighing;
dbEntry.DocDataReweighing = SAPIncSupply.DocDataReweighing;
dbEntry.WeightReweighing = SAPIncSupply.WeightReweighing;
dbEntry.DateTimeReweighing = SAPIncSupply.DateTimeReweighing;
dbEntry.PostReweighing = SAPIncSupply.PostReweighing;
dbEntry.CodeCargo = SAPIncSupply.CodeCargo;
dbEntry.IDCargo = SAPIncSupply.IDCargo;
dbEntry.CodeMaterial = SAPIncSupply.CodeMaterial;
dbEntry.NameMaterial = SAPIncSupply.NameMaterial;
dbEntry.CodeStationShipment = SAPIncSupply.CodeStationShipment;
dbEntry.NameStationShipment = SAPIncSupply.NameStationShipment;
dbEntry.CodeShop = SAPIncSupply.CodeShop;
dbEntry.NameShop = SAPIncSupply.NameShop;
dbEntry.CodeNewShop = SAPIncSupply.CodeNewShop;
dbEntry.NameNewShop = SAPIncSupply.NameNewShop;
dbEntry.PermissionUnload = SAPIncSupply.PermissionUnload;
dbEntry.Step1 = SAPIncSupply.Step1;
dbEntry.Step2 = SAPIncSupply.Step2;
}
}
try
{
context.SaveChanges();
}
catch (Exception e)
{
LogRW.LogError(e, "SaveSAPIncSupply", eventID);
return(-1);
}
return(dbEntry.ID);
}
/// <summary>
/// Добавить или править
/// </summary>
/// <param name="SAPIncSupply"></param>
/// <returns></returns>
public int SaveSAPIncSupply(SAPIncSupply SAPIncSupply)
{
return(rep_sap.SaveSAPIncSupply(SAPIncSupply));
}
/// <summary>
/// Проверка наличия вагона в справочнике САП
/// </summary>
/// <param name="idsostav"></param>
/// <param name="vagon"></param>
/// <returns></returns>
public bool IsWagonToSAPSupply(int idsostav, int vagon)
{
SAPIncSupply sap = sapis.GetSAPIncSupply(idsostav, vagon);
return(sap != null ? true : false);
}
