public DbToScript(string longservername, string dbname)
{
InitializeComponent();
DbName = dbname;
dsb = ObjHelper.CreatDsb(longservername);
dbobj = ObjHelper.CreatDbObj(longservername);
this.lblServer.Text = longservername;
List <string> dblist = dbobj.GetDBList();
if (dblist != null)
{
if (dblist.Count > 0)
{
foreach (string name in dblist)
{
this.cmbDB.Items.Add(name);
}
}
}
//DataTable dt = dbobj.GetDBList();
//if (dt != null)
//{
// foreach (DataRow row in dt.Rows)
// {
// this.cmbDB.Items.Add(row["name"].ToString());
// }
//}
this.btn_Creat.Enabled = false;
this.cmbDB.Text = DbName;
}
//创建数据库信息类接口
public static LTP.IDBO.IDbObject CreatDbObj(string longservername)
{
LTP.CmConfig.DbSettings dbset = LTP.CmConfig.DbConfig.GetSetting(longservername);
LTP.IDBO.IDbObject dbobj = LTP.DBFactory.DBOMaker.CreateDbObj(dbset.DbType);
dbobj.DbConnectStr = dbset.ConnectStr;
return(dbobj);
}
public void SetListView(DbView dbviewfrm)
{
#region 得到类型对象
TreeNode SelNode = dbviewfrm.treeView1.SelectedNode;
if (SelNode == null)
{
return;
}
switch (SelNode.Tag.ToString())
{
case "table":
{
servername = SelNode.Parent.Parent.Parent.Text;
dbname = SelNode.Parent.Parent.Text;
tablename = SelNode.Text;
dbobj = ObjHelper.CreatDbObj(servername);
SetListViewMenu("column");
BindlistViewCol(dbname, tablename);
}
break;
case "view":
{
servername = SelNode.Parent.Parent.Parent.Text;
dbname = SelNode.Parent.Parent.Text;
tablename = SelNode.Text;
dbobj = ObjHelper.CreatDbObj(servername);
SetListViewMenu("column");
BindlistViewCol(dbname, tablename);
}
break;
case "column":
{
servername = SelNode.Parent.Parent.Parent.Parent.Text;
dbname = SelNode.Parent.Parent.Parent.Text;
tablename = SelNode.Parent.Text;
dbobj = ObjHelper.CreatDbObj(servername);
SetListViewMenu("column");
BindlistViewCol(dbname, tablename);
}
break;
default:
{
this.listView1.Items.Clear();
}
break;
}
if (dbobj != null)
{
cb = new CodeBuilders(dbobj);
}
#endregion
}
public DataExport(string longservername, string dbname)
{
InitializeComponent();
DbName = dbname;
dbset = LTP.CmConfig.DbConfig.GetSetting(longservername);
dbobj = LTP.DBFactory.DBOMaker.CreateDbObj(dbset.DbType);
dbobj.DbConnectStr = dbset.ConnectStr;
cb = new LTP.CodeBuild.CodeBuilders(dbobj);
dsb = LTP.DBFactory.DBOMaker.CreateScript(dbset.DbType);// ObjHelper.CreatDsb(longservername);
this.lblServer.Text = dbset.Server;
}
public DataList(LTP.IDBO.IDbObject idbobj, string dbName, string tabName)
{
InitializeComponent();
try
{
dbobj = idbobj;
dbname = dbName;
tabname = tabName;
StatusLabel_dbname.Text = "库:" + dbname + "，表:" + tabname + " ";
mythread = new Thread(new ThreadStart(ThreadWork));
mythread.Start();
//ThreadWork();
}
catch (System.Exception er)
{
//MessageBox.Show(er.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
}
public DbToScript(string longservername)
{
InitializeComponent();
dsb = ObjHelper.CreatDsb(longservername);
dbobj = ObjHelper.CreatDbObj(longservername);
int s = longservername.IndexOf("(");
string server = longservername.Substring(0, s);
this.lblServer.Text = server;
List <string> dblist = dbobj.GetDBList();
if (dblist != null)
{
if (dblist.Count > 0)
{
foreach (string dbname in dblist)
{
this.cmbDB.Items.Add(dbname);
}
}
}
//DataTable dt = dbobj.GetDBList();
//if (dt != null)
//{
// foreach (DataRow row in dt.Rows)
// {
// string dbname = row["name"].ToString();
// this.cmbDB.Items.Add(dbname);
// }
//}
this.btn_Creat.Enabled = false;
if (cmbDB.Items.Count > 0)
{
this.cmbDB.SelectedIndex = 0;
}
}
private void CreatDbObj(string servername)
{
LTP.CmConfig.DbSettings dbset = LTP.CmConfig.DbConfig.GetSetting(servername);
dbobj = LTP.DBFactory.DBOMaker.CreateDbObj(dbset.DbType);
dbobj.DbConnectStr = dbset.ConnectStr;
}
