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