//下面为新添加的版本信息更新的方法 public static void CheckHBVersion_New() { //bool bPowerOn = CoreInterface.GetBoardStatus() != JetStatusEnum.PowerOff; HEAD_BOARD_TYPE headBoardType = (HEAD_BOARD_TYPE)CoreInterface.get_HeadBoardType(true); SBoardInfo sBoardInfo = new SBoardInfo(); if (CoreInterface.GetBoardInfo(0, ref sBoardInfo) != 0) { SFWVersion fwv = new SFWVersion(sBoardInfo.m_nHBBoardVersion); string sVersion = fwv.m_nMainVersion.ToString() + "." + fwv.m_nSubVersion.ToString() + "." + fwv.m_nBuildVersion.ToString() + "." + fwv.m_nHWVersion.ToString(); string sql = "select VERSION_REPLACE.DISPLAY_REASON,VERSION_REPLACE.SUBMIT_TIME from VERSION_REPLACE left " + "join VERSION_INFO on VERSION_REPLACE.REPLACE_VID=VERSION_INFO.VID where VERSION_INFO.VERSION_NUM='" + sVersion + "' " + "and VERSION_INFO.HBTYPE='" + headBoardType.ToString() + "' ORDER BY VERSION_REPLACE.SUBMIT_TIME DESC"; DataTable data = SqliteHelp.SelectData(sql); if (data != null && data.Rows.Count > 0) { string msg = data.Rows[0][0].ToString(); if (!string.IsNullOrEmpty(msg.Trim())) { MessageBox.Show(msg.Trim(), @"头板版本更新提示"); } } } }
public static SqliteHelp GetInstance() { if (sqliteHelp == null) { sqliteHelp = new SqliteHelp(); } return(sqliteHelp); }
public static void DownHeadVersionInfoDataBase_SQLite() { try { if (LocalConnectionStatus()) { //第一个参数是 下载地址, //第二个参数是 下载后的临时文件地址, //第三个参数是 下载完成后,将临时文件保存到的指定地址 string filename = Path.Combine(Application.StartupPath, @"DownloadFile.exe"); string url = "http://47.93.225.113:5002/KeyValueStores/ExportData"; string dbtemp = Path.Combine(Application.StartupPath, @"HeadVersionInfoTemp.db"); string db = Path.Combine(Application.StartupPath, @"HeadVersionInfo.db"); string dbtime = ""; string sql = "select DBVersion.PublishTime from DBVersion"; DataTable data = SqliteHelp.SelectData(sql); if (data != null && data.Rows.Count > 0) { string msg = data.Rows[0][0].ToString(); if (!string.IsNullOrEmpty(msg.Trim())) { dbtime = msg; } } else { dbtime = DateTime.MinValue.ToString("G"); } Process[] ps = Process.GetProcessesByName("ConsoleApp"); foreach (Process process in ps) { process.Kill(); } if (File.Exists(filename)) { Process process = new Process { StartInfo = { FileName = filename, CreateNoWindow = true, UseShellExecute = false, Arguments = url + " " + dbtemp + " " + db + " \"DBName=f8b11d42-3446-4126-906a-64d43fea1728&PublishTime=" + DateTime.Parse(dbtime).ToString("yyyy-MM-dd") + "\" UniqueName=f8b11d42-3446-4126-906a-64d43fea1728" } }; process.Start(); } } } catch { } }
void Start() { //创建名为Hungmingfu的数据库 SqliteHelp sql = new SqliteHelp("data source=HaoYouXi.db"); //创建名为table1的数据表 try { sql.CreateTable("表1", new string[] { "ID", "Name", "Age", "Email" }, new string[] { "INT", "TEXT", "INT", "TEXT" }); } catch (System.Exception) { print("表单重复"); } ////插入两条数据 //sql.InsertInto ("表1", new string[] { "'1'", "'张三'", "'22'", "'*****@*****.**'" }); //sql.InsertInto("表1", new string[] { "'2'", "'李四'", "'25'", "'*****@*****.**'" }); ////更新数据,将Name = "张三"的记录中的Name改为"Zhang3" //sql.UpdateInto("表1", new string[] { "Name" }, new string[] { "'Zhang3'" }, "Name", "=", "'张三'"); ////插入3条数据 //sql.InsertInto("表1", new string[] { "3", "'王五'", "25", "'*****@*****.**'" }); //sql.InsertInto("表1", new string[] { "4", "'王五'", "26", "'*****@*****.**'" }); //sql.InsertInto("表1", new string[] { "5", "'王五'", "27", "'*****@*****.**'" }); ////删除Name = "王五"且Age = 26的记录,DeleteValuesOR方法类似 //sql.DeleteValuesAND("表1", new string[] { "Name", "Age" }, new string[] { "=", "=" }, new string[] { "'王五'", "'26'" }); ////读取整张表 //SqliteDataReader reader = sql.ReadFullTable("表1"); //while (reader.Read()) //{ // //读取ID // Debug.Log(reader.GetInt32(reader.GetOrdinal("ID"))); // //读取Name // Debug.Log(reader.GetString(reader.GetOrdinal("Name"))); // //读取Age // Debug.Log(reader.GetInt32(reader.GetOrdinal("Age"))); // //读取Email // Debug.Log(reader.GetString(reader.GetOrdinal("Email"))); //} ////读取数据表中Age >= 25的所有记录的ID和Name //reader = sql.ReadTable("表1", new string[] { "ID", "Name" }, new string[] { "Age" }, new string[] { ">=" }, new string[] { "'25'" }); //while (reader.Read()) //{ // //读取ID // Debug.Log(reader.GetInt32(reader.GetOrdinal("ID"))); // //读取Name // Debug.Log(reader.GetString(reader.GetOrdinal("Name"))); //} ////自定义SQL,删除数据表中所有Name = "王五"的记录 //sql.ExecuteQuery("DELETE FROM 表1 WHERE NAME='王五'"); //关闭数据库连接 sql.CloseSqlConnection(); }