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 Adddbconfig_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; db.Addtime = DateTime.Now; var configfilename = AppDomain.CurrentDomain.BaseDirectory + "datebaseconfig.txt"; if (File.Exists(configfilename)) { var text = File.ReadAllText(configfilename); var list = new List <Datebasemodel>(); if (text.Length > 0) { try { list = JsonConvert.DeserializeObject <List <Datebasemodel> >(text); } catch { } } list.Add(db); var insertstr = JsonConvert.SerializeObject(list); File.WriteAllText(configfilename, insertstr); SetParent(db.Name); MessageBox.Show("配置成功"); this.Close(); } 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 = "创建失败"; } }