一个简单的代码生成“器”

'//一个简单的代码生成“器”

'//在比较大的数据库操作时，对字段操作有好多变量、属性、函数的类似的重复性的大量代码

'//如果一个个来重写，确是令人烦躁的事，因此自己弄了一个小程序作这部分工作。

Public Class FrmPropertyCode

Inherits System.Windows.Forms.Form

#Region " Windows 窗体设计器生成的代码 "

Public Sub New()

MyBase.New()

'该调用是 Windows 窗体设计器所必需的。

InitializeComponent()

'在 InitializeComponent() 调用之后添加任何初始化

Initialize()

End Sub

'窗体重写 dispose 以清理组件列表。

Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)

If disposing Then

If Not (components Is Nothing) Then

components.Dispose()

End If

MyBase.Dispose(disposing)

End Sub

'Windows 窗体设计器所必需的

Private components As System.ComponentModel.IContainer

'注意: 以下过程是 Windows 窗体设计器所必需的

'可以使用 Windows 窗体设计器修改此过程。

'不要使用代码编辑器修改它。

Friend WithEvents VariableTextBox As System.Windows.Forms.TextBox

Friend WithEvents CodeTextBox As System.Windows.Forms.TextBox

Friend WithEvents PropertyComboBox As System.Windows.Forms.ComboBox

Friend WithEvents PropertyTextBox As System.Windows.Forms.TextBox

Friend WithEvents SavePropertyButton As System.Windows.Forms.Button

Friend WithEvents BuildCodeButton As System.Windows.Forms.Button

Friend WithEvents Label1 As System.Windows.Forms.Label

Friend WithEvents Label2 As System.Windows.Forms.Label

Friend WithEvents Label3 As System.Windows.Forms.Label

Friend WithEvents Label4 As System.Windows.Forms.Label

<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()

Dim resources As System.Resources.ResourceManager = New System.Resources.ResourceManager(GetType(FrmPropertyCode))

Me.VariableTextBox = New System.Windows.Forms.TextBox

Me.CodeTextBox = New System.Windows.Forms.TextBox

Me.PropertyComboBox = New System.Windows.Forms.ComboBox

Me.PropertyTextBox = New System.Windows.Forms.TextBox

Me.SavePropertyButton = New System.Windows.Forms.Button

Me.BuildCodeButton = New System.Windows.Forms.Button

Me.Label1 = New System.Windows.Forms.Label

Me.Label2 = New System.Windows.Forms.Label

Me.Label3 = New System.Windows.Forms.Label

Me.Label4 = New System.Windows.Forms.Label

Me.SuspendLayout()

'VariableTextBox

Me.VariableTextBox.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Bottom) _

Or System.Windows.Forms.AnchorStyles.Left), System.Windows.Forms.AnchorStyles)

Me.VariableTextBox.Location = New System.Drawing.Point(8, 48)

Me.VariableTextBox.Multiline = True

Me.VariableTextBox.Name = "VariableTextBox"

Me.VariableTextBox.ScrollBars = System.Windows.Forms.ScrollBars.Both

Me.VariableTextBox.Size = New System.Drawing.Size(168, 176)

Me.VariableTextBox.TabIndex = 0

Me.VariableTextBox.Text = ""

'CodeTextBox

Me.CodeTextBox.Anchor = CType((((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Bottom) _

Or System.Windows.Forms.AnchorStyles.Left) _

Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)

Me.CodeTextBox.BackColor = System.Drawing.SystemColors.Info

Me.CodeTextBox.Location = New System.Drawing.Point(192, 48)

Me.CodeTextBox.Multiline = True

Me.CodeTextBox.Name = "CodeTextBox"

Me.CodeTextBox.ScrollBars = System.Windows.Forms.ScrollBars.Both

Me.CodeTextBox.Size = New System.Drawing.Size(344, 176)

Me.CodeTextBox.TabIndex = 1

Me.CodeTextBox.Text = ""

'PropertyComboBox

Me.PropertyComboBox.Anchor = CType((System.Windows.Forms.AnchorStyles.Bottom Or System.Windows.Forms.AnchorStyles.Left), System.Windows.Forms.AnchorStyles)

Me.PropertyComboBox.BackColor = System.Drawing.SystemColors.Info

Me.PropertyComboBox.Location = New System.Drawing.Point(88, 240)

Me.PropertyComboBox.Name = "PropertyComboBox"

Me.PropertyComboBox.Size = New System.Drawing.Size(224, 20)

Me.PropertyComboBox.TabIndex = 2

'PropertyTextBox

Me.PropertyTextBox.Anchor = CType(((System.Windows.Forms.AnchorStyles.Bottom Or System.Windows.Forms.AnchorStyles.Left) _

Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)

Me.PropertyTextBox.BackColor = System.Drawing.SystemColors.Info

Me.PropertyTextBox.Location = New System.Drawing.Point(8, 296)

Me.PropertyTextBox.Multiline = True

Me.PropertyTextBox.Name = "PropertyTextBox"

Me.PropertyTextBox.ScrollBars = System.Windows.Forms.ScrollBars.Both

Me.PropertyTextBox.Size = New System.Drawing.Size(536, 112)

Me.PropertyTextBox.TabIndex = 3

Me.PropertyTextBox.Text = ""

'SavePropertyButton

Me.SavePropertyButton.Anchor = CType((System.Windows.Forms.AnchorStyles.Bottom Or System.Windows.Forms.AnchorStyles.Left), System.Windows.Forms.AnchorStyles)

Me.SavePropertyButton.FlatStyle = System.Windows.Forms.FlatStyle.Flat

Me.SavePropertyButton.Location = New System.Drawing.Point(320, 240)

Me.SavePropertyButton.Name = "SavePropertyButton"

Me.SavePropertyButton.Size = New System.Drawing.Size(104, 32)

Me.SavePropertyButton.TabIndex = 4

Me.SavePropertyButton.Text = "保存样式"

'BuildCodeButton

Me.BuildCodeButton.Anchor = CType((System.Windows.Forms.AnchorStyles.Bottom Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)

Me.BuildCodeButton.FlatStyle = System.Windows.Forms.FlatStyle.Flat

Me.BuildCodeButton.Location = New System.Drawing.Point(432, 240)

Me.BuildCodeButton.Name = "BuildCodeButton"

Me.BuildCodeButton.Size = New System.Drawing.Size(104, 32)

Me.BuildCodeButton.TabIndex = 5

Me.BuildCodeButton.Text = "生成代码"

'Label1

Me.Label1.Anchor = CType((System.Windows.Forms.AnchorStyles.Bottom Or System.Windows.Forms.AnchorStyles.Left), System.Windows.Forms.AnchorStyles)

Me.Label1.Location = New System.Drawing.Point(8, 240)

Me.Label1.Name = "Label1"

Me.Label1.Size = New System.Drawing.Size(80, 23)

Me.Label1.TabIndex = 6

Me.Label1.Text = "样式选择:"

'Label2

Me.Label2.Location = New System.Drawing.Point(8, 16)

Me.Label2.Name = "Label2"

Me.Label2.Size = New System.Drawing.Size(88, 23)

Me.Label2.TabIndex = 7

Me.Label2.Text = "变量框:"

'Label3

Me.Label3.Location = New System.Drawing.Point(192, 16)

Me.Label3.Name = "Label3"

Me.Label3.Size = New System.Drawing.Size(96, 23)

Me.Label3.TabIndex = 8

Me.Label3.Text = "代码框:"

'Label4

Me.Label4.Anchor = CType((System.Windows.Forms.AnchorStyles.Bottom Or System.Windows.Forms.AnchorStyles.Left), System.Windows.Forms.AnchorStyles)

Me.Label4.Location = New System.Drawing.Point(8, 272)

Me.Label4.Name = "Label4"

Me.Label4.Size = New System.Drawing.Size(96, 17)

Me.Label4.TabIndex = 9

Me.Label4.Text = "样式框:"

'FrmPropertyCode

Me.AutoScaleBaseSize = New System.Drawing.Size(6, 14)

Me.ClientSize = New System.Drawing.Size(552, 421)

Me.Controls.Add(Me.Label4)

Me.Controls.Add(Me.Label3)

Me.Controls.Add(Me.Label2)

Me.Controls.Add(Me.Label1)

Me.Controls.Add(Me.BuildCodeButton)

Me.Controls.Add(Me.SavePropertyButton)

Me.Controls.Add(Me.PropertyTextBox)

Me.Controls.Add(Me.CodeTextBox)

Me.Controls.Add(Me.VariableTextBox)

Me.Controls.Add(Me.PropertyComboBox)

Me.Icon = CType(resources.GetObject("$this.Icon"), System.Drawing.Icon)

Me.Name = "FrmPropertyCode"

Me.Text = "属性代码生成器"

Me.ResumeLayout(False)

End Sub

#End Region

'//以下为添加代码

Private ds As New DataSet

'//以下两个变量存放当前记录值，在SavePropertyButton函数中用来判断进行相关操作

Private CurrentName As String = ""

Private CurrentText As String = ""

Private WithEvents Manager As CurrencyManager

Private Sub Initialize()

Application.DoEvents()

'//读取XML架构文件

ds.ReadXmlSchema("Property.xsd")

'//读取XML数据文件

ds.ReadXml("Property.xml")

Me.PropertyComboBox.DataSource = ds.Tables(0)

Me.PropertyComboBox.DisplayMember = "Name"

Me.PropertyTextBox.DataBindings.Add(New Binding("Text", ds.Tables(0), "Text"))

Manager = CType(Me.BindingContext(ds.Tables(0)), CurrencyManager)

End Sub

Private Sub SavePropertyButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SavePropertyButton.Click

'//改名

If Not Me.PropertyComboBox.Text.Equals(CurrentName) AndAlso Me.PropertyTextBox.Text.Equals(CurrentText) Then

CType(Manager.Current, DataRowView).Row("Name") = Me.PropertyComboBox.Text

End If

'//改内容

If Me.PropertyComboBox.Text.Equals(CurrentName) AndAlso Not Me.PropertyTextBox.Text.Equals(CurrentText) Then

CType(Manager.Current, DataRowView).Row("Text") = Me.PropertyTextBox.Text

End If

'//新增

If Not Me.PropertyComboBox.Text.Equals(CurrentName) AndAlso Not Me.PropertyTextBox.Text.Equals(CurrentText) Then

CType(Manager.Current, DataRowView).Row("Text") = CurrentText

Dim Row As DataRow = ds.Tables(0).NewRow

Row("Name") = Me.PropertyComboBox.Text

Row("Text") = Me.PropertyTextBox.Text

ds.Tables(0).Rows.Add(Row)

End If

ds.Tables(0).AcceptChanges()

'//保存数据

ds.WriteXml("Property.Xml")

Manager.Refresh()

Manager.Position = ds.Tables(0).Rows.Count - 1

End Sub

Private Sub Position_Changed(ByVal sender As Object, ByVal e As EventArgs) Handles Manager.PositionChanged

CurrentName = Me.PropertyComboBox.Text

CurrentText = Me.PropertyTextBox.Text

End Sub

Private Sub BuildCodeButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BuildCodeButton.Click

Me.CodeTextBox.Clear()

Dim Line As String

For Each Line In Me.VariableTextBox.Lines

Me.CodeTextBox.AppendText(String.Format(Me.PropertyTextBox.Text, Line.Split(","c)))

Me.CodeTextBox.AppendText(ControlChars.CrLf)

End Sub

End Class

'//以下为架构文件Property.xsd内容

<?xml version="1.0" encoding="utf-8" ?>

<xs:schema id="Property" targetNamespace="http://tempuri.org/Property.xsd" elementFormDefault="qualified"

xmlns="http://tempuri.org/Property.xsd" xmlns:mstns="http://tempuri.org/Property.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema">

<xs:element name="PropertyCollection">

<xs:complexType>

<xs:sequence>

<xs:element name="Property" type="Property" />

</xs:sequence>

</xs:complexType>

<xs:key name="PropertyCollectionKey1">

<xs:selector xpath=".//mstns:Property" />

<xs:field xpath="mstns:Name" />

</xs:key>

</xs:element>

<xs:complexType name="Property">

<xs:sequence>

<xs:element name="Name" type="xs:string" />

<xs:element name="Text" type="xs:string" />

</xs:sequence>

</xs:complexType>

</xs:schema>

'//以下为数据文件Property.XML内容

<?xml version="1.0" encoding="utf-8" ?>

<Name>声明_Private_Integer</Name>

<Text>Private _{0} As Integer</Text>

</Property>

<Name>声明_Private_String</Name>

<Text>Private _{0} As String</Text>

</Property>

<Name>属性_Protected_String</Name>

<Text>Public ReadOnly Property {0} AS String

Get

Return _{0}

End Get

End Property</Text>

</Property>

</PropertyCollection>

'//比较简单，反正是一时之用,使用效果见http://community.csdn.net/Expert/topic/3424/3424369.xml?temp=.4860041