/// <summary>
/// 点击确定按钮时触发的事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_query_Click(object sender, EventArgs e)
{
//判断集中不能添加的情况
//信息为空，pberror可见
bool b1 = tb_dbname.Text.Trim().Equals(string.Empty);
bool b2 = cbb_leixing.Text.Trim().Equals(string.Empty);
bool b3 = pb_error.Visible;
if (b1 || b2 || b3)
{
MessageBox.Show("新建失败！");
return;
}
ChachongbiaoInfo myinfo = new ChachongbiaoInfo()
{
_mingcheng = tb_dbname.Text.Trim(),
_leixing = cbb_leixing.Text,
_chuangjianren = LoginInfo._huaming,
_chuangjianshijian = DateTime.Now.ToString()
};
//创建数据表并向数据库汇总表中添加新建信息
bool b = _mycontroller.CreateDB(myinfo);
if (b)
{
MessageBox.Show("新建数据库成功！");
this.DialogResult = DialogResult.OK;
}
}
/// <summary>
/// 创建数据表
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public bool CreateDB(ChachongbiaoInfo info)
{
string str_sql = $"CREATE TABLE jjdbwenbenjiexi.{info._mingcheng} (md5 varchar(100) NULL)";
_mysqlhelper.ExecuteNonQuery(str_sql);
str_sql = $"insert into jjdbwenbenjiexi.查重库信息表 values('{info._mingcheng}'," +
$"'{info._leixing}','{LoginInfo._huaming}','{info._chuangjianshijian}',0)";
int num = _mysqlhelper.ExecuteNonQuery(str_sql);
return(num > 0 ? true : false);
}
