public static LocalSQLiteDb GetInstance()
{
if (instance == null)
{
instance = new LocalSQLiteDb();
}
return(instance);
}
public static string DBInit()
{
string ret = "";
try
{
//不存在数据库，需要创建数据库和数据表
if (!File.Exists(LocalSQLiteDb.path + @"/" + LocalSQLiteDb.dbName))
{
SQLiteConnection.CreateFile(LocalSQLiteDb.path + @"/" + LocalSQLiteDb.dbName);
LocalSQLiteDb.sqlConn = new SQLiteConnection();
LocalSQLiteDb.sqlConn.ConnectionString = LocalSQLiteDb.connStr;
//SQLiteDb.sqlConn.Open();//加密
//SQLiteDb.sqlConn.ChangePassword("sinoservice;");//加密
LocalSQLiteDb.GetInstance().beginTransaction();
string sql = "";
//创建打印机配置表
sql = @"CREATE TABLE [PrintSetting](
[ID] INTEGER PRIMARY KEY AUTOINCREMENT,
[reporttemplate] [nvarchar](500),
[printName] [nvarchar](500),
[printSetting] [nvarchar](Max)
)";
LocalSQLiteDb.GetInstance().ExecuteSql(sql);
LocalSQLiteDb.GetInstance().commitTransaction();
ret = "创表成功";
}
}
catch (Exception e)
{
LocalSQLiteDb.GetInstance().rollBackTransaction();
ret = "创表失败";
}
return(ret);
}