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; }