用ASP.NET写你自己的代码生成器

最新推荐文章于 2018-09-20 09:12:56 发布
最新推荐文章于 2018-09-20 09:12:56 发布
阅读量369 收藏
点赞数
分类专栏： asp.net 文章标签： asp.net layout button textbox server string
<script language='javascript' src='http://www.shiqiaotou.com/donetk/Header.js'></script>

FRMMAIN.ASPX

<%@ Page language="c#" Codebehind="FrmMain.aspx.cs" AutoEventWireup="false" Inherits="Web_Test.FrmMain" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
    <HEAD>
        <title>FrmMain</title>
        <meta name="GENERATOR" Content="Microsoft Visual Studio 7.0">
        <meta name="CODE_LANGUAGE" Content="C#">
        <meta name="vs_defaultClientScript" content="JavaScript">
        <meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
    </HEAD>
    <body MS_POSITIONING="GridLayout">
        <form id="FrmMain" method="post" runat="server">
            <asp:TextBox id="txtServerName" style="Z-INDEX: 101; LEFT: 116px; POSITION: absolute; TOP: 24px; Design_Time_Lock: True" runat="server" Font-Size="10pt" Design_Time_Lock="True">192.168.0.220</asp:TextBox>
            <asp:Label id="Label7" style="Z-INDEX: 112; LEFT: 24px; POSITION: absolute; TOP: 98px; Design_Time_Lock: True" runat="server" Width="79px" Height="20px" Font-Size="10pt" Design_Time_Lock="True">数据库列表</asp:Label>
            <asp:Label id="Label6" style="Z-INDEX: 111; LEFT: 27px; POSITION: absolute; TOP: 169px; Design_Time_Lock: True" runat="server" Width="53px" Height="20px" Font-Size="10pt" Design_Time_Lock="True" Visible="False">字段名</asp:Label>
            <asp:Label id="Label5" style="Z-INDEX: 109; LEFT: 27px; POSITION: absolute; TOP: 135px; Design_Time_Lock: True" runat="server" Width="53px" Height="20px" Font-Size="10pt" Design_Time_Lock="True">表名</asp:Label>
            <asp:Button id="Button1" style="Z-INDEX: 107; LEFT: 496px; POSITION: absolute; TOP: 91px; Design_Time_Lock: True" runat="server" Width="102px" Text="GetTable" Font-Size="10pt" Design_Time_Lock="True"></asp:Button>
            <asp:Label id="Label4" style="Z-INDEX: 106; LEFT: 288px; POSITION: absolute; TOP: 63px; Design_Time_Lock: True" runat="server" Width="79px" Height="20px" Font-Size="10pt" Design_Time_Lock="True">密码</asp:Label>
            <asp:Label id="Label2" style="Z-INDEX: 105; LEFT: 25px; POSITION: absolute; TOP: 61px; Design_Time_Lock: True" runat="server" Width="79px" Height="20px" Font-Size="10pt" Design_Time_Lock="True">用户名</asp:Label>
            <asp:Label id="Label1" style="Z-INDEX: 104; LEFT: 25px; POSITION: absolute; TOP: 28px; Design_Time_Lock: True" runat="server" Width="79px" Height="20px" Font-Size="10pt" Design_Time_Lock="True">服务器名</asp:Label>
            <asp:TextBox id="txtPassword" style="Z-INDEX: 103; LEFT: 376px; POSITION: absolute; TOP: 60px; Design_Time_Lock: True" runat="server" Font-Size="10pt" BackColor="Transparent" ForeColor="Black" BorderColor="White" Design_Time_Lock="True"></asp:TextBox>
            <asp:TextBox id="txtUserName" style="Z-INDEX: 102; LEFT: 116px; POSITION: absolute; TOP: 62px; Design_Time_Lock: True" runat="server" Font-Size="10pt" Design_Time_Lock="True">sa</asp:TextBox>
            <asp:DropDownList id="DropDownList1" style="Z-INDEX: 108; LEFT: 115px; POSITION: absolute; TOP: 135px; Design_Time_Lock: True" runat="server" Width="208px" AutoPostBack="True" Font-Size="10pt" Design_Time_Lock="True"></asp:DropDownList>
            <asp:DropDownList id="DropDownList2" style="Z-INDEX: 110; LEFT: 115px; POSITION: absolute; TOP: 171px; Design_Time_Lock: True" runat="server" Width="208px" Height="28px" Font-Size="10pt" Design_Time_Lock="True" Visible="False"></asp:DropDownList>
            <asp:Button id="Button2" style="Z-INDEX: 113; LEFT: 355px; POSITION: absolute; TOP: 92px; Design_Time_Lock: True" runat="server" Width="107px" Text="GetDataBase" Design_Time_Lock="True"></asp:Button>
            <asp:DropDownList id="DropDownList3" style="Z-INDEX: 114; LEFT: 115px; POSITION: absolute; TOP: 98px; Design_Time_Lock: True" runat="server" Width="207px" Height="25px" Design_Time_Lock="True"></asp:DropDownList>
            <asp:Button id="Button3" style="Z-INDEX: 115; LEFT: 354px; POSITION: absolute; TOP: 132px; Design_Time_Lock: True" runat="server" Width="110px" Text="生 成" Design_Time_Lock="True" Visible="False"></asp:Button>
            <asp:TextBox id="txtLayOut" style="Z-INDEX: 117; LEFT: 26px; POSITION: absolute; TOP: 206px; Design_Time_Lock: True" runat="server" Width="619px" Height="367px" TextMode="MultiLine" BackColor="Ivory" Design_Time_Lock="True"></asp:TextBox>
            <asp:Button id="Button4" style="Z-INDEX: 118; LEFT: 497px; POSITION: absolute; TOP: 130px; Design_Time_Lock: True" runat="server" Height="25px" Width="105px" Text="实体类" Design_Time_Lock="True"></asp:Button>
            <asp:Button id="Button5" style="Z-INDEX: 119; LEFT: 355px; POSITION: absolute; TOP: 171px; Design_Time_Lock: True" runat="server" Width="107px" Text="Test" Height="25px" Design_Time_Lock="True" Visible="False"></asp:Button>
            <asp:Button id="Button6" style="Z-INDEX: 120; LEFT: 499px; POSITION: absolute; TOP: 171px; Design_Time_Lock: True" runat="server" Height="23px" Width="105px" Text="集合类" Design_Time_Lock="True" Visible="False"></asp:Button>
        </form>
    </body>
</HTML>
FRMMAIN.ASPX.CS

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

namespace Web_Test
{
    /// <summary>
    /// 作者：davi
    /// 日期：3003-03-18
    /// </summary>
    public class FrmMain : System.Web.UI.Page
    {
        protected System.Web.UI.WebControls.Label Label1;
        protected System.Web.UI.WebControls.Label Label2;
        protected System.Web.UI.WebControls.Label Label4;
        protected System.Web.UI.WebControls.DropDownList DropDownList1;
        protected System.Web.UI.WebControls.Label Label5;
        protected System.Web.UI.WebControls.TextBox txtServerName;
        protected System.Web.UI.WebControls.TextBox txtUserName;
        protected System.Web.UI.WebControls.TextBox txtPassword;
        protected System.Web.UI.WebControls.Button Button1;
        protected System.Web.UI.WebControls.DropDownList DropDownList2;
        protected System.Web.UI.WebControls.Label Label6;
        protected System.Web.UI.WebControls.Label Label7;
        protected System.Web.UI.WebControls.Button Button2;
        protected System.Web.UI.WebControls.DropDownList DropDownList3;
        protected System.Web.UI.WebControls.Button Button3;
        protected System.Web.UI.WebControls.TextBox txtLayOut;
        protected System.Web.UI.WebControls.Button Button4;
        protected System.Web.UI.WebControls.Button Button5;
        protected System.Web.UI.WebControls.Button Button6;
        private SqlConnection m_Scon;
        private DataSet m_DS;

        private void Page_Load(object sender, System.EventArgs e)
        {
            m_Scon = new SqlConnection();
            m_DS = new DataSet();
        }


        #region Web Form Designer generated code
        //[STAThreadAttribute]
        override protected void OnInit(EventArgs e)
        {
            //
            // CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。
            //
            InitializeComponent();
            base.OnInit(e);
        }
       
        /// <summary>
        /// 设计器支持所需的方法 - 不要使用代码编辑器修改
        /// 此方法的内容。
        /// </summary>
        private void InitializeComponent()
        {   
            this.Button1.Click += new System.EventHandler(this.Button1_Click);
            this.DropDownList1.SelectedIndexChanged += new System.EventHandler(this.DropDownList1_SelectedIndexChanged);
            this.Button2.Click += new System.EventHandler(this.Button2_Click);
            this.Button3.Click += new System.EventHandler(this.Button3_Click);
            this.Button4.Click += new System.EventHandler(this.Button4_Click);
            this.Button5.Click += new System.EventHandler(this.Button5_Click);
            this.Button6.Click += new System.EventHandler(this.Button6_Click);
            this.Load += new System.EventHandler(this.Page_Load);

        }
        #endregion

        #region 显示数据库的表 Button1_Click
        /// <summary>
        /// 显示数据库的表
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void Button1_Click(object sender, System.EventArgs e)
        {
            try
            {
                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_tables",m_Scon);
                m_Scmd.CommandType = CommandType.StoredProcedure;
                SqlParameter myParm = m_Scmd.Parameters.Add("@table_type",SqlDbType.VarChar,100);
                myParm.Value = "'TABLE'";
                m_Scon.Open();
                SqlDataReader m_Sdr = m_Scmd.ExecuteReader();
                this.DropDownList1.Items.Clear();
                while(m_Sdr.Read())
                {
                    if(m_Sdr["TABLE_NAME"].ToString()!="dtproperties")
                    {
                        ListItem m_LI = new ListItem();
                        m_LI.Text = m_Sdr["TABLE_NAME"].ToString();
                        m_LI.Value = m_Sdr["TABLE_NAME"].ToString();
                        this.DropDownList1.Items.Add(m_LI);
                    }
                }
                m_Sdr.Close();
                m_Scon.Close();
            }
            catch
            {
                if(m_Scon.State.ToString().ToUpper()=="OPEN")
                {
                    m_Scon.Close();
                }
            }
        }

        #endregion

        #region Show Columns in a table DropDownList1_SelectedIndexChanged
        /// <summary>
        /// 显示表的所有列
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void DropDownList1_SelectedIndexChanged(object sender, System.EventArgs e)
        {
            try
            {
                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();
                    this.DropDownList2.Items.Clear();
                    while(m_Sdr.Read())
                    {
                        ListItem m_LI = new ListItem();
                        m_LI.Text = m_Sdr["COLUMN_NAME"].ToString();
                        m_LI.Value = m_Sdr["COLUMN_NAME"].ToString();
                        this.DropDownList2.Items.Add(m_LI);
                    }
                    m_Sdr.Close();
                    m_Scon.Close();
                }
            }
            catch
            {
                if(m_Scon.State.ToString().ToUpper()=="OPEN")
                {
                    m_Scon.Close();
                }
            }
        }

        #endregion

        #region Show All DataBase Button2_Click
        /// <summary>
        /// 显示所有数据库
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void Button2_Click(object sender, System.EventArgs e)
        {
            try
            {
                m_Scon.ConnectionString = "user id="+this.txtUserName.Text+
                    ";password="+this.txtPassword.Text+
                    ";data source="+this.txtServerName.Text;
                SqlCommand m_Scmd = new SqlCommand("sp_databases",m_Scon);
                m_Scmd.CommandType = CommandType.StoredProcedure;
                m_Scon.Open();
                SqlDataReader m_Sdr = m_Scmd.ExecuteReader();
                this.DropDownList1.Items.Clear();
                while(m_Sdr.Read())
                {
                    ListItem m_LI = new ListItem();
                    m_LI.Text = m_Sdr["DATABASE_NAME"].ToString();
                    m_LI.Value = m_Sdr["DATABASE_NAME"].ToString();
                    this.DropDownList3.Items.Add(m_LI);
                }
                m_Sdr.Close();
                m_Scon.Close();       
            }
            catch
            {
                if(m_Scon.State.ToString().ToUpper()=="OPEN")
                {
                    m_Scon.Close();
                }
            }
        }

        #endregion
#region Make Form
        /// <summary>
        /// 生成表单项
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void Button3_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 ColName = "";
                string ColType = "";
                while(m_Sdr.Read())
                {
                    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

        #region Test
        private void Button5_Click(object sender, System.EventArgs e)
        {
            //
        }
        #endregion

        #region Functions
        private string BL(int values)
        {
            switch(values)
            {
                case 4:
                    return "/t";
                case 8:
                    return "/t/t";
                case 12:
                    return "/t/t/t";
                case 16:
                    return "/t/t/t/t";
                case 20:
                    return "/t/t/t/t/t";
            }
            return "";
        }

        private string GT(string Values)
        {
            switch(Values.ToUpper())
            {
                case "INT":
                    return "int";
                case "NVARCHAR":
                    return "string";
                case "TINYINT":
                    return "int";
                case "INT IDENTITY":
                    return "int";
                case "BIT":
                    return "int";
                case "UNIQUEIDENTIFIER":
                    return "string";
                case "DATETIME":
                    return "string";
                case "VARCHAR":
                    return "string";
                default:
                    return "string";
            }
        }
        #endregion

        #region Make Object Collection Class
        private void Button6_Click(object sender, System.EventArgs e)
        {
            if(this.DropDownList1.SelectedIndex!=-1)
            {
                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 + "using System.Collections;/r/n";
                m_LayOut = m_LayOut + "/r/n";

                m_LayOut = m_LayOut + "namespace e3.Pantheon.WorkFlow.Structure/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) + "///作者：/r/n";
                m_LayOut = m_LayOut + BL(4) + "///创建日期："+System.DateTime.Now.ToShortDateString()+"/r/n";
                m_LayOut = m_LayOut + BL(4) + "///用途说明：/r/n";
                m_LayOut = m_LayOut + BL(4) + "///修改记录：/r/n";
                m_LayOut = m_LayOut + BL(4) + "///</comment>/r/n";

                m_LayOut = m_LayOut + BL(4) + "public class " + TableName + "s : System.Collections.CollectionBase/r/n";
                m_LayOut = m_LayOut + BL(4) + "{/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) + "public " + TableName + "s()/r/n";  //构造函数
                m_LayOut = m_LayOut + BL(8) + "{/r/n";
                m_LayOut = m_LayOut + BL(12) + "//TODO:在这里增加构造函数逻辑/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 + "s()/r/n";  //析构函数
                m_LayOut = m_LayOut + BL(8) + "{/r/n";
                m_LayOut = m_LayOut + BL(12) + "//TODO:在这里增加析构函数逻辑/r/n";
                m_LayOut = m_LayOut + BL(8) + "}/r/n/r/n";

                m_LayOut = m_LayOut + BL(8) + "public void Remove(int index)/r/n";   //删除
                m_LayOut = m_LayOut + BL(8) + "{/r/n";
                m_LayOut = m_LayOut + BL(12) + "if(index>Counter-1||Counter<0)/r/n";
                m_LayOut = m_LayOut + BL(12) + "{}/r/n";
                m_LayOut = m_LayOut + BL(12) + "else/r/n";
                m_LayOut = m_LayOut + BL(12) + "{/r/n";
                m_LayOut = m_LayOut + BL(16) + "List.RemoveAt(index);/r/n";
                m_LayOut = m_LayOut + BL(12) + "}/r/n";
                m_LayOut = m_LayOut + BL(8) + "}/r/n/r/n";

                m_LayOut = m_LayOut + BL(8) + "public void Add("+TableName+" m_"+TableName+")/r/n";  //增加
                m_LayOut = m_LayOut + BL(8) + "{/r/n";
                m_LayOut = m_LayOut + BL(12) + "List.Add("+" m_"+TableName+");/r/n";
                m_LayOut = m_LayOut + BL(8) + "}/r/n/r/n";

                m_LayOut = m_LayOut + BL(8) + "public "+TableName+" this[int index]/r/n";  //集合的元素
                m_LayOut = m_LayOut + BL(8) + "{/r/n";

                m_LayOut = m_LayOut + BL(12) + "get/r/n"; 
                m_LayOut = m_LayOut + BL(12) + "{/r/n";
                m_LayOut = m_LayOut + BL(16) + "if(index <List.Count)/r/n";
                m_LayOut = m_LayOut + BL(16) + "{/r/n";
                m_LayOut = m_LayOut + BL(20) + "return ("+TableName+")List[Index];/r/n";
                m_LayOut = m_LayOut + BL(16) + "}/r/n";
                m_LayOut = m_LayOut + BL(16) + "else/r/n";
                m_LayOut = m_LayOut + BL(16) + "{/r/n";
                m_LayOut = m_LayOut + BL(16) + "return null;/r/n";
                m_LayOut = m_LayOut + BL(16) + "}/r/n";
                m_LayOut = m_LayOut + BL(12) + "}/r/n";

                m_LayOut = m_LayOut + BL(12) + "set/r/n";
                m_LayOut = m_LayOut + BL(12) + "{/r/n";
                m_LayOut = m_LayOut + BL(16) + "if(iIndex<List.Count)/r/n";
                m_LayOut = m_LayOut + BL(16) + "{/r/n";
                m_LayOut = m_LayOut + BL(20) + "List[index]=value;/r/n";
                m_LayOut = m_LayOut + BL(16) + "}/r/n";
                m_LayOut = m_LayOut + BL(12) + "}/r/n";

                m_LayOut = m_LayOut + BL(8) + "}/r/n";

                m_LayOut = m_LayOut + BL(4) + "}/r/n";  //class

                m_LayOut = m_LayOut + "}/r/n";  //namespace

                this.txtLayOut.Text = m_LayOut;
            }
        }
        #endregion

<script language='javascript' src='http://www.shiqiaotou.com/donetk/Footer.js'></script>
donetk
关注
专栏目录
ASP.NET源代码生成工具
06-08
自动生成源代码。以及存储过程，让开发从此变的简单！非常实用的工具！
asp.net企业级代码生成器
03-08
asp.net企业级代码生成器是一款基于三层模式的.net环境代码生成工具，生成的目标程序使用的是c#脚本语言，可以直接导入到visual studio 2008以上版本运行，目前已经实现了数据层，业务逻辑层代码的全自动生成，生成的代码，完全可以直接运行
免费.NET代码生成器KevinCodeBuilder
热门推荐
KevinTseng
10-28 1万+
.NET代码生成器KevinCodeBuilder >>> 免费下载: 百度云 CSDN >>>点击学习：视频教程 + 完整源码 自己在做.NET开发的时候，简单的三层架构会有很多重复的代码，如果手敲会比较浪费时间。前段时间在互联网找了下.net的代码生成器，发现要么太复杂甚至生成的代码会报错，要么要收费而且效果不是自己想要的。 所以，干脆...
asp.net 代码生成器
myvv_net的专栏
11-11 652
http://www.codeplus.net 出品的代码生成器!还没用过,只是看别人的评论说的不错!决定试试!做个记号 
ASP.Net: EshineASPNet教程-自动生成代码模块
Eshine的博客
01-12 2131
完整教程链接：ASP.Net: EshineASPNet-基于ASP.Net敏捷开发开源框架本教程介绍一套自主开发的项目实现自动生成代码，以及使用codesmith自动生成代码。首先要讲的是在一个项目里面，很多代码是有共性的，比如数据库表要对应类，增删改查的方法，这些都是公用的必须有的，做这个算没有创意的体力活，堆代码，这种就最适合用自动生成了。然后是三层架构，这是一个比较老的话题了，也能搜到很多文
ASP.NET项目实战之代码生成器
06-10
这些资源可以帮助学习者逐步了解和掌握如何构建一个ASP.NET代码生成器，从基础概念到实际操作，逐步深入理解三层架构的设计和实现。 在学习过程中，你将学习到： - ASP.NET的基础知识，包括Web Forms、MVC或Core等...
asp.net 代码生成器 .NET代码生成器 C#代码生成器 三层源代码生成器
07-22
8、《Coder.NET代码生成器》需要.Net FrameWork2.0运行环境，基于SQL Server 2005使用。 9、如无法运行本软件，请下载并安装由微软公司提供的.Net FrameWork2.0系统. 10、如果您在使用过程中遇到程序问题或建议...
.net代码生成器批量生成代码
10-28
《.NET代码生成器批量生成代码详解》 在软件开发过程中，编码工作占据了大量时间，尤其是在构建复杂的系统架构时，如三层架构。为提高开发效率，.NET代码生成器应运而生，它能帮助开发者快速生成规范化的代码，节省...
Asp.net动软代码自动生成器
12-08
8. **版本控制兼容**：考虑到现代开发流程通常使用版本控制系统如Git，一个优秀的代码生成器应确保生成的代码能够很好地融入到版本控制中，不会引起冲突或管理难题。 9. **持续集成/持续部署(CI/CD)**：代码生成器...
.Net三层架构代码生成器
03-28
在实际应用中，使用.NET三层架构代码生成器能够带来以下优势： - 提高开发效率：通过自动化生成代码，开发者可以更快地搭建起基本框架。 - 降低错误率：减少手动编写代码时可能出现的错误。 - 维护性：由于各层职责...
ASP.NET代码生成器
06-18
【基本说明】 1、能够生成三层模式操作的所有后台代码，简单的SQL Server 2005数据库操作。 2、生成的代码包括了 MODEL、BLL、DAL、SQLHelper、Config 生成的代码内有详细注释可提供参考。 3、提供数据库增、删、改、查、分页及其事务，并提供多种重载方式。每个张表都提供13个基本数据库访问方法。 4、所有数据表必须有主键！这个主要是为了保证获取记录和分页获取的统一性，其实可以取消这个规则。 5、建议新建App_Code文件夹将生成的C#代码放里面。见此文件夹直接拷贝到项目下既可以使用。 6、不保证所提供软件或程序的完整性和安全性。 7、请在使用前查毒 (这也是您使用其它网络资源所必须注意的) 。 8、《Coder代码生成器》需要.Net FrameWork2.0以上运行环境，基于SQL Server 2005使用。 9、如无法运行本软件，请下载并安装由微软公司提供的.Net FrameWork2.0系统. 10、如果您在使用过程中遇到程序问题或建议请于我联系我的Email是 mailto:mikun@163.com。 11、如有疑问请联系作者 米坤 QQ：327095501 或登陆 http://miko6110.download.csdn.net/下载更新版本。 【生成单表代码】 输入数据库名(Server)登录名(Name)密码(Pwd)，连接后选择库名(Database)表名(Tables)， 之后单击'选择'选择保存路径，点击'单类结构'新建App_Code文件夹将生成的C#代码(ASP.NET后台代码)放里面。 【生成三层模式项目】 (1)B/S架构（ASP·NET）： 输入数据库名(Server)登录名(Name)密码(Pwd)连接数据库成功后，连接后选择库名(Database) 表名(Tables)，命名空间(Namespace)为空时默认数据库名为整个项目工程名，也可自定义， 然后直接点之后单击'选择'选择保存路径，点击'简单三层'生成整个项目确定就好了。 (2)C/S架构（Windows应用程序）： 输入数据库名(Server)登录名(Name)密码(Pwd)连接数据库成功后连接后选择库名(Database) 表名(Tables)，命名空间(Namespace)为空时默认数据库名为整个项目命名空间名，也可自定义， 直接点之后单击'选择'选择保存路径，点击'简单三层'生成整个项目确定， 生成项目后打开该项目解决方案将表示层删掉， 再单击vs的(文件→添加→新建项目→选择Windows应用程序)，这样就生成C/S架构的程序了！
ASP.NET代码生成工具
07-26
包含:代码生成工具CodeSimth(绿色版)和三套摸版
代码生成工具ASP.NET Maker 2016特别版
09-09
ASP.NET Maker 是一套非常容易使用的代码生成工具，同 ASPMaker，它能快速地根据数据库连接资料来源中生成一套完整的 ASP.NET 程序
C# ASP.Net完整代码生成器
09-07
【基本说明】 1、能够生成三层工厂模式操作的所有基本代码，简单的数据库操作。 2、生成的代码包括了 MODEL、BLL、Factory、IDAL、DAL、DBHelper、Config 生成的代码内有详细注释可提供参考。 3、提供数据库增、删、改、查、分页及其事务，并提供多种重载方式。 4、所有数据表必须有主键且主键是第一列，这个主要是为了保证获取记录和分页获取的统一性，其实可以取消这个规则。 6、建议新建App_Code文件夹将生成的C#代码放里面。见此文件夹直接拷贝到项目下既可以使用。 7、不保证所提供软件或程序的完整性和安全性。 8、请在使用前查毒 (这也是您使用其它网络资源所必须注意的) 。 9、《Coder(ASP.NET代码生成器)》需要.Net FrameWork2.0运行环境，基于SQL Server 2005使用。 10、如无法运行本软件，请下载并安装由微软公司提供的.Net FrameWork2.0系统. 11、如果您在使用过程中遇到程序问题或建议请于我联系我的Email是 mailto:liliang119007@163.com。 【生成单层代码】 输入数据库名(Server)登录名(Name)密码(Pwd)，连接后选择库名(Database)表名(Tables) 之后单击'生成单层代码'新建App_Code文件夹将生成的C#代码(ASP.NET后台代码)放里面， 【生成三层工厂模式项目】 (1)B/S架构： 输入数据库名(Server)登录名(Name)密码(Pwd)连接数据库成功后直接点生成整个项目选择路径确定就好了。 (2)C/S架构： 输入数据库名(Server)登录名(Name)密码(Pwd)连接数据库成功后直接点生成整个项目选择路径确定， 生成项目后打开该项目解决方案将表示层删掉， 再单击vs的(文件→添加→新建项目→选择Windows应用程序)，这样就生成C/S架构的程序了！
ORM及代码生成器C#源码(最新版V4.5.8.5、非常适于ASP.NET MVC)
04-25
对象关系映射架构（DBFramework）及代码生成器源码 一、使用对象关系映射组件Kenly.DBFramework.dll不用编写任何SQL或者存储过程即可实现下列功能： 1、数据表、视图和存储过程与对象之间的转换。 2、数据表、视图的自定义条件查询。 3、数据表、视图的分页查询。 4、根据ID、主键或自定义条件对数据表进行增、删、改操作。 5、实现一对一、一对多、多对一和多对多的关系映射。 6、支持单个对象和多个对象之间的事务控制。 7、支持查询结果排序。 8、支持查询表达式生成。 9、支持延迟加载。 二、代码生成器 1、根据指定的数据库连接，自动生成数据表、视图和存储过程对应的对象代码（C#代码）。 2、自动生成相关的工程文件，生成完整的业务层项目文件。 3、可以帮助生成自定义查询方法。 4、支持SQLServer2000、SQLServer2005和Oracle代码生成插件，支持插件扩展。 提供 1、对象关系映射组件： Kenly.DBFramework.dll 2、代码生成器源码：CodeHelper。 3、代码生成器插件源码（支持SQLServer2000、SQLServer2005和Oracle）：Plugin。 4、使用手册：DBFramework.Manual V4.5.3.pdf。 主要API： public abstract class ViewGateway where T: new() { // Methods static ViewGateway(); protected ViewGateway(); protected static int Count(); protected static int Count(string condition); protected static List CountGroup(string groupBy); protected static List CountGroup(string condition, string groupBy); public static List CreateInstances(int count); protected static List Distinct(string columnName); protected static List Distinct(string columnName, string condition); protected static List Distinct(string columnName, string condition, bool ignoreNull); protected static bool Exists(string condition); public bool ExistsById(); public bool ExistsByPK(); protected static List Find(PagingArg pagingArg, params string[] propertyNames); protected static List Find(string condition, params string[] propertyNames); protected static List Find(PagingArg pagingArg, bool sqlServer2000, params string[] propertyNames); protected static List Find(string condition, PagingArg pagingArg, params string[] propertyNames); protected static List Find(string condition, PagingArg pagingArg, bool sqlServer2000, params string[] propertyNames); protected static List FindAll(params string[] propertyNames); protected static void FindTop(T firstOne); protected static List FindTop(int topCount, params string[] propertyNames); protected static void FindTop(string condition, T firstOne); protected static List FindTop(string condition, int topCount, params string[] propertyNames); protected static void InitializeGateway(GatewayConfig config); protected static void InitializeGateway(DatabaseType dbType, string connectionString); protected void InitializeInstance(T entity); protected static object Max(string columnName); protected static object Max(string columnName, string condition); protected static List MaxGroup(string columnName, string groupBy); protected static List MaxGroup(string columnName, string condition, string groupBy); protected static object Min(string columnName); protected static object Min(string columnName, string condition); protected static List MinGroup(string columnName, string groupBy); protected static List MinGroup(string columnName, string condition, string groupBy); protected static DataTable Query(PagingArg pagingArg, params string[] propertyNames); protected static DataTable Query(string condition, params string[] propertyNames); protected static DataTable Query(PagingArg pagingArg, bool sqlServer2000, params string[] propertyNames); protected static DataTable Query(string condition, PagingArg pagingArg, params string[] propertyNames); protected static DataTable Query(string condition, PagingArg pagingArg, bool sqlServer2000, params string[] propertyNames); protected static DataTable QueryAll(params string[] propertyNames); protected static DataTable QueryTop(int topCount, params string[] propertyNames); protected static DataTable QueryTop(string condition, int topCount, params string[] propertyNames); public ArrayList RetrieveAssociations(); public ArrayList RetrieveAssociations(Type elementType); public ArrayList RetrieveAssociations(params Type[] elementTypes); public void RetrieveById(); public void RetrieveByPK(); protected internal virtual void RetrieveBySql(string sql); public void ShadowCopyTo(object targetEntity); public void ShadowCopyTo(T targetEntity); protected static double Sum(string columnName); protected static double Sum(string columnName, string condition); protected static List SumGroup(string columnName, string groupBy); protected static List SumGroup(string columnName, string condition, string groupBy); public static string ToColumnName(string propertyName); public static T ToObject(DataRow adaptedRow); public static List ToObjects(DataTable adaptedTable); public static List ToObjects(DataRow[] adaptedRows); public static string ToPropertyName(string columnName); public static DataTable ToTable(IList entities); public static DataTable ToTable(params T[] entities); public static DataTable ToTable(bool isAdapted, params T[] entities); public static DataTable ToTable(bool isAdapted, IList entities); // Properties protected internal static string CommandText { get; } protected internal static GatewayConfig Config { get; } internal T Entity { get; set; } public object EntityId { get; } public object PrimaryKey { get; } protected static Order SortedOrder { get; set; } } public abstract class TableGateway : ViewGateway where T: TableGateway, new() { // Methods static TableGateway(); protected TableGateway(); public int AddNew(); public static int AddNew(IList entities); public static int AddNew(T entity); public int AddNew(bool returnIdentity); public static int AddNew(T entity, bool returnIdentity); public static int AddNew(IList entities, out Transaction transaction); public static int AddNew(IList entities, bool returnIdentity); public static int AddNew(T entity, out Transaction transaction); public static int AddNew(IList entities, bool returnIdentity, out Transaction transaction); public static int AddNew(T entity, bool returnIdentity, out Transaction transaction); public IDbTransaction BeginTransaction(); public IDbTransaction BeginTransaction(IsolationLevel isolationLevel); public IDbTransaction BeginTransaction(double activeTime); public IDbTransaction BeginTransaction(IsolationLevel isolationLevel, double activeTime); public bool Commit(); protected static int Delete(string condition); protected static int Delete(string condition, out Transaction transaction); public int DeleteById(); public static int DeleteById(T entity); public static int DeleteById(IList entities); public static int DeleteById(IList entities, out Transaction transaction); public static int DeleteById(T entity, out Transaction transaction); public int DeleteByPK(); public static int DeleteByPK(T entity); public static int DeleteByPK(IList entities); public static int DeleteByPK(IList entities, out Transaction transaction); public static int DeleteByPK(T entity, out Transaction transaction); protected void OnPropertyChanged(MethodBase propertyMethod); protected void OnPropertyChanged(string propertyName); protected internal override void RetrieveBySql(string sql); public bool Rollback(); protected static int Update(T entity, string condition); protected static int Update(T entity, string condition, out Transaction transaction); public int UpdateById(); public static int UpdateById(IList entities); public static int UpdateById(T entity); public static int UpdateById(T entity, out Transaction transaction); public static int UpdateById(IList entities, out Transaction transaction); public int UpdateByPK(); public static int UpdateByPK(IList entities); public static int UpdateByPK(T entity); public static int UpdateByPK(IList entities, out Transaction transaction); public static int UpdateByPK(T entity, out Transaction transaction); // Properties public bool Changed { get; } public List ChangedPropertyNames { get; } } public class StoredProcedure : IStoredProcedure { public bool BeginTransaction(); public void CloseReader(IDataReader reader); public bool Commit(); public DataSet ExecuteDataSet(); public DataTable ExecuteDataTable(); public DataTable ExecuteDataTable(); public List ExecuteEntity(); public int ExecuteNonQuery(); public IDataReader ExecuteReader(); public object ExecuteScalar(); protected static void InitializeGateway(GatewayConfig config); protected static void InitializeGateway(DatabaseType dbType, string connectionString); protected void InitializeInstance(T entity); public bool Rollback(); } public class AggregateEntity where T: AggregateEntity, new() { public static List Execute(); protected static List Execute(string condition); public static DataTable ExecuteDataTable(); protected static DataTable ExecuteDataTable(string condition); protected static void InitializeGateway(GatewayConfig config); protected static void InitializeGateway(DatabaseType dbType, string connectionString); // Properties protected static Order SortedOrder { get; set; } } public static class EntityMapper { // Methods public static void AdaptToDatabase(DataTable adaptedTable); public static void AdaptToEntity(DataTable rawTable); public static void CopyToEntities(IList entities, IList adaptedRows); public static void CopyToEntities(IList entities, DataTable adaptedTable); public static void CopyToEntity(T entity, DataRow row); public static List CreateEntities(int count); public static DataTable CreateTable(); public static DataTable CreateTable(bool isAdapted); public static string ToColumnName(string propertyName); public static List ToEntities(IList adaptedRows); public static List ToEntities(DataTable table); public static T ToEntity(DataRow adaptedRow); public static string ToPropertyName(string columnName); public static DataTable ToTable(IList entities); public static DataTable ToTable(params T[] entities); public static DataTable ToTable(bool isAdapted, params T[] entities); public static DataTable ToTable(bool isAdapted, IList entities); } public static class EntityUtility { // Methods public static List Inherit(IList entities); public static T Inherit(object entity); public static T Inherit(Tbase baseEntity, TransformAction method); public static List Inherit(IList baseEntities, TransformAction method); public static void ShadowCopy(IList targetEntities, IList sourceEntities); public static void ShadowCopy(object targetEntity, object sourceEntity); }
代码生成器(Asp.net(C#))
weixin_30553065的博客
01-01 55
花了3个礼拜的时间写的一个简单的代码生成器,这是源码:^_^ ,生成简单的3层和基础页面 HLSource源码 转载于:https://www.cnblogs.com/zhuibobo/archive/2008/01/01/1022466.html...
ASP.NET项目实战之代码生成器-KevinTseng-专题视频课程
KevinTseng
09-20 380
在ASP.NET网站开发中，代码生成器是非常不错的工具。在这里，老师将从零开始，教你如何制作出一款好看而且实用的.NET代码生成器，一键生成网站三层架构模型，体验火箭般的开发速度！...
ASP.NET代码生成器源码解析与学习指南
"ASP.NET代码生成器源码学习" 在ASP.NET开发中，代码生成器是一种非常实用的工具，它能够帮助开发者快速生成基础代码，从而提高开发效率并减少手动编码的工作量。通过学习吉日嘎拉大师的博客，我们可以深入理解代码...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值