?? frmmain.cs
字號:
this.lvMBZD.GridLines = true;
this.lvMBZD.Location = new System.Drawing.Point(0, 0);
this.lvMBZD.Name = "lvMBZD";
this.lvMBZD.Size = new System.Drawing.Size(726, 480);
this.lvMBZD.TabIndex = 9;
this.lvMBZD.View = System.Windows.Forms.View.Details;
this.lvMBZD.MouseDown += new System.Windows.Forms.MouseEventHandler(this.lvMBZD_MouseDown);
this.lvMBZD.DragDrop += new System.Windows.Forms.DragEventHandler(this.lvMBZD_DragDrop);
this.lvMBZD.DragEnter += new System.Windows.Forms.DragEventHandler(this.lvMBZD_DragEnter);
this.lvMBZD.ColumnClick += new System.Windows.Forms.ColumnClickEventHandler(this.lvMBZD_ColumnClick);
//
// splitter1
//
this.splitter1.BackColor = System.Drawing.Color.LightSteelBlue;
this.splitter1.Location = new System.Drawing.Point(152, 0);
this.splitter1.Name = "splitter1";
this.splitter1.Size = new System.Drawing.Size(3, 700);
this.splitter1.TabIndex = 1;
this.splitter1.TabStop = false;
//
// panLeft
//
this.panLeft.Controls.Add(this.lbMBB);
this.panLeft.Controls.Add(this.panel6);
this.panLeft.Dock = System.Windows.Forms.DockStyle.Left;
this.panLeft.Location = new System.Drawing.Point(0, 0);
this.panLeft.Name = "panLeft";
this.panLeft.Size = new System.Drawing.Size(152, 700);
this.panLeft.TabIndex = 0;
//
// lbMBB
//
this.lbMBB.Dock = System.Windows.Forms.DockStyle.Fill;
this.lbMBB.ItemHeight = 12;
this.lbMBB.Location = new System.Drawing.Point(0, 24);
this.lbMBB.Name = "lbMBB";
this.lbMBB.Size = new System.Drawing.Size(152, 676);
this.lbMBB.TabIndex = 15;
this.lbMBB.SelectedIndexChanged += new System.EventHandler(this.lbMBB_SelectedIndexChanged);
//
// panel6
//
this.panel6.BackColor = System.Drawing.Color.LightSteelBlue;
this.panel6.Controls.Add(this.lbTarget);
this.panel6.Dock = System.Windows.Forms.DockStyle.Top;
this.panel6.Location = new System.Drawing.Point(0, 0);
this.panel6.Name = "panel6";
this.panel6.Size = new System.Drawing.Size(152, 24);
this.panel6.TabIndex = 0;
this.panel6.Paint += new System.Windows.Forms.PaintEventHandler(this.panel6_Paint);
//
// lbTarget
//
this.lbTarget.AutoSize = true;
this.lbTarget.Font = new System.Drawing.Font("宋體", 10.5F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.lbTarget.ForeColor = System.Drawing.Color.DarkMagenta;
this.lbTarget.Location = new System.Drawing.Point(0, 5);
this.lbTarget.Name = "lbTarget";
this.lbTarget.Size = new System.Drawing.Size(121, 19);
this.lbTarget.TabIndex = 1;
this.lbTarget.Text = "=====目標表=====";
this.lbTarget.Click += new System.EventHandler(this.label3_Click);
//
// splitter2
//
this.splitter2.BackColor = System.Drawing.Color.LightSteelBlue;
this.splitter2.Dock = System.Windows.Forms.DockStyle.Right;
this.splitter2.Location = new System.Drawing.Point(885, 0);
this.splitter2.Name = "splitter2";
this.splitter2.Size = new System.Drawing.Size(3, 704);
this.splitter2.TabIndex = 1;
this.splitter2.TabStop = false;
//
// panRight
//
this.panRight.Controls.Add(this.lbYB);
this.panRight.Controls.Add(this.panel3);
this.panRight.Dock = System.Windows.Forms.DockStyle.Right;
this.panRight.Location = new System.Drawing.Point(888, 0);
this.panRight.Name = "panRight";
this.panRight.Size = new System.Drawing.Size(136, 704);
this.panRight.TabIndex = 0;
//
// lbYB
//
this.lbYB.Dock = System.Windows.Forms.DockStyle.Fill;
this.lbYB.ItemHeight = 12;
this.lbYB.Location = new System.Drawing.Point(0, 24);
this.lbYB.Name = "lbYB";
this.lbYB.Size = new System.Drawing.Size(136, 676);
this.lbYB.TabIndex = 7;
this.lbYB.SelectedIndexChanged += new System.EventHandler(this.lbYB_SelectedIndexChanged);
//
// panel3
//
this.panel3.BackColor = System.Drawing.Color.LightSteelBlue;
this.panel3.Controls.Add(this.lbSource);
this.panel3.Dock = System.Windows.Forms.DockStyle.Top;
this.panel3.ForeColor = System.Drawing.Color.Transparent;
this.panel3.Location = new System.Drawing.Point(0, 0);
this.panel3.Name = "panel3";
this.panel3.Size = new System.Drawing.Size(136, 24);
this.panel3.TabIndex = 5;
this.panel3.Paint += new System.Windows.Forms.PaintEventHandler(this.panel3_Paint);
//
// lbSource
//
this.lbSource.AutoSize = true;
this.lbSource.BackColor = System.Drawing.Color.LightSteelBlue;
this.lbSource.Font = new System.Drawing.Font("宋體", 10.5F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.lbSource.ForeColor = System.Drawing.Color.DarkMagenta;
this.lbSource.Location = new System.Drawing.Point(0, 8);
this.lbSource.Name = "lbSource";
this.lbSource.Size = new System.Drawing.Size(106, 19);
this.lbSource.TabIndex = 0;
this.lbSource.Text = "=====原表=====";
//
// oleY
//
this.oleY.ConnectionString = "User ID=sa;Data Source=ZM;Tag with column collation when possible=False;Initial C" +
"atalog=cs;Use Procedure for Prepare=1;Auto Translate=True;Persist Security Info=" +
"False;Provider=SQLOLEDB;Workstation ID=ZM;Use Encryption for Data=False;Packet S" +
"ize=4096";
//
// label2
//
this.label2.AutoSize = true;
this.label2.BackColor = System.Drawing.SystemColors.Control;
this.label2.Font = new System.Drawing.Font("宋體", 10.5F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.label2.Location = new System.Drawing.Point(8, 8);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(0, 19);
this.label2.TabIndex = 0;
//
// frmMain
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.BackColor = System.Drawing.SystemColors.InactiveCaption;
this.ClientSize = new System.Drawing.Size(1024, 704);
this.Controls.Add(this.panel1);
this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon")));
this.Menu = this.mm;
this.Name = "frmMain";
this.Text = "數據轉換工具";
this.WindowState = System.Windows.Forms.FormWindowState.Maximized;
this.Load += new System.EventHandler(this.frmMain_Load);
this.panel1.ResumeLayout(false);
this.panel5.ResumeLayout(false);
this.panCenter.ResumeLayout(false);
this.panel8.ResumeLayout(false);
this.panLeft.ResumeLayout(false);
this.panel6.ResumeLayout(false);
this.panRight.ResumeLayout(false);
this.panel3.ResumeLayout(false);
this.ResumeLayout(false);
}
#endregion
/// <summary>
/// The main entry point for the application.
/// </summary>
[STAThread]
static void Main()
{
Application.Run(new frmMain());
}
private void miYSJY_Click(object sender, System.EventArgs e)
{
lbYB.Items.Clear();
frmYSJY winYSJY=new frmYSJY();
winYSJY.ShowDialog();
if(oleY.State==System.Data.ConnectionState.Open)
oleY.Close();
oleY.ConnectionString=winYSJY.strConn;
try
{
oleY.Open();
}
catch(System.Exception a)
{
MessageBox.Show("*****連接目標數據庫失敗！("+a.Message+")*****");
return;
}
DataTable t = oleY.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables,new object[]{null, null, null, "Link"});
foreach(DataRow ds in t.Rows)
{
lbYB.Items.Add(ds[2]);
}
t.Clear();
t = oleY.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables,new object[]{null, null, null, "TABLE"});
foreach(DataRow ds in t.Rows)
{
lbYB.Items.Add(ds[2]);
}
oleY.Close();
}
private void miMBSJY_Click(object sender, System.EventArgs e)
{
frmMBSJY winMBSJY=new frmMBSJY();
winMBSJY.ShowDialog();
if(trans.TargetConn.State==System.Data.ConnectionState.Open)
trans.TargetConn.Close();
trans.TargetConn.ConnectionString=winMBSJY.strConn;
try
{
trans.TargetConn.Open();
}
catch(System.Data.OleDb.OleDbException a)
{
MessageBox.Show("*****連接目標數據庫失敗！("+a.Message+")*****");
return;
}
DataTable t = trans.TargetConn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables,new object[]{null, null, null, "TABLE"});
foreach(DataRow ds in t.Rows)
{
lbMBB.Items.Add(ds[2]);
}
trans.TargetConn.Close();
}
private void lbYB_SelectedIndexChanged(object sender, System.EventArgs e)
{
if(trans.SourceTable.Count<=0)
trans.SourceTable.Add(lbYB.Items[lbYB.SelectedIndex].ToString());
else
trans.SourceTable[0]=lbYB.Items[lbYB.SelectedIndex].ToString();
_alSourceField=GetFieldListbyTN(trans.SourceConn,trans.SourceTable[0].ToString());
if(winYBJG==null )
{
winYBJG=new frmYBJG(lbYB.SelectedItem.ToString(),_alSourceField);
}
else
{
if( winYBJG.strTableName!=lbYB.SelectedItem.ToString())
{
winYBJG.Dispose();
winYBJG=new frmYBJG(lbYB.SelectedItem.ToString(),_alSourceField);
}
}
winYBJG.Show();
}
/// <summary>
/// 獲得指定表的字段列表
/// </summary>
/// <param name="oleConn">目標連接</param>
/// <param name="strTN">指定的表名</param>
/// <returns>字段列表</returns>
private ArrayList GetFieldListbyTN(OleDbConnection oleConn,string strTN)
{
ArrayList strsRe=new ArrayList();
if(oleConn.State==System.Data.ConnectionState.Closed)
oleConn.Open();
/*if(oleConn.State==System.Data.ConnectionState.Closed)
oleConn.Open();*/
DataTable schemaTable = oleConn.GetOleDbSchemaTable(OleDbSchemaGuid.Columns,new Object[] {null, null, strTN, null});
//strsRe=new string[schemaTable.Rows.Count];
for (int i = 0; i < schemaTable.Rows.Count; i++)
{
strsRe.Add(schemaTable.Rows[i].ItemArray[3].ToString());
}
return strsRe;
}
private ArrayList GetFieldListTypesbyTN(OleDbConnection oleT,string strTN)
{
if(oleT.State==System.Data.ConnectionState.Closed)
oleT.Open();
System.Data.OleDb.OleDbCommand dc =oleT.CreateCommand();//創建一個執行對象用于執行sql查詢
dc.CommandText= "select * from " + strTN.Trim() + " where 1=0";
System.Data.OleDb.OleDbDataReader dr = dc.ExecuteReader();//執行sql查詢
DataTable schemaTable = dr.GetSchemaTable();
ArrayList fieldsLX=new ArrayList();
for(int i = 0;i < schemaTable.Columns.Count;i++)
if(schemaTable.Columns[i].ColumnName.IndexOf("DataType") >= 0)
for(int k = 0;k < schemaTable.Rows.Count;k++)
fieldsLX.Add(schemaTable.Rows[k].ItemArray[i].ToString());
dr.Close();
dc.Dispose();
oleT.Close();
return fieldsLX;
}
/// <summary>
/// 獲得制定表名的所有字段名和字段類型
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -