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="Seq"></param> /// <param name="Content"></param> /// <param name="IsSend"></param> /// <param name="FileName"></param> /// <param name="MsgType"></param> /// <param name="FileSize"></param> public void InsertMessage(Message msg, string Seq) { bool IsSend = msg.IsSend; string Content = msg.Content; string FileName = msg.fileName; int MsgType = msg.MsgType; string FileSize = msg.FileSize; object[] values = { null, Seq, Content, IsSend, FileName, DateTime.Now, MsgType, FileSize, msg.MsgId }; Helper.InsertValues(TABLE_NAME, values); }