//--------------------------------------------------------------------OBTENER COD SIGUIENTE--------------------------------------------------------------------//
public string obtenerfinal(string tabla, string campo)
{
String camporesultante = "";
try
{
string sql = "SELECT MAX(" + campo + "+1) FROM " + tabla + ";"; //SELECT MAX(idFuncion) FROM `funciones`
OdbcCommand command = new OdbcCommand(sql, cn.conexionbd());
OdbcDataReader reader = command.ExecuteReader();
reader.Read();
camporesultante = reader.GetValue(0).ToString();
if (String.IsNullOrEmpty(camporesultante))
{
camporesultante = "1";
}
}
catch (Exception)
{
Console.WriteLine(camporesultante);
}
return(camporesultante);
}
//---------------Insertar Conceptos
public OdbcDataReader InsertarConceptos(string sCodigo, string sNombre, string sDescripcion, string sValor, string sTipoOp)
{
try
{
cn.conexionbd();
string consulta = "insert into conceptos values(" + sCodigo + ", '" + sNombre + "' ,'" + sDescripcion + "'," + sValor + "," + sTipoOp + ",1);";
comm = new OdbcCommand(consulta, cn.conexionbd());
OdbcDataReader mostrar = comm.ExecuteReader();
return(mostrar);
}
catch (Exception err)
{
Console.WriteLine(err.Message);
return(null);
}
}
public OdbcDataReader insertarbitacora(string sCodigo, string sip, string Smac, string susuario, string sdepartamento, string sfechahora, string saccion, string sformulario)
{
try
{
cn.conexionbd();
string consulta = "insert into bitacora values(" + sCodigo + ", '" + sip + "', '" + Smac + "' ,'" + susuario + "','" + sdepartamento + "','" + sfechahora + "','" + saccion + "','" + sformulario + "');";
comm = new OdbcCommand(consulta, cn.conexionbd());
OdbcDataReader mostrar = comm.ExecuteReader();
return(mostrar);
}
catch (Exception err)
{
Console.WriteLine(err.Message);
return(null);
}
}