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)
{
}
