{
ColName = m_Sdr["COLUMN_NAME"].ToString();
ColType = m_Sdr["TYPE_NAME"].ToString();
}
m_Sdr.Close();
m_Scon.Close();
}
}
#endregion
#region Make object
/// <summary>
/// 生成实体
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Button4_Click(object sender, System.EventArgs e)
{
if(this.DropDownList1.SelectedIndex!=-1)
{
m_Scon.ConnectionString = "user id=" this.txtUserName.Text
";password=" this.txtPassword.Text
";initial catalog=" this.DropDownList3.SelectedItem.Text
";data source=" this.txtServerName.Text;
SqlCommand m_Scmd = new SqlCommand("sp_columns",m_Scon);
m_Scmd.CommandType = CommandType.StoredProcedure;
SqlParameter myParm = m_Scmd.Parameters.Add("@table_name",SqlDbType.VarChar,100);
myParm.Value = this.DropDownList1.SelectedItem.Value;
m_Scon.Open();
SqlDataReader m_Sdr = m_Scmd.ExecuteReader();
string TableName = this.DropDownList1.SelectedItem.Value;
string m_LayOut = "";
m_LayOut = m_LayOut "using System;\r\n";
m_LayOut = m_LayOut "using System.Data;\r\n" ;
m_LayOut = m_LayOut "using System.Data.SqlClient;\r\n";
m_LayOut = m_LayOut "\r\n";
m_LayOut = m_LayOut "namespace OceanSoft\r\n";
m_LayOut = m_LayOut "{\r\n";
m_LayOut = m_LayOut BL(4) "///<comment>\r\n";
m_LayOut = m_LayOut BL(4) "///\r\n";
m_LayOut = m_LayOut BL(4) "///</comment>\r\n";
string ColName = ""; //列名
string ColType = ""; //列的数据类型
string ColDefine = ""; //列定义
string ColProperty = ""; //列属性
while(m_Sdr.Read())
{
ColName = m_Sdr["COLUMN_NAME"].ToString();
ColType = GT(m_Sdr["TYPE_NAME"].ToString());
ColDefine = ColDefine BL(8) "private " ColType " m_" ColName ";\r\n";
ColProperty = ColProperty BL(8) "\r\n";
ColProperty = ColProperty BL(8) "public " ColType " " ColName "\r\n";
ColProperty = ColProperty BL(8) "{\r\n";
ColProperty = ColProperty BL(12) "get\r\n";
ColProperty = ColProperty BL(12) "{\r\n";
ColProperty = ColProperty BL(16) "return m_" ColName " ;\r\n";
ColProperty = ColProperty BL(12) "}\r\n";
ColProperty = ColProperty BL(12) "set\r\n";
ColProperty = ColProperty BL(12) "{\r\n";
ColProperty = ColProperty BL(16) "m_" ColName " = value ;\r\n";
ColProperty = ColProperty BL(12) "}\r\n";
ColProperty = ColProperty BL(8) "}\r\n";
}
m_Sdr.Close();
m_Scon.Close();
m_LayOut = m_LayOut BL(4) "public class " TableName "\r\n";
m_LayOut = m_LayOut BL(4) "{\r\n";
m_LayOut = m_LayOut BL(4) "\r\n";
m_LayOut = m_LayOut ColDefine; //定义
m_LayOut = m_LayOut BL(8) "///<summary>\r\n";
m_LayOut = m_LayOut BL(8) "///构造函数\r\n";
m_LayOut = m_LayOut BL(8) "///<summary>\r\n";
m_LayOut = m_LayOut BL(8) "public " TableName "()\r\n"; //构造函数
m_LayOut = m_LayOut BL(8) "{\r\n";
m_LayOut = m_LayOut BL(8) "}\r\n\r\n";
m_LayOut = m_LayOut BL(8) "///<summary>\r\n";
m_LayOut = m_LayOut BL(8) "///析构函数\r\n";
m_LayOut = m_LayOut BL(8) "///<summary>\r\n";
m_LayOut = m_LayOut BL(8) "~" TableName "()\r\n"; //析构函数
m_LayOut = m_LayOut BL(8) "{\r\n";
m_LayOut = m_LayOut BL(8) "}\r\n";
m_LayOut = m_LayOut ColProperty; //实体属性
m_LayOut = m_LayOut BL(4) "}\r\n";
m_LayOut = m_LayOut "}\r\n";
this.txtLayOut.Text = m_LayOut;
}
}
#endregion
文章整理：西部数码--专业提供域名注册、虚拟主机服务
http://www.west263.com
以上信息与文章正文是不可分割的一部分,如果您要转载本文章,请保留以上信息，谢谢!
