/// <summary>
/// 初始化
/// </summary>
public static bool Init()
{
try
{
string dbPath = Environment.CurrentDirectory + "/" + "flow_history.db";
//如果不存在数据库文件，则创建该数据库文件
if (!System.IO.File.Exists(dbPath))
{
SQLiteDBHelper.CreateDB(dbPath);
}
db = new SQLiteDBHelper(dbPath);
string sql;
sql = "CREATE TABLE IF NOT EXISTS flow(fid integer PRIMARY KEY autoincrement DEFAULT (1),pid integer, flow_up long, flow_down long, note_date date);";
db.ExecuteNonQuery(sql, null); // 创建 flow 表
sql = "CREATE TABLE IF NOT EXISTS program(pid integer PRIMARY KEY autoincrement DEFAULT (1), name varchar(30), path text, describe text);";
db.ExecuteNonQuery(sql, null); // 创建 program 表
}
catch (Exception e)
{
//FM_Info.showError(e);
return(false);
}
return(true);
}
public void InitDataBase()
{
// 创建数据库文件
if (!File.Exists(_dataFile))
{
SQLiteDBHelper.CreateDB(_dataFile);
// 设置连接字符串
SQLiteDBHelper.SetConnectionString(Environment.CurrentDirectory + "\\" + _dataFile);
// 创建表结构
_repository.CreateSchema();
UserRepository userRep = new UserRepository();
User systemUser = new User();
systemUser.Id = this.NewGUID();
systemUser.Name = "系统管理员";
systemUser.Account = "admin";
systemUser.Password = "******";
userRep.Insert(systemUser);
}
else
{
// 设置连接字符串
SQLiteDBHelper.SetConnectionString(Environment.CurrentDirectory + "\\" + _dataFile);
}
}
private void button_NewDBFile_Click(object sender, EventArgs e)
{
SQLiteDBHelper _helper = new SQLiteDBHelper(Config.CfgInfo.StaticDB_PATH);
string path = Config.CfgInfo.FoldBrowserPath + "\\" + textBox_new_wellname.Text.Trim() + "_" + textBox_new_wellid.Text.Trim() + "_" + textBox_new_welltime.Text.Trim() + ".db3";
_helper.CreateDB(path, "2", "07", getXMLConfig());
WitsTable wt = new WitsTable("APS", "07", getXMLConfig());
}
public void CreateTable()
{
//如果不存在改数据库文件，则创建该数据库文件
if (!System.IO.File.Exists(_dbPath))
{
SQLiteDBHelper.CreateDB(_dbPath);
}
//SQLiteDBHelper db = new SQLiteDBHelper(dbPath);
//string sql = "CREATE TABLE Product(Id integer NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,Url varchar(200),CreateTime datetime)";
//db.ExecuteNonQuery(sql, null);
}
private void button3_Click(object sender, EventArgs e)
{
string dbPath = connectionString;
//如果不存在改数据库文件，则创建该数据库文件
if (!System.IO.File.Exists(dbPath))
{
SQLiteDBHelper.CreateDB(connectionString);
}
string sqlcreatetab = "CREATE TABLE CriticalData" +
"(id integer IDENTITY(1,1) NOT NULL," +
"lcNum varchar(1,20) NOT NULL," +
"generatorId int NOT NULL," +
"oilPress real NOT NULL," +
"waterTemp real NOT NULL," +
"frequency real NOT NULL," +
"motorSpeed real NOT NULL," +
"voltage real NOT NULL," +
"current real NOT NULL," +
"motorPower real NOT NULL," +
"powerFactor real ," +
"oilMass real NOT NULL," +
"alarmValue int NOT NULL," +
"dateTime datetime NOT NULL)";
string Inspe = "CREATE TABLE InspectionRecords(" +
"id int IDENTITY(1,1) NOT NULL," +
"lcNum nchar(20) NOT NULL," +
"status nchar(10) NOT NULL," +
"planTime datetime NOT NULL," +
"recordTime datetime NULL," +
"worker nchar(20) NOT NULL," +
"remarks nchar(30) NULL)";
StringBuilder temperaturesql = new StringBuilder();
temperaturesql.Append(" CREATE TABLE tab_temperature (lcnum nvarchar(10) NULL,");
for (int i = 1; i <= 57; i++)
{
temperaturesql.Append("s" + i + " int NULL,t" + i + " real NULL,");
}
temperaturesql.Append("sendtime datetime NULL)");
SQLiteDBHelper db = new SQLiteDBHelper("");
bool result1 = db.ExecuteNonQuery(sqlcreatetab, null) > 0;
bool result2 = db.ExecuteNonQuery(Inspe, null) > 0;
bool result3 = db.ExecuteNonQuery(temperaturesql.ToString(), null) > 0;
if (result1 && result2 && result3)
{
MessageBox.Show("ok");
}
}
public static void CreateTable()
{
string EXEPath = System.AppDomain.CurrentDomain.SetupInformation.ApplicationBase;
string dbPath = EXEPath + "Demo.db3";
//如果不存在改数据库文件，则创建该数据库文件
if (!System.IO.File.Exists(dbPath))
{
SQLiteDBHelper.CreateDB(dbPath);
}
InitConsumableRecord();
//SQLiteDBHelper db = new SQLiteDBHelper(dbPath);
//string sql = "CREATE TABLE Test3(id integer NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,Name char(3),TypeName varchar(50),addDate datetime,UpdateTime Date,Time time,Comments blob)";
}
public static void CreateTable()
{
string dbPath = "D:\\Demo.db3";
//如果不存在改数据库文件，则创建该数据库文件
if (!System.IO.File.Exists(dbPath))
{
SQLiteDBHelper.CreateDB("D:\\Demo.db3");
}
SQLiteDBHelper db = new SQLiteDBHelper("D:\\Demo.db3");
string sql = "CREATE TABLE Test3(id integer NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,Name char(3),TypeName varchar(50),addDate datetime,UpdateTime Date,Time time,Comments blob)";
db.ExecuteNonQuery(sql, null);
}
public GreateDataBase()
{
string DataBase = "Log//Log.db";
SQLiteDBHelper.CreateLogDB(DataBase);
string DataPath = System.AppDomain.CurrentDomain.SetupInformation.ApplicationBase + @"Data";
DataBase = "Data//Data.db";
if (!System.IO.File.Exists(DataBase))
{
System.IO.Directory.CreateDirectory(DataPath);
SQLiteDBHelper.CreateDB(DataBase);
Lognet.Log.Warn("箱号数据库不存在，重新创建数据库");
}
}
void GetDataBase()
{
path = GetCurrentPath();
if (File.Exists(path))
{
db = new SQLiteDBHelper(path);
}
else
{
SQLiteDBHelper.CreateDB(path);
db = new SQLiteDBHelper(path);
string sql = "CREATE TABLE CodeMass(ID integer NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE," +
"CodeName char(40)," +
"Language char(3)," +
"Comments varchar(100)," +
"AddTime datetime,UpdateTime Date," +
"Source_Code Text)";
db.ExecuteNonQuery(sql, null);
}
}
private void GetSip2Form_Load(object sender, EventArgs e)
{
//获取基目录，它由程序集冲突解决程序用来探测程序集。
string dbPath = AppDomain.CurrentDomain.BaseDirectory + "Sip2Info.db";
SQLiteDBHelper db = new SQLiteDBHelper(dbPath);
//如果不存在数据库文件，则创建该数据库文件
if (!System.IO.File.Exists(dbPath))
{
SQLiteDBHelper.CreateDB(dbPath);
// 创建表
string sqlCreate = "CREATE TABLE Sip2Info(" +
"id integer NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE" +
",name varchar(500)" +
",ip varchar(500)" +
",port varchar(500)" +
",ao varchar(500)" +
",ap varchar(500)" +
",charset varchar(500)" +
",uid varchar(500)" +
",pwd varchar(500)" +
",VP varchar(500)" +
",locationcode varchar(500)" +
",readercode varchar(500)" +
",PIN varchar(500)" +
",bookcode varchar(500)" +
")";
db.ExecuteNonQuery(sqlCreate, null);
}
// 查询数据
string sql = "select id, name as 名称, ip, port, ao, ap, charset as 字符集, uid, pwd, vp, locationcode, readercode, pin, bookcode from Sip2Info";
DataTable dt = db.ExecuteDataTable(sql, null);
DataSet ds = new DataSet();
ds.Tables.Add(dt);
dgvSip2Server.DataSource = ds.Tables[0];
}
//创建curveName字典和数据库及其表
private void createCurveNameDictionaryAndDB()
{
//创建数据库
if (m_wellConfig_From.getwellcountPath() == "" || m_wellConfig_From.getwellcountPath() == null)
{
MessageBox.Show("未配置井路径，请配置！");
return;
}
String wellcountPath = m_wellConfig_From.getwellcountPath();
String wellcount = m_wellConfig_From.getwellcount();
String filename = wellcount + ".db3";
String dbPath = m_wellConfig_From.creatDirectory(wellcountPath, filename);
m_realDBHelper = m_wellConfig_From.getRealDBHelper();
m_realDBHelper.CreateDB(dbPath);
//m_realDBHelper.InsertWellInfo(dbPath);
m_dBHelper = new SQLiteDBHelper(dbPath);
m_dBHelper.CreateDB(dbPath);
List <String> serverTableList = new List <string>();
List <String> clientTableList = new List <string>();
DataTable curveNameTable = new DataTable();
List <String> curveNameList = new List <string>();
//获取Server和Client所选仪器及对应选择的表号
Dictionary <String, List <String> > selectServerToolDictionary = m_recConfig_Form.getSelectServerToolDictionary();
Dictionary <String, List <String> > selectClientToolDictionary = m_recConfig_Form.getSelectClientToolDictionary();
//创建曲线字典和wits表
if (selectServerToolDictionary != null)
{
foreach (String toolName in selectServerToolDictionary.Keys)
{
if (selectServerToolDictionary.TryGetValue(toolName, out serverTableList))
{
//根据toolName创建Wits表字典，供查询index对应的curveName（短助记符）
Dictionary <String, DataTable> curveNameDictionary = m_CurveNameDictionary.createDictionary(toolName, serverTableList);
m_curveNameDictionary.Add(toolName, m_CurveNameDictionary.createDictionary(toolName, serverTableList));
serverTableList.Clear();
//同一个仪器名下的wits表
Dictionary <String, WitsTable> witsTableDic = new Dictionary <string, WitsTable>();
//创建数据库表和WITS表
foreach (String tableNo in curveNameDictionary.Keys)
{
if (curveNameDictionary.TryGetValue(tableNo, out curveNameTable))
{
for (int i = 0; i < curveNameTable.Rows.Count; i++)
{
curveNameList.Add(curveNameTable.Rows[i][1].ToString());
}
m_dBHelper.CreateTabs(toolName, tableNo, curveNameList);
WitsTable witsTable = new WitsTable(toolName, tableNo, curveNameList);
witsTableDic.Add(tableNo, witsTable);
curveNameTable.Clear();
curveNameList.Clear();
}
}
m_witsTableDictionary.Add(toolName, witsTableDic);
}
}
}
if (selectClientToolDictionary != null)
{
foreach (String toolName in selectClientToolDictionary.Keys)
{
if (selectClientToolDictionary.TryGetValue(toolName, out clientTableList))
{
//根据toolName创建Wits表字典，供查询index对应的curveName（短助记符）
Dictionary <String, DataTable> curveNameDictionary = m_CurveNameDictionary.createDictionary(toolName, clientTableList);
m_curveNameDictionary.Add(toolName, m_CurveNameDictionary.createDictionary(toolName, clientTableList));
clientTableList.Clear();
//同一个仪器名下的wits表
Dictionary <String, WitsTable> witsTableDic = new Dictionary <string, WitsTable>();
//创建数据库表和WITS表
foreach (String tableNo in curveNameDictionary.Keys)
{
if (curveNameDictionary.TryGetValue(tableNo, out curveNameTable))
{
for (int i = 0; i < curveNameTable.Rows.Count; i++)
{
curveNameList.Add(curveNameTable.Rows[i][1].ToString());
}
m_dBHelper.CreateTabs(toolName, tableNo, curveNameList);
WitsTable witsTable = new WitsTable(toolName, tableNo, curveNameList);
witsTableDic.Add(tableNo, witsTable);
curveNameTable.Clear();
curveNameList.Clear();
}
}
m_witsTableDictionary.Add(toolName, witsTableDic);
}
}
}
}
private void SaveBtn_Click(object sender, EventArgs e)
{
//获取基目录，它由程序集冲突解决程序用来探测程序集。
string dbPath = AppDomain.CurrentDomain.BaseDirectory + "Sip2Info.db";
SQLiteDBHelper db = new SQLiteDBHelper(dbPath);
//如果不存在数据库文件，则创建该数据库文件
if (!System.IO.File.Exists(dbPath))
{
SQLiteDBHelper.CreateDB(dbPath);
// 创建表
string sql = "CREATE TABLE Sip2Info(" +
"id integer NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE" +
",name varchar(500)" +
",ip varchar(500)" +
",port varchar(500)" +
",ao varchar(500)" +
",ap varchar(500)" +
",charset varchar(500)" +
",uid varchar(500)" +
",pwd varchar(500)" +
",VP varchar(500)" +
",locationcode varchar(500)" +
",readercode varchar(500)" +
",PIN varchar(500)" +
",bookcode varchar(500)" +
")";
db.ExecuteNonQuery(sql, null);
}
// 添加数据
string name = txtName.Text;
string ip = txtIP.Text;
string port = txtPort.Text;
string ao = txtAO.Text;
string ap = txtAP.Text;
string charset = txtCharset.Text;
string uid = txtUserName.Text;
string pwd = txtPwd.Text;
string vp = cboxVP.Text;
string locationcode = txtLocationCode.Text;
string readercode = txtReaderCode.Text;
string pin = txtPIN.Text;
string bookcode = txtBookCode.Text;
SQLiteParameter[] ps =
{
new SQLiteParameter()
{
ParameterName = "id",
Value = id
},
new SQLiteParameter()
{
ParameterName = "name",
Value = name
},
new SQLiteParameter()
{
ParameterName = "ip",
Value = ip
},
new SQLiteParameter()
{
ParameterName = "port",
Value = port
},
new SQLiteParameter()
{
ParameterName = "ao",
Value = ao
},
new SQLiteParameter()
{
ParameterName = "ap",
Value = ap
},
new SQLiteParameter()
{
ParameterName = "charset",
Value = charset
},
new SQLiteParameter()
{
ParameterName = "uid",
Value = uid
},
new SQLiteParameter()
{
ParameterName = "pwd",
Value = pwd
},
new SQLiteParameter()
{
ParameterName = "vp",
Value = vp
},
new SQLiteParameter()
{
ParameterName = "locationcode",
Value = locationcode
},
new SQLiteParameter()
{
ParameterName = "readercode",
Value = readercode
},
new SQLiteParameter()
{
ParameterName = "pin",
Value = pin
},
new SQLiteParameter()
{
ParameterName = "bookcode",
Value = bookcode
},
};
if (id == 0)
{
string addSql = "Insert into Sip2Info(name, ip, port, ao, ap, charset, uid, pwd, vp, locationcode, readercode, pin, bookcode) values(@name, @ip, @port, @ao, @ap, @charset, @uid, @pwd, @vp, @locationcode, @readercode, @pin, @bookcode)";
db.ExecuteNonQuery(addSql, ps);
}
else
{
string updateSql = "update Sip2Info set name = @name, ip = @ip, port = @port, ao = @ao, ap = @ap, charset = @charset, uid = @uid , pwd = @pwd, vp = @vp, locationcode = @locationcode, readercode = @readercode, pin = @pin, bookcode = @bookcode where id = @id";
db.ExecuteNonQuery(updateSql, ps);
}
// 关闭窗口
this.Close();
if (getForm != null)
{
getForm.Reload();
}
}