public static bool Upgrade() { DbHelperOleDb dbUtil = new DbHelperOleDb(); try { List <string> tables = dbUtil.GetTableNameList(); if (!tables.Exists(x => x.Equals("TB_DBVersion"))) { ArrayList sqlList = new ArrayList() { "CREATE TABLE TB_DBVersion (ID AutoIncrement,versioncode varchar);", "INSERT into TB_DBVersion (versioncode) VALUES (2);" }; DBUtility.DbHelperOleDb.ExecuteSqlTran(sqlList); } if (!tables.Exists(x => x.Equals("TB_StandardParams"))) { string createParamTableSql = "CREATE TABLE TB_StandardParams (ID AutoIncrement ,StandID int NULL,StandName varchar NULL,Ath_Sex varchar NULL,Ath_AgeMinLimit int NULL,Ath_AgeMaxLimit int NULL,Ath_Project varchar NULL,Ath_MainProject varchar NULL,Joint_Side varchar NULL,Test_Mode varchar NULL,Joint varchar NULL,Plane varchar NULL,Speed1 varchar NULL,Speed2 varchar NULL);"; DBUtility.DbHelperOleDb.ExecuteSql(createParamTableSql); } return(true); } catch (Exception ee) { MessageBox.Show("升级数据库出错!\r\n错误信息:" + ee.Message, "系统错误"); return(false); } }