public void CreateEasyJobTable(EntityDB.IDatabaseService db)
{
bool exists = true;
try
{
db.ExecSqlString("select * from __wayeasyjob");
}
catch (Exception ex)
{
exists = false;
}
if (!exists)
{
db.ExecSqlString("CREATE TABLE [__wayeasyjob](contentConfig TEXT NOT NULL)");
var dbconfig = new DataBaseConfig();
try
{
dbconfig.LastUpdatedID = Convert.ToInt32(db.ExecSqlString("select lastID from __EasyJob"));
}
catch
{
}
db.ExecSqlString("insert into __wayeasyjob (contentConfig) values (@p0)", dbconfig.ToJsonString());
}
//try
//{
// db.ExecSqlString("CREATE TABLE [] ([lastID] integer NOT NULL)");
// db.ExecSqlString("insert into (lastID) values (0)");
//}
//catch
//{
//}
}
public void CreateEasyJobTable(EntityDB.IDatabaseService db)
{
bool exists = true;
try
{
db.ExecSqlString("select * from __wayeasyjob");
}
catch
{
exists = false;
}
if (!exists)
{
db.ExecSqlString("CREATE TABLE [__wayeasyjob](contentConfig varchar(1000) NOT NULL)");
var dbconfig = new DataBaseConfig();
try
{
dbconfig.LastUpdatedID = Convert.ToInt32(db.ExecSqlString("select lastID from __EasyJob"));
}
catch
{
}
db.ExecSqlString("insert into __wayeasyjob (contentConfig) values (@p0)", dbconfig.ToJsonString());
}
}
