private void InitDataBase(int version)
{
int result = db.ExecuteScalar("SELECT count(*) from sqlite_master where type='table' and name='" + TABLE_NAME + "'");
if (result == 0)
{
//表不存在
string[] colNames = { "KEY", "VALUE" };
string[] colTypes = { "TEXT", "TEXT" };
db.CreateTable(TABLE_NAME, colNames, colTypes);
db.InsertValues(TABLE_NAME, new string[] { "version", version + "" });
}
else
{
//判断数据库是否需要升级
DataTable dt = db.GetTable("select * from " + TABLE_NAME + " where KEY='version'");
if (dt != null && dt.Rows.Count > 0)
{
int OldVersion = Convert.ToInt32(dt.Rows[0]["VALUE"]);
if (OldVersion < version)
{
UpdateDB();
db.UpdateValues(TABLE_NAME, new string[] { "VALUE" }, new string[] { version + "" }, "KEY", "version", "=");
}
}
}
CreateAllTables();
}
/// <summary>
/// 创建表
/// </summary>
/// <param name="db"></param>
/// <param name="ifNotExists"></param>
public static void CreateTable(SqLiteHelper db)
{
Helper = db;
string[] colNames =
{
"ID", "Seq", "Content", "IsSend", "FileName", "CreateTime", "MsgType", "FileSize"
};
string[] colTypes =
{
"INTEGER PRIMARY KEY", "TEXT", "TEXT", "Boolean", "TEXT", "TEXT", "INTEGER", "TEXT"
};
db.CreateTable(TABLE_NAME, colNames, colTypes);
}