public int desvincularConn(List <string[]> listaDiferentesInstancias, string[] uuid)
{
PEntidades.SrvSAPUProv.ZEDATA_UUID[] objetoUui = PEntidades.Utiles.objetoUuid(uuid);
PEntidades.SrvSAPUProv.Z_UFAC_CARGADAS cargadas = new PEntidades.SrvSAPUProv.Z_UFAC_CARGADAS();
//PEntidades.SrvSAPUProv.Z_UFAC_CARGADASResponse result;
int res = 0;
PEntidades.SrvSAPUProv.ZWS_UPROVEEDORESClient srv = new PPersistencia.WebServices().getZWS_UPROVEEDORESInstanceNew(
listaDiferentesInstancias[0][1].ToString().Trim(),
listaDiferentesInstancias[0][4].Split(new Char[] { ',' })
);
PPersistencia.SAPConn psc = new PPersistencia.SAPConn(); //cambio del llamado hacia SAP
List <ParamsCallSAP> listPA = new List <ParamsCallSAP>();
ParamsCallSAP pr = new ParamsCallSAP();
pr = new ParamsCallSAP(); //cargadas.BELNR = "";
pr.NameVar = "BELNR";
pr.ValVar = "";
pr.TipVar = "S";
listPA.Add(pr);
pr = new ParamsCallSAP(); //cargadas.BUKRS = "";
pr.NameVar = "BUKRS";
pr.ValVar = "";
pr.TipVar = "S";
listPA.Add(pr);
pr = new ParamsCallSAP(); //cargadas.BWTAR = "";
pr.NameVar = "BWTAR";
pr.ValVar = "";
pr.TipVar = "S";
listPA.Add(pr);
pr = new ParamsCallSAP(); //cargadas.CORREO = "";
pr.NameVar = "CORREO";
pr.ValVar = "";
pr.TipVar = "S";
listPA.Add(pr);
pr = new ParamsCallSAP(); //cargadas.DESADJUNTAR = "X";
pr.NameVar = "DESADJUNTAR";
pr.ValVar = "X";
pr.TipVar = "S";
listPA.Add(pr);
pr = new ParamsCallSAP(); // cargadas.EBELN = "";
pr.NameVar = "EBELN";
pr.ValVar = "";
pr.TipVar = "S";
listPA.Add(pr);
pr = new ParamsCallSAP(); // cargadas.EBELP = "";
pr.NameVar = "EBELP";
pr.ValVar = "";
pr.TipVar = "S";
listPA.Add(pr);
pr = new ParamsCallSAP(); // cargadas.FECHA_XML = "";
pr.NameVar = "FECHA_XML";
pr.ValVar = "";
pr.TipVar = "S";
listPA.Add(pr);
pr = new ParamsCallSAP(); //cargadas.IMP_RETEN = 0;
pr.NameVar = "IMP_RETEN";
pr.ValVard = 0;
pr.TipVar = "D";
listPA.Add(pr);
pr = new ParamsCallSAP(); //cargadas.KSCHL = "";
pr.NameVar = "KSCHL";
pr.ValVar = "";
pr.TipVar = "S";
listPA.Add(pr);
pr = new ParamsCallSAP(); //cargadas.LIFNR = "";
pr.NameVar = "LIFNR";
pr.ValVar = "";
pr.TipVar = "S";
listPA.Add(pr);
pr = new ParamsCallSAP(); //cargadas.MSJ_SAP = "";
pr.NameVar = "MSJ_SAP";
pr.ValVar = "";
pr.TipVar = "S";
listPA.Add(pr);
pr = new ParamsCallSAP(); //cargadas.MSJ_SAT = "";
pr.NameVar = "MSJ_SAT";
pr.ValVar = "";
pr.TipVar = "S";
listPA.Add(pr);
pr = new ParamsCallSAP(); //cargadas.PDFFILE = "";
pr.NameVar = "PDFFILE";
pr.ValVar = "";
pr.TipVar = "S";
listPA.Add(pr);
pr = new ParamsCallSAP(); //cargadas.RAW = null;
pr.NameVar = "RAW";
pr.ValVarb = null;
pr.TipVar = "Y";
listPA.Add(pr);
pr = new ParamsCallSAP(); //cargadas.RAWPDF = null;
pr.NameVar = "RAWPDF";
pr.ValVarb = null;
pr.TipVar = "Y";
listPA.Add(pr);
pr = new ParamsCallSAP(); //cargadas.STATUS = "";
pr.NameVar = "STATUS";
pr.ValVar = "";
pr.TipVar = "S";
listPA.Add(pr);
pr = new ParamsCallSAP(); //cargadas.TIPO = "";
pr.NameVar = "TIPO";
pr.ValVar = "";
pr.TipVar = "S";
listPA.Add(pr);
pr = new ParamsCallSAP(); //cargadas.TIPOARCHIVO = "";
pr.NameVar = "TIPOARCHIVO";
pr.ValVar = "";
pr.TipVar = "S";
listPA.Add(pr);
pr = new ParamsCallSAP(); //cargadas.WERKS = "";
pr.NameVar = "WERKS";
pr.ValVar = "";
pr.TipVar = "S";
listPA.Add(pr);
pr = new ParamsCallSAP(); //cargadas.XBLNR = "";
pr.NameVar = "XBLNR";
pr.ValVar = "";
pr.TipVar = "S";
listPA.Add(pr);
pr = new ParamsCallSAP(); //cargadas.XMLFILE = "";
pr.NameVar = "XMLFILE";
pr.ValVar = "";
pr.TipVar = "S";
listPA.Add(pr);
pr = new ParamsCallSAP(); //cargadas.ZCFDI_UUID = "";
pr.NameVar = "ZCFDI_UUID";
pr.ValVar = "";
pr.TipVar = "S";
listPA.Add(pr);
List <TablasCallSAP> listT = new List <TablasCallSAP>();
TablasCallSAP tr = new TablasCallSAP();
List <ParamsCallSAP> listTb = new List <ParamsCallSAP>();
int cont = 0;
foreach (string uui in uuid)
{
pr = new ParamsCallSAP();
pr.NameVar = "UUID_XML";
pr.ValVar = uui;
pr.TipVar = "S";
listTb.Add(pr);
cont++;
}
tr.TablaVar = "PROVEEDOR_TB";
tr.CamposVar = listTb;
listT.Add(tr);
srv.Open();
srv.InnerChannel.OperationTimeout = new TimeSpan(0, 10, 0);
string msg;
msg = psc.conSAP2("Z_DFAC_CARGADAS", listPA, listT); //result = srv.Z_UFAC_CARGADAS(cargadas);
srv.Close();
if (msg != "" && msg != null)
{
res = int.Parse(msg.Trim());
}
return(res);
}
public int setFV60cargadasNew(string bukrs, string gjahr, string belnr, string uuid_cfdi, string rfc_emisor,
string rfc_receptor, decimal wrbtr, string waers, decimal kursf, string bldat, byte[] rawxml, byte[] rawpdf, string fileName)
{
int res = 0;
PPersistencia.SAPConn psc = new PPersistencia.SAPConn();
List <ParamsCallSAP> list = new List <ParamsCallSAP>();
ParamsCallSAP pr = new ParamsCallSAP();
pr = new ParamsCallSAP();
pr.NameVar = "BUKRS";
pr.ValVar = bukrs;
pr.TipVar = "S";
list.Add(pr);
pr = new ParamsCallSAP();
pr.NameVar = "GJAHR";
pr.ValVar = gjahr;
pr.TipVar = "S";
list.Add(pr);
pr = new ParamsCallSAP();
pr.NameVar = "BELNR";
pr.ValVar = belnr;
pr.TipVar = "S";
list.Add(pr);
pr = new ParamsCallSAP();
pr.NameVar = "UUID_CFDI";
pr.ValVar = uuid_cfdi;
pr.TipVar = "S";
list.Add(pr);
pr = new ParamsCallSAP();
pr.NameVar = "RFC_EMISOR";
pr.ValVar = rfc_emisor;
pr.TipVar = "S";
list.Add(pr);
pr = new ParamsCallSAP();
pr.NameVar = "RFC_RECEPTOR";
pr.ValVar = rfc_receptor;
pr.TipVar = "S";
list.Add(pr);
pr = new ParamsCallSAP();
pr.NameVar = "WRBTR";
pr.ValVar = wrbtr.ToString();
pr.TipVar = "S";
list.Add(pr);
pr = new ParamsCallSAP();
pr.NameVar = "WAERS";
pr.ValVar = waers;
pr.TipVar = "S";
list.Add(pr);
pr = new ParamsCallSAP();
pr.NameVar = "KURSF";
pr.ValVar = kursf.ToString();
pr.TipVar = "S";
list.Add(pr);
pr = new ParamsCallSAP();
pr.NameVar = "BLDAT";
pr.ValVar = bldat;
pr.TipVar = "S";
list.Add(pr);
pr = new ParamsCallSAP();
pr.NameVar = "FILE_NAME";
pr.ValVar = fileName;
pr.TipVar = "S";
list.Add(pr);
pr = new ParamsCallSAP();
pr.NameVar = "RAWPDF";
pr.ValVarb = rawpdf;
pr.TipVar = "Y";
list.Add(pr);
pr = new ParamsCallSAP();
pr.NameVar = "RAWXML";
pr.ValVarb = rawxml;
pr.TipVar = "Y";
list.Add(pr);
List <TablasCallSAP> listT = new List <TablasCallSAP>(); // no lleva Tablas, solo para el llamado
TablasCallSAP tr = new TablasCallSAP();
List <ParamsCallSAP> listTb = new List <ParamsCallSAP>();
string rescon = psc.conSAP2("Z_DFAC_CARGA_FV60", list, listT);
if (rescon != "" && rescon != null)
{
try
{
res = int.Parse(rescon.Trim());
}
catch (Exception)
{
msg = rescon.Trim();
}
}
return(res);
}
public int setFacturascargadasNewConn(string bukrs, string correo, string ebeln, string lifnr, string msjsap, string msgsat, string estatus, string tipo,
string werks, string xblnr, string fecha_xml, string xmlfile, string endpoint, string[] userPass, byte[] raw, string uuid, decimal total,
string numeroItem, string BELNR, string BWTAR, string KSCHL, string tipoarchivo, byte[] rawpdf, string pdffile, decimal retencion)
{
//PEntidades.SrvSAPUProv.Z_UFAC_CARGADASResponse result;
PEntidades.SrvSAPUProv.Z_UFAC_CARGADAS cargadas = new PEntidades.SrvSAPUProv.Z_UFAC_CARGADAS();
int res = 0;
//PEntidades.SrvSAPUProv.ZWS_UPROVEEDORESClient srv = new PPersistencia.WebServices().getZWS_UPROVEEDORESInstanceNew(endpoint, userPass);
PPersistencia.SAPConn psc = new PPersistencia.SAPConn(); //cambio del llamado hacia SAP
List <ParamsCallSAP> listPA = new List <ParamsCallSAP>();
ParamsCallSAP pr = new ParamsCallSAP();
pr = new ParamsCallSAP(); //cargadas.BELNR = BELNR;
pr.NameVar = "BELNR";
pr.ValVar = BELNR;
pr.TipVar = "S";
listPA.Add(pr);
pr = new ParamsCallSAP(); //cargadas.BUKRS = bukrs;
pr.NameVar = "BUKRS";
pr.ValVar = bukrs;
pr.TipVar = "S";
listPA.Add(pr);
pr = new ParamsCallSAP(); //cargadas.BWTAR = BWTAR;
pr.NameVar = "BWTAR";
pr.ValVar = BWTAR;
pr.TipVar = "S";
listPA.Add(pr);
pr = new ParamsCallSAP(); //cargadas.CORREO = correo;
pr.NameVar = "CORREO";
pr.ValVar = correo;
pr.TipVar = "S";
listPA.Add(pr);
pr = new ParamsCallSAP(); //cargadas.DESADJUNTAR = "";
pr.NameVar = "DESADJUNTAR";
pr.ValVar = "";
pr.TipVar = "S";
listPA.Add(pr);
pr = new ParamsCallSAP(); //cargadas.EBELN = ebeln;
pr.NameVar = "EBELN";
pr.ValVar = ebeln;
pr.TipVar = "S";
listPA.Add(pr);
pr = new ParamsCallSAP(); //cargadas.EBELP = numeroItem;
pr.NameVar = "EBELP";
pr.ValVar = numeroItem;
pr.TipVar = "S";
listPA.Add(pr);
pr = new ParamsCallSAP(); //cargadas.FECHA_XML = fecha_xml;
pr.NameVar = "FECHA_XML";
pr.ValVar = fecha_xml;
pr.TipVar = "S";
listPA.Add(pr);
pr = new ParamsCallSAP(); //cargadas.IMP_RETEN = retencion;
pr.NameVar = "IMP_RETEN";
pr.ValVard = retencion;
pr.TipVar = "D";
listPA.Add(pr);
pr = new ParamsCallSAP(); //cargadas.KSCHL = KSCHL;
pr.NameVar = "KSCHL";
pr.ValVar = KSCHL;
pr.TipVar = "S";
listPA.Add(pr);
pr = new ParamsCallSAP(); //cargadas.LIFNR = lifnr;
pr.NameVar = "LIFNR";
pr.ValVar = lifnr;
pr.TipVar = "S";
listPA.Add(pr);
pr = new ParamsCallSAP(); //cargadas.MSJ_SAP = msjsap;
pr.NameVar = "MSJ_SAP";
pr.ValVar = msjsap;
pr.TipVar = "S";
listPA.Add(pr);
pr = new ParamsCallSAP(); //cargadas.MSJ_SAT = msgsat;
pr.NameVar = "MSJ_SAT";
pr.ValVar = msgsat;
pr.TipVar = "S";
listPA.Add(pr);
pr = new ParamsCallSAP(); //cargadas.PDFFILE = pdffile;
pr.NameVar = "PDFFILE";
pr.ValVar = pdffile;
pr.TipVar = "S";
listPA.Add(pr);
pr = new ParamsCallSAP(); //cargadas.RAW = raw;
pr.NameVar = "RAW";
pr.ValVarb = raw;
pr.TipVar = "Y";
listPA.Add(pr);
pr = new ParamsCallSAP(); //cargadas.RAWPDF = rawpdf;
pr.NameVar = "RAWPDF";
pr.ValVarb = rawpdf;
pr.TipVar = "Y";
listPA.Add(pr);
pr = new ParamsCallSAP(); //cargadas.STATUS = estatus;
pr.NameVar = "STATUS";
pr.ValVar = estatus;
pr.TipVar = "S";
listPA.Add(pr);
pr = new ParamsCallSAP(); //cargadas.TIPO = tipo;
pr.NameVar = "TIPO";
pr.ValVar = tipo;
pr.TipVar = "S";
listPA.Add(pr);
pr = new ParamsCallSAP(); //cargadas.TIPOARCHIVO = tipoarchivo;
pr.NameVar = "TIPOARCHIVO";
pr.ValVar = tipoarchivo;
pr.TipVar = "S";
listPA.Add(pr);
pr = new ParamsCallSAP(); //cargadas.UUID_XML = null;
pr.NameVar = "UUID_XML";
pr.ValVar = null;
pr.TipVar = "S";
listPA.Add(pr);
pr = new ParamsCallSAP(); //cargadas.WERKS = werks;
pr.NameVar = "WERKS";
pr.ValVar = werks;
pr.TipVar = "S";
listPA.Add(pr);
pr = new ParamsCallSAP(); //cargadas.XBLNR = xblnr;
pr.NameVar = "XBLNR";
pr.ValVar = xblnr;
pr.TipVar = "S";
listPA.Add(pr);
pr = new ParamsCallSAP(); //cargadas.XMLFILE = xmlfile;
pr.NameVar = "XMLFILE";
pr.ValVar = xmlfile;
pr.TipVar = "S";
listPA.Add(pr);
pr = new ParamsCallSAP(); //cargadas.ZCFDI_UUID = uuid;
pr.NameVar = "ZCFDI_UUID";
pr.ValVar = uuid;
pr.TipVar = "S";
listPA.Add(pr);
List <TablasCallSAP> listT = new List <TablasCallSAP>(); // no lleva tablas, solo para la llamada
TablasCallSAP tr = new TablasCallSAP();
List <ParamsCallSAP> listTb = new List <ParamsCallSAP>();
string msg;
msg = psc.conSAP2("Z_DFAC_CARGADAS", listPA, listT); //result = srv.Z_UFAC_CARGADAS(cargadas);
if (msg != "" && msg != null)
{
try
{
res = int.Parse(msg.Trim());
}
catch (Exception)
{
res = 1;
}
}
return(res);
}
public int desvincularFV60(string uuid_cfdi, string bukrs, string gjahr, string belnr)
{
int res = 0;
PPersistencia.SAPConn psc = new PPersistencia.SAPConn();
List <ParamsCallSAP> list = new List <ParamsCallSAP>();
ParamsCallSAP pr = new ParamsCallSAP();
pr = new ParamsCallSAP();
pr.NameVar = "P_BELNR";
pr.ValVar = belnr;
pr.TipVar = "S";
list.Add(pr);
pr = new ParamsCallSAP();
pr.NameVar = "P_GJAHR";
pr.ValVar = gjahr;
pr.TipVar = "S";
list.Add(pr);
pr = new ParamsCallSAP();
pr.NameVar = "P_BUKRS";
pr.ValVar = bukrs;
pr.TipVar = "S";
list.Add(pr);
pr = new ParamsCallSAP();
pr.NameVar = "P_UUID";
pr.ValVar = uuid_cfdi;
pr.TipVar = "S";
list.Add(pr);
List <TablasCallSAP> listT = new List <TablasCallSAP>(); // no lleva Tablas, solo para el llamado
TablasCallSAP tr = new TablasCallSAP();
List <ParamsCallSAP> listTb = new List <ParamsCallSAP>();
string rescon = psc.conSAP2("Z_UFAC_FV60_DESADJUNTAR", list, listT);
if (rescon != "" && rescon != null)
{
try
{
int Start, End; //buscar # de archivos desadjuntados
string xCuantos;
if (rescon.Contains("P_RETURN=") && rescon.Contains(", IMPORT"))
{
Start = rescon.IndexOf("P_RETURN=", 0) + "P_RETURN=".Length;
End = rescon.IndexOf(", IMPORT", Start);
xCuantos = rescon.Substring(Start, End - Start);
res = int.Parse(xCuantos.Trim());
return(res);
}
else
{
return(0);
}
}
catch (Exception)
{
msg = rescon.Trim();
}
}
return(res);
}