/// <summary>
/// 该方法用于添加新数据库
/// </summary>
public void AddDatabase()
{
WinFormAddDatabase mywinform = new WinFormAddDatabase();
mywinform.StartPosition = System.Windows.Forms.FormStartPosition.CenterParent;
if (mywinform.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
string tablename = mywinform.tablename;
string leixing = mywinform.leixing;
if (leixing.Equals("标准句"))
{
string str_sql = $"CREATE TABLE {tablename}(xuhao UInt8,bianhao String,shijian Date,laiyuan String,neirong String,redu UInt16) " +
$"ENGINE MergeTree() " +
$"PARTITION BY shijian " +
$"ORDER BY xuhao ";
mydb.ExecuteNonQuery(str_sql);
System.Windows.Forms.MessageBox.Show($"数据表 {tablename} 已成功添加!");
}
else if ((leixing.Equals("标准正文")))
{
string str_sql = $"CREATE TABLE {tablename}(xuhao UInt8,bianhao String,shijian Date,laiyuan String,zhengwenneirong String) " +
$"ENGINE MergeTree() " +
$"PARTITION BY shijian " +
$"ORDER BY xuhao ";
//$"PRIMARY KEY bianhao";
mydb.Open();
mydb.ExecuteNonQuery(str_sql);
System.Windows.Forms.MessageBox.Show($"数据表 {tablename} 已成功添加!");
}
}
}
private void pb_adddb_Click(object sender, EventArgs e)
{
WinFormAddDatabase mywin = new WinFormAddDatabase()
{
StartPosition = FormStartPosition.CenterParent
};
if (mywin.ShowDialog() == DialogResult.OK)
{
//在数据库中新建一个表
string tn = mywin.tablename;
_myc.CreateTable(tn);
MessageBox.Show("创建数据库成功！");
}
}
