做个简单的代码生成器

主界面

功能

由数据库生成html代码以及ajax的初始化代码
根据html的标签生成ajax代码和ashx接收代码
由数据库生成实体类及简单的操作

使用环境

asp.net+SQL Server

测试数据库代码

create table Region(

re_id int identity(1,1) primary key,--主键id

re_name nvarchar(16) not null,--地区名称

re_shorthand nvarchar(8) not null,--地区简写

re_parentID int not null,--父系id

re_relation nvarchar( 32) not null--功能关系

);

create table testfk(

pk int primary key,

fk1 foreign key references Region(re_id),

fk2 foreign key references Region(re_id),

fk13213 foreign key references Region(re_id)

);

由数据库生成html

做个简单的代码生成器

html代码

 
<div class="box box-info">
<div class="box-header with-border">
<h3 class="box-title">骑着猪猪的CodeMonkey生成代码</h3>
</div>
<!-- /.box-header -->
<!-- form start -->
<div class="form-horizontal">
<div class="box-body">
<div class="form-group">
<label class="col-sm-2 control-label">pk</label>
<div class="col-sm-10">
<input type="text" class="form-control" id="pk" placeholder="pk"/>
</div>
</div>
<div class="form-group">
<label class="col-sm-2 control-label">fk1</label>
<div class="col-sm-10">
<select id="fk1" class="form-control" onchange="fk1change()">
</select>
</div>
</div><div class="form-group">
<label class="col-sm-2 control-label">fk2</label>
<div class="col-sm-10">
<select id="fk2" class="form-control" onchange="fk2change()">
</select>
</div>
</div><div class="form-group">
<label class="col-sm-2 control-label">fk13213</label>
<div class="col-sm-10">
<select id="fk13213" class="form-control" onchange="fk13213change()">
</select>
</div>
</div>
</div>
<!-- /.box-body -->
<div class="box-footer">
<button type="reset" class="btn btn-default">取消</button>
<button type="button" class="btn btn-info pull-right" onclick="ok()">确定</button>
</div>
<!-- /.box-footer -->
</div>
</div>

ashx代码

 
<%@ WebHandler Language="C#" Class="Initfk1Select" %>
using System;
using System.Web;
using DataBaseClassLibrary;
public class Initfk1Select : IHttpHandler {
    public void ProcessRequest (HttpContext context) {
        context.Response.ContentType = "text/plain";
        MicrosoftSQLServer db = new MicrosoftSQLServer(SystemInfo._configure["constring"].ToString());
        string str = db.Execute_Select_ResultTableJSON("select * from BCMS_Region", false);
        context.Response.Write(str);
    }
    public bool IsReusable {
        get {
            return false;
        }
    }
}
//----------------------------------------------------------------------------------------------
<%@ WebHandler Language="C#" Class="Initfk2Select" %>
using System;
using System.Web;
using DataBaseClassLibrary;
public class Initfk2Select : IHttpHandler {
    public void ProcessRequest (HttpContext context) {
        context.Response.ContentType = "text/plain";
        MicrosoftSQLServer db = new MicrosoftSQLServer(SystemInfo._configure["constring"].ToString());
        string str = db.Execute_Select_ResultTableJSON("select * from BCMS_Region", false);
        context.Response.Write(str);
    }
    public bool IsReusable {
        get {
            return false;
        }
    }
}
//----------------------------------------------------------------------------------------------
<%@ WebHandler Language="C#" Class="Initfk13213Select" %>
using System;
using System.Web;
using DataBaseClassLibrary;
public class Initfk13213Select : IHttpHandler {
    public void ProcessRequest (HttpContext context) {
        context.Response.ContentType = "text/plain";
        MicrosoftSQLServer db = new MicrosoftSQLServer(SystemInfo._configure["constring"].ToString());
        string str = db.Execute_Select_ResultTableJSON("select * from BCMS_Region", false);
        context.Response.Write(str);
    }
    public bool IsReusable {
        get {
            return false;
        }
    }
}
//----------------------------------------------------------------------------------------------

ajax代码

 
function fk1Init()
{
    $.ajax({
        type: "post",
        url: "Initfk1Select.ashx",
        timeout: 1000000,
        data: {
        },
        datatype: "json",
        success: function (result) {
            var str = eval(result);
            var resHtml = "";
            $.each(str, function (index, val) {
                resHtml += "<option value=\""+val.re_id+"\">"+val.re_name+"</option>";
                //alert(resHtml);
            });
            $("#fk1").html(resHtml);
        },
        error: function (XMLHttpRequest, textStatus, errorThrown) {
            $("#erroInfo").text("网络错误");
            $("#loginInfo").modal("show");
        }
    });
}
function fk1change()
{
    alert($("#fk1").val())
}
function fk2Init()
{
    $.ajax({
        type: "post",
        url: "Initfk2Select.ashx",
        timeout: 1000000,
        data: {
        },
        datatype: "json",
        success: function (result) {
            var str = eval(result);
            var resHtml = "";
            $.each(str, function (index, val) {
                resHtml += "<option value=\""+val.re_id+"\">"+val.re_name+"</option>";
                //alert(resHtml);
            });
            $("#fk2").html(resHtml);
        },
        error: function (XMLHttpRequest, textStatus, errorThrown) {
            $("#erroInfo").text("网络错误");
            $("#loginInfo").modal("show");
        }
    });
}
function fk2change()
{
    alert($("#fk2").val())
}
function fk13213Init()
{
    $.ajax({
        type: "post",
        url: "Initfk13213Select.ashx",
        timeout: 1000000,
        data: {
        },
        datatype: "json",
        success: function (result) {
            var str = eval(result);
            var resHtml = "";
            $.each(str, function (index, val) {
                resHtml += "<option value=\""+val.re_id+"\">"+val.re_name+"</option>";
                //alert(resHtml);
            });
            $("#fk13213").html(resHtml);
        },
        error: function (XMLHttpRequest, textStatus, errorThrown) {
            $("#erroInfo").text("网络错误");
            $("#loginInfo").modal("show");
        }
    });
}
function fk13213change()
{
    alert($("#fk13213").val())
}

由输入标签生成ajax和ashx部分代码

做个简单的代码生成器

html->ajax

ajax代码

 
// ==========================================================================================
// Name:请求test.ashx的ajax
// Author:骑着猪猪的CodeMonkey
// Create date:2017/7/18
// Explain:这是有骑着猪猪的CodeMonkey的代码生成器生成的代码
// 用于插入提交数据给服务器
// ==========================================================================================
pk=$('#pk').val();
fk1=$('#fk1').val();
fk2=$('#fk2').val();
fk13213=$('#fk13213').val();
$.ajax({
    type: "post",
    url: "test.ashx",
    timeout: 1000000,
    data: {
    "pk":pk,
    "fk1":fk1,
    "fk2":fk2,
    "fk13213":fk13213
},
datatype: "json",
success: function (result) {
    var obj = jQuery.parseJSON(result);
    //...自己的业务逻辑
},
error: function (XMLHttpRequest, textStatus, errorThrown) {
    alert("网络错误");
}
});
// ==========================================================================================
// Name:请求test.ashx的ajax
// Author:骑着猪猪的CodeMonkey
// Create date:2017/7/18
// Explain:这是有骑着猪猪的CodeMonkey的代码生成器生成的代码
// 用于将服务器返回的数据填充到界面上
// ==========================================================================================
$.ajax({
    type: "post",
    url: "test.ashx",
    timeout: 1000000,
    data: {
        "primaryKey":pk//需要自己填写
    },
    datatype: "json",
    success: function (result) {
        var obj = jQuery.parseJSON(result);
        $('#pk').val(obj.pk);
        $('#fk1').val(obj.fk1);
        $('#fk2').val(obj.fk2);
        $('#fk13213').val(obj.fk13213);
    },
    error: function (XMLHttpRequest, textStatus, errorThrown) {
        alert("网络错误");
    }
});

ashx代码

 
string pk = context.Request["pk"].ToString();
string fk1 = context.Request["fk1"].ToString();
string fk2 = context.Request["fk2"].ToString();
string fk13213 = context.Request["fk13213"].ToString();
ClassName obj = new ClassName(pk,fk1,fk2,fk13213);

由数据库生成实体类

做个简单的代码生成器

数据库生成实体类

实体类代码

 
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Newtonsoft.Json;
using DataBaseClassLibrary;
using System.Data;
namespace TestCodeTools
{
    /// <summary> 
    /// 由数据库表testfk生成的实体类 
    /// 作者：骑着猪猪的CodeMonkey 
    /// </summary> 
    public class testfk
    {
        public string pk;
        public string fk1;
        public string fk2;
        public string fk13213;
        public testfk()
        {
        }
        public testfk(string pk,string fk1,string fk2,string fk13213)
        {
            this.pk=pk;
            this.fk1=fk1;
            this.fk2=fk2;
            this.fk13213=fk13213;
        }
        /// <summary> 
        /// 向表中插入一行数据 
        /// </summary> 
        /// <returns>受响应的行数</returns> 
        public int inserttestfk()
        {
            string par = JsonConvert.SerializeObject(this);
            MicrosoftSQLServer db = new MicrosoftSQLServer("Input Database Constring");
            string cmd = "insert into testfk values(pk,@fk1,@fk2,@fk13213)";
            int x = db.Execute_NonQuery(cmd, par, false);
            return x;
        }
        /// <summary> 
            /// 根据主键在表中删除一行数据 
            /// </summary> 
        /// <param name="primaryKey"></param> 
        /// <returns></returns> 
        public static int deletetestfkByPrimaryKey(string primaryKey)
        {
            Dictionary<string, object> par = new Dictionary<string, object>();
            par.Add("@pk", primaryKey);
            MicrosoftSQLServer db = new MicrosoftSQLServer("Input Database Constring");
            string cmd = "delete from testfk where pk = @pk";
            int x = db.Execute_NonQuery(cmd, par, false);
            return x;
        }
        /// <summary> 
            /// 按住键修改某一行信息 
            /// </summary> 
        /// 
        /// <returns>受响应行数</returns> 
        public int updatetestfkByPrimaryKey()
        {
            string par = JsonConvert.SerializeObject(this);
            MicrosoftSQLServer db = new MicrosoftSQLServer("Input Database Constring");
            string cmd = "update testfk set fk1=@fk1,fk2=@fk2,fk13213=@fk13213 where pk=@pk;";
            int x = db.Execute_NonQuery(cmd, par, false);
            return x;
        }
        /// <summary> 
            /// 查询testfk中的所有信息 
            /// </summary> 
        /// <returns>json</returns> 
        public static string selecttestfkReturnJSON()
        {
            MicrosoftSQLServer db = new MicrosoftSQLServer("Input Database Constring");
            string cmd = "select * from testfk;";
            string x = db.Execute_Select_ResultTableJSON(cmd,false);
            return x;
        }
        /// <summary> 
            /// 查询testfk中的所有信息 
            /// </summary> 
        /// <returns>DataTable</returns> 
        public static DataTable selecttestfkReturnTable()
        {
            MicrosoftSQLServer db = new MicrosoftSQLServer("Input Database Constring");
            string cmd = "select * from testfk;";
            DataTable x = db.Execute_Select_ResultTable(cmd, false);
            return x;
        }
        /// <summary> 
            /// 按primaryKey查询testfk中的信息 
            /// </summary> 
        /// <param name="primary">主键</param> 
        /// <returns>json</returns> 
        public static string selecttestfkReturnJSONByPrimary(string primary)
        {
            MicrosoftSQLServer db = new MicrosoftSQLServer("Input Database Constring");
            Dictionary<string, object> par = new Dictionary<string, object>();
            par.Add("@pk", primary);
            string cmd = "select * from testfk where pk = @pk";
            string x = db.Execute_Select_ResultTableJSON(cmd, par,false);
            return x;
        }
        /// <summary> 
            /// 按primaryKey查询testfk中的信息 
            /// </summary> 
        /// <param name="primary">主键</param> 
        /// <returns>DataTable</returns> 
        public static DataTable selecttestfkReturnTable(string primary)
        {
            MicrosoftSQLServer db = new MicrosoftSQLServer("Input Database Constring");
            string cmd = "select * from testfk where pk = @pk";
            Dictionary<string, object> par = new Dictionary<string, object>();
            par.Add("@pk", primary);
            DataTable x = db.Execute_Select_ResultTable(cmd,par, false);
            return x;
        }
        public static testfk selectClassNameReturnObject(string primary)
        {
            string json = selecttestfkReturnJSONByPrimary(primary);
            json = json.Substring(1, json.Length - 2);
            testfk obj = (testfk)JsonConvert.DeserializeObject(json, typeof(testfk));
            return obj;
        }
    }
}

备注

因为要保证生成器的通用型，所以在生成的代码中还需要更具实际的情况做一些小的调整

	<div class="box box-info">
	<div class="box-header with-border">
	<h3 class="box-title">骑着猪猪的CodeMonkey生成代码</h3>
	</div>
	<!-- /.box-header -->
	<!-- form start -->
	<div class="form-horizontal">
	<div class="box-body">
	<div class="form-group">
	<label class="col-sm-2 control-label">pk</label>
	<div class="col-sm-10">
	<input type="text" class="form-control" id="pk" placeholder="pk"/>
	</div>
	</div>
	<div class="form-group">
	<label class="col-sm-2 control-label">fk1</label>
	<div class="col-sm-10">
	<select id="fk1" class="form-control" onchange="fk1change()">
	</select>
	</div>
	</div><div class="form-group">
	<label class="col-sm-2 control-label">fk2</label>
	<div class="col-sm-10">
	<select id="fk2" class="form-control" onchange="fk2change()">
	</select>
	</div>
	</div><div class="form-group">
	<label class="col-sm-2 control-label">fk13213</label>
	<div class="col-sm-10">
	<select id="fk13213" class="form-control" onchange="fk13213change()">
	</select>
	</div>
	</div>
	</div>
	<!-- /.box-body -->
	<div class="box-footer">
	<button type="reset" class="btn btn-default">取消</button>
	<button type="button" class="btn btn-info pull-right" onclick="ok()">确定</button>
	</div>
	<!-- /.box-footer -->
	</div>
	</div>

	<%@ WebHandler Language="C#" Class="Initfk1Select" %>
	using System;
	using System.Web;
	using DataBaseClassLibrary;
	public class Initfk1Select : IHttpHandler {
	public void ProcessRequest (HttpContext context) {
	context.Response.ContentType = "text/plain";
	MicrosoftSQLServer db = new MicrosoftSQLServer(SystemInfo._configure["constring"].ToString());
	string str = db.Execute_Select_ResultTableJSON("select * from BCMS_Region", false);
	context.Response.Write(str);
	}
	public bool IsReusable {
	get {
	return false;
	}
	}
	}
	//----------------------------------------------------------------------------------------------
	<%@ WebHandler Language="C#" Class="Initfk2Select" %>
	using System;
	using System.Web;
	using DataBaseClassLibrary;
	public class Initfk2Select : IHttpHandler {
	public void ProcessRequest (HttpContext context) {
	context.Response.ContentType = "text/plain";
	MicrosoftSQLServer db = new MicrosoftSQLServer(SystemInfo._configure["constring"].ToString());
	string str = db.Execute_Select_ResultTableJSON("select * from BCMS_Region", false);
	context.Response.Write(str);
	}
	public bool IsReusable {
	get {
	return false;
	}
	}
	}
	//----------------------------------------------------------------------------------------------
	<%@ WebHandler Language="C#" Class="Initfk13213Select" %>
	using System;
	using System.Web;
	using DataBaseClassLibrary;
	public class Initfk13213Select : IHttpHandler {
	public void ProcessRequest (HttpContext context) {
	context.Response.ContentType = "text/plain";
	MicrosoftSQLServer db = new MicrosoftSQLServer(SystemInfo._configure["constring"].ToString());
	string str = db.Execute_Select_ResultTableJSON("select * from BCMS_Region", false);
	context.Response.Write(str);
	}
	public bool IsReusable {
	get {
	return false;
	}
	}
	}
	//----------------------------------------------------------------------------------------------

	function fk1Init()
	{
	$.ajax({
	type: "post",
	url: "Initfk1Select.ashx",
	timeout: 1000000,
	data: {
	},
	datatype: "json",
	success: function (result) {
	var str = eval(result);
	var resHtml = "";
	$.each(str, function (index, val) {
	resHtml += "<option value=\""+val.re_id+"\">"+val.re_name+"</option>";
	//alert(resHtml);
	});
	$("#fk1").html(resHtml);
	},
	error: function (XMLHttpRequest, textStatus, errorThrown) {
	$("#erroInfo").text("网络错误");
	$("#loginInfo").modal("show");
	}
	});
	}
	function fk1change()
	{
	alert($("#fk1").val())
	}
	function fk2Init()
	{
	$.ajax({
	type: "post",
	url: "Initfk2Select.ashx",
	timeout: 1000000,
	data: {
	},
	datatype: "json",
	success: function (result) {
	var str = eval(result);
	var resHtml = "";
	$.each(str, function (index, val) {
	resHtml += "<option value=\""+val.re_id+"\">"+val.re_name+"</option>";
	//alert(resHtml);
	});
	$("#fk2").html(resHtml);
	},
	error: function (XMLHttpRequest, textStatus, errorThrown) {
	$("#erroInfo").text("网络错误");
	$("#loginInfo").modal("show");
	}
	});
	}
	function fk2change()
	{
	alert($("#fk2").val())
	}
	function fk13213Init()
	{
	$.ajax({
	type: "post",
	url: "Initfk13213Select.ashx",
	timeout: 1000000,
	data: {
	},
	datatype: "json",
	success: function (result) {
	var str = eval(result);
	var resHtml = "";
	$.each(str, function (index, val) {
	resHtml += "<option value=\""+val.re_id+"\">"+val.re_name+"</option>";
	//alert(resHtml);
	});
	$("#fk13213").html(resHtml);
	},
	error: function (XMLHttpRequest, textStatus, errorThrown) {
	$("#erroInfo").text("网络错误");
	$("#loginInfo").modal("show");
	}
	});
	}
	function fk13213change()
	{
	alert($("#fk13213").val())
	}

	// ==========================================================================================
	// Name:请求test.ashx的ajax
	// Author:骑着猪猪的CodeMonkey
	// Create date:2017/7/18
	// Explain:这是有骑着猪猪的CodeMonkey的代码生成器生成的代码
	// 用于插入提交数据给服务器
	// ==========================================================================================
	pk=$('#pk').val();
	fk1=$('#fk1').val();
	fk2=$('#fk2').val();
	fk13213=$('#fk13213').val();
	$.ajax({
	type: "post",
	url: "test.ashx",
	timeout: 1000000,
	data: {
	"pk":pk,
	"fk1":fk1,
	"fk2":fk2,
	"fk13213":fk13213
	},
	datatype: "json",
	success: function (result) {
	var obj = jQuery.parseJSON(result);
	//...自己的业务逻辑
	},
	error: function (XMLHttpRequest, textStatus, errorThrown) {
	alert("网络错误");
	}
	});
	// ==========================================================================================
	// Name:请求test.ashx的ajax
	// Author:骑着猪猪的CodeMonkey
	// Create date:2017/7/18
	// Explain:这是有骑着猪猪的CodeMonkey的代码生成器生成的代码
	// 用于将服务器返回的数据填充到界面上
	// ==========================================================================================
	$.ajax({
	type: "post",
	url: "test.ashx",
	timeout: 1000000,
	data: {
	"primaryKey":pk//需要自己填写
	},
	datatype: "json",
	success: function (result) {
	var obj = jQuery.parseJSON(result);
	$('#pk').val(obj.pk);
	$('#fk1').val(obj.fk1);
	$('#fk2').val(obj.fk2);
	$('#fk13213').val(obj.fk13213);
	},
	error: function (XMLHttpRequest, textStatus, errorThrown) {
	alert("网络错误");
	}
	});

	string pk = context.Request["pk"].ToString();
	string fk1 = context.Request["fk1"].ToString();
	string fk2 = context.Request["fk2"].ToString();
	string fk13213 = context.Request["fk13213"].ToString();
	ClassName obj = new ClassName(pk,fk1,fk2,fk13213);

	using System;
	using System.Collections.Generic;
	using System.Linq;
	using System.Text;
	using System.Threading.Tasks;
	using Newtonsoft.Json;
	using DataBaseClassLibrary;
	using System.Data;
	namespace TestCodeTools
	{
	/// <summary>
	/// 由数据库表testfk生成的实体类
	/// 作者：骑着猪猪的CodeMonkey
	/// </summary>
	public class testfk
	{
	public string pk;
	public string fk1;
	public string fk2;
	public string fk13213;
	public testfk()
	{
	}
	public testfk(string pk,string fk1,string fk2,string fk13213)
	{
	this.pk=pk;
	this.fk1=fk1;
	this.fk2=fk2;
	this.fk13213=fk13213;
	}
	/// <summary>
	/// 向表中插入一行数据
	/// </summary>
	/// <returns>受响应的行数</returns>
	public int inserttestfk()
	{
	string par = JsonConvert.SerializeObject(this);
	MicrosoftSQLServer db = new MicrosoftSQLServer("Input Database Constring");
	string cmd = "insert into testfk values(pk,@fk1,@fk2,@fk13213)";
	int x = db.Execute_NonQuery(cmd, par, false);
	return x;
	}
	/// <summary>
	/// 根据主键在表中删除一行数据
	/// </summary>
	/// <param name="primaryKey"></param>
	/// <returns></returns>
	public static int deletetestfkByPrimaryKey(string primaryKey)
	{
	Dictionary<string, object> par = new Dictionary<string, object>();
	par.Add("@pk", primaryKey);
	MicrosoftSQLServer db = new MicrosoftSQLServer("Input Database Constring");
	string cmd = "delete from testfk where pk = @pk";
	int x = db.Execute_NonQuery(cmd, par, false);
	return x;
	}
	/// <summary>
	/// 按住键修改某一行信息
	/// </summary>
	///
	/// <returns>受响应行数</returns>
	public int updatetestfkByPrimaryKey()
	{
	string par = JsonConvert.SerializeObject(this);
	MicrosoftSQLServer db = new MicrosoftSQLServer("Input Database Constring");
	string cmd = "update testfk set fk1=@fk1,fk2=@fk2,fk13213=@fk13213 where pk=@pk;";
	int x = db.Execute_NonQuery(cmd, par, false);
	return x;
	}
	/// <summary>
	/// 查询testfk中的所有信息
	/// </summary>
	/// <returns>json</returns>
	public static string selecttestfkReturnJSON()
	{
	MicrosoftSQLServer db = new MicrosoftSQLServer("Input Database Constring");
	string cmd = "select * from testfk;";
	string x = db.Execute_Select_ResultTableJSON(cmd,false);
	return x;
	}
	/// <summary>
	/// 查询testfk中的所有信息
	/// </summary>
	/// <returns>DataTable</returns>
	public static DataTable selecttestfkReturnTable()
	{
	MicrosoftSQLServer db = new MicrosoftSQLServer("Input Database Constring");
	string cmd = "select * from testfk;";
	DataTable x = db.Execute_Select_ResultTable(cmd, false);
	return x;
	}
	/// <summary>
	/// 按primaryKey查询testfk中的信息
	/// </summary>
	/// <param name="primary">主键</param>
	/// <returns>json</returns>
	public static string selecttestfkReturnJSONByPrimary(string primary)
	{
	MicrosoftSQLServer db = new MicrosoftSQLServer("Input Database Constring");
	Dictionary<string, object> par = new Dictionary<string, object>();
	par.Add("@pk", primary);
	string cmd = "select * from testfk where pk = @pk";
	string x = db.Execute_Select_ResultTableJSON(cmd, par,false);
	return x;
	}
	/// <summary>
	/// 按primaryKey查询testfk中的信息
	/// </summary>
	/// <param name="primary">主键</param>
	/// <returns>DataTable</returns>
	public static DataTable selecttestfkReturnTable(string primary)
	{
	MicrosoftSQLServer db = new MicrosoftSQLServer("Input Database Constring");
	string cmd = "select * from testfk where pk = @pk";
	Dictionary<string, object> par = new Dictionary<string, object>();
	par.Add("@pk", primary);
	DataTable x = db.Execute_Select_ResultTable(cmd,par, false);
	return x;
	}
	public static testfk selectClassNameReturnObject(string primary)
	{
	string json = selecttestfkReturnJSONByPrimary(primary);
	json = json.Substring(1, json.Length - 2);
	testfk obj = (testfk)JsonConvert.DeserializeObject(json, typeof(testfk));
	return obj;
	}
	}
	}