private void excel2btn_Click(object sender, EventArgs e)
{
var inputlist = new Dictionary <string, List <string> >();
for (var i = 0; i < node.Nodes.Count; i++)
{
var curnode = node.Nodes[i];
var str = new StringBuilder();
var dicitem = dic[curnode.Text];
if (curnode.Checked)
{
var alldata = new List <string>();
var cols = ds.Data.Tables[curnode.Text];
//处理表名
str.Append($"{curnode.Text}\t{dicitem}");
str.Append("\n");
//处理header
foreach (DataColumn item in cols.Columns)
{
str.Append($"{item.Caption}\t");
}
str.Append("\n");
//处理行
foreach (DataRow item in cols.Rows)
{
StringBuilder sb = new StringBuilder();
for (var p = 0; p < cols.Columns.Count; p++)
{
sb.Append($"{item[p].ToString()}\t");
}
sb.Append("\n");
str.Append(sb.ToString());
}
alldata = str.ToString().Split(new char[] { '\n' }, StringSplitOptions.RemoveEmptyEntries).ToList();
inputlist.Add(curnode.Text, alldata);
}
}
var db = new Datebasemodel();
db.Dbip = Dbip.Text;
db.Dbtype = Dbtype.SelectedItem.ToString();
db.Dbname = Dbname.Text;
db.Dbport = Dbport.Text;
db.Useraccount = Useraccount.Text;
db.Userpassword = Userpassword.Text;
db.Name = Name.Text;
//结果str
StringBuilder resstr = new StringBuilder();
foreach (var item in inputlist)
{
var res = CreateTableLogic.CreateTble(item.Value, true, db);
resstr.AppendLine($"{item.Key}表:{res.Message}");
}
this.excel2result.Text = resstr.ToString();
}
private void consql_Click(object sender, EventArgs e)
{
var model = new Datebasemodel();
model.Dbip = Dbip.Text;
model.Dbport = Dbport.Text;
model.Dbtype = Dbtype.Text;
model.Useraccount = Useraccount.Text;
model.Userpassword = Userpassword.Text;
DbConnection conn = CreateTableLogic.GetConnByType(model);
if (conn == null)
{
MessageBox.Show("连接失败");
}
else
{
MessageBox.Show("连接成功");
}
}
private void Createtablebtn_Click(object sender, EventArgs e)
{
var db = new Datebasemodel();
db.Dbip = Dbip.Text;
db.Dbtype = Dbtype.SelectedItem.ToString();
db.Dbname = Dbname.Text;
db.Dbport = Dbport.Text;
db.Useraccount = Useraccount.Text;
db.Userpassword = Userpassword.Text;
db.Name = Name.Text;
var alldata = this.tableinfo.Text.Split(new char[] { '\n' }, StringSplitOptions.RemoveEmptyEntries)?.ToList();
var res = CreateTableLogic.CreateTble(alldata, this.Isdrop.Checked, db);
if (res.IsSucceed)
{
this.Resultrichnew.Text = res.Message;
}
else
{
this.Resultrichnew.Text = "创建失败";
}
}