/// <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())); } }