/// <summary>
/// Execute query a NMT_TMP_FILES
/// </summary>
public DataSet CreateTableCatalogoTemp(string NombreTabla,bool local)
{
ConexionBD conexion;
string consulta = String.Format("EXEC [spCreateTableKPITemp] '{0}'", NombreTabla);
try
{
conexion = new ConexionBD();
if(local)
return conexion.getDataSet(consulta);
else
return conexion.getDataSetBitacora(consulta);
}
catch (Exception Error)
{
throw (new Exception(Error.ToString()));
}
}
/// <summary>
/// Habilitar inserción a tabla temporal
/// </summary>
public void NoHabilitarInsertTemp(bool local)
{
ConexionBD conexion;
string consulta = String.Format("EXEC spNoHabilitarInsertTemp");
try
{
conexion = new ConexionBD();
if (local)
conexion.getDataSet(consulta);
else
conexion.getDataSetBitacora(consulta);
}
catch (Exception Error)
{
throw (new Exception(Error.ToString()));
}
}
/// <summary>
/// Execute query a NMT_TMP_FILES
/// </summary>
public void Merge_NMT_Table(string tablaFuente,string TablaDestino, bool local)
{
ConexionBD conexion;
string consulta = String.Format("EXEC spMergeTable '{0}','{1}'", tablaFuente, TablaDestino);
try
{
conexion = new ConexionBD();
if(local)
conexion.getDataSet(consulta);
else
conexion.getDataSetBitacora(consulta);
}
catch (Exception Error)
{
throw (new Exception(Error.ToString()));
}
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public DataSet getVersionAPP()
{
ConexionBD conexion;
string consulta = "EXEC spSelectVersionAPP_MDZ ";
try
{
//Obteniendo informacion remota
conexion = new ConexionBD();
return conexion.getDataSetBitacora(consulta);
}
catch (Exception Error)
{
//expected error por falta de conexion.
throw (new Exception(Error.ToString()));
}
}
/// <summary>
/// Execute query a truncate
/// </summary>
public void Truncate_NMT_Table(string Tabla,bool local)
{
ConexionBD conexion;
string consulta = String.Format("EXEC spTruncateTable '{0}'", Tabla);
try
{
conexion = new ConexionBD();
if (local)
conexion.getDataSet(consulta);
else
conexion.getDataSetBitacora(consulta);
}
catch (Exception Error)
{
throw (new Exception(Error.ToString()));
}
}
/// <summary>
/// Execute query a NMT_TMP_FILES
/// </summary>
public void ExecuteSQLNMT_TMP_FILES(string Tabla, string columnas, string valores,bool local)
{
ConexionBD conexion;
string consulta = String.Format("EXEC spExecuteSQLTableKPITemp '{0}','{1}','{2}'", Tabla, columnas, valores.Replace("'", "''''"));
try
{
conexion = new ConexionBD();
if (local)
conexion.getDataSet(consulta);
else
conexion.getDataSetBitacora(consulta);
}
catch (Exception Error)
{
throw (new Exception(Error.ToString()));
}
}
