//下面为新添加的版本信息更新的方法
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();
}
