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