/// <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); }