public EFDirectory_CertificationData(EFDbContext db) { this.db = db; }
public EFUZ_DOC(EFDbContext db) { this.db = db; }
public EFDirectory_ModelsWagons(EFDbContext db) { this.db = db; }
public EFWagonsMotionSignals(EFDbContext db) { this.db = db; }
public EFParksListWagons(EFDbContext db) { this.db = db; }
public EFDirectory_OuterWays(EFDbContext db) { this.db = db; }
public EFDirectory_OperatorsWagonsGroup(EFDbContext db) { this.db = db; }
public EFArrival_UZ_Document_Docs(EFDbContext db) { this.db = db; }
public EFDirectory_ExternalStation(EFDbContext db) { this.db = db; }
public EFCardsWagons(EFDbContext db) { this.db = db; }
public EFDirectory_TypeOwnerShip(EFDbContext db) { this.db = db; }
public EFDirectory_Consignee(EFDbContext db) { this.db = db; }
public EFDirectory_Shipper(EFDbContext db) { this.db = db; }
public EFWagonInternalOperation(EFDbContext db) { this.db = db; }
public EFOutgoing_UZ_Vagon_Cont(EFDbContext db) { this.db = db; }
public EFDirectory_WagonLoadingStatus(EFDbContext db) { this.db = db; }
public EFOutgoingCars(EFDbContext db) { this.db = db; }
public EFSAPIncomingSupply(EFDbContext db) { this.db = db; }
public EFArrival_UZ_Vagon_Cont(EFDbContext db) { this.db = db; }
public EFParkState_Way(EFDbContext db) { this.db = db; }
public EFDirectory_PayerSender(EFDbContext db) { this.db = db; }
public EFDirectory_WagonsRent(EFDbContext db) { this.db = db; }
public EFDirectory_Locomotive(EFDbContext db) { this.db = db; }
public EFDirectory_Countrys(EFDbContext db) { this.db = db; }
public EFDirectory_CargoETSNG(EFDbContext db) { this.db = db; }
public EFDirectory_TypesRepairsWagons(EFDbContext db) { this.db = db; }
public EFOutgoing_UZ_Cont_Pay(EFDbContext db) { this.db = db; }
public EFDirectory_PoligonTravelWagons(EFDbContext db) { this.db = db; }
/// <summary> /// Обновим входящую поставку в WIR /// </summary> /// <param name="context"></param> /// <param name="id_wir"></param> /// <param name="out_sypp"></param> /// <param name="user"></param> /// <returns></returns> public int UpdateWIR_SAPOutgoingSupply(ref EFDbContext context, long id_wir, Out_Supply out_sypp, string user) { try { if (context == null) { context = new EFIDS.Concrete.EFDbContext(); } ; // Проверим и скорректируем пользователя if (String.IsNullOrWhiteSpace(user)) { user = System.Environment.UserDomainName + @"\" + System.Environment.UserName; } EFWagonInternalRoutes ef_wir = new EFWagonInternalRoutes(context); EFSAPOutgoingSupply ef_sap_os = new EFSAPOutgoingSupply(context); // Получим wir WagonInternalRoutes wir = ef_wir.Context.Where(w => w.id == id_wir).FirstOrDefault(); if (wir == null) { return((int)errors_base.not_wir_db); // В базе данных нет записи по WagonInternalRoutes (Внутреннее перемещение вагонов) } // Проверим sap исходящая поставка указана if (wir.id_sap_outbound_supply != null) { SAPOutgoingSupply sap_os = ef_sap_os.Context.Where(s => s.id == wir.id_sap_outbound_supply).FirstOrDefault(); if (sap_os == null) { return((int)errors_base.not_sap_os_db); // В базе данных нет записи по SAPOutgoingSupply (SAP Исходящая поставка) } // Проверим id соответсвуют (SAPOutgoingSupply и Out_Supply) if (sap_os.id_out_supply == out_sypp.id) { // Соответсвует обновим sap_os.id_outgoing_car = wir.id_outgoing_car; sap_os.num = wir.num; sap_os.VBELN = out_sypp.VBELN; sap_os.ERDAT = out_sypp.ERDAT; sap_os.ZBEZEI = out_sypp.ZBEZEI; sap_os.STAWN = out_sypp.STAWN; sap_os.NAME1_AG = out_sypp.NAME1_AG; sap_os.KUNNR_AG = out_sypp.KUNNR_AG; sap_os.ZRWNAME = out_sypp.ZRWNAME; sap_os.ZENDSTAT = out_sypp.ZENDSTAT; sap_os.ZCRSTNAME = out_sypp.ZCRSTNAME; sap_os.ZCROSSSTAT = out_sypp.ZCROSSSTAT; sap_os.ZZVES_NETTO = out_sypp.ZZVES_NETTO; sap_os.ABTNR = out_sypp.ABTNR; sap_os.VTEXT = out_sypp.VTEXT; sap_os.ZZDOLG = out_sypp.ZZDOLG; sap_os.ZZFIO = out_sypp.ZZFIO; sap_os.ZZPLATEL = out_sypp.ZZPLATEL; sap_os.ZZNAME_PLATEL = out_sypp.ZZNAME_PLATEL; //sap_os.note = out_sypp.note, sap_os.change = DateTime.Now; sap_os.change_user = user; ef_sap_os.Update(sap_os); return(2); // Обновлена } else { ef_sap_os.Delete(sap_os.id); // не соответсвует, удалим (и создадим новый) } } // Содадим и добавим новую исходящую поставку SAPOutgoingSupply sap_os_new = new SAPOutgoingSupply() { id = 0, id_out_supply = 0, id_outgoing_car = wir.id_outgoing_car, num = wir.num, VBELN = out_sypp.VBELN.Trim(), ERDAT = out_sypp.ERDAT, ZBEZEI = out_sypp.ZBEZEI.Trim(), STAWN = out_sypp.STAWN.Trim(), NAME1_AG = out_sypp.NAME1_AG.Trim(), KUNNR_AG = out_sypp.KUNNR_AG.Trim(), ZRWNAME = out_sypp.ZRWNAME.Trim(), ZENDSTAT = out_sypp.ZENDSTAT.Trim(), ZCRSTNAME = out_sypp.ZCRSTNAME.Trim(), ZCROSSSTAT = out_sypp.ZCROSSSTAT.Trim(), ZZVES_NETTO = out_sypp.ZZVES_NETTO, ABTNR = out_sypp.ABTNR.Trim(), VTEXT = out_sypp.VTEXT.Trim(), ZZDOLG = out_sypp.ZZDOLG.Trim(), ZZFIO = out_sypp.ZZFIO.Trim(), ZZPLATEL = out_sypp.ZZPLATEL.Trim(), ZZNAME_PLATEL = out_sypp.ZZNAME_PLATEL.Trim(), note = null, create = DateTime.Now, create_user = user, }; sap_os_new.Out_Supply = out_sypp; ef_sap_os.Add(sap_os_new); wir.SAPOutgoingSupply = sap_os_new; ef_wir.Update(wir); return(1); // Добавлена новая } catch (Exception e) { e.ExceptionMethodLog(String.Format("UpdateWIR_SAPOutgoingSupply(context = {0}, id_wir = {1}, cur_out_sypp = {2}, user = {3})", context, id_wir, out_sypp, user), servece_owner, eventID); return((int)errors_base.global); } }
public EFDirectory_OwnersWagons(EFDbContext db) { this.db = db; }