SqliteDbHelper db;//声明连接对象
//TestRouteBaseInfo建表语句
private void CreateTableTestRouteBaseInfo()
{
db.CreateTable("TestRouteBaseInfo",
new string[] {
"Idx", "TestRoutes", "LineMileage",
"Material", "Time", "Picture"
},
new string[] { "INTEGER PRIMARY KEY AUTOINCREMENT", "TEXT",
"TEXT", "TEXT", "TEXT", "TEXT" });
}
SqliteDbHelper db;//声明连接对象
/// <summary>
/// 建表语句
/// </summary>
private void CreateTableUserInfo()
{
db.CreateTable("UserInfo",
new string[] {
"Idx", "UserName", "PassWord",
"Type", "Picture"
},
new string[] { "INTEGER PRIMARY KEY AUTOINCREMENT", "TEXT",
"TEXT", "TEXT", "TEXT" });
}
SqliteDbHelper db;//声明连接对象
/// <summary>
/// 建表语句
/// </summary>
private void CreateTable()
{
db.CreateTable("CarInfo",
new string[] {
"Idx", "Type", "CarNumber", "SeatNum", "CurbWeight", "FullRated", "Displacement",
"FrontSuspensionSystem", "RearSuspensionSystem", "DriveMethod", "Gearbox",
"Brake", "BuyingTime", "InitialOdometerReading", "Picture"
},
new string[] { "INTEGER PRIMARY KEY AUTOINCREMENT", "TEXT", "TEXT", "INT", "DOUBLE", "DOUBLE", "DOUBLE", "TEXT", "TEXT",
"TEXT", "TEXT", "TEXT", "DATETIME", "INT", "TEXT" });
}
/// <summary>
/// 建表语句
/// </summary>
private void CreateTable()
{
db.CreateTable("EquipmentInfo", new string[] { "Idx", "Name", "Code", "TermOfValidity", "Picture" }, new string[] { "INTEGER PRIMARY KEY AUTOINCREMENT", "TEXT", "TEXT", "DATETIME", "TEXT" });
}