C# Module字段属性生成器（oracle）

  在module里面， 常常遇到将大表字段写成对应属性的情况，一个一个字段写代码很累。于是我写了一个关于Oracle数据库表字段对应生成属性的程序。

1、设计：

C# winFrom窗体：

  private System.Windows.Forms.ComboBox cbxTabName; private System.Windows.Forms.Button btnCreatePropertyCode; private System.Windos.Forms.TextBox textBox1; private System.Windows.Forms.DataGridView dgvFieldsList; private System.Windows.Forms.DataGridViewCheckBoxColumn Column1; private System.Windows.Forms.DataGridViewTextBoxColumn column_name;

 

2、绑定数据源列表 combobox：

   void PropertyCodeMaker_Load(object sender, EventArgs e) { //加载数据源所有表 LoadDataTableFromDataSource(); } private void LoadDataTableFromDataSource() { List<string> lst = mger.LoadDataTableFromDataSource(); cbxTabName.Items.AddRange(lst.ToArray()); }

 

其中mger为  业务逻辑操作类实例：

BLL.PropertyCodeMakerMgr mger = new BLL.PropertyCodeMakerMgr();  

 

3、依据combobox列表选中的table 名不同列出其字段：

//选择表名 private void cbxTabName_SelectedIndexChanged(object sender, EventArgs e) { string tabName = cbxTabName.SelectedItem.ToString(); if (string.IsNullOrEmpty(tabName)) return; DataTable dt = mger.DisplayFields(tabName); dgvFieldsList.DataSource = dt.DefaultView; if (dgvFieldsList.Rows.Count > 0) { foreach (DataGridViewRow row in dgvFieldsList.Rows) { row.Cells[0].Value = true; } } }

 

4、一点小技巧：生成DataGridView行号代码如下：

 

//显示行号 private void dgvFieldsList_RowPostPaint(object sender, DataGridViewRowPostPaintEventArgs e) { Rectangle rectangle = new Rectangle(e.RowBounds.Location.X, e.RowBounds.Location.Y, dgvFieldsList.RowHeadersWidth - 4, e.RowBounds.Height); TextRenderer.DrawText(e.Graphics, (e.RowIndex + 1).ToString(), dgvFieldsList.RowHeadersDefaultCellStyle.Font, rectangle, dgvFieldsList.RowHeadersDefaultCellStyle.ForeColor, TextFormatFlags.VerticalCenter | TextFormatFlags.Right); }

 

5、生成字段属性代码，显示到textbox1上：

//生成属性代码 private void btnCreatePropertyCode_Click(object sender, EventArgs e) { if (dgvFieldsList.Rows.Count <= 0) { MessageBox.Show("未找到可生成代码的字段！请检查后重试！"); return; } StringBuilder sb = new StringBuilder(); string codeStr = @" private string [0]; public string [1] { get { return [0]; } set { [0] = value; } } "; foreach (DataGridViewRow row in dgvFieldsList.Rows) { string arg0 = null; string arg1 = null; if (row.Cells[0].Value != null && Boolean.Parse(row.Cells[0].Value.ToString())) { arg0 = "_" + row.Cells[1].Value.ToString(); arg1 = GetFirstLetterUpperFiled(arg0); string codeTemp = codeStr.Replace("[0]", arg0).Replace("[1]", arg1); sb.Append(codeTemp); } } this.textBox1.Text = sb.ToString(); } //属性名 private static string GetFirstLetterUpperFiled(string s) { Regex regex = new Regex("^[a-zA-Z]$", RegexOptions.IgnoreCase); foreach (char item in s.ToCharArray()) { if (regex.IsMatch(item.ToString())) { string endString = s.Substring(s.IndexOf(item) + 1); s = item.ToString().ToUpper(System.Globalization.CultureInfo.CurrentUICulture) + endString; break; } } return s; }

 

 

6、运行如下：