36 lines
2.1 KiB
C#
36 lines
2.1 KiB
C#
using Sap.Data.Hana;
|
|
using System;
|
|
|
|
namespace Net.Business.Services.Log
|
|
{
|
|
public class B_Log
|
|
{
|
|
public static string Add(string Origen, byte[] Trama_Origen, byte[] Trama_Respuesta, string Proceso, string Nro_Orden, string DocEntry, string DocNumSAP, string DocEntrySAP)
|
|
{
|
|
string DB = Net.Data.LocalData.LogTable;
|
|
string Code = System.Guid.NewGuid().ToString();
|
|
string Fecha = DateTime.Now.ToString("yyyy-MM-dd");
|
|
HanaConnection hana = new HanaConnection(Net.Data.LocalData.ConnectionString);
|
|
hana.Open();
|
|
HanaCommand hanaCommand = hana.CreateCommand();
|
|
hanaCommand.CommandText = $"INSERT INTO \"ITC_WMS_SAP\".\"{DB}\" (\"CODIGO\", \"ORIGEN\", \"TRAMA_ORIGEN\" , \"TRAMA_RESPUESTA\", \"PROCESO\", \"FECHA\", \"NRO_ORDEN\", \"DOCENTRY\", \"DOCNUMSAP\", \"DOCENTRYSAP\", \"HORA\") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
|
|
hanaCommand.Parameters.Add("CODIGO", HanaDbType.VarChar).Value = Code;
|
|
hanaCommand.Parameters.Add("ORIGEN", HanaDbType.VarChar).Value = Origen;
|
|
hanaCommand.Parameters.Add("TRAMA_ORIGEN", HanaDbType.Blob).Value = Trama_Origen;
|
|
hanaCommand.Parameters.Add("TRAMA_RESPUESTA", HanaDbType.Blob).Value = Trama_Respuesta;
|
|
hanaCommand.Parameters.Add("PROCESO", HanaDbType.VarChar).Value = Proceso;
|
|
hanaCommand.Parameters.Add("FECHA", HanaDbType.Date).Value = Fecha;
|
|
hanaCommand.Parameters.Add("NRO_ORDEN", HanaDbType.VarChar).Value = Nro_Orden;
|
|
hanaCommand.Parameters.Add("DOCENTRY", HanaDbType.VarChar).Value = DocEntry;
|
|
hanaCommand.Parameters.Add("DOCNUMSAP", HanaDbType.VarChar).Value = DocNumSAP;
|
|
hanaCommand.Parameters.Add("DOCENTRYSAP", HanaDbType.VarChar).Value = DocEntrySAP;
|
|
hanaCommand.Parameters.Add("HORA", HanaDbType.VarChar).Value = DateTime.Now.ToString("HH:mm:ss");
|
|
hanaCommand.CommandType = System.Data.CommandType.Text;
|
|
hanaCommand.ExecuteNonQuery();
|
|
hana.Close();
|
|
|
|
return Code;
|
|
}
|
|
}
|
|
}
|