public TypeBuilderBase(TypeDefinition type, string methodName) { this.type = type; this.methodName = methodName; Xml = new XmlBaseInfo(); Data = new DataBaseInfo(); FillBuilderBase(type); }
private void btn_import_Click(object sender, EventArgs e) { //导入Excel表格时将列展开,如果列显示不全可能缺少某列 int rst = 0; string rstmsg = ""; //获取文件数据 //rst = GetDataSet(out rstmsg); //if (rst != 1) //{ // MessageBox.Show(rstmsg); // return; //} btnRefresh_Click(null, null); //导入文件数据 if (ds == null) { MessageBox.Show("导入数据为空。"); return; } if (ds == null || ds.Tables == null || ds.Tables.Count < 1 || ds.Tables[0].Rows.Count < 1) { MessageBox.Show("导入数据为空。"); return; } CurrencyDal.CodeMaker.DataBase dal = new CurrencyDal.CodeMaker.DataBase(); IDbLink dldal = new DbLink(); DbLinkInfo dlinfo = new DbLinkInfo(); string tableName = ""; if (ckb_IsAddTable.Checked) { var lisitem = comboBoxDB.SelectedItem as ListItem; int DbLinkID = string.IsNullOrEmpty(lisitem.ID) ? 0 : int.Parse(lisitem.ID); dlinfo = dldal.DbLinkGetInfo(DbLinkID); tableName = tb_AddTableName.Text.Trim(); dinfo = new DbDataInfo(); dinfo.DbLinkID = DbLinkID; dinfo.DbName = dlinfo.DbName; dinfo.Name = tableName; dinfo.NameType = (int)DbDataTypeEnum.表; } else { dlinfo = dldal.DbLinkGetInfo(dinfo.DbLinkID); tableName = dinfo.Name; } List <string> fieldlist = new List <string>(); string field = tb_field.Text.Trim(); field = field.Replace(" ", ""); DataBaseInfo dbinfo = new DataBaseInfo(); int index = tabControl1.SelectedIndex; DataTable dt = ds.Tables[index]; #region 新建表 if (ckb_IsAddTable.Checked && dt != null && dt.Rows.Count > 0) { string sqlmsg = ""; CurrencyDal.CodeMaker.RunSql rdal = new CurrencyDal.CodeMaker.RunSql(); field = ""; StringBuilder sql = new StringBuilder(); tableName = tb_AddTableName.Text.Trim(); string sqljc = "select 1 As Num from " + tableName; DataSet dsjs = rdal.Run(dlinfo, sql.ToString(), out sqlmsg, out rstmsg); try { if (dsjs != null && dsjs.Tables[0] != null) { MessageBox.Show("表" + tableName + "已存在。"); return; } } catch { } sql.Append("Create Table "); sql.Append(tableName); sql.Append(" ( "); string createField = ""; string fieldType = ""; if (dlinfo.DbType == 1) { fieldType = "nvarchar"; } else if (dlinfo.DbType == 2) { fieldType = "nvarchar2"; } else if (dlinfo.DbType == 3) { fieldType = "nvarchar"; } else { fieldType = "nvarchar"; } for (int i = 0; i < dt.Columns.Count; i++) { string cname = dt.Columns[i].ColumnName; //sql.Append("[" + cname + "] [nvarchar](255) NULL,"); if (createField == "") { createField = cname + " " + fieldType + "(255) NULL"; } else { createField += "," + cname + " " + fieldType + "(255) NULL"; } if (field == "") { field = cname; } else { field += "," + cname; } } sql.Append(createField); sql.Append(")"); DataSet dset = rdal.Run(dlinfo, sql.ToString(), out sqlmsg, out rstmsg); } #endregion dbinfo = GetDbInfo(dinfo.DbLinkID); TableInfo tinfo = dbinfo.Tables[tableName]; rst = dal.ImportData(dlinfo, tinfo, field, dt, out rstmsg); MessageBox.Show(rstmsg); }
private async void DataBase_DataBaseInfoChanged(object sender, EventArgs e) { this.dataBaseInfo = this.dataBase.DataBaseInfo; await this.RefreshAsync(); }
public DataBaseDescriptor(Authentication authentication, DataBaseInfo dataBaseInfo) : base(authentication, null, DescriptorTypes.None) { this.dataBaseInfo = dataBaseInfo; this.Owner = this; }
public DataBaseItemViewModel(Authentication authentication, DataBaseInfo dataBaseInfo, object owner) : base(authentication, new DataBaseDescriptor(authentication, dataBaseInfo), owner) { }