public void InsertData()
{
SQLiteCommand cmdInsert = new SQLiteCommand(conn);
var data = new StationFixPara();
cmdInsert.CommandText = $"INSERT INTO {TableName} VALUES({data.ValuesTableToString()})";//插入几条数据
cmdInsert.ExecuteNonQuery();
data = new StationFixPara();
cmdInsert.CommandText = $"INSERT INTO {TableName} VALUES({data.ValuesTableToString()})";
cmdInsert.ExecuteNonQuery();
data = new StationFixPara();
cmdInsert.CommandText = $"INSERT INTO {TableName} VALUES({data.ValuesTableToString()})";
cmdInsert.ExecuteNonQuery();
}
public ComWithSqlite()
{
conn = null;
string dbPath = "Data Source =" + Environment.CurrentDirectory + "/" + DatabaseName + ".db";
conn = new SQLiteConnection(dbPath); //创建数据库实例，指定文件位置
conn.Open(); //打开数据库，若文件不存在会自动创建
string sql = $"CREATE TABLE IF NOT EXISTS {TableName}({StationFixPara.CreateTableToString()});"; //建表语句
SQLiteCommand cmdCreateTable = new SQLiteCommand(sql, conn);
cmdCreateTable.ExecuteNonQuery();//如果表不存在，创建数据表
//conn.Close();
}
public void InsertData(List <StationCode> stationCodes)
{
SQLiteCommand cmdInsert = new SQLiteCommand(conn);
int i = 0;
foreach (var stationCode in stationCodes)
{
var data = new StationFixPara()
{
ID = i,
Name = stationCode.Dictionary["station"],
ActArea = stationCode.Dictionary["actarea"],
Addr = stationCode.Dictionary["addr"],
DisplaySort = stationCode.Dictionary["dispsort"],
FC1_Visible = stationCode.Dictionary["fc1visible"],
FC2_Visible = stationCode.Dictionary["fc2visible"],
FC3_Visible = stationCode.Dictionary["fc3visible"],
FC4_Visible = stationCode.Dictionary["fc4visible"],
FC5_Visible = stationCode.Dictionary["fc5visible"],
FC6_Visible = stationCode.Dictionary["fc6visible"],
FC7_Visible = stationCode.Dictionary["fc7visible"],
FC8_Visible = stationCode.Dictionary["fc8visible"],
FC9_Visible = stationCode.Dictionary["fc9visible"],
FC10_Visible = stationCode.Dictionary["fc10visible"],
RegieterArea = stationCode.Dictionary["registearea"],
Flow1_Visible = stationCode.Dictionary["flow1visible"],
Flow2_Visible = stationCode.Dictionary["flow2visible"],
Flow3_Visible = stationCode.Dictionary["flow3visible"],
Flow4_Visible = stationCode.Dictionary["flow4visible"],
Ip = stationCode.Dictionary["ip"],
Port = stationCode.Dictionary["port"],
IsUsed = stationCode.Dictionary["used"],
LP1_Visible = stationCode.Dictionary["lp1visible"],
LP2_Visible = stationCode.Dictionary["lp2visible"],
LP3_Visible = stationCode.Dictionary["lp3visible"],
LP4_Visible = stationCode.Dictionary["lp4visible"],
LT1_Visible = stationCode.Dictionary["lt1visible"],
LT2_Visible = stationCode.Dictionary["lt2visible"],
LT3_Visible = stationCode.Dictionary["lt3visible"],
LT4_Visible = stationCode.Dictionary["lt4visible"],
SP1_Visible = stationCode.Dictionary["sp1visible"],
SP2_Visible = stationCode.Dictionary["sp2visible"],
SP3_Visible = stationCode.Dictionary["sp3visible"],
SP4_Visible = stationCode.Dictionary["sp4visible"],
ST1_Visible = stationCode.Dictionary["lt1visible"],
ST2_Visible = stationCode.Dictionary["lt2visible"],
ST3_Visible = stationCode.Dictionary["lt3visible"],
ST4_Visible = stationCode.Dictionary["lt4visible"],
WaterboxDown = stationCode.Dictionary["waterbox_down"],
WaterboxHeight = stationCode.Dictionary["waterboxheight"],
WaterboxStop = stationCode.Dictionary["waterbox_stop"],
WaterboxSupply = stationCode.Dictionary["waterbox_supply"],
WaterboxUp = stationCode.Dictionary["waterbox_up"],
Waterbox_VisiBle = stationCode.Dictionary["waterboxvisible"],
};
++i;
cmdInsert.CommandText = $"INSERT INTO {TableName} VALUES({data.ValuesTableToString()})";//插入几条数据
cmdInsert.ExecuteNonQuery();
}
}