/// <summary>
/// 该方法用于删除数据库中的格式设置信息
/// </summary>
/// <param name="formatname"></param>
public void DeleteFormat(string formatname, string tablename)
{
string str_sql = $"alter table {tablename} delete where geshimingcheng='{formatname}'";
chhelper.SelectDB("default");
chhelper.DoSQL(str_sql);
}
/// <summary>
/// 该方法用于获得指定格式下所有设置
/// </summary>
/// <param name="formatname"></param>
/// <returns></returns>
public Dictionary <string, object> GetSetting(string formatname)
{
string str_sql = $"select * from zhengwensetting where geshimingcheng='{formatname}'";
chhelper.SelectDB("default");
var dt = chhelper.GetDataFromTable(str_sql);
Dictionary <string, object> dic = new Dictionary <string, object>();
DataRow mydr = dt.Rows[0];
dic.Add("下划线", mydr["xiahuaxian"].ToString() == "1" ? true : false);
dic.Add("正文查重", mydr["zhengwenchachong"].ToString() == "1" ? true : false);
dic.Add("词句查重", mydr["cijuchachong"].ToString() == "1" ? true : false);
dic.Add("尾注", mydr["weizhu"].ToString() == "1" ? true : false);
dic.Add("重复率前", mydr["chongfulvqian"].ToString() == "1" ? true : false);
dic.Add("重复率后", mydr["chongfulvhou"].ToString() == "1" ? true : false);
dic.Add("删除100", mydr["shanchu100"].ToString() == "1" ? true : false);
dic.Add("日志路径", mydr["rizhilujing"].ToString());
dic.Add("路径100", mydr["lujing100"].ToString());
dic.Add("路径非100", mydr["lujingfei100"].ToString());
dic.Add("自动导出", mydr["zidongdaochu"].ToString() == "1" ? true : false);
dic.Add("词句查重表", mydr["cijuchachongbiao"].ToString());
dic.Add("正文查重表", mydr["zhengwenchachongbiao"].ToString());
dic.Add("正文入库", mydr["zhengwenruku"].ToString() == "1" ? true : false);
dic.Add("词句入库", mydr["cijuruku"].ToString() == "1" ? true : false);
dic.Add("正文入库表", mydr["zhengwenrukubiao"].ToString());
dic.Add("词句入库表", mydr["cijurukubiao"].ToString());
dic.Add("日期", Convert.ToDateTime(mydr["shijian"].ToString()));
return(dic);
}
/// <summary>
/// 数据表名称标题发生改变时触发的事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Lbl_dbname_TextChanged(object sender, EventArgs e)
{
//获得数据表名称
string shtname = lbl_dbname.Text;
Setting._currentdb = shtname;
//获得该表下数据datatable
string str_sql = $"select * from {shtname}";
mycontroller.SelectDB("default");
DataTable mydt = mycontroller.GetDataFromTable(str_sql);
lbl_shuliang.Text = $"（{mydt.Rows.Count} 条）";
//将数据绑定到dgv_data
CommonMethod.AddXuhao(mydt);
dgv_data.DataSource = null;
dgv_data.DataSource = mydt;
}
private void WinFormSelectDb_Load(object sender, EventArgs e)
{
//获得数据所有表明
//string dbfile = $"{Environment.CurrentDirectory}\\ruitengdb.db";
string dbfile = "select name from tables where database='default'";
mycontroller.SelectDB("system");
var dt = mycontroller.GetDataFromTable(dbfile);
List <string> listtablename = new List <string>();
for (int i = 0; i < dt.Rows.Count; i++)
{
string tablename = dt.Rows[i]["name"].ToString();
if (!listtablename.Contains(tablename))
{
listtablename.Add(dt.Rows[i]["name"].ToString());
}
}
lb_db.Items.AddRange(listtablename.ToArray());
}