public IRfcTable tablaEscalas(string knumh)
{
if (conectar())
{
RfcRepository repo = oDestino.Repository;
IRfcFunction bapi = repo.CreateFunction("ZFWF_AP_043");//Módulo de función
bapi.SetValue("KNUMH", knumh);
//bapi.SetValue("USUARIO", usuario);
bapi.Invoke(oDestino);
IRfcTable tabla = bapi.GetTable("KONM");
for (int i = 0; i < tabla.Count; i++)
{
tabla.CurrentIndex = i;
}
return(tabla);
}
else
{
return(null);
}
}
public InvoiceValueModel GetInvoiceValue(RfcDestination rfcDest)
{
InvoiceValueModel invoiceValueModel = new InvoiceValueModel();
RfcDestination SAPRfcDestination = RfcDestinationManager.GetDestination("accelyides");
RfcRepository rfcrep = SAPRfcDestination.Repository;
IRfcFunction BapiGetCompanyDetail = null;
BapiGetCompanyDetail = rfcrep.CreateFunction("BAPI_INCOMINGINVOICE_GETDETAIL");
BapiGetCompanyDetail.SetValue("INVOICEDOCNUMBER", "1000000020");
BapiGetCompanyDetail.SetValue("FISCALYEAR", "2013");
BapiGetCompanyDetail.Invoke(rfcDest);
IRfcTable tblReturn = BapiGetCompanyDetail.GetTable("ITEMDATA");
DataTable TBL = tblReturn.ToDataTable("TBL");
for (int i = 0; i < TBL.Rows.Count; i++)
{
InvoiceValueModel invoiceValueModel1 = new InvoiceValueModel();
invoiceValueModel1.REF_DOC = TBL.Rows[i]["REF_DOC"].ToString();
// invoiceValueModel.lstInvoiceValue.Add(invoiceValueModel1);
}
IRfcStructure IRS_OS_HEADER = BapiGetCompanyDetail.GetStructure("HEADERDATA");
invoiceValueModel.Value = IRS_OS_HEADER.GetValue("USERNAME").ToString();
//Console.WriteLine(invoiceValueModel.Value);
//Console.ReadKey();
RfcSessionManager.EndContext(rfcDest);
return(invoiceValueModel);
}
// Kiểm tra dữ liệu phát sinh
public static string Prc_check_data_ps(string p_short_name, DataRow p_dr, RfcDestination p_sap)
{
string v_error_code = "";
// Need a repository for the metadata from the ABAP Dictionary
// of the corresponding destination system.
RfcRepository v_repo = p_sap.Repository;
IRfcFunction v_babi = v_repo.CreateFunction("ZFM_PSCD_MAPPING_TK_DC");
IRfcStructure v_struc = v_babi.GetStructure("I_SOURCE");
v_struc.SetValue("ROW_NUM", p_dr["STT"].ToString());
v_struc.SetValue("DOC_TYPE", p_dr["LOAI"].ToString());
v_struc.SetValue("TAX_OFFICE_CODE", p_dr["MA_CQT"].ToString());
v_struc.SetValue("TIN", p_dr["TIN"].ToString());
v_struc.SetValue("PROFIT_CENTER", p_dr["MA_CHUONG"].ToString());
v_struc.SetValue("BUSINESS_AREA", p_dr["MA_KHOAN"].ToString());
v_struc.SetValue("SEGMENT", p_dr["MA_TMUC"].ToString());
v_struc.SetValue("PAY_GROUP", p_dr["TKHOAN"].ToString());
v_struc.SetValue("POSTING_DATE", p_dr["NGAY_HTOAN"].ToString());
v_struc.SetValue("START_PERIOD", p_dr["KY_PSINH_TU"].ToString());
v_struc.SetValue("END_PERIOD", p_dr["KY_PSINH_DEN"].ToString());
v_struc.SetValue("DUE_DATE", p_dr["HAN_NOP"].ToString());
v_struc.SetValue("RETURN_CODE", p_dr["MA_TKHAI"].ToString());
v_struc.SetValue("AMOUNT", p_dr["SO_TIEN"].ToString());
v_babi.Invoke(p_sap);
v_error_code = v_babi.GetString("E_ERROR_CODE");
return(v_error_code);
}
public IRfcTable ListaPLTYP() //Trae TODAS las listas de precios
{
if (conectar())
{
RfcRepository repo = oDestino.Repository;
IRfcFunction bapi = repo.CreateFunction("ZFWF_AP_007");//Módulo de función
//bapi.SetValue("SPRAS", ");
//bapi.SetValue("PERNR", pr);
//bapi.SetValue("SPART", sp);
//bapi.SetValue("ZTIWF", "005");
bapi.Invoke(oDestino);
//IRfcTable tabla = bapi.GetTable("IT_KNVP");
string cadena = "";
IRfcTable tabla = bapi.GetTable("IT_T189T");
return(tabla);
}
else
{
return(null);
}
}
public responce_ZMOV_10000 sapRun(request_ZMOV_10000 import)
{
RfcDestination configSap = RfcDestinationManager.GetDestination("SCLEM");
RfcRepository SapRfcRepository = configSap.Repository;
IRfcFunction rfcFunction = SapRfcRepository.CreateFunction("ZMOV_10000");
rfcFunction.SetValue("CHARG", import.CHARG);
rfcFunction.SetValue("MATNR", import.MATNR);
rfcFunction.Invoke(configSap);
string aa = rfcFunction.ToString();
responce_ZMOV_10000 res = new responce_ZMOV_10000();
IRfcTable rfcTable_CHAR_OF_BATCH = rfcFunction.GetTable("CHAR_OF_BATCH");
res.CHAR_OF_BATCH = new ZMOV_10000_CHAR_OF_BATCH[rfcTable_CHAR_OF_BATCH.RowCount];
int i_CHAR_OF_BATCH = 0;
foreach (IRfcStructure row in rfcTable_CHAR_OF_BATCH)
{
ZMOV_10000_CHAR_OF_BATCH datoTabla = new ZMOV_10000_CHAR_OF_BATCH();
datoTabla.ATNAM = row.GetString("ATNAM");
datoTabla.ATWTB = row.GetString("ATWTB");
datoTabla.XDELETE = row.GetString("XDELETE");
datoTabla.CHAR_NOT_VALID = row.GetString("CHAR_NOT_VALID");
datoTabla.ATINN = row.GetInt("ATINN");
datoTabla.ATWTB_LONG = row.GetString("ATWTB_LONG");
res.CHAR_OF_BATCH[i_CHAR_OF_BATCH] = datoTabla; ++i_CHAR_OF_BATCH;
}
return(res);
}
public IRfcTable AutoCHARG(string ma, string ch) //Trae la lista de clientes para autocompletar
{
if (conectar())
{
RfcRepository repo = oDestino.Repository;
IRfcFunction bapi = repo.CreateFunction("ZFWF_AP_046");//Módulo de función
bapi.SetValue("MATNR", ma);
bapi.SetValue("CHARG", ch);
bapi.Invoke(oDestino);
IRfcTable tabla = bapi.GetTable("it_MCHB");
for (int i = 0; i < tabla.Count; i++)
{
tabla.CurrentIndex = i;
}
return(tabla);
}
else
{
return(null);
}
}
public IRfcTable getClienteP(string vk, string vt, string sp, string ku, string em, string tp) //Trae el cliente consultado
{
if (conectar())
{
RfcRepository repo = oDestino.Repository;
IRfcFunction bapi = repo.CreateFunction("ZFWF_AP_005");//Módulo de función
bapi.SetValue("VKORG", vk);
bapi.SetValue("VTWEG", vt);
bapi.SetValue("SPART", sp);
bapi.SetValue("KUNNR", ku);
//if (!tp.Equals("A"))
if (tp.Trim().Equals("V") | tp.Trim().Equals("C")) //ADD RSG 23.06.2017
{
bapi.SetValue("PERNR", em);
}
bapi.Invoke(oDestino);
IRfcTable tabla = bapi.GetTable("IT_KNVP");
for (int i = 0; i < tabla.Count; i++)
{
tabla.CurrentIndex = i;
}
return(tabla);
}
else
{
return(null);
}
}
public IRfcTable AutoKUNNR(string vk, string vt, string sp, string ku, string em) //Trae la lista de clientes para autocompletar
{
if (conectar())
{
RfcRepository repo = oDestino.Repository;
IRfcFunction bapi = repo.CreateFunction("ZFWF_AP_003");//Módulo de función
bapi.SetValue("VKORG", vk);
bapi.SetValue("VTWEG", vt);
bapi.SetValue("SPART", sp);
bapi.SetValue("KUNNR", ku);
bapi.SetValue("PERNR", em);
bapi.Invoke(oDestino);
IRfcTable tabla = bapi.GetTable("IT_KNAVV");
for (int i = 0; i < tabla.Count; i++)
{
tabla.CurrentIndex = i;
}
return(tabla);
}
else
{
return(null);
}
}
public IRfcTable AutoMATKL(string mk, string sp) //Trae la lista de clientes para autocompletar
{
if (conectar())
{
RfcRepository repo = oDestino.Repository;
IRfcFunction bapi = repo.CreateFunction("ZFWF_AP_014");//Módulo de función
bapi.SetValue("MATKL", mk);
if (!sp.Equals(""))
{
bapi.SetValue("SPART", sp);
}
bapi.Invoke(oDestino);
IRfcTable tabla = bapi.GetTable("IT_T023T");
for (int i = 0; i < tabla.Count; i++)
{
tabla.CurrentIndex = i;
}
return(tabla);
}
else
{
return(null);
}
}
public List <string> monedas() //Trae cadena de mail y teléfono
{
if (conectar())
{
RfcRepository repo = oDestino.Repository;
IRfcFunction bapi = repo.CreateFunction("ZFWF_AP_021");//Módulo de función
bapi.Invoke(oDestino);
IRfcTable tcurr = bapi.GetTable("IT_TCURC");
List <string> m = new List <string>();
for (int i = 0; i < tcurr.Count; i++)
{
tcurr.CurrentIndex = i;
m.Add(tcurr.GetString("WAERS"));
}
return(m);
}
else
{
return(null);
}
}
public List <meins> meinss() //Trae cadena de mail y teléfono
{
if (conectar())
{
RfcRepository repo = oDestino.Repository;
IRfcFunction bapi = repo.CreateFunction("ZFWF_AP_045");//Módulo de función
bapi.Invoke(oDestino);
IRfcTable tcurr = bapi.GetTable("IT_T006A");
List <meins> mm = new List <meins>();
for (int i = 0; i < tcurr.Count; i++)
{
tcurr.CurrentIndex = i;
meins m = new meins();
m.MSEHI = tcurr.GetString("MSEHI");
//m.MSEHI = tcurr.GetString("MSEH3");
m.MSEH3 = tcurr.GetString("MSEH3");
m.desc = tcurr.GetString("MSEHL");
mm.Add(m);
}
//List<string> ms = new List<string>();
//foreach(meins m in mm)
//{
// ms.Add("<option value='"+m.MSEHI+"'>"+ m.MSEH3+ " - " + "</option>");
//}
return(mm);
}
else
{
return(null);
}
}
public IRfcTable consultaLPDetail(string vk, string vt, string sp, string ku, string ma, string mk, string pl, string ta)//Trae detalle KONH por lista de precio
{
if (conectar())
{
RfcRepository repo = oDestino.Repository;
IRfcFunction bapi = repo.CreateFunction("ZFWF_AP_011");//Módulo de función
bapi.SetValue("VKORG", vk);
bapi.SetValue("VTWEG", vt);
bapi.SetValue("SPART", sp);
bapi.SetValue("KUNNR", ku);
bapi.SetValue("MATNR", ma);
bapi.SetValue("MATKL", mk);
bapi.SetValue("PLTYP", pl);
bapi.SetValue("TABLA", ta);
bapi.Invoke(oDestino);
IRfcTable tabla = bapi.GetTable("IT_LP");
return(tabla);
}
else
{
return(null);
}
}
public IRfcTable consultaLODetail(string sp, string ma, string ta, bool ch)//Trae detalle KONH por lista de precio
{
if (conectar())
{
RfcRepository repo = oDestino.Repository;
IRfcFunction bapi = repo.CreateFunction("ZFWF_AP_024");//Módulo de función
bapi.SetValue("SPART", sp);
bapi.SetValue("MATNR", ma);
bapi.SetValue("TABLA", ta);
if (ch)
{
bapi.SetValue("DEGRADADO", "X");
}
bapi.Invoke(oDestino);
IRfcTable tabla = bapi.GetTable("IT_LP");
return(tabla);
}
else
{
return(null);
}
}
public void tableLList(string plant)
{
connect();
RfcDestination rfcDest = RfcDestinationManager.GetDestination(parms);
RfcRepository rfcRep = rfcDest.Repository;
IRfcFunction IReader = rfcRep.CreateFunction("ZSSCN_DYNAMIC_SELECT");
IReader.SetValue("IV_SELECT", "COD_ITEM DESCRICAO");
IReader.SetValue("IV_FROM", "/SSCN/LLIST");
IReader.SetValue("IV_WHERE", "NOME_LISTA = 'CENTRO_TRAB' AND CENTRO = '" + plant + "' AND EXTRA_FLD3 = 'X' AND IDIOMA = 'EN'");
IReader.SetValue("IV_ORDER", "COD_ITEM DESCRICAO");
IReader.Invoke(rfcDest);
string optionData = (string)IReader.GetValue("EV_RESULT_SET");
Directory.CreateDirectory("Relatorio");
filePathTxt = filePathTxt + @"\pathLList.txt";
System.IO.File.WriteAllText(filePathTxt, optionData);
List <IndividualCapacity_SapTable> jsonList = JsonConvert.DeserializeObject <List <IndividualCapacity_SapTable> >(optionData);
if (jsonList.Count() > 0)
{
//file
CreateExcel1 = new IndividualCapacity_LListExcel();
CreateExcel1.CreateWorkbook(filePathXlsx = filePathXlsx + @"\DadosLList.xlsx");
//Adicionar Celulas
jsonList
.Select((mandante, x) => new { mandante, position = x })
.ToList()
.ForEach(item => CreateExcel1.AddCell(item.position, item.mandante));
//Salvando dados no excel
CreateExcel1.Save();
}
}
public void tablePlants()
{
connect();
RfcDestination rfcDest = RfcDestinationManager.GetDestination(parms);
RfcRepository rfcRep = rfcDest.Repository;
IRfcFunction IReader = rfcRep.CreateFunction("ZSSCN_DYNAMIC_SELECT");
IReader.SetValue("IV_SELECT", "USERID PLANT");
IReader.SetValue("IV_FROM", "/SSCN/PLANT");
IReader.SetValue("IV_WHERE", "USERID = 'SIGGA127'");
IReader.Invoke(rfcDest);
string optionData = (string)IReader.GetValue("EV_RESULT_SET");
Directory.CreateDirectory("Relatorio");
filePathTxt = filePathTxt + @"\pathPlant.txt";
System.IO.File.WriteAllText(filePathTxt, optionData);
List <IndividualCapacity_SapTable> jsonList = JsonConvert.DeserializeObject <List <IndividualCapacity_SapTable> >(optionData);
if (jsonList.Count() > 0)
{
//file
CreateExcel = new IndividualCapacity_PlantExcel();
CreateExcel.CreateWorkbook(filePathXlsx = filePathXlsx + @"\DadosPlant.xlsx");
//Adicionar Celulas
jsonList
.Select((mandante, x) => new { mandante, position = x })
.ToList()
.ForEach(item => CreateExcel.AddCell(item.position, item.mandante));
//Salvando dados no excel
CreateExcel.Save();
}
}
public void tableLPer_Wkc(string plant, string workcenter)
{
connect();
RfcDestination rfcDest = RfcDestinationManager.GetDestination(parms);
RfcRepository rfcRep = rfcDest.Repository;
IRfcFunction IReader = rfcRep.CreateFunction("ZSSCN_DYNAMIC_SELECT");
IReader.SetValue("IV_SELECT", "A~PERNR A~ENAME");
IReader.SetValue("IV_FROM", "/SSCN/LPERSON AS A INNER JOIN /SSCN/LPER_WKC AS B ON ( A~PERNR = B~PERNR )");
IReader.SetValue("IV_WHERE", "B~WERKS = '" + plant + "' AND B~ARBPL = '" + workcenter + "'");
IReader.Invoke(rfcDest);
string optionData = (string)IReader.GetValue("EV_RESULT_SET");
Directory.CreateDirectory("Relatorio");
filePathTxt = filePathTxt + @"\pathLPerWkc.txt";
System.IO.File.WriteAllText(filePathTxt, optionData);
List <IndividualCapacity_SapTable> jsonList = JsonConvert.DeserializeObject <List <IndividualCapacity_SapTable> >(optionData);
if (jsonList.Count() > 0)
{
//file
CreateExcel3 = new IndividualCapacity_LperWkcExcel();
CreateExcel3.CreateWorkbook(filePathXlsx = filePathXlsx + @"\DadosLPerWkc.xlsx");
//Adicionar Celulas
jsonList
.Select((mandante, x) => new { mandante, position = x })
.ToList()
.ForEach(item => CreateExcel3.AddCell(item.position, item.mandante));
//Salvando dados no excel
CreateExcel3.Save();
}
}
public IRfcTable ListaVKORG(string v, string p) //Trae TODAS las Organizaciones de compra
{
if (conectar())
{
RfcRepository repo = oDestino.Repository;
IRfcFunction bapi = repo.CreateFunction("ZFWF_AP_001");//Módulo de función
if (!v.Equals(""))
{
bapi.SetValue("VKORG", v);
}
if (!p.Equals(""))
{
bapi.SetValue("PERNR", p);
}
bapi.Invoke(oDestino);
IRfcTable tabla = bapi.GetTable("IT_TVKO");
for (int i = 0; i < tabla.Count; i++)
{
tabla.CurrentIndex = i;
}
return(tabla);
}
else
{
return(null);
}
}
public IRfcTable busquedaL(string vk, string vt, string sp, string pr, string p1, string p2, string fs, string fa, string k1, string k2)
{
if (conectar())
{
RfcRepository repo = oDestino.Repository;
IRfcFunction bapi = repo.CreateFunction("ZFWF_AP_030");//Módulo de función
bapi.SetValue("VKORG", vk);
bapi.SetValue("VTWEG", vt);
bapi.SetValue("SPART", sp);
bapi.SetValue("PERNR", pr);
bapi.SetValue("KUNNR1", k1);
bapi.SetValue("KUNNR2", k2);
bapi.SetValue("FECHA_S", fs);
bapi.SetValue("FECHA_A", fa);
bapi.SetValue("PLTYP1", p1);
bapi.SetValue("PLTYP2", p2);
bapi.Invoke(oDestino);
IRfcTable tabla = bapi.GetTable("IT_DATA");
for (int i = 0; i < tabla.Count; i++)
{
tabla.CurrentIndex = i;
}
return(tabla);
}
else
{
return(null);
}
}
public IRfcTable ListaVTWEG(string v, string p, string k) //Trae TODOS los canales de distribución
{
if (conectar())
{
RfcRepository repo = oDestino.Repository;
IRfcFunction bapi = repo.CreateFunction("ZFWF_AP_002");//Módulo de función
if (!v.Equals(""))
{
bapi.SetValue("VTWEG", v);
}
if (!p.Equals(""))
{
bapi.SetValue("PERNR", p);
}
if (!k.Equals(""))
{
bapi.SetValue("VKORG", k);
}
bapi.Invoke(oDestino);
IRfcTable tabla = bapi.GetTable("IT_TVTW");
for (int i = 0; i < tabla.Count; i++)
{
tabla.CurrentIndex = i;
}
return(tabla);
}
else
{
return(null);
}
}
public IRfcTable getBitacora(string tipo, string folio) //Trae el cliente consultado
{
if (conectar())
{
RfcRepository repo = oDestino.Repository;
//IRfcFunction bapi = repo.CreateFunction("ZFWF_WFO_005");//Módulo de función
IRfcFunction bapi = repo.CreateFunction("ZFWF_PFI_011");//Módulo de función
bapi.SetValue("P_ZTIWF", "005");
bapi.SetValue("P_ZKYWF", folio);
bapi.Invoke(oDestino);
IRfcTable tabla = bapi.GetTable("P_BITACORA");
//IRfcTable tabla = bapi.GetTable("P_FLUJOBIT");
for (int i = 0; i < tabla.Count; i++)
{
tabla.CurrentIndex = i;
}
return(tabla);
}
else
{
return(null);
}
}
public IRfcTable AutoMATNR(string ma, string sp) //Trae la lista de materiales para autocompletar
{
if (conectar())
{
RfcRepository repo = oDestino.Repository;
IRfcFunction bapi = repo.CreateFunction("ZFWF_AP_013");//Módulo de función
bapi.SetValue("MATNR", ma);
bapi.SetValue("SPART", sp);
bapi.Invoke(oDestino);
IRfcTable tabla = bapi.GetTable("IT_MAKT");
for (int i = 0; i < tabla.Count; i++)
{
tabla.CurrentIndex = i;
}
return(tabla);
}
else
{
return(null);
}
}
public string estatusSol(string tipo, string folio) //Trae la desc o unidad de material
{
if (conectar())
{
RfcRepository repo = oDestino.Repository;
IRfcFunction bapi = repo.CreateFunction("ZFWF_WFO_004");//Módulo de función
bapi.SetValue("P_ZTIWF", "005");
bapi.SetValue("P_ZKYWF", folio);
bapi.Invoke(oDestino);
string oper = bapi.GetString("P_ZSWAR");
string evto = bapi.GetString("P_ZEVTI");
string cadena = "";
if (oper.Equals("P"))
{
cadena = "Pendiente";
}
else if (oper.Equals("R"))
{
cadena = "Rechazada";
}
else if (oper.Equals("A"))
{
cadena = "Aprobada";
}
return(cadena);
}
else
{
return(null);
}
}
public IRfcTable AutoPLTYP(string pl, string sp, string pr) //Trae la lista de clientes para autocompletar
{
if (conectar())
{
RfcRepository repo = oDestino.Repository;
IRfcFunction bapi = repo.CreateFunction("ZFWF_AP_016");//Módulo de función
bapi.SetValue("PLTYP", pl);
bapi.SetValue("PERNR", pr);
bapi.SetValue("SPART", sp);
bapi.SetValue("ZTIWF", "005");
bapi.SetValue("TIPO", "02");
bapi.SetValue("CONDICION", "X");
bapi.Invoke(oDestino);
IRfcTable tabla = bapi.GetTable("IT_T189T");
for (int i = 0; i < tabla.Count; i++)
{
tabla.CurrentIndex = i;
}
return(tabla);
}
else
{
return(null);
}
}
public IRfcTable tablaCabeceraL(string visto, string pernr)
{
if (conectar())
{
RfcRepository repo = oDestino.Repository;
IRfcFunction bapi = repo.CreateFunction("ZFWF_AP_018");//Módulo de función
bapi.SetValue("VISTO", visto);
//bapi.SetValue("USUARIO", usuario);
bapi.SetValue("PERNR", pernr);
bapi.Invoke(oDestino);
IRfcTable tabla = bapi.GetTable("IT_CABECERA");
for (int i = 0; i < tabla.Count; i++)
{
tabla.CurrentIndex = i;
}
return(tabla);
}
else
{
return(null);
}
}
public IRfcTable getCliente(string vk, string vt, string sp, string ku) //Trae el cliente consultado
{
if (conectar())
{
RfcRepository repo = oDestino.Repository;
IRfcFunction bapi = repo.CreateFunction("ZFWF_AP_005");//Módulo de función
bapi.SetValue("VKORG", vk);
bapi.SetValue("VTWEG", vt);
bapi.SetValue("SPART", sp);
bapi.SetValue("KUNNR", ku);
bapi.Invoke(oDestino);
IRfcTable tabla = bapi.GetTable("IT_KNAVV");
for (int i = 0; i < tabla.Count; i++)
{
tabla.CurrentIndex = i;
}
return(tabla);
}
else
{
return(null);
}
}
public IRfcTable consultaDetalleL(string folio, string pernr)
{
if (conectar())
{
RfcRepository repo = oDestino.Repository;
IRfcFunction bapi = repo.CreateFunction("ZFWF_AP_019");//Módulo de función
bapi.SetValue("FOLIO", folio);
bapi.SetValue("PERNR", pernr);
bapi.Invoke(oDestino);
IRfcTable tabla = bapi.GetTable("IT_DETALLE");
for (int i = 0; i < tabla.Count; i++)
{
tabla.CurrentIndex = i;
}
return(tabla);
}
else
{
return(null);
}
}
public string getLP_Desc(string idioma, string lista) //Trae la descripción lista de precio consultada
{
if (conectar())
{
RfcRepository repo = oDestino.Repository;
IRfcFunction bapi = repo.CreateFunction("ZFWF_AP_007");//Módulo de función
//bapi.SetValue("SPRAS", ");
bapi.SetValue("PLTYP", lista);
bapi.Invoke(oDestino);
//IRfcTable tabla = bapi.GetTable("IT_KNVP");
string cadena = "";
IRfcTable tabla = bapi.GetTable("IT_T189T");
for (int i = 0; i < tabla.Count & i < 1; i++)
{
tabla.CurrentIndex = i;
cadena = tabla.GetString("PLTYP") + " " + tabla.GetString("PTEXT");
}
return(cadena);
}
else
{
return(null);
}
}
public static string RFCxSociedad(string xname, string appsh, string xsapr, string sysn, string xuser, string pasw, string cliente, string sociedad)
{
RfcConfigParameters parms = new RfcConfigParameters();
parms.Add(RfcConfigParameters.Name, xname);
parms.Add(RfcConfigParameters.AppServerHost, appsh);
parms.Add(RfcConfigParameters.SAPRouter, xsapr.ToString().Trim());
parms.Add(RfcConfigParameters.SystemNumber, sysn.ToString().Trim());
parms.Add(RfcConfigParameters.User, xuser.ToString().Trim());
parms.Add(RfcConfigParameters.Password, pasw.ToString().Trim());
parms.Add(RfcConfigParameters.Client, cliente.ToString().Trim());
parms.Add(RfcConfigParameters.Language, "ES");
parms.Add(RfcConfigParameters.PoolSize, "5");
parms.Add(RfcConfigParameters.PeakConnectionsLimit, "10");
parms.Add(RfcConfigParameters.PoolIdleTimeout, "600");
RfcDestination rfcDest = null;
rfcDest = RfcDestinationManager.GetDestination(parms);
RfcRepository repo = rfcDest.Repository; //Crea repositorio para la función
IRfcFunction conexion = repo.CreateFunction("Z_URFC");
conexion.SetValue("SOCIEDAD", sociedad);
conexion.Invoke(rfcDest); //Se ejecuta la consulta
//string xresul = conexion.GetString("RFC");
return(conexion.GetString("RFC"));
}
public Address GetUserAddress(string username)
{
IRfcFunction fun;
try
{
RfcRepository repository = Dest.Repository;
fun = repository.CreateFunction("BAPI_USER_GET_DETAIL");
fun.SetValue("USERNAME", username);
fun.Invoke(Dest);
}
catch (RfcCommunicationException ex)
{
throw new SapCommunicationException("Keine Verbindung zum SAP-Server", ex);
}
IRfcStructure address = fun.GetStructure("ADDRESS");
string street = address.GetString("STREET");
string number = address.GetString("HOUSE_NO");
string postcode = address.GetString("POSTL_COD1");
string city = address.GetString("CITY");
return(new Address(street, number, postcode, city));
}
public IRfcTable tablaEscalasSol(string folio, string pos)
{
if (conectar())
{
RfcRepository repo = oDestino.Repository;
IRfcFunction bapi = repo.CreateFunction("ZFWF_AP_044");//Módulo de función
bapi.SetValue("FOLIO", folio);
bapi.SetValue("POS", pos);
//bapi.SetValue("USUARIO", usuario);
bapi.Invoke(oDestino);
IRfcTable tabla = bapi.GetTable("IT_ESCALAS");
for (int i = 0; i < tabla.Count; i++)
{
tabla.CurrentIndex = i;
}
return(tabla);
}
else
{
return(null);
}
}
public PlainRfcPreparedFunction(string functionName,
PlainRfcStructureMapper structureMapper,
RfcRepository repository,
RfcDestination destination)
: base(functionName)
{
this.repository = repository;
this.destination = destination;
this.structureMapper = structureMapper;
}
private void EnsureConnectionIsOpen()
{
if (!isOpen)
{
try {
this.destination = RfcDestinationManager.GetDestination(destinationName);
this.repository = this.destination.Repository;
this.isOpen = true;
}
catch (Exception ex)
{
throw new SharpRfcCallException("Could not connect to SAP.", ex);
}
}
}
public Boolean CreateConnection()
{
try
{
this.con = new SapConnection();
RfcDestinationManager.RegisterDestinationConfiguration(con);
this.dest = RfcDestinationManager.GetDestination("NSP");
this.repo = dest.Repository;
}
catch (Exception ex)
{
try
{
// Break connection
RfcDestinationManager.UnregisterDestinationConfiguration(con);
}
catch (Exception ex2) { }
throw ex;
}
return true;
}
