public DataTable VentasGCSAPConsultar(DateTime fecha1, DateTime fecha2, string Canal)
{
DataTable dt = new DataTable();
try
{
cnx.Open();
HanaCommand cmd = new HanaCommand("", cnx);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
cmd.CommandText = "SBO_ACSA_PROD.ACSA_VTAS_WEB_VentaGC";
HanaParameter f1 = new HanaParameter();
HanaParameter f2 = new HanaParameter();
HanaParameter pc = new HanaParameter();
// Parametro Fecha 1.
f1 = cmd.CreateParameter();
f1.HanaDbType = HanaDbType.Date;
f1.Direction = ParameterDirection.Input;
f1.Value = fecha1;
cmd.Parameters.Add(f1);
// Parametro Fecha 2.
f2 = cmd.CreateParameter();
f2.HanaDbType = HanaDbType.Date;
f2.Direction = ParameterDirection.Input;
f2.Value = fecha2;;
cmd.Parameters.Add(f2);
// Parametro Canal.
pc = cmd.CreateParameter();
pc.HanaDbType = HanaDbType.VarChar;
pc.Direction = ParameterDirection.Input;
pc.Value = Canal;
cmd.Parameters.Add(pc);
cmd.ExecuteNonQuery();
HanaDataAdapter ada = new HanaDataAdapter(cmd);
ada.Fill(dt);
return(dt);
}
catch (SqlException)
{
throw new Exception();
}
finally
{
if (cnx.State == ConnectionState.Open)
{
cnx.Close();
}
cmd.Parameters.Clear();
}
}
public DataTable VentaClienteDT(DateTime fechaInicial, DateTime fechaFinal)
{
DataTable dt = new DataTable();
try
{
cnx.Open();
HanaCommand cmd = new HanaCommand("", cnx);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
cmd.CommandText = "SBO_ACSA_PROD.ACSA_VEN_RPT_VENTACLIENTES";
HanaParameter f1 = new HanaParameter();
HanaParameter f2 = new HanaParameter();
// Parametro Fecha 1.
f1 = cmd.CreateParameter();
f1.HanaDbType = HanaDbType.Date;
f1.Direction = ParameterDirection.Input;
f1.Value = fechaInicial;
cmd.Parameters.Add(f1);
// Parametro Fecha 2.
f2 = cmd.CreateParameter();
f2.HanaDbType = HanaDbType.Date;
f2.Direction = ParameterDirection.Input;
f2.Value = fechaFinal;;
cmd.Parameters.Add(f2);
cmd.ExecuteNonQuery();
HanaDataAdapter ada = new HanaDataAdapter(cmd);
ada.Fill(dt);
return(dt);
}
catch (SqlException)
{
throw new Exception();
}
finally
{
if (cnx.State == ConnectionState.Open)
{
cnx.Close();
}
cmd.Parameters.Clear();
}
}
public DataTable VentasGeneralesDetalladaSAPDT(DateTime FechaInicial, DateTime FechaFinal)
{
DataTable dt = new DataTable();
try
{
cnx.Open();
HanaCommand cmd = new HanaCommand("", cnx);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
cmd.CommandText = "SBO_ACSA_PROD.ACSA_VEN_RPT_VENTAXARTICULO";
HanaParameter fechaInicial = new HanaParameter();
HanaParameter fechaFinal = new HanaParameter();
// Parametro Fecha Inicial.
fechaInicial = cmd.CreateParameter();
fechaInicial.HanaDbType = HanaDbType.Date;
fechaInicial.Direction = ParameterDirection.Input;
fechaInicial.Value = FechaInicial;
cmd.Parameters.Add(fechaInicial);
// Parametro Fecha Final.
fechaFinal = cmd.CreateParameter();
fechaFinal.HanaDbType = HanaDbType.Date;
fechaFinal.Direction = ParameterDirection.Input;
fechaFinal.Value = FechaFinal;
cmd.Parameters.Add(fechaFinal);
cmd.ExecuteNonQuery();
HanaDataAdapter ada = new HanaDataAdapter(cmd);
ada.Fill(dt);
return(dt);
}
catch (SqlException)
{
throw new Exception();
}
finally
{
if (cnx.State == ConnectionState.Open)
{
cnx.Close();
}
cmd.Parameters.Clear();
}
}
public DataSet VentasGeneralesDetalladaSAPDS(string Marca)
{
DataSet dts = new DataSet();
try
{
cnx.Open();
HanaCommand cmd = new HanaCommand("", cnx);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
cmd.CommandText = "SBO_ACSA_PROD.ACSA_VTAS_WEB_LISTAPRECIOSTOCK";
HanaParameter mar = new HanaParameter();
// Parametro Canal.
mar = cmd.CreateParameter();
mar.HanaDbType = HanaDbType.VarChar;
mar.Direction = ParameterDirection.Input;
mar.Value = Marca;
cmd.Parameters.Add(mar);
cmd.ExecuteNonQuery();
HanaDataAdapter ada = new HanaDataAdapter(cmd);
ada.Fill(dts, "ACSA_VTAS_WEB_LISTAPRECIOSTOCK");
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
cmd.Parameters.Clear();
}
//return (dts.Tables["VentasMensualesGCDetalladoxCanal"]);
return(dts);
/*
*
* catch (SqlException)
* {
*
* throw new Exception();
*
* }
* finally
* {
* if (cnx.State == ConnectionState.Open)
* {
* cnx.Close();
* }
* cmd.Parameters.Clear();
* }*/
}
public DataTable VentasGeneralesDetalladaSAPDT(string Marca)
{
DataTable dt = new DataTable();
try
{
cnx.Open();
HanaCommand cmd = new HanaCommand("", cnx);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
cmd.CommandText = "SBO_ACSA_PROD.ACSA_VTAS_WEB_LISTAPRECIOSTOCK";
HanaParameter mar = new HanaParameter();
// Parametro Canal.
mar = cmd.CreateParameter();
mar.HanaDbType = HanaDbType.VarChar;
mar.Direction = ParameterDirection.Input;
mar.Value = Marca;
cmd.Parameters.Add(mar);
cmd.ExecuteNonQuery();
HanaDataAdapter ada = new HanaDataAdapter(cmd);
ada.Fill(dt);
return(dt);
}
catch (SqlException)
{
throw new Exception();
}
finally
{
if (cnx.State == ConnectionState.Open)
{
cnx.Close();
}
cmd.Parameters.Clear();
}
}
public DataTable SapListaPrecioDetalleDT(string Lista)
{
DataTable dt = new DataTable();
try
{
cnx.Open();
HanaCommand cmd = new HanaCommand("", cnx);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
cmd.CommandText = "SBO_ACSA_PROD.ACSA_VTAS_WEB_LISTA_PRECIO_DETALLES";
HanaParameter List = new HanaParameter();
// Parametro Canal.
List = cmd.CreateParameter();
List.HanaDbType = HanaDbType.VarChar;
List.Direction = ParameterDirection.Input;
List.Value = Lista;
cmd.Parameters.Add(List);
cmd.ExecuteNonQuery();
HanaDataAdapter ada = new HanaDataAdapter(cmd);
ada.Fill(dt);
return(dt);
}
catch (SqlException)
{
throw new Exception();
}
finally
{
if (cnx.State == ConnectionState.Open)
{
cnx.Close();
}
cmd.Parameters.Clear();
}
}
public DataTable VentasSTOCKSAPConsultar(String CodigoStock)
{
DataTable dt = new DataTable();
try
{
cnx.Open();
HanaCommand cmd = new HanaCommand("", cnx);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
cmd.CommandText = "SBO_ACSA_PROD.ACSA_LOG_WEB_Stock";
HanaParameter param = new HanaParameter();
param = cmd.CreateParameter();
param.HanaDbType = HanaDbType.NVarChar;
param.Direction = ParameterDirection.Input;
param.Value = CodigoStock;
cmd.Parameters.Add(param);
cmd.ExecuteNonQuery();
HanaDataAdapter ada = new HanaDataAdapter(cmd);
ada.Fill(dt);
return(dt);
}
catch (SqlException)
{
throw new Exception();
}
finally
{
if (cnx.State == ConnectionState.Open)
{
cnx.Close();
}
cmd.Parameters.Clear();
}
}
public DataSet SAPSeguimientoOCDS(DateTime FechaInicio, DateTime FechaFin, string CodProveedor, string NomProveedor, string Solicitud, string Orden, string Entrada, string Factura)
{
DataSet dts = new DataSet();
try
{
cnx.Open();
HanaCommand cmd = new HanaCommand("", cnx);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
cmd.CommandText = "SBO_ACSA_PROD.ACSA_LOG_RPT_SEGUIMIENTO_OC";
HanaParameter fechaI = new HanaParameter();
HanaParameter fechaFin = new HanaParameter();
HanaParameter codPro = new HanaParameter();
HanaParameter nomPro = new HanaParameter();
HanaParameter Soli = new HanaParameter();
HanaParameter Ord = new HanaParameter();
HanaParameter entrada = new HanaParameter();
HanaParameter factura = new HanaParameter();
// Parametro Fecha 1.
fechaI = cmd.CreateParameter();
fechaI.HanaDbType = HanaDbType.Date;
fechaI.Direction = ParameterDirection.Input;
fechaI.Value = FechaInicio;
cmd.Parameters.Add(fechaI);
// Parametro Fecha 2.
fechaFin = cmd.CreateParameter();
fechaFin.HanaDbType = HanaDbType.Date;
fechaFin.Direction = ParameterDirection.Input;
fechaFin.Value = FechaFin;;
cmd.Parameters.Add(fechaFin);
codPro = cmd.CreateParameter();
codPro.HanaDbType = HanaDbType.VarChar;
codPro.Direction = ParameterDirection.Input;
codPro.Value = CodProveedor;
cmd.Parameters.Add(codPro);
nomPro = cmd.CreateParameter();
nomPro.HanaDbType = HanaDbType.VarChar;
nomPro.Direction = ParameterDirection.Input;
nomPro.Value = NomProveedor;
cmd.Parameters.Add(nomPro);
Soli = cmd.CreateParameter();
Soli.HanaDbType = HanaDbType.VarChar;
Soli.Direction = ParameterDirection.Input;
Soli.Value = Solicitud;
cmd.Parameters.Add(Soli);
Ord = cmd.CreateParameter();
Ord.HanaDbType = HanaDbType.VarChar;
Ord.Direction = ParameterDirection.Input;
Ord.Value = Orden;
cmd.Parameters.Add(Ord);
entrada = cmd.CreateParameter();
entrada.HanaDbType = HanaDbType.VarChar;
entrada.Direction = ParameterDirection.Input;
entrada.Value = Entrada;
cmd.Parameters.Add(entrada);
factura = cmd.CreateParameter();
factura.HanaDbType = HanaDbType.VarChar;
factura.Direction = ParameterDirection.Input;
factura.Value = Factura;
cmd.Parameters.Add(factura);
cmd.ExecuteNonQuery();
HanaDataAdapter ada = new HanaDataAdapter(cmd);
ada.Fill(dts, "ACSA_LOG_RPT_SEGUIMIENTO_OC");
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
cmd.Parameters.Clear();
}
//return (dts.Tables["VentasMensualesGCDetalladoxCanal"]);
return(dts);
/*
*
* catch (SqlException)
* {
*
* throw new Exception();
*
* }
* finally
* {
* if (cnx.State == ConnectionState.Open)
* {
* cnx.Close();
* }
* cmd.Parameters.Clear();
* }*/
}
public DataSet VentaClienteDS(DateTime fechaInicial, DateTime fechaFinal)
{
DataSet dts = new DataSet();
try
{
cnx.Open();
HanaCommand cmd = new HanaCommand("", cnx);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
cmd.CommandText = "SBO_ACSA_PROD.ACSA_VEN_RPT_VENTACLIENTES";
HanaParameter f1 = new HanaParameter();
HanaParameter f2 = new HanaParameter();
// Parametro Fecha 1.
f1 = cmd.CreateParameter();
f1.HanaDbType = HanaDbType.Date;
f1.Direction = ParameterDirection.Input;
f1.Value = fechaInicial;
cmd.Parameters.Add(f1);
// Parametro Fecha 2.
f2 = cmd.CreateParameter();
f2.HanaDbType = HanaDbType.Date;
f2.Direction = ParameterDirection.Input;
f2.Value = fechaFinal;;
cmd.Parameters.Add(f2);
cmd.ExecuteNonQuery();
HanaDataAdapter ada = new HanaDataAdapter(cmd);
ada.Fill(dts, "ACSA_VEN_RPT_VENTACLIENTES");
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
cmd.Parameters.Clear();
}
//return (dts.Tables["VentasMensualesGCDetalladoxCanal"]);
return(dts);
/*
*
* catch (SqlException)
* {
*
* throw new Exception();
*
* }
* finally
* {
* if (cnx.State == ConnectionState.Open)
* {
* cnx.Close();
* }
* cmd.Parameters.Clear();
* }*/
}
public DataSet VentasGeneralesDetalladaSAPEEDS(DateTime fecha1, DateTime fecha2, string Canal)
{
DataSet dts = new DataSet();
try
{
cnx.Open();
HanaCommand cmd = new HanaCommand("", cnx);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
cmd.CommandText = "SBO_ACSA_PROD.ACSA_VTAS_WEB_VentaGCxDetalladaProducto";
HanaParameter f1 = new HanaParameter();
HanaParameter f2 = new HanaParameter();
HanaParameter pc = new HanaParameter();
// Parametro Fecha 1.
f1 = cmd.CreateParameter();
f1.HanaDbType = HanaDbType.Date;
f1.Direction = ParameterDirection.Input;
f1.Value = fecha1;
cmd.Parameters.Add(f1);
// Parametro Fecha 2.
f2 = cmd.CreateParameter();
f2.HanaDbType = HanaDbType.Date;
f2.Direction = ParameterDirection.Input;
f2.Value = fecha2;;
cmd.Parameters.Add(f2);
// Parametro Canal.
pc = cmd.CreateParameter();
pc.HanaDbType = HanaDbType.VarChar;
pc.Direction = ParameterDirection.Input;
pc.Value = Canal;
cmd.Parameters.Add(pc);
cmd.ExecuteNonQuery();
HanaDataAdapter ada = new HanaDataAdapter(cmd);
ada.Fill(dts, "ACSA_VTAS_WEB_VentaGCxDetalladaProducto");
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
cmd.Parameters.Clear();
}
//return (dts.Tables["VentasMensualesGCDetalladoxCanal"]);
return(dts);
/*
*
* catch (SqlException)
* {
*
* throw new Exception();
*
* }
* finally
* {
* if (cnx.State == ConnectionState.Open)
* {
* cnx.Close();
* }
* cmd.Parameters.Clear();
* }*/
}
public DataTable SAPSeguimientoOCIMPDT(DateTime FechaInicio, DateTime FechaFin, string CodProveedor, string NomProveedor, string Solicitud, string Orden, string Reserva, string Entrada, string Precio, string Transferencia)
{
DataTable dt = new DataTable();
try
{
cnx.Open();
HanaCommand cmd = new HanaCommand("", cnx);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
cmd.CommandText = "SBO_ACSA_PROD.ACSA_LOG_RPT_SEGUIMIENTO_OC_IMP";
HanaParameter fechaI = new HanaParameter();
HanaParameter fechaFin = new HanaParameter();
HanaParameter codPro = new HanaParameter();
HanaParameter nomPro = new HanaParameter();
HanaParameter Soli = new HanaParameter();
HanaParameter Ord = new HanaParameter();
HanaParameter reser = new HanaParameter();
HanaParameter entrada = new HanaParameter();
HanaParameter precio = new HanaParameter();
HanaParameter transferencia = new HanaParameter();
// Parametro Fecha 1.
fechaI = cmd.CreateParameter();
fechaI.HanaDbType = HanaDbType.Date;
fechaI.Direction = ParameterDirection.Input;
fechaI.Value = FechaInicio;
cmd.Parameters.Add(fechaI);
// Parametro Fecha 2.
fechaFin = cmd.CreateParameter();
fechaFin.HanaDbType = HanaDbType.Date;
fechaFin.Direction = ParameterDirection.Input;
fechaFin.Value = FechaFin;;
cmd.Parameters.Add(fechaFin);
codPro = cmd.CreateParameter();
codPro.HanaDbType = HanaDbType.VarChar;
codPro.Direction = ParameterDirection.Input;
codPro.Value = CodProveedor;
cmd.Parameters.Add(codPro);
nomPro = cmd.CreateParameter();
nomPro.HanaDbType = HanaDbType.VarChar;
nomPro.Direction = ParameterDirection.Input;
nomPro.Value = NomProveedor;
cmd.Parameters.Add(nomPro);
Soli = cmd.CreateParameter();
Soli.HanaDbType = HanaDbType.VarChar;
Soli.Direction = ParameterDirection.Input;
Soli.Value = Solicitud;
cmd.Parameters.Add(Soli);
Ord = cmd.CreateParameter();
Ord.HanaDbType = HanaDbType.VarChar;
Ord.Direction = ParameterDirection.Input;
Ord.Value = Orden;
cmd.Parameters.Add(Ord);
reser = cmd.CreateParameter();
reser.HanaDbType = HanaDbType.VarChar;
reser.Direction = ParameterDirection.Input;
reser.Value = Reserva;
cmd.Parameters.Add(reser);
entrada = cmd.CreateParameter();
entrada.HanaDbType = HanaDbType.VarChar;
entrada.Direction = ParameterDirection.Input;
entrada.Value = Entrada;
cmd.Parameters.Add(entrada);
precio = cmd.CreateParameter();
precio.HanaDbType = HanaDbType.VarChar;
precio.Direction = ParameterDirection.Input;
precio.Value = Precio;
cmd.Parameters.Add(precio);
transferencia = cmd.CreateParameter();
transferencia.HanaDbType = HanaDbType.VarChar;
transferencia.Direction = ParameterDirection.Input;
transferencia.Value = Transferencia;
cmd.Parameters.Add(transferencia);
cmd.ExecuteNonQuery();
HanaDataAdapter ada = new HanaDataAdapter(cmd);
ada.Fill(dt);
return(dt);
}
catch (SqlException)
{
throw new Exception();
}
finally
{
if (cnx.State == ConnectionState.Open)
{
cnx.Close();
}
cmd.Parameters.Clear();
}
}
public DataTable CostoInvetarioDSDT(DateTime FechaInicio, DateTime FechaFin, string CodCliente, string Canal)
{
DataTable dt = new DataTable();
try
{
cnx.Open();
HanaCommand cmd = new HanaCommand("", cnx);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
cmd.CommandText = "SBO_ACSA_PROD.ACSA_CON_RPT_INVENTARIO";
HanaParameter f1 = new HanaParameter();
HanaParameter f2 = new HanaParameter();
HanaParameter cc = new HanaParameter();
HanaParameter c = new HanaParameter();
// Parametro Fecha 1.
f1 = cmd.CreateParameter();
f1.HanaDbType = HanaDbType.Date;
f1.Direction = ParameterDirection.Input;
f1.Value = FechaInicio;
cmd.Parameters.Add(f1);
// Parametro Fecha 2.
f2 = cmd.CreateParameter();
f2.HanaDbType = HanaDbType.Date;
f2.Direction = ParameterDirection.Input;
f2.Value = FechaFin;;
cmd.Parameters.Add(f2);
// Parametro Cliente.
cc = cmd.CreateParameter();
cc.HanaDbType = HanaDbType.VarChar;
cc.Direction = ParameterDirection.Input;
cc.Value = CodCliente;
cmd.Parameters.Add(cc);
// Parametro Canal.
c = cmd.CreateParameter();
c.HanaDbType = HanaDbType.VarChar;
c.Direction = ParameterDirection.Input;
c.Value = Canal;
cmd.Parameters.Add(c);
cmd.ExecuteNonQuery();
HanaDataAdapter ada = new HanaDataAdapter(cmd);
ada.Fill(dt);
return(dt);
}
catch (SqlException)
{
throw new Exception();
}
finally
{
if (cnx.State == ConnectionState.Open)
{
cnx.Close();
}
cmd.Parameters.Clear();
}
}
public DataTable DocumentosAutorizadosConsultar(DateTime fechaInicial, DateTime fechaFinal, string numSAP, string codCliente, string codAlmacen)
{
DataTable dt = new DataTable();
try
{
cnx.Open();
HanaCommand cmd = new HanaCommand("", cnx);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
cmd.CommandText = "SBO_ACSA_PROD.ACSA_VEN_RPT_FLUJODEOVS";
HanaParameter FechaInicio = new HanaParameter();
HanaParameter FechaFin = new HanaParameter();
HanaParameter NumSAP = new HanaParameter();
HanaParameter CodCliente = new HanaParameter();
HanaParameter CodAlmacen = new HanaParameter();
// Parametro Fecha 1.
FechaInicio = cmd.CreateParameter();
FechaInicio.HanaDbType = HanaDbType.Date;
FechaInicio.Direction = ParameterDirection.Input;
FechaInicio.Value = fechaInicial;
cmd.Parameters.Add(FechaInicio);
// Parametro Fecha 2.
FechaFin = cmd.CreateParameter();
FechaFin.HanaDbType = HanaDbType.Date;
FechaFin.Direction = ParameterDirection.Input;
FechaFin.Value = fechaFinal;;
cmd.Parameters.Add(FechaFin);
// Parametro Numero de Orden de Venta.
NumSAP = cmd.CreateParameter();
NumSAP.HanaDbType = HanaDbType.VarChar;
NumSAP.Direction = ParameterDirection.Input;
NumSAP.Value = numSAP;
cmd.Parameters.Add(NumSAP);
// Parametro Cliente.
CodCliente = cmd.CreateParameter();
CodCliente.HanaDbType = HanaDbType.VarChar;
CodCliente.Direction = ParameterDirection.Input;
CodCliente.Value = codCliente;
cmd.Parameters.Add(CodCliente);
// Parametro Almacen.
CodAlmacen = cmd.CreateParameter();
CodAlmacen.HanaDbType = HanaDbType.VarChar;
CodAlmacen.Direction = ParameterDirection.Input;
CodAlmacen.Value = codAlmacen;
cmd.Parameters.Add(CodAlmacen);
cmd.ExecuteNonQuery();
HanaDataAdapter ada = new HanaDataAdapter(cmd);
ada.Fill(dt);
return(dt);
}
catch
{
throw new Exception();
}
finally
{
if (cnx.State == ConnectionState.Open)
{
cnx.Close();
}
cmd.Parameters.Clear();
}
}