代码自动生成器（C#）

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using Oracle.DataAccess.Client; using System.IO; namespace GrenerateCde { public partial class frmGrenerateCde : Form { string sQuote = "\u0022";//引号 string sEnter = "\r\n";//回车换行 private StreamWriter sw; private string headCde = ""; public frmGrenerateCde() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { if(string.IsNullOrEmpty(ORACLE.DBstring)){ ORACLE.DBstring = "User ID=" + txt_user.Text.Trim() + ";Password=" + txt_passwd.Text.Trim() + ";Data Source=" + txt_datasource.Text.Trim() + ";"; } ORACLE.ConnOleDB(); if (ORACLE.OleConn != null) { MessageBox.Show("恭喜!数据库连接成功!", "提示"); } ORACLE.OleConn.Close(); ORACLE.OleConn.Dispose(); } private void Form1_Load(object sender, EventArgs e) { this.saveFileDialog1.Filter = "(*.txt)|*.txt|(*.cs)|*.cs"; setCdehead(); this.txt_cdehead.Text = headCde; } private void setCdehead() { headCde = "/****************************************** " +sEnter+ "* " + sEnter + "* 模块名称：实体 " + sEnter + "* 当前版本：1.0 " + sEnter + "* 开发人员：" + txt_author.Text.Trim() + sEnter + "* 完成时间：" + System.DateTime.Now.ToShortDateString() + sEnter + "* 版本历史：此代码由实体代码生成工具自动生成。 " + sEnter + "* " + sEnter + "******************************************/" + sEnter; } private void button3_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(ORACLE.DBstring)) { ORACLE.DBstring = "User ID=" + txt_user.Text.Trim() + ";Password=" + txt_passwd.Text.Trim() + ";Data Source=" + txt_datasource.Text.Trim() + ";"; } } private void button4_Click(object sender, EventArgs e) { this.folderBrowserDialog1.ShowDialog(); this.save_FilePath.Text = this.folderBrowserDialog1.SelectedPath; } private void rb_headcde_CheckedChanged(object sender, EventArgs e) { if (rb_headcde.Checked) { rb_author.Checked = false; this.txt_author.Visible = false; this.txt_cdehead.Visible = true; } else { rb_author.Checked = true; this.txt_author.Visible = true; this.txt_cdehead.Visible = false; setCdehead(); } } private void button2_Click(object sender, EventArgs e) { ORACLE.DBstring = ORACLE.DBstring = "User ID=" + txt_user.Text.Trim() + ";Password=" + txt_passwd.Text.Trim() + ";Data Source=" + txt_datasource.Text.Trim() + ";"; COLUMN_DESCRIB colDes = new COLUMN_DESCRIB(); if (colDes.SelectTableName(this.this.cmbTable.Text) <= 0) { MessageBox.Show("没有找到该表或查询时出错"); return; } string sWrite = ""; if (rb_author.Checked) { sWrite = sWrite + headCde; }else{ sWrite = sWrite + this.txt_cdehead.Text.Trim()+sEnter; } sWrite = sWrite + "using System;" + sEnter; sWrite = sWrite + "using System.Collections.Generic;" + sEnter; sWrite = sWrite + "using System.Text;" + sEnter; sWrite = sWrite + "using System.Data;" + sEnter; sWrite = sWrite + "using Share;" + sEnter; sWrite = sWrite + sEnter; sWrite = sWrite + "namespace " + this.txt_namespace.Text + sEnter; sWrite = sWrite + "{" + sEnter; sWrite = sWrite + " public class " + this.txt_classname.Text + sEnter; sWrite = sWrite + " {" + sEnter; for (int i = 0; i < colDes._RowCount; i++) { colDes.SetRow(i); sWrite = sWrite + " /// <summary>" + sEnter; sWrite = sWrite + " /// " + colDes.COMMENTS + " " + colDes.DATA_TYPE + "(" + colDes.DATA_LENGTH + ")" + sEnter; sWrite = sWrite + " /// </summary>" + sEnter; sWrite = sWrite + " private " + GetType(colDes.DATA_TYPE) + " " + colDes.COLUMN_NAME + ";" + sEnter; sWrite = sWrite + " /// <summary>" + sEnter; sWrite = sWrite + " /// " + colDes.COMMENTS + " " + colDes.DATA_TYPE + "(" + colDes.DATA_LENGTH + ")" + sEnter; sWrite = sWrite + " /// </summary>" + sEnter; sWrite = sWrite + " public " + GetType(colDes.DATA_TYPE) + " _" + colDes.COLUMN_NAME + sEnter; sWrite = sWrite + " {" + sEnter; sWrite = sWrite + " set{ " + colDes.COLUMN_NAME + " = value;}" + sEnter; sWrite = sWrite + " get{ return " + colDes.COLUMN_NAME + ";}" + sEnter; sWrite = sWrite + " }" + sEnter; sWrite = sWrite + sEnter; } if(this.checkBox1.Checked){ sWrite = sWrite + " public string ErrorText;" + sEnter; sWrite = sWrite + " private DataTable dataTable;" + sEnter; } sWrite = sWrite + sEnter; sWrite = sWrite + " private void Init()" + sEnter; sWrite = sWrite + " {" + sEnter; //sWrite = sWrite + " DateTime? dt = null;" + sEnter; sWrite = sWrite + sEnter; for (int i = 0; i < colDes._RowCount; i++) { colDes.SetRow(i); sWrite = sWrite + " _" + colDes.COLUMN_NAME + " = " + GetDefaultValue(colDes.DATA_TYPE) + ";" + sEnter; } sWrite = sWrite + " }" + sEnter; sWrite = sWrite + sEnter; if (this.checkBox1.Checked) { sWrite = sWrite + " public int Insert()" + sEnter; sWrite = sWrite + " {" + sEnter; sWrite = sWrite + " string sDate = PUBLIC_CLASS.GetSysDate(" + sQuote + "YYYYMMDD" + sQuote + ");" + sEnter; sWrite = sWrite + " if (sDate == " + sQuote + "-1" + sQuote + ") return -1;" + sEnter; sWrite = sWrite + sEnter; sWrite = sWrite + " string sSql = " + sQuote + "Insert into " + this.this.cmbTable.Text + "("; for (int i = 0; i < colDes._RowCount; i++) { colDes.SetRow(i); if (i != colDes._RowCount - 1) { sWrite = sWrite + colDes.COLUMN_NAME + ","; } else { sWrite = sWrite + colDes.COLUMN_NAME + ") " + sQuote + ";" + sEnter; } } sWrite = sWrite + " sSql = sSql + " + sQuote + "Values("; for (int i = 0; i < colDes._RowCount;