public string facturaproyecto(DbObject objectToAutonumber, string Key)
{
string n = "0";
Type tipo = objectToAutonumber.GetType();
string tabla = tipo.Name.ToLower();
if (objectToAutonumber.Table != "")
{
tabla = objectToAutonumber.Table;
}
switch (DataBaseProvider)
{
case TypeOfDataBase.MicrosoftAccess:
query = "SELECT TOP 1 " + Key + " FROM " + tabla + " ORDER BY " + Key + " DESC";
try
{
oleDbConnection.Open();
}
catch (Exception ex)
{
error = ex.Message;
return("0");
}
OleDbCommand cmd = new OleDbCommand(query, oleDbConnection);
try
{
object o = cmd.ExecuteScalar();
if (o == null)
{
return("0");
}
n = (string)(o);
}
catch (Exception ex)
{
error = ex.Message;
return("0");
}
finally
{
oleDbConnection.Close();
}
break;
case TypeOfDataBase.MicrosoftSqlServer:
query = "SELECT " + Key + " FROM " + tabla + " ORDER BY " + Key + " DESC LIMIT 1";
break;
case TypeOfDataBase.MySqlServer:
query = "SELECT folio FROM " + tabla + " where origen='PREFACTURA PROYECTOS' and idproyecto=" + Key + " LIMIT 1";
try
{
mysqlconn.Open();
}
catch (Exception ex)
{
error = ex.Message;
return("0");
}
MySqlCommand cmd2 = new MySqlCommand(query, mysqlconn);
try
{
object o = cmd2.ExecuteScalar();
if (o == null)
{
return("0");
}
n = o.ToString();
}
catch (Exception ex)
{
error = ex.Message;
return("0");
}
finally
{
mysqlconn.Close();
}
break;
}
return(n);
}
public int NextNumber(DbObject objectToAutonumber, string Key)
{
int n = 0;
Type tipo = objectToAutonumber.GetType();
string tabla = tipo.Name.ToLower();
if (objectToAutonumber.Table != "")
{
tabla = objectToAutonumber.Table;
}
switch (DataBaseProvider)
{
case TypeOfDataBase.MicrosoftAccess:
query = "SELECT TOP 1 " + Key + " FROM " + tabla + " ORDER BY " + Key + " DESC";
try
{
oleDbConnection.Open();
}
catch (Exception ex)
{
error = ex.Message;
return(-1);
}
OleDbCommand cmd = new OleDbCommand(query, oleDbConnection);
try
{
object o = cmd.ExecuteScalar();
if (o == null)
{
return(1);
}
n = (int)(o);
}
catch (Exception ex)
{
error = ex.Message;
return(-1);
}
finally
{
oleDbConnection.Close();
}
break;
case TypeOfDataBase.MicrosoftSqlServer:
query = "SELECT " + Key + " FROM " + tabla + " ORDER BY " + Key + " DESC LIMIT 1";
break;
case TypeOfDataBase.MySqlServer:
query = "SELECT " + Key + " FROM " + tabla + " ORDER BY " + Key + " DESC LIMIT 1";
try
{
mysqlconn.Open();
}
catch (Exception ex)
{
error = ex.Message;
return(-1);
}
MySqlCommand cmd2 = new MySqlCommand(query, mysqlconn);
try
{
object o = cmd2.ExecuteScalar();
if (o == null)
{
return(1);
}
n = (int)(o);
}
catch (Exception ex)
{
error = ex.Message;
return(-1);
}
finally
{
mysqlconn.Close();
}
break;
}
return(n + 1);
}
