public void IngresarAvisos(EntityConnectionStringBuilder connection, Avisos av) { var context = new samEntities(connection.ToString()); context.avisos_MDL(av.QMNUM, av.QMART, av.QMTXT, av.TXT04_ES, av.TXT04_EN, av.TXT30_ES, av.TXT30_EN, av.TPLNR, av.PLTXT, av.EQUNR, av.EQKTX, av.BAUTL, av.INGRP, av.IWERK, av.INNAM, av.ARBPL, av.SWERK, av.KTEXT, av.I_PARNR, av.NAME_LIST, av.PARNR_VERA, av.NAME_VERA, av.QMNAM, av.QMDAT, av.MZEIT, av.QMGRP, av.HEADKTXT, av.FOLIO_SAM, av.LVORM, av.AUFNR); }
public void ActualizarCabTextoAvi(EntityConnectionStringBuilder connection, TextoAvisosCalidadCrea txt) { var context = new samEntities(connection.ToString()); context.UPDATE_cabecera_avisos_textos_calidad_crea_MDL(txt.FOLIO_SAM, txt.RECIBIDO); }
public void IngresarTipoMov(EntityConnectionStringBuilder connection, TiposMovimientos tp) { var context = new samEntities(connection.ToString()); context.INSERT_tipo_movimientos_MDL(tp.BWART, tp.BTEXT); }
public void ActualizarAvisoCreacion(EntityConnectionStringBuilder connection, string folio_sam, string mensaje) { var context = new samEntities(connection.ToString()); context.UPDATE_AVISOS_FOL_MDL(folio_sam, mensaje); }
public IEnumerable <SELECT_cabecera_avisos_crea_lista_MDL_Result> ObtenerListaFolios(EntityConnectionStringBuilder connection, string fecha, string hora) { var context = new samEntities(connection.ToString()); return(context.SELECT_cabecera_avisos_crea_lista_MDL(fecha, hora)); }
public void IngresaGRUPOS_PLANIFICACION(EntityConnectionStringBuilder connection, GRUPOS_PLANIFICACION um) { var context = new samEntities(connection.ToString()); context.INSERT_grupo_planificacion_MDL(um.INGRP, um.IWERK); }
public void VaciarEquipos(EntityConnectionStringBuilder connection, Equipos eq) { var context = new samEntities(connection.ToString()); context.DELETE_equipos_MDL(eq.EQUNR, eq.SWERK); }
public void ActualizaMov_cabecera_crea(EntityConnectionStringBuilder connection, Mov_cabecera_crea movcab) { var context = new samEntities(connection.ToString()); context.UPDATE_movimientos_cabecera_crea_MDL(movcab.FOLIO_SAM, movcab.RECIBIDO); }
public void ActulizaPosLotInsNot(EntityConnectionStringBuilder connection, CalidadPosNot posnot) { var context = new samEntities(connection.ToString()); context.UPDATE_posiciones_lotes_inspeccion_notificaciones_crea_MDL(posnot.FOLIO_SAM, posnot.RECIBIDO); }
public void InsertarComponentes_de_ordenesPM(EntityConnectionStringBuilder connection, Componentes_de_ordenesPM co) { try { var contex = new samEntities(connection.ToString()); contex.INSERT_Componentes_mdl(co.AUFNR, co.FOLIO_SAM, co.POSNR, co.MATNR, co.MATXT, co.MENGE, co.EINHEIT, co.POSTP, co.SOBKZ_D, co.LGORT, co.WERKS, co.VORNR, co.CHARG, co.WEMPF, co.ABLAD, co.XLOEK, co.SCHGT, co.RGEKZ, co.AUDISP, co.BWART, co.SPECIAL_STOCK, co.ZREST); } catch (Exception) { } }
public void ActualizarComponentes(EntityConnectionStringBuilder connection, Componentes_de_ordenesPM co) { var context = new samEntities(connection.ToString()); context.UPDATE_Componentes_MDL(co.AUFNR, co.FOLIO_SAM, co.POSNR, co.MATNR, co.MATXT, co.MENGE, co.EINHEIT, co.POSTP, co.SOBKZ_D, co.LGORT, co.WERKS, co.VORNR, co.CHARG, co.WEMPF, co.ABLAD, co.XLOEK, co.SCHGT, co.RGEKZ, co.AUDISP, co.BWART, co.SPECIAL_STOCK); }
public void ActualizaResultado(EntityConnectionStringBuilder connection, string folio_sam, string mensaje) { var context = new samEntities(connection.ToString()); context.UPDATE_Noti_PP_MDL(folio_sam, mensaje); }
public void BorrarMateralAlm303(EntityConnectionStringBuilder connection, MaterialesAlmacen adm) { var context = new samEntities(connection.ToString()); context.DELETE_materiales_almacen_303_MDL(adm.MATNR, adm.WERKS); }
public void ActualizaPosConsumosCrea(EntityConnectionStringBuilder connection, PosConsumosCrea poscon) { var context = new samEntities(connection.ToString()); context.UPDATE_posiciones_consumos_crea_MDL(poscon.FOLIO_SAM, poscon.RECIBIDO); }
public void InsertarMM(EntityConnectionStringBuilder connection, Inventario i) { var context = new samEntities(connection.ToString()); context.INSERT_Inventario_MM_MDL(i.MATNR, i.MAKTX_ES, i.MAKTX_EN, i.WERKS, i.MEINS, i.LGORT, i.LGOBE, i.CLABS, i.CINSM, i.CSPEM, i.CUMLM, i.CHARG, i.MTART, i.MATKL, i.SERNR, i.XCHPF, i.CLABS, "", "", ""); }
public void ActualizarDecisionEmpleo2(EntityConnectionStringBuilder connection, DecisionEmpleo de) { var context = new samEntities(connection.ToString()); context.UPDATE_decision_empleo_lote_crea2_MDL(de.FOLIO_SAM, de.RECIBIDO); }
public void ActualizaInvMM(EntityConnectionStringBuilder connection, Inventario i) { var context = new samEntities(connection.ToString()); context.UPDATE_INV_MM_MDL(i.MATNR, i.MAKTX_ES, i.MAKTX_EN, i.WERKS, i.MEINS, i.LGORT, i.LGOBE, i.CLABS, i.CINSM, i.CSPEM, i.CUMLM, i.CHARG, i.MTART, i.MATKL, i.SERNR, i.XCHPF, i.CLABS, "", "", i.CUMLM); }
public IEnumerable <SELECT_cabecera_lotes_inspeccion_notificaciones_crea_list_MDL_Result> ObtenerListaLotesPM(EntityConnectionStringBuilder connection, string fecha, string hora) { var context = new samEntities(connection.ToString()); return(context.SELECT_cabecera_lotes_inspeccion_notificaciones_crea_list_MDL(fecha, hora)); }
public void InsertarBoomMate(EntityConnectionStringBuilder connection, Boom_MatePP bm) { try { var contex = new samEntities(connection.ToString()); contex.Insert_BoomMate_MDL(bm.WERKS, bm.STLTY, bm.STLNR, bm.STLAL, bm.STKOZ, bm.STLKN, bm.STPOZ, bm.STASZ, bm.MATNR, bm.BMENG, bm.DATUV, bm.LKENZ, bm.LOEKZ, bm.ANDAT, bm.ANNAM, bm.IDNRK, bm.PSWRK, bm.POSTP, bm.SPOSN, bm.SORTP, bm.KMPME, bm.KMPMG, bm.FMENG); } catch (Exception) { } }
public void ActulizarCabLotInsNot(EntityConnectionStringBuilder connection, CalidadCabNot cabnot) { var context = new samEntities(connection.ToString()); context.UPDATE_cabecera_lotes_inspeccion_notificaciones_crea_MDL(cabnot.FOLIO_SAM, cabnot.RECIBIDO); }
public void ActualizaCabAvisosCrea(EntityConnectionStringBuilder connection, CabAvisosCrea cabavi) { var context = new samEntities(connection.ToString()); context.UPDATE_cabecera_avisos_crea_MDL(cabavi.FOLIO_SAM, cabavi.RECIBIDO); }
public void IngresaPedido_I(EntityConnectionStringBuilder connection, Pedidos_I pd) { if (pd.BEWTP == "E") { pd.BEWTP = "WE"; } else if (pd.BEWTP == "D") { pd.BEWTP = "Lerf"; } else if (pd.BEWTP != "D" || pd.BEWTP != "E") { pd.BEWTP = pd.BEWTP; } var context = new samEntities(connection.ToString()); context.InsertPedidosHistorial_MDL(pd.EBELN, pd.EBELP, pd.MATNR, pd.TXZ01, pd.MENGE, pd.MEINS, pd.BEWTP, pd.BWART, pd.MBLNR, pd.BUZEI, pd.CANTIADE, pd.UM_PED, pd.EINDT, pd.BUDAT, pd.FOLIO_SAM, pd.LVORM); }
public IEnumerable <SELECT_avisos_valida_hora_MDL_Result> ObtenerValidacionHoraAvisos(EntityConnectionStringBuilder connection, int id, string hora) { var context = new samEntities(connection.ToString()); return(context.SELECT_avisos_valida_hora_MDL(id, hora)); }
public void IngresaBom(EntityConnectionStringBuilder connection, BomEquipo be) { var context = new samEntities(connection.ToString()); context.bom_equipos_MDL(be.MANDT, be.EQUNR, be.WERKS, be.STLAN, be.STLTY, be.STLNR, be.STLAL, be.STKOZ, be.STLKN, be.STPOZ, be.STASZ, be.DATUV, be.LKENZ, be.LOEKZ, be.ANDAT, be.ANNAM, be.IDNRK, be.PSWRK, be.POSTP, be.SPOSN, be.SORTP, be.KMPME, be.KMPMG, be.FMENG); }
public void IngresarInventarios(EntityConnectionStringBuilder connection, Inventarios ins) { var context = new samEntities(connection.ToString()); context.INSERT_inventarios_MDL(ins.MATNR, ins.MAKTX_ES, ins.MAKTX_EN, ins.WERKS, ins.MEINS, ins.LGORT, ins.LGOBE, ins.CLABS, ins.CINSM, ins.CSPEM, ins.CUMLM, ins.CHARG, ins.MTART, ins.MATKL, ins.SERNR, ins.XCHPF, ins.CLABS, "0", "0", ins.CUMLM); }
public void VaciarRelacion2(EntityConnectionStringBuilder connection, Relacion2 rl) { var context = new samEntities(connection.ToString()); context.DELETE_relacion2_MDL(rl.EQUNR, rl.IWERK); }
public void ActualicarPosTextoAvi(EntityConnectionStringBuilder connection, TextoPosAvisosCalidad tpo) { var context = new samEntities(connection.ToString()); context.UPDATE_posiciones_avisos_textos_calidad_crea_MDL(tpo.FOLIO_SAM, tpo.RECIBIDO); }
public void IngresaNOTIFICACIONES(EntityConnectionStringBuilder connection, NOTIFICACIONES not) { var context = new samEntities(connection.ToString()); context.notificaciones_cabecera_vis_MDL(not.AUFNR, not.WERKS, not.CABECERA, not.VORNR, not.UVORN, not.KAPAR, not.RMZHL, not.AUERU, not.STOKZ, not.BUDAT, not.ARBPL, not.ISMNW_2, not.ISMNU, not.LEARR, not.LTXA1, not.SATZA, not.ISDD, not.IEDD, not.OFMNW, not.ARBEI, not.FSAVD, not.SSAVD, not.FSEDD, not.SSEDD, not.ARBID, not.LVORM); }
public void ActualizarTipoMov(EntityConnectionStringBuilder connection, TiposMovimientos tp) { var context = new samEntities(connection.ToString()); context.UPDATE_tipo_movimientos_MDL(tp.BWART, tp.BTEXT); }
public void VaciarAvisos(EntityConnectionStringBuilder connection, Avisos av) { var context = new samEntities(connection.ToString()); context.DELETE_avisos_MDL(av.QMNUM, av.IWERK); }