最近因为工作需求，要制作一个网页模板，主要是用于快速开发，可以查询Sql数据表信息的模板，
昨天做好了，这个只是一个Demo，但是功能已经齐全了，
开发新的网站时，需要新增一个xml，复制粘贴网页的前端和后台，注意，前端的样式和逻辑还是要分开写的。
这样，基本上在10分钟以内，就能开发一个新的网页（只有核心的查询功能）。
这是效果图：
下面记录一下这个Demo：
首先是要在Web项目的web.config中配置数据库的连接字符串和xml文件名：
<appSettings>
<add key="xmlDir" value="xml"/>
</appSettings>
<connectionStrings>
<add name="connStr" connectionString="Data Source=10.76.25.XX;DATABASE=XXX;Persist Security Info=True;User ID=sa;Password=XXXXXX;Max Pool Size=300;" providerName="System.Data.SqlClient"/>
</connectionStrings>
接着，我有做好了一个帮助类QueryHelper：
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.IO;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Xml.Linq; namespace Cong.Utility
{
public delegate void DelegatePageIndexChange(object obj, GridViewPageEventArgs e); public class QueryHelper
{
private string xmlName { get; set; }
private Page page { get; set; }
private GridView gv { get; set; } private DelegatePageIndexChange dele; public QueryHelper(string xmlName, Page page, DelegatePageIndexChange dele)
{
this.xmlName = xmlName;
this.page = page;
this.gv = page.FindControl("gv") as GridView;
this.dele = dele; gv.PageIndexChanging += Gv_PageIndexChanging;
} public void BindData(object objIndex)
{
var xmlDir = ConfigurationManager.AppSettings["xmlDir"];
//获取xml节点
string path = AppDomain.CurrentDomain.BaseDirectory + (xmlDir == null ? "" : (xmlDir.ToString() + "\\")) + xmlName;
if (!File.Exists(path))
throw new Exception("xml is not exist."); XDocument xdoc = XDocument.Load(path);
XElement root = xdoc.Root; //获取基本查询语句的变量
string tableName = root.Element("tableName").Value;
string topNumber = root.Element("top").Value; //拼接where条件语句
List<string> conditions = new List<string>();
List<SqlParameter> ps = new List<SqlParameter>();
foreach (var ele in root.Element("field").Elements())
{
if (ele.Element("search").Value.Equals(""))
{
HtmlInputText tb = page.FindControl("search_" + ele.Name.ToString()) as HtmlInputText;
if (tb == null)
continue; if (!tb.Value.Trim().Equals(""))
{
conditions.Add(string.Format("{0} like '%'+@{0}+'%'", ele.Name.ToString()));
ps.Add(new SqlParameter("@" + ele.Name.ToString(), tb.Value.Trim()));
}
}
}
//是否有删除标识
foreach (var ele in root.Element("flag").Elements())
{
if (ele.Value.Equals(""))
conditions.Add(ele.Name + " " + ele.Value);
}
string strWhere = "";
if (conditions.Count > )
strWhere = "where " + string.Join(" and ", conditions.ToArray()); //拼接sort条件语句
List<string> sorts = new List<string>();
foreach (var ele in root.Element("sorts").Elements())
{
sorts.Add(ele.Element("field").Value + " " + ele.Element("type").Value);
}
string strOrderBy = "";
if (sorts.Count > )
strOrderBy = "order by " + string.Join(",", sorts.ToArray()); //拼接sql语句
string sql = string.Format("select top {0} * from {1} {2} {3}", topNumber, tableName, strWhere, strOrderBy);
DataTable dt = SqlHelper.ExecuteDataTable(sql, ps); BindGV(dt, root, objIndex);
} public void BindGV(DataTable dt, XElement root, object objIndex)
{
gv.DataSource = null;
gv.Columns.Clear();
gv.AutoGenerateColumns = false;
gv.AllowPaging = true;
gv.PageSize = int.Parse(root.Element("pageSize").Value); BoundField gvColumn = null;
foreach (var ele in root.Element("field").Elements())
{
if (ele.Element("visible").Value.Equals(""))
{
gvColumn = new BoundField();
gvColumn.HeaderText = ele.Element("cn").Value;
gvColumn.DataField = ele.Name.ToString();
gv.Columns.Add(gvColumn);
gvColumn = null;
}
} gv.DataSource = dt;
gv.PageIndex = objIndex == null ? : Convert.ToInt32(objIndex);
gv.DataBind();
} private void Gv_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
dele(sender, e);
BindData(e.NewPageIndex);
}
}
}
然后，是SqlHelper，这个就不放出来了，以前也发过。
接着创建一个xml，我是放在项目主目录下的“xml”文件夹内，内容如下：
<?xml version="1.0" encoding="utf-8" ?>
<root>
<tableName>V_121_LOT_LIST</tableName>
<top>100</top>
<field>
<lot_id>
<cn>Id</cn>
<visible>0</visible>
<search>0</search>
</lot_id>
<lot_code>
<cn>批号</cn>
<visible>0</visible>
<search>0</search>
</lot_code>
<plan_qty>
<cn>生产数量</cn>
<visible>1</visible>
<search>1</search>
</plan_qty>
<now_qty>
<cn>当前数量</cn>
<visible>0</visible>
<search>1</search>
</now_qty>
</field>
<flag>
<state_flg>1</state_flg>
<del_flg>1</del_flg>
</flag>
<sorts>
<sort>
<field>lot_id</field>
<type>desc</type>
</sort>
</sorts>
<pageSize>20</pageSize>
</root>
最后，创建一个WebForm.aspx，
下面分别是后台和前端的代码：
using Cong.Utility;
using System;
using System.Web.UI.WebControls; namespace QueryTemplet
{
public partial class lot : System.Web.UI.Page
{
private static string xmlName = "lot.xml"; protected QueryHelper qh = null; protected void Page_Load(object sender, EventArgs e)
{
qh = new QueryHelper(xmlName, this, Gv_PageIndexChanging);
qh.BindData(ViewState["pageIndex"]);
} private void Gv_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
ViewState["pageIndex"] = e.NewPageIndex;
} protected void btnSearch_Click(object sender, EventArgs e)
{
qh.BindData(ViewState["pageIndex"]);
}
}
}
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="lot.aspx.cs" Inherits="QueryTemplet.lot" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
Id：<input type="text" id="search_lot_id" runat="server" />
批号：<input type="text" id="search_lot_code" runat="server" />
<br />
<asp:Button Text="查找" ID="btnSearch" runat="server" OnClick="btnSearch_Click" />
</div>
<div>
<asp:GridView ID="gv" runat="server">
</asp:GridView>
</div>
</form>
</body>
</html>
前端的代码，自己再套上样式和编写js代码就可以使用了。
最后，也放出另一个效果图，我做好这个新的页面，只复制粘贴了几分钟。
就这些，欢迎交流。