<?xml version="1.0" encoding="utf-8"?>
<DBTable>
  <table>
    <CName>任职资格台账</CName>
    <EName>rzzgtz</EName>
    <Identity>R_Id</Identity>
    <columns>
      <eColumn eName="xuhao" eType="nvarchar(MAX)" cName="序号" eLength="varchar(10)" />
      <eColumn eName="Ztype" eType="nvarchar(MAX)" cName="证书类别" eLength="varchar(10)" />
      <eColumn eName="bM" eType="nvarchar(MAX)" cName="部门" eLength="varchar(10)" />
      <eColumn eName="Name" eType="nvarchar(MAX)" cName="姓名" eLength="varchar(10)" />
      <eColumn eName="Gender" eType="nvarchar(MAX)" cName="性别" eLength="varchar(10)" />
      <eColumn eName="CID" eType="nvarchar(MAX)" cName="省份证号" eLength="varchar(10)" />
      <eColumn eName="tTemp" eType="nvarchar(MAX)" cName="文化程度" eLength="varchar(10)" />
      <eColumn eName="ziwu" eType="nvarchar(MAX)" cName="职务/职称" eLength="varchar(10)" />
      <eColumn eName="fzjg" eType="nvarchar(MAX)" cName="发证机关" eLength="varchar(10)" />
      <eColumn eName="XCID" eType="nvarchar(MAX)" cName="证书编号" eLength="varchar(10)" />
      <eColumn eName="Qtime" eType="nvarchar(MAX)" cName="取证时间" eLength="varchar(10)" />
      <eColumn eName="fTime" eType="nvarchar(MAX)" cName="复审时间" eLength="varchar(10)" />
      <eColumn eName="Other" eType="nvarchar(MAX)" cName="备注" eLength="varchar(10)" />
    </columns>
  </table>
<DBTable>

/**
 *张国强 2014-02-19 15:06
 *XML文件的读写方法
 *编写目的：将中文表名和数据中的表名进行绑定
 */

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
//
using System.Xml;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;



namespace CommonLib
{
    public class XMLBase : Page
    {
        //声明一个XMLDom对象
        XmlDocument xmlDoc = null;
        XmlNode root = null;
        /// <summary>
        /// 文件地址
        /// </summary>
        string xmlPath = ConfigurationManager.ConnectionStrings["XMLPath"].ConnectionString;
        /// <summary>
        /// 第一步加载xml文件
        /// </summary>
        public void LoadDome()
        {
            xmlDoc = new XmlDocument();
            string path = Server.MapPath(xmlPath);//转换为物理路径
            xmlDoc.Load(path);//加载文件
            root = xmlDoc.SelectSingleNode("DBTable");
        }
        /// <summary>
        /// 向XML中添加一个节点
        /// </summary>
        /// <param name="cName">中文名称</param>
        /// <param name="eName">对应的数据表名称</param>
        public void InsertNode(string cName, string eName, string id)
        {
            XmlElement table = xmlDoc.CreateElement("table");
            //添加中文名
            XmlElement c_Name = xmlDoc.CreateElement("CName");
            c_Name.InnerText = cName;
            table.AppendChild(c_Name);
            //添加英文名
            XmlElement e_Name = xmlDoc.CreateElement("EName");
            e_Name.InnerText = eName;
            table.AppendChild(e_Name);
            //添加主键
            XmlElement iditent = xmlDoc.CreateElement("Identity");
            iditent.InnerText = id;
            table.AppendChild(iditent);
            root.AppendChild(table);
            string path = Server.MapPath(xmlPath);//转换为物理路径
            xmlDoc.Save(path);//将添加的数据保存到文件中
        }



        /// <summary>
        /// 向子节点中添加列名数据
        /// </summary>
        /// <param name="cTable">中文名称表明</param>
        /// <param name="eTableName">英文名称表明</param>
        /// <param name="eName">列名英文名</param>
        /// <param name="eType">数据类型</param>
        /// <param name="cName">列名中文名</param>
        /// <param name="eLenght">数据长度</param>
        public void InsertNode(string cTable, string eTableName, string eName, string eType, string cName, string eLenght)
        {
            //找到父节点名
            XmlNode fatherNode = xmlDoc.SelectSingleNode("DBTable");
            XmlNode nodeRoot = null;

            for (int i = 0; i < fatherNode.ChildNodes.Count; i++)
            {
                nodeRoot = fatherNode.ChildNodes[i];
                var c_Name = nodeRoot.ChildNodes[0].InnerText;
                var e_Name = nodeRoot.ChildNodes[1].InnerText;
                if (cName == c_Name && e_Name == eName)
                {
                    break;
                }
            }
            //想父节点添加数据
            var se = (nodeRoot as XmlNode).SelectSingleNode("columns");
            XmlElement columns = null;
            if (se == null)
            {
                columns = xmlDoc.CreateElement("columns");
            }
            else
            {
                columns = (se as XmlElement);
            }

            XmlElement eColumn = xmlDoc.CreateElement("eColumn");
            eColumn.SetAttribute("eName", eName);
            eColumn.SetAttribute("eType", eType);
            eColumn.SetAttribute("cName", cName);
            eColumn.SetAttribute("eLength", eLenght);
            columns.AppendChild(eColumn);
            nodeRoot.AppendChild(columns);
            string path = Server.MapPath(xmlPath);//转换为物理路径
            xmlDoc.Save(path);//将添加的数据保存到文件中




        }

        /// <summary>
        /// 检查节点绑定时候有重复的内容
        /// </summary>
        /// <param name="cName">中文名称</param>
        /// <param name="eName">对应的数据表名称</param>
        /// <returns>存在返回false 不存在返回true</returns>
        public bool CheckNode(string cName, string eName)
        {
            bool resout = true;
            XmlNode nodeRoot = xmlDoc.SelectSingleNode("DBTable");//找到根节点
            for (int i = 0; i < nodeRoot.ChildNodes.Count; i++)
            {
                var tab = nodeRoot.ChildNodes[i];
                var c_Name = tab.ChildNodes[0].InnerText;
                var e_Name = tab.ChildNodes[1].InnerText;


                if (cName == c_Name || e_Name == eName)
                {
                    resout = false;
                }
            }
            return resout;
        }
        /// <summary>
        /// 删除节点
        /// </summary>
        /// <param name="cName"></param>
        /// <param name="eName"></param>
        /// <param name="res"></param>
        public void DeleteNode(string cName, string eName, bool res)
        {
            XmlNode node = GetXMLNode(cName, eName);
            if (node != null)
            {
                XmlNode par = node.ParentNode;
                if (res)
                {
                    string sql = " drop table " + eName;
                    par.RemoveChild(par);
                }
                else
                {
                    par.RemoveChild(node);
                }
            }
            string path = Server.MapPath(xmlPath);//转换为物理路径
            xmlDoc.Save(path);//将添加的数据保存到文件中
        }
        /// <summary>
        /// 检查是否存在值相同的节点
        /// </summary>
        /// <param name="cName">中文表明</param>
        /// <param name="eName">英文表明</param>
        /// <returns>查找到的节点</returns>
        public XmlNode GetXMLNode(string cName, string eName)
        {
            XmlNode resout = null;
            XmlNode nodeRoot = xmlDoc.SelectSingleNode("DBTable");//找到根节点
            for (int i = 0; i < nodeRoot.ChildNodes.Count; i++)
            {
                var tab = nodeRoot.ChildNodes[i];
                var c_Name = tab.ChildNodes[0].InnerText;
                var e_Name = tab.ChildNodes[1].InnerText;

                if (cName == c_Name && e_Name == eName)
                {
                    resout = tab;
                    break;
                }
            }
            return resout;
        }


        /// <summary>
        /// 修改节点
        /// </summary>
        /// <param name="cName">y中文名</param>
        /// <param name="EName">英文名</param>
        /// <returns></returns>
        public bool UpdateNode(string cName, string eName)
        {
            bool resoult = false;
            XmlNode nodeRoot = xmlDoc.SelectSingleNode("DBTable");//找到根节点
            for (int i = 0; i < nodeRoot.ChildNodes.Count; i++)
            {
                var tab = nodeRoot.ChildNodes[i];
                if (tab.ChildNodes[1].InnerText == eName)
                {
                    tab.ChildNodes[0].InnerText = cName;
                    string path = Server.MapPath(xmlPath);//转换为物理路径
                    xmlDoc.Save(path);//将添加的数据保存到文件中
                    resoult = true;
                }

            }
            return resoult;

        }

        /// <summary>
        /// 获取数据表字段
        /// </summary>
        /// <param name="eName">英文表名</param>
        /// <param name="cName">中文表名</param>
        /// <returns>用’|‘ 分割 第一个数据列为因为列表名 用‘，’ 号隔开 第二个数据列为备注名用‘[’ 隔开</returns>
        public string Check(string eName, string cName)
        {
            string resout = "";

            XmlNode node = GetXMLNode(cName, eName);

            if (node != null)
            {
                //获取列集合
                var columns = node.SelectSingleNode("columns");
                for (int i = 0; i < columns.ChildNodes.Count; i++)
                {
                    resout += columns.ChildNodes[i].Attributes[0].Value.ToString() + ",";
                }
                resout = resout.Substring(0, resout.Length - 1);
                resout += "|";
                for (int i = 0; i < columns.ChildNodes.Count; i++)
                {
                    resout += columns.ChildNodes[i].Attributes[2].Value.ToString() + "[";
                }
                resout = resout.Substring(0, resout.Length - 1);
            }

            return resout;
        }

        #region  张国强 2014-02-24

        /// <summary>
        /// 获取所有的数据表名称
        /// </summary>
        /// <returns>获取xml数据中的中文名和英文名格式【中文名，英文名】结果需要拆分以逗号拆分</returns>
        public List<XMLTableInfo> GetTableList()
        {
            List<XMLTableInfo> tableList = new List<XMLTableInfo>();
            var node = xmlDoc.SelectSingleNode("DBTable");
            for (int i = 0; i < node.ChildNodes.Count; i++)
            {
                XMLTableInfo tb = new XMLTableInfo();
                tb.CName = node.ChildNodes[i].ChildNodes[0].InnerText.ToString();
                tb.EName = node.ChildNodes[i].ChildNodes[1].InnerText.ToString();
                tableList.Add(tb);
            }
            return tableList;
        }

        public string GetIdentity(string eName, string cName)
        {
            string iditent = "";
            //获取节点
            XmlNode node = GetXMLNode(cName, eName);
            if (node != null)
            {
                iditent = node.SelectSingleNode("Identity").InnerText;
            }
            return iditent;
        }
        #endregion

    }

    /// <summary>
    /// XML 数据表名称结构
    /// </summary>
    public class XMLTableInfo
    {
        /// <summary>
        /// 中文名称
        /// </summary>
        public string CName { get; set; }
        /// <summary>
        /// 英文名称
        /// </summary>
        public string EName { get; set; }
    }}

<?xml version="1.0" encoding="utf-8"?>

<!--
  有关如何配置 ASP.NET 应用程序的详细信息，请访问
  http://go.microsoft.com/fwlink/?LinkId=169433
  -->

<configuration>
  <connectionStrings>
    <!--数据库连接字段-->
    <add name="SqlServer" connectionString="server=192.168.1.124;database=ExcelToSqlserver; uid=sa; pwd=123;"/>
    <!--XML文件路径-->
    <add name="XMLPath" connectionString="~/DBTablePage.xml" /> 
    <!--EXCEL 数据导入表文件-->
    <add name="ExcelUpLoadPath" connectionString="~/upload/EXCEL/" />
    <add name="RecorddPath" connectionString="../upload/attached/" />
   
   
    
  </connectionStrings>
    <system.web>
      <compilation debug="true" targetFramework="4.0" />
      <httpRuntime requestValidationMode="2.0" />
    </system.web>

</configuration>

/**
 *张国强 2014-02-10
 *目的管理excel文件的读写
 *数据读取，表头检查
 *数据类型检查
 */

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Data;
using System.Data.OleDb;
using System.IO;

using System.Configuration;
using System.Web.UI.WebControls;




namespace CommonLib
{
    public class ExcelHelper : System.Web.UI.Page
    {
        static string conStr = ConfigurationManager.ConnectionStrings["SqlServer"].ToString();
        static SqlConnection con = new SqlConnection(conStr);

        /// <summary>
        /// 通过不同的文件名称获取不同的链接对象
        /// </summary>
        /// <param name="path">上传路径地址</param>
        /// <returns>返回链接对象</returns>
        public static OleDbConnection GetConnection(string path)
        {
            /*Office 2007*/
            string ace = "Microsoft.ACE.OLEDB.12.0";
            /*Office 97 - 2003*/
            string jet = "Microsoft.Jet.OLEDB.4.0";
            string xl2007 = "Excel 12.0 Xml";
            string xl2003 = "Excel 8.0";
            string imex = "IMEX=1";
            /* csv */
            string text = "text";
            string fmt = "FMT=Delimited";
            string hdr = "NO";
            string conn = "Provider={0};Data Source={1};Extended Properties=\"{2};HDR={3};{4}\";";
            string ext = Path.GetExtension(path);

            DataTable dt = new DataTable("data");
            switch (ext.ToLower())
            {
                case ".xlsx":
                    conn = String.Format(conn, ace, Path.GetFullPath(path), xl2007, hdr, imex);
                    break;
                case ".xls":
                    conn = String.Format(conn, jet, Path.GetFullPath(path), xl2003, hdr, imex);
                    break;
                case ".csv":
                    conn = String.Format(conn, jet, Path.GetDirectoryName(path), text, hdr, fmt);
                    //sheet = Path.GetFileName(path);
                    break;
                default:
                    throw new Exception("File Not Supported!");
            }
            OleDbConnection con = new OleDbConnection(conn);
            return con;
        }


        /// <summary>
        /// 根据excel路径和sheet名称，返回excel的DataTable
        /// </summary>
        public static DataTable GetExcelDataTable(string path, string tname)
        {
            string select = string.Format("SELECT * FROM [{0}$]", tname);
            string ext = Path.GetExtension(path);
            OleDbDataAdapter oda;
            DataTable dt = new DataTable("data");
            OleDbConnection con = GetConnection(path);
            con.Open();
            oda = new OleDbDataAdapter(select, con);

            oda.Fill(dt);
            con.Close();
            return dt;
        }

        /// <summary>
        /// 获取数据表中的Sheet名称
        /// 2014-02-26
        /// 问题后延
        /// </summary>
        /// /// <param name="saveName">上传文件路径名称</param>
        /// <returns>Sheet数据列表</returns>
        public static List<string> GetExcelSheetName(string saveName)
        {
            List<string> list = null;
            Microsoft.Office.Interop.Excel.ApplicationClass excelApp = new Microsoft.Office.Interop.Excel.ApplicationClass();
            Microsoft.Office.Interop.Excel.Workbooks wbs = excelApp.Workbooks;
            Microsoft.Office.Interop.Excel.Workbook wb = wbs.Open(saveName, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
            int count = wb.Worksheets.Count;
            if (count > 0)
            {
                list = new List<string>();
                for (int i = 0; i < count; i++)
                {
                    string name = ((Microsoft.Office.Interop.Excel.Worksheet)wb.Worksheets[i]).Name;
                    list.Add(name);
                }
                wb.Close(null, null, null);
                excelApp.Quit();
                System.Runtime.InteropServices.Marshal.ReleaseComObject(excelApp);
                System.Runtime.InteropServices.Marshal.ReleaseComObject(excelApp);
                System.Runtime.InteropServices.Marshal.ReleaseComObject(wbs);
                excelApp = null;
                wbs = null;
                wb = null;
                GC.Collect();
            }
            return list;
        }

        /// <summary>
        /// 读取Excel表中有效数据生成数据集合
        /// 2014-02-26
        /// </summary>
        /// <param name="dTable">DataTable</param>
        /// <param name="rowIndex">行有效数据开始</param>
        /// <param name="colIndex">列有效数据开始</param>
        /// <param name="saveName">Excel上传文件保存路径</param>
        /// <param name="sheetName">Sheet名称 默认为Sheet1</param>
        /// <returns>返回数据表数据用逗号隔开</returns>
        public static List<string> GetExcelDate(int rowIndex, int colIndex, string saveName, string sheetName = "Sheet1")
        {
            List<string> list = null;
            DataTable dtabe = ExcelHelper.GetExcelDataTable(saveName, sheetName);
            int icolums = dtabe.Columns.Count;
            int irows = dtabe.Rows.Count;
            //获取数据表中数据
            if (irows > rowIndex)
            {
                list = new List<string>();

                for (int j = rowIndex; j < irows; j++)
                {

                    string da = "";
                    for (int i = colIndex; i < icolums; i++)
                    {

                        da += dtabe.Rows[j][i].ToString() + ",";
                    }

                    if (da.Length != icolums)//判读空数据行
                    {
                        da = da.Substring(0, da.Length - 1);
                        list.Add(da);

                    }

                }
            }
            return list;
        }

        /// <summary>
        /// 检查Excel数据表中的表头和数据库中的表头时候相符
        /// 2014-02-26
        /// </summary>
        /// <param name="eName">数据库中的英文表名</param>
        /// <param name="cName">中文备注表名名称</param>
        /// <param name="saveName">上传Excel文件保存路径地址服务器地址</param>
        /// <param name="sheetName">Excel数据表中Sheet名称</param>
        /// <returns>返回检测结果，结果为空值验证通过，不为空值验证失败不可以正常导入</returns>
        public string CheckExcelTitle(string eName, string cName, string saveName, string sheetName = "Sheet1")
        {
            string resout = "";
            XMLBase xmlBase = new XMLBase();
            xmlBase.LoadDome();
            //获取数据表格字段值
            string che = xmlBase.Check(eName, cName);
            string[] columesInfo = null;
            if (che != "")
            {

                columesInfo = che.Split(‘|‘);
            }
            string ename = columesInfo[0];
            string cname = columesInfo[1];
            //获得数据表中列字段值
            // ename = ename.Substring(0, ename.Length - 1);
            //获得XML数据列名
            // cname = cname.Substring(0, cname.Length - 1);
            string[] TbE_name = ename.Split(‘,‘);
            string[] TbC_name = cname.Split(‘[‘);
            DataTable dtabe = ExcelHelper.GetExcelDataTable(saveName, sheetName);
            int icolums = dtabe.Columns.Count;
            int irows = dtabe.Rows.Count;
            //获取表头
            List<string> list = new List<string>();
            string na = "";
            for (int i = 0; i < icolums; i++)
            {
                na += dtabe.Rows[0][i].ToString() + "+";
                list.Add(dtabe.Rows[0][i].ToString());
            }

            if (list.Count != TbC_name.Length)
            {
                resout = "列名和数据库中列名长度不一样！";
            }
            else
            {
                for (int i = 0; i < TbC_name.Length; i++)
                {
                    if (TbC_name[i] != list[i])
                    {
                        string mes = "第" + (i + 1) + "列表头不是【" + TbC_name[i] + "】请重新调整";
                        resout += mes;
                    }
                }
            }

            return resout;

        }


        /// <summary>
        /// 获取SQl数据集
        /// </summary>
        /// <param name="sql"></param>
        /// <returns></returns>
        public static DataSet GetDataSet(string sql)
        {
            if (sql == "")
            {
                return null;
            }
            SqlConnection con = new SqlConnection();
            con.ConnectionString = conStr;
            con.Open();
            SqlDataAdapter adp = new SqlDataAdapter(sql, con);
            DataSet ds = new DataSet();
            adp.Fill(ds, "table");
            con.Close();
            return ds;
        }

        #region 2014-02-28 生成执行语句
        /// <summary>
        /// 生成添加数据Sql语句
        /// 2014-02-26
        /// </summary>
        /// <returns>通过传入参数返回添加Sql语句最后需要添</returns>
        public static string InserToSqlQuerystring(string eName, string cName)
        {
            string sql = "";
            XMLBase xml = new XMLBase();
            xml.LoadDome();
            //获取列名
            string che = xml.Check(eName, cName);
            if (che != "")
            {
                sql = "insert into  " + eName + "  (";
                //截取数据
                string colums = che.Split(‘|‘)[0];
                sql += colums + ") values  ";
            }
            return sql;
        }

        /// <summary>
        /// 获取删除语句
        /// </summary>
        /// <param name="eName">英文名称</param>
        /// <param name="cName">中文名称</param>
        /// <param name="id">需要删除的Id编号</param>
        /// <returns></returns>
        public static string DeleteQuerystring(string eName, string cName, string id)
        {
            string sql = "";
            //获取数据表数据列
            XMLBase xml = new XMLBase();
            xml.LoadDome();
            //获取列名
            string che = xml.GetIdentity(eName, cName);
            if (id.IndexOf(‘,‘) == -1)
            {
                sql = "delete " + eName + " where " + che + "= " + id;
            }
            else
            {
                sql = "delete " + eName + " where " + che + " in ( " + id + " )";
            }

            return sql;
        }
        /// <summary>
        /// 动态生成修改语句
        /// </summary>
        /// <param name="eName">英文名</param>
        /// <param name="cName">中文名</param>
        /// <param name="id">编号ID</param>
        /// <returns> 语句</returns>
        public static string UpdateQueryString(string eName, string cName, int id)
        {
            string sql = "";
            XMLBase xml = new XMLBase();
            xml.LoadDome();
            //获取列名
            string che = xml.Check(eName, cName);
            sql = "update  " + eName + "   set  ";
            if (che != "")
            {
                string[] colums = che.Split(‘|‘)[0].Split(‘,‘);
                for (int i = 0; i < colums.Length; i++)
                {
                    sql += colums[i] + "= {" + i + "} ,";
                }
            }
            sql = sql.Substring(0, sql.Length - 1);
            sql += "  where " + xml.GetIdentity(eName, cName) + "=" + id;
            return sql;

        }

        /// <summary>
        /// 查询出一条数据
        /// </summary>
        /// <param name="eName">中文表明</param>
        /// <param name="cName">英文表明</param>
        /// <param name="id">主键Id</param>
        /// <returns></returns>
        public static string GetModelQueryString(string eName, string cName, int id)
        {
            string sql = "";
            XMLBase xBase = new XMLBase();
            xBase.LoadDome();
            sql = "select * from " + eName + "  where " + xBase.GetIdentity(eName, cName) + " =" + id;
            return sql;
        }
        //2014-03-03 生成执行语句
        /// <summary>
        /// 获取查询数据总数量
        /// </summary>
        /// <param name="eName"></param>
        /// <param name="cName"></param>
        /// <returns></returns>
        public static string GetCountQueryString(string eName, string where)
        {
            string countsql = "select count(*) from  " + eName + "   ";
            if (where != "")
            {
                countsql += " where  " + where;
            }

            return countsql;
        }

        /// <summary>
        ///动态生成分页语句
        /// </summary>
        /// <param name="eName"></param>
        /// <param name="cName"></param>
        /// <param name="strWhere">查询条件</param>
        /// <param name="orderby">派</param>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        public static string GetPageQueryStrong(string eName, string cName, string strWhere, string orderby, int pageIndex, int pageSize)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("SELECT * FROM ( ");
            strSql.Append(" SELECT ROW_NUMBER() OVER (");
            if (!string.IsNullOrEmpty(orderby.Trim()))
            {
                strSql.Append("order by T." + orderby);
            }
            else
            {
                XMLBase ba = new XMLBase();
                ba.LoadDome();

                strSql.Append("order by T." + ba.GetIdentity(eName, cName) + " desc");
            }
            strSql.Append(")AS Row, T.*  from  " + eName + "  T ");
            if (!string.IsNullOrEmpty(strWhere.Trim()))
            {
                strSql.Append(" WHERE " + strWhere);
            }
            strSql.Append(" ) TT");
            strSql.AppendFormat(" WHERE TT.Row between {0} and {1}", (pageIndex - 1) * pageSize + 1, pageIndex * pageSize);
            return strSql.ToString();
        }
        #endregion

        #region 2014-02-28 执行结果
        /// <summary>
        /// 向数据库中添加数据
        /// 2014-02-26
        /// </summary>
        /// <param name="sql">执行的Sql语句返回影响数据库中的行数</param>
        /// <returns></returns>
        public static int ExecuteNonQuery(string sql)
        {

            int resour = 0;

            try
            {
                con.Open();
                SqlCommand cmd = new SqlCommand(sql, con);
                resour = cmd.ExecuteNonQuery();
                con.Close();
                GC.Collect();
            }
            catch (Exception)
            {
                con.Close();

            }
            return resour;

        }

        /// <summary>
        /// 添加 修改，数据库返回情况
        /// </summary>
        /// <param name="sql"></param>
        /// <returns></returns>
        public static int ExecSclaer(string sql)
        {
            int resour = 0;
            try
            {
                con.Open();
                SqlCommand cmd = new SqlCommand(sql, con);
                object obj = cmd.ExecuteScalar();
                resour = Convert.ToInt32(obj);
                con.Close();
                GC.Collect();
            }
            catch (Exception)
            {
                con.Close();
                GC.Collect();
            }
            return resour;
        }

        /// <summary>
        /// 获取一条数据
        /// </summary>
        /// <param name="sql"></param>
        /// <returns>返回单挑数据‘|‘隔开</returns>
        public static string SelectToSqlModel(string sql)
        {
            string vals = "";
            SqlCommand cmd = new SqlCommand(sql, con);
            con.Open();
            SqlDataReader read = cmd.ExecuteReader(CommandBehavior.CloseConnection);
            if (read.HasRows)
            {

                while (read.Read())
                {
                    for (int i = 0; i < read.FieldCount; i++)
                    {
                        vals += read[i].ToString() + "|";
                    }
                }
            }
            read.Close();
            con.Close();
            GC.Collect();
            vals = vals.Substring(0, vals.Length - 1);
            return vals;
        }
        #endregion

        #region Excel 模板导出
        public static void exportTemper(string eName, string cName, string saveName, string sql)
        {
           //自行拓展
        }
        #endregion


    }
}

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="ExcelToSqlserver.Default" %>

<!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>XML操作处理</title>
</head>
<body>
    <form id="form1" runat="server">
        <div>
            <h3>创建表格：</h3>
            <p>
                中文表名：<asp:TextBox ID="txtCname" runat="server"></asp:TextBox>
                <br />
                <br />
                数据表名：<input type="text" id="txtEName" runat="server"  onkeyup="this.value=this.value.replace(/[^a-zA_Z_]/,‘‘);" />提示：接受输入字母和下划线
                <br />
                <br />
                数据主键：<input type="text" runat="server" id="txtIditent" size="20" onkeyup="this.value=this.value.replace(/[^a-zA-Z_]/,‘‘);" /> 提示：接受输入字母和下划线
                <br />
                <br />
                <asp:Button ID="btnAdd" runat="server" OnClick="Button1_Click" Enabled="false" Text="添加" Style="height: 21px" />
                &nbsp;
        <asp:Button ID="btnChange" runat="server" OnClick="Button2_Click" Enabled="false" Text="修改" />
                &nbsp;
        <asp:Button ID="btnDel" runat="server" OnClick="Button3_Click" Enabled="false" Text="删除" />
                &nbsp;&nbsp;
        <asp:Button ID="btnCheck" runat="server" OnClick="btnCheck_Click" Text="检查" />
                <br />
                <asp:Label ID="Label1" runat="server"></asp:Label>
            </p>
        </div>
       
    </form>
</body>
</html>

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="IniTableColums.aspx.cs" Inherits="ExcelToSqlserver.IniTableColums" %>

<!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>
    <script type="text/javascript" src="Scripts/jquery-1.8.2.min.js"></script>
</head>
<body>
    <form id="form1" runat="server">
        当前位置：添加表头<br />
        <br />
        数据表名称：<asp:TextBox ID="txtCName" runat="server" ReadOnly="True"></asp:TextBox>
        <input type="hidden" runat="server" id="hiddTableName" />
        <br />
        <br />
        <h3>提示：英文名是需要在数据库中保存的由字母和下划线组成</h3>
        <div class="divCoulm">
            <hr />
            英文名：<input class="txtEName" type="text" onkeyup="this.value=this.value.replace(/[^a-zA-Z]/,‘‘);" />
            &nbsp; 对应数据类型：<select class="rdType">
                <option value="nvarchar(MAX)" selected="selected">文字类型</option>
                <option value="float">小数类型</option>
                <option value="int">整数类型</option>
            </select>
            <br />
            <br />
            备注名：<input type="text" class="txtBeizhu" />
            &nbsp; 数据字节长度：<select class="txtLenght">
                <option value="varchar(10)">10</option>
                <option value="varchar(20)">20</option>
                <option value="nvarchar(MAX)">最大</option>
            </select>
            <br />
            <br />
            <input type="button" onclick="del(this)" class="delColum" value="删除" />
            <br />
            <hr />
        </div>
        <input type="button" value="继续添加数据列" id="btnGo" />
        &nbsp;&nbsp;&nbsp;&nbsp;
        <input type="button" value="确定" id="btnOK" />
    </form>
</body>
</html>
<script type="text/javascript">
    $(function () {

        //声明列名录入界面
        var addDocument = "   <div class=‘divCoulm‘> <hr />  英文名：<input class=‘txtEName‘ onkeyup=\"this.value=this.value.replace(/[^a-zA-Z]/,‘‘);\" type=‘text‘ /> 英文名有字母组成，没有下划线<br/> 对应数据类型：<select class=‘rdType‘>";

        addDocument += " <option value=‘nvarchar(MAX)‘ selected=‘selected‘>文字类型</option> <option value=‘float‘>小数类型</option>";

        addDocument += " <option value=‘varchar(9)‘>整数类型</option></select><br /> <br />  备注名：<input type=‘text‘ class=‘txtBeizhu‘ />";

        addDocument += "   &nbsp; 数据字节长度：<select class=‘txtLenght‘> <option value=‘varchar(10)‘>10</option> <option value=‘varchar(20)‘>20</option><option value=‘nvarchar(MAX)‘>最大</option></select>    <br /> <br />   <input type=\"button\" class=\"delColum\" onclick=‘ del(this)‘ value=\"删除\" />  <hr />  </div>";

        $("#btnGo").click(function () {
          var isGo;
            var div = $(this).prev("div");
            var eName = div.children(".txtEName").val();//英文名
            var eType = div .children(".rdType").val();//数据类型
            var cName = div .children(".txtBeizhu").val();//中文名称
            var cLength = div.children(".txtLenght").val();//字段长度
                isGo = CheckVoide(eName, eType, cName, cLength);
           
            if (!isGo) { alert("数据有误"); } else {
                $(".divCoulm").last().append(addDocument);
            }
        });

        $("#btnOK").click(function () {
            //获取数据
            var mess = "";
            $(".divCoulm").each(function () {
                var eName = $(this).children(".txtEName").val();//英文名
                var eType = $(this).children(".rdType").val();//数据类型
                var cName = $(this).children(".txtBeizhu").val();//中文名称
                var cLength = $(this).children(".txtLenght").val();//字段长度
                var isGo = CheckVoide(eName, eType, cName, cLength);
                if (isGo) {
                    mess += eName + "_" + eType + "_" + cName + "_" + cLength + "|";
                }
            });
            debugger;
            var go = confirm("确认添加添加后不得修改");
            if (go) {
                var tableName = $("#hiddTableName").val();//英文名称
                var tableCName = $("#txtCName").val();//中文名称;
                $.post("Ajax/CreatInfoToXML.ashx", { tableName: tableName, tableCName: tableCName, mess: mess }, function () {
                    window.location.href = "EnterExcel.aspx";
                });
            }
        });

        $(".delColum").click(function () {
            debugger;
            $(this).parent("div").html("");
        });

    });
    //检查数据是否为空
    function CheckVoide(eName, eType, cName, cLength) {
        if (eName == "" || eType == "" || cName == "" || cLength == "") {
            return false;
        } else if (eName != "" || eType != "" || cName != "" || cLength != "") {
            return true;
        }
    }
    function del(id)
    {
        $(id).parent("div").remove();
    }
</script>

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="EnterExcel.aspx.cs" Inherits="ExcelToSqlserver.EnterExcel" %>

<!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>EXCEL数据导入</title>
    <style type="text/css">
         li {
        display: inline;
        list-style: none;
         display: inline;
        list-style: none;
        padding-left: 15px;
    }
    </style>
    <script type="text/javascript" src="Scripts/jquery-1.8.2.min.js"></script>

</head>
<body>
    <form id="form1" runat="server">
    <div>
             <div>
            <ul>
                <li><a id="a_insert" runat="server">手动录入数据</a></li>
                <li>批量导入数据</li>

            </ul>
        </div>
        <br />
        导入数据：<asp:DropDownList ID="dropTableInfo" runat="server" Height="16px" Width="140px" AutoPostBack="True" OnSelectedIndexChanged="dropTableInfo_SelectedIndexChanged">
        </asp:DropDownList>
        <input type="hidden" runat="server" id="hiddTableName" />
             <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="删除节点测试" />
        <br />
        <br />
        选择EXCEL数据表：<asp:FileUpload ID="FileUpload1" runat="server" />
        <asp:Label ID="lblMess" runat="server" Text=""></asp:Label>
        <br />
        <br />
        选择有效数据行：第<asp:DropDownList ID="dropch" runat="server" Height="16px" Width="61px">
            <asp:ListItem>1</asp:ListItem>
            <asp:ListItem Selected="True">2</asp:ListItem>
            <asp:ListItem>3</asp:ListItem>
            <asp:ListItem>4</asp:ListItem>
            <asp:ListItem Value="5"></asp:ListItem>
            <asp:ListItem>6</asp:ListItem>
        </asp:DropDownList>行为有效数据
        <br />
        <br />
        <asp:Button ID="btnCheck" runat="server" Text="检查" OnClick="btnCheck_Click" />
        &nbsp;&nbsp;&nbsp;&nbsp;
        <asp:Button ID="btnOK" runat="server" Text="确认导入" OnClick="btnOK_Click" Enabled="False" />
        &nbsp;&nbsp;&nbsp;&nbsp; 
        <asp:Button ID="btnCon" runat="server" Enabled="false" Text="取消" OnClick="btnCon_Click" />
    </div>
         <div id="divShow" runat="server" visible="false">
            <h4>表头格式：参照以下表头来制作表格</h4>
             <strong>你也可以</strong>
             <br />
          <table cellpadding="1px" border="1px" >
              <tbody id="head" runat="server">
                  <tr>
                      <th style="border:1px solid;" >asdfafd</th>
                       <th style="border:1px solid;" >asdfafd</th>
                  </tr>
              </tbody>
          </table>
        </div>
    </form>
</body>
</html>

/*
 *张国强 2014-02-20
 *excel 表头检查
 *数据表读取数据
 *SQlserver数据表表头检查
 *主要操：EXCEL 数据表读取
 */
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
///
using CommonLib;
using System.Configuration;
using System.Data;

namespace ExcelToSqlserver
{
    public partial class EnterExcel : System.Web.UI.Page
    {

        XMLBase xmlBase = new XMLBase();

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                ViewState["excelPath"] = null;
                ViewState["start"] = 0;
                ViewState["end"] = 0;
                xmlBase.LoadDome();
                List<XMLTableInfo> datesource = xmlBase.GetTableList();
                if (datesource.Count > 0)
                {
                    dropTableInfo.DataSource = datesource;
                    dropTableInfo.DataTextField = "CName"; ;
                    dropTableInfo.DataValueField = "EName";
                    dropTableInfo.DataBind();
                    dropTableInfo.SelectedIndex = 0;
                    
                }
                dropTableInfo.Items.Add(new ListItem() { Text="没有数据表新建", Value="-1" });
                string eName = dropTableInfo.SelectedItem.Value;
                string cName = dropTableInfo.SelectedItem.Text;
                a_insert.Attributes.Add("href", "InsertInfo.aspx?cmd=insert&eName=" + eName + "&cName=" + cName);
            }
        }

        /// <summary>
        /// 检查数据列表
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void btnCheck_Click(object sender, EventArgs e)
        {
            //上传到服务器上
            string upFulPath = ConfigurationManager.ConnectionStrings["ExcelUpLoadPath"].ConnectionString;
            if (!FileUpload1.HasFile)
            {
                Response.Write("<script>alert(‘请选择上传文件‘)</script>");
                return;
            }
            string fileName = FileUpload1.FileName;
            string filetype = System.IO.Path.GetExtension(FileUpload1.FileName).ToLower();
            if (filetype == ".xlsx" || filetype == ".xls")
            {
                upFulPath = Server.MapPath(upFulPath);
                string saveName = upFulPath + DateTime.Now.ToString("yyyy-MM-dd-HH-mm-ss") + fileName;
                FileUpload1.SaveAs(saveName);
                lblMess.Text = "文件已上传";
                lblMess.Attributes.Add("style", "color:green;");
                ViewState["excelPath"] = saveName;
                btnCon.Enabled=true;
                xmlBase.LoadDome();
                string cName = dropTableInfo.SelectedItem.Text;
                string eName = dropTableInfo.SelectedValue;
                ///检查表头
                string cheInfo = new ExcelHelper().CheckExcelTitle(eName, cName, saveName, "Sheet1");
                if (cheInfo == "")
                {
                    Response.Write("<script>alert(‘验证通过‘)</script>");
                    btnOK.Enabled = true;
                   
                   
                }
                else
                {
                    //Excel数据表表头格形式提示
                    xmlBase.LoadDome();
                    string tab = xmlBase.Check(eName, cName);
                    string[] tblist = tab.Split(‘|‘)[1].Split(‘[‘);
                    string st = "<tr>";
                    for (int i = 0; i < tblist.Length; i++)
                    {
                        st += "<td>"+tblist[i]+"</td>";  
                    }
                    st+="</tr>";
                    this.head.InnerHtml = st;
                    divShow.Visible = true;

                    Response.Write("<script>alert(‘" + cheInfo + "‘)</script>");
                }
            }
            else
            {
                lblMess.Text = "不是有效的excel文件！请重选";
                return;

            }
            FileUpload1.Enabled = false;
            btnCheck.Enabled = false;

        }

        /// <summary>
        /// 导入数据
        /// 2014-02-16
        /// 
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void btnOK_Click(object sender, EventArgs e)
        {

            string path = ViewState["excelPath"].ToString();
            int rowIndex = Convert.ToInt32(dropch.SelectedValue);
            List<string> list = ExcelHelper.GetExcelDate(rowIndex - 1, 0, path, "Sheet1");
            string cName = dropTableInfo.SelectedItem.Text;
            string eName = dropTableInfo.SelectedValue;
            string sql = ExcelHelper.InserToSqlQuerystring(eName, cName);
            int inseCount = 0;
            for (int i = 0; i < list.Count; i++)
            {
                string vals = "";
                for (int j = 0; j < list[i].Split(‘,‘).Length; j++)
                {
                    vals += "‘" + list[i].Split(‘,‘)[j] + "‘ ,";
                }
                vals = vals.Substring(0, vals.Length - 1);
                string inser = sql + "  (" + vals + " );select @@IDENTITY";
               
                if (i==0)
                {
                    ViewState["start"] = ExcelHelper.ExecSclaer(inser);
                }
                else if(i==list.Count-1)
                {
                    ViewState["end"] = ExcelHelper.ExecSclaer(inser);
                }
                else
                {
                    ExcelHelper.ExecSclaer(inser);
                }
            }
            string mess = "Excel有效数据：" + list.Count + " 条 已经成功导入数据：" + inseCount + "条";
            Response.Write("<script>alert(‘" + mess + "‘)</script>");
            Response.Redirect("ExcelListShow.aspx?tbname=" + dropTableInfo.SelectedValue + "&start="+ViewState["start"].ToString()+"&end="+ViewState["end"].ToString()+"&cName="+dropTableInfo.SelectedItem.Text+"&eName="+dropTableInfo.SelectedValue);
        }

        //取消删除数据表
        protected void btnCon_Click(object sender, EventArgs e)
        {
            string path = ViewState["excelPath"].ToString();
            bool re = System.IO.File.Exists(path);
            if (re)
            {
                System.IO.File.Delete(path);
                lblMess.Text = "上传文件已删除";
                lblMess.Attributes.Add("style","color:green;");
                btnOK.Enabled = false;
                ViewState["excelPath"] = "";
                divShow.Visible = false;
                btnCon.Enabled = false;
                btnCheck.Enabled= true;
                FileUpload1.Enabled = true;
            }
        }

        protected void dropTableInfo_SelectedIndexChanged(object sender, EventArgs e)
        {
            string eName = dropTableInfo.SelectedItem.Value;
            string cName = dropTableInfo.SelectedItem.Text;
            lblMess.Text = "";
            if (eName=="-1")
            {
                Response.Redirect("Default.aspx");
            }
            else
            {
                a_insert.Attributes.Add("href", "InsertInfo.aspx?cmd=insert&eName=" + eName + "&cName=" + cName);
            }
           
        }

        protected void btnOutTemp_Click(object sender, EventArgs e)
        {
            string eName = dropTableInfo.SelectedItem.Value;
            string cName = dropTableInfo.SelectedItem.Text;

        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            XMLBase xb = new XMLBase();
            xb.LoadDome();
            xb.DeleteNode("中文名", "china", false);
        }
    }
}

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="ExcelListShow.aspx.cs" Inherits="ExcelToSqlserver.ExcelListShow" %>

<!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>
   
    <script type="text/javascript" src="Scripts/jquery-1.8.2.min.js"></script>
  
</head>
<body>
    <form id="form1" runat="server">
      <div>
          <input type="hidden"  id="hiddcName" runat="server" />
          <input type="hidden" id="hiddeName" runat="server" />
          <input  type
              ="hidden" id="hiddcmd" runat="server" />
          <a id="a_Add" runat="server">添加数据</a>    &nbsp;&nbsp;
        <a id="a_Del" href="#" runat="server">删除数据</a>
         
      </div>
    <div style="text-align:center;">
        <asp:GridView ID="NewGrid" runat="server">
            <Columns>

            </Columns>
        </asp:GridView>
    </div>
    </form>
</body>
</html>
<script type="text/javascript">
    $(function () {
        //全选择 全部不选择
        $(".heck_box").click(function () {
            var t = $(this).attr("checked");
            if (t) {
                $(".CheckBox").attr("checked", t);
            } else {
                $(".CheckBox").attr("checked", false);
            }
        });
        //删除数据隐藏行
        $(".A_DelBind").click(function () {
            $(this).parent("td").parent("tr").hide();
        });
        //删除事件
        $("#a_Del").click(function () {

            //获取表明
            var eName = $("#hiddeName").val();
            var cName = $("#hiddcName").val();
            var id = "";
            //获取主键ID
            $(".CheckBox").each(function () {
                var t = $(this).attr("checked");
                if (t) {
                    id += $(this).val() + ",";
                }
            });
            if (id=="") {
                alert("没有选中删除数据！");
                return false; 
            }
            if (id.length>2) {
                id = id.substring(0, id.length - 1);
            }
            var con = confirm("即将删除数据，删除后不能回复！");
            if (con) {
                $.get("Ajax/AjaxDateToSql.ashx", { cmd: "delete", id: id, cName: cName, eName: eName }, function () {


                });
            }

        });

    });
</script>

/*
 * 张国强
 * 2014-02-26
 * 动态生成GridView数据列表
 * 创建超链接
 * 
 * **/
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
//
using CommonLib;

namespace ExcelToSqlserver
{
    public partial class ExcelListShow : System.Web.UI.Page
    {
        XMLBase xBase = new XMLBase();

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                string tbname = Request.QueryString["tbname"].ToString();
               ViewState["start"] = Request.QueryString["start"].ToString();
               ViewState["end"] = Request.QueryString["end"].ToString();
                string cName = Request.QueryString["cName"].ToString();
                ViewState["cName"] = cName;
                string eName = Request.QueryString["eName"].ToString();

                //////测试
                //string tbname = "RZZGTZ"; //Request.QueryString["tbname"].ToString();
                //string top = "20";// Request.QueryString["top"].ToString();
                //string cName = "任职资格台账";// Request.QueryString["cName"].ToString();
                //ViewState["cName"] = cName;
                //string eName = "RZZGTZ";// Request.QueryString["eName"].ToString();

                hiddcName.Value = cName;
                hiddeName.Value = eName;
                ViewState["eName"] = eName;
                xBase.LoadDome();

                ViewState["identity"] = xBase.GetIdentity(eName, cName);
                a_Add.Attributes.Add("href", "InsertInfo.aspx?cName=" + cName + "&eName=" + eName + "&cmd=insert");
                xBase.LoadDome();
                //加载数据数据库中列名和备注名
                string tbInfo = xBase.Check(eName, cName);
                ViewState["tableInfo"] = null;
                if (tbInfo != null)
                {
                    ViewState["tableInfo"] = tbInfo;
                }
                //数据绑定
                string sql = "select *  from " + eName + "  where  " + xBase.GetIdentity(eName,cName)+"  between "+ ViewState["start"].ToString()+"  and  "+ ViewState["end"].ToString();
                new GridViewTemplate().LoadInfo(this.NewGrid, eName, cName, sql);
            }
        }


    }
}

/*2014-02-27
 * 张国强
 * Email:imei8service@gmail.com
 * 前台页面提交数据处理
 * 包括添加数据
 * 修改数据
 * 删除数据
 * 三种操作
 * 
 * **/
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
//
using CommonLib;

namespace ExcelToSqlserver.Ajax
{
    /// <summary>
    /// AjaxDateToSql 的摘要说明
    /// </summary>
    public class AjaxDateToSql : IHttpHandler
    {
        XMLBase xBase = new XMLBase();
        public void ProcessRequest(HttpContext context)
        {
            context.Response.ContentType = "text/plain";
            string cmd = context.Request.QueryString["cmd"].ToString();
            switch (cmd)
            {
                case "insert"://添加数据
                    Insert(context);
                    break;
                case "delete"://删除数据
                    Delete(context);
                    break;
                case "editor":
                    Editor(context);
                    break;
                default:
                    break;
            }
        }

        /// <summary>
        /// 修改数据
        /// </summary>
        /// <param name="context"></param>
        private void Editor(HttpContext context)
        {
            try
            {
                string cName = context.Request.QueryString["cName"].ToString();
                string eName = context.Request.QueryString["eName"].ToString();
                string id = context.Request.QueryString["id"].ToString();
                string values = context.Request.QueryString["values"].ToString();
                string sql = ExcelHelper.UpdateQueryString(eName, cName, Convert.ToInt32(id));
                string[] val = values.Split(‘|‘);
                string sql2 = string.Format(sql, val);
                int res = ExcelHelper.ExecuteNonQuery(sql2);
                if (res > 0)
                {
                    context.Response.Write("修改成功");
                }
                else
                {
                    context.Response.Write("NO");
                }
            }
            catch (Exception  ex)
            {
                 context.Response.Write("NO");
               
            }
            
        }

        /// <summary>
        /// 删除数据
        /// </summary>
        /// <param name="context"></param>
        private void Delete(HttpContext context)
        {
            //cName=""&eName=&id=‘
            string cName = context.Request.QueryString["cName"].ToString();
            string eName = context.Request.QueryString["eName"].ToString();
            string id = context.Request.QueryString["id"].ToString();
            //获取删除语句
            string s = ExcelHelper.DeleteQuerystring(eName, cName, id);
            int resout = ExcelHelper.ExecuteNonQuery(s);
            if (resout > 0)
            {
               context.Response.Redirect("../ShowList.aspx?cName=" + cName + "&eName=" + eName);
            }


        }
        /// <summary>
        /// 添加数据
        /// </summary>
        /// <param name="context"></param>
        private void Insert(HttpContext context)
        {
            string sql = context.Request.QueryString["values"].ToString();
            string eName = context.Request.QueryString["eName"].ToString();
            string cName = context.Request.QueryString["cName"].ToString();
            if (sql != "")
            {
                xBase.LoadDome();
                string s = ExcelHelper.InserToSqlQuerystring(eName, cName);
                string[] va = sql.Split(‘|‘);
                string v = "";
                for (int i = 0; i < va.Length; i++)
                {
                    v += va[i] + ",";
                }
                v = v.Substring(0, v.Length - 1);
                s += " (" + v + " );select @@IDENTITY";
                int t = ExcelHelper.ExecSclaer(s);
                if (t > 0)
                {
                    context.Response.Write("添加成功");
                }
                else
                {
                    context.Response.Write("NO");
                }
            }
            else
            {
                context.Response.Write("NO");
            }

        }

        public bool IsReusable
        {
            get
            {
                return false;
            }
        }
    }
}

/*
 * 2014-02-27
 * GridView数据列绑定帮助文档
 * 用于动态添查询数据绑定到数据表中
 * 提供各种类型的绑定
 * 
 * **/
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
//
using System.Web.UI;
using System.Web.UI.WebControls;

namespace CommonLib
{
    /// <summary>
    /// GridView数据列绑定中兴
    /// </summary>
    public class GridViewTemplate : ITemplate
    {
        public delegate void EventHandler(object sender, EventArgs e);
        public event EventHandler eh;
       
        private DataControlRowType templateType;
        private string columnName;
        private string controlID;
        private XMLTableInfo xmTable = null;
        private BindType bind = BindType.label;
        public GridViewTemplate()
        { }
        /// <summary>
        /// 构造函数
        /// </summary>
        /// <param name="type">绑定列类型</param>
        /// <param name="colname">绑定列名称或者需要绑定的数据库字段</param>
        /// <param name="colname">绑定字段类型控件</param>
        public GridViewTemplate(DataControlRowType type, string colname, BindType bin, XMLTableInfo tab)
        {
            templateType = type;
            columnName = colname;
            bind = bin;
            this.xmTable = tab;
        }
        /// <summary>
        /// 绑定事件
        /// </summary>
        /// <param name="type"></param>
        /// <param name="controlID"></param>
        /// <param name="colname"></param>
        public GridViewTemplate(DataControlRowType type, string controlID, string colname)
        {
            templateType = type;
            this.controlID = controlID;
            columnName = colname;
        }
        public void InstantiateIn(System.Web.UI.Control container)
        {
            switch (templateType)
            {
                case DataControlRowType.Header://标题绑定
                    if (bind == BindType.label)
                    {
                        Literal lc = new Literal();
                        lc.Text = columnName;
                        container.Controls.Add(lc);
                    }
                    if (bind == BindType.checkbok)
                    {
                        Literal lc = new Literal();
                        lc.Text = "<input type=‘checkbox‘ class=‘heck_box‘ />全选";
                        container.Controls.Add(lc);
                    }
                    if (bind == BindType.editor)
                    {
                        Literal lc = new Literal();
                        lc.Text = "编辑";
                        container.Controls.Add(lc);
                    }
                    if (bind == BindType.delete)
                    {
                        Literal lc = new Literal();
                        lc.Text = "";// "删除";
                        container.Controls.Add(lc);
                    }

                    break;
                case DataControlRowType.DataRow://普通列绑定
                    if (bind == BindType.label)
                    {
                        Label tb = new Label();
                        tb.DataBinding += tb_DataBinding;
                        container.Controls.Add(tb);
                    }
                    if (bind == BindType.checkbok)
                    {
                        Literal lic = new Literal();
                        lic.DataBinding += lic_DataBinding;
                        container.Controls.Add(lic);
                    }
                    if (bind == BindType.editor)
                    {
                        Literal lec = new Literal();
                        lec.DataBinding += lec_DataBinding;
                        container.Controls.Add(lec);
                    }
                    if (bind == BindType.editor)
                    {
                        Literal del = new Literal();
                        del.DataBinding += del_DataBinding;
                        container.Controls.Add(del);
                    }

                    break;
                default:
                    break;
            }
        }

        void del_DataBinding(object sender, EventArgs e)
        {

            Literal tb = (Literal)sender;

            GridViewRow row = (GridViewRow)tb.NamingContainer;
            tb.ID = columnName;
            tb.Text = " &nbsp;&nbsp;<a class=‘A_DelBind‘ href=‘Ajax/AjaxDateToSql.ashx?cmd=delete&cName=" + xmTable.CName + "&eName=" + xmTable.EName + "&id=" + DataBinder.Eval(row.DataItem, columnName).ToString() + "‘>删除</>";
        }

        void lec_DataBinding(object sender, EventArgs e)
        {
            Literal tb = (Literal)sender;

            GridViewRow row = (GridViewRow)tb.NamingContainer;
            tb.ID = columnName;
            tb.Text = "<a href=‘InsertInfo.aspx?cmd=editor&cName=" + xmTable.CName + "&eName=" + xmTable.EName + "&id=" + DataBinder.Eval(row.DataItem, columnName).ToString() + "‘>编辑</>";
        }

        void lic_DataBinding(object sender, EventArgs e)
        {

            Literal btn = (Literal)sender;

            GridViewRow row = (GridViewRow)btn.NamingContainer;
            btn.ID = columnName;
            btn.Text = "<input type=‘checkbox‘ class=‘CheckBox‘ value=‘" + DataBinder.Eval(row.DataItem, columnName).ToString() + "‘/>";

        }
        /// <summary>
        /// 2014-02-27
        /// 张国强
        /// 绑定字段数据列事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void tb_DataBinding(object sender, EventArgs e)
        {
            Label tb = (Label)sender;

            GridViewRow row = (GridViewRow)tb.NamingContainer;
            tb.ID = columnName;
            tb.Text = DataBinder.Eval(row.DataItem, columnName).ToString();
        }

        #region 提取公共部分

        /// <summary>
        /// 绑定数据到GridView控件
        /// </summary>
        /// <param name="NewGrid">GridViews控件</param>
        /// <param name="eName">英文名称</param>
        /// <param name="cName">中文名称</param>
        /// <param name="sqlOrTop">需要查询的数据字符串</param>
        public  void LoadInfo(GridView NewGrid, string eName, string cName,string sqlOrTop)
        {
            NewGrid.Columns.Clear();
            XMLTableInfo tb = new XMLTableInfo();
            tb.CName = cName;
            tb.EName = eName;
            XMLBase xBase = new XMLBase();
            xBase.LoadDome();
            string tableInfo = xBase.Check(eName, cName);
            //1，拆分数据
            string[] Ename = tableInfo.Split(‘|‘)[0].Split(‘,‘);
            string[] Cname = tableInfo.Split(‘|‘)[1].Split(‘[‘);
            xBase.LoadDome();
            string id = xBase.GetIdentity(eName, cName);
            //循环数据
            for (int i = 0; i < Ename.Length; i++)
            {
                //BoundColumn cu = new BoundColumn();
                //cu.DataField = Ename[i];
                //cu.HeaderText = Cname[i];
                TemplateField temp = new TemplateField();
                temp.ShowHeader = true;
                if (i == 0)
                {
                    temp.HeaderTemplate = new GridViewTemplate(DataControlRowType.Header, Cname[i], BindType.checkbok, tb);
                    temp.ItemTemplate = new GridViewTemplate(DataControlRowType.DataRow, id, BindType.checkbok, tb);
                }
                else
                {
                    temp.HeaderTemplate = new GridViewTemplate(DataControlRowType.Header, Cname[i], BindType.label, tb);
                    temp.ItemTemplate = new GridViewTemplate(DataControlRowType.DataRow, Ename[i], BindType.label, tb);
                }


                NewGrid.Columns.Add(temp);
            }
            //添加编辑列
            TemplateField tempEditor = new TemplateField();
            tempEditor.HeaderTemplate = new GridViewTemplate(DataControlRowType.Header, "操作", BindType.editor, tb);
            tempEditor.ItemTemplate = new GridViewTemplate(DataControlRowType.DataRow, id, BindType.editor, tb);
            NewGrid.Columns.Add(tempEditor);

            TemplateField tempDelete = new TemplateField();
            tempDelete.HeaderTemplate = new GridViewTemplate(DataControlRowType.Header, "删除", BindType.delete, tb);
            tempDelete.ItemTemplate = new GridViewTemplate(DataControlRowType.DataRow, id, BindType.delete, tb);
            NewGrid.Columns.Add(tempDelete);

            string sql = "";
            if (sqlOrTop.Length<11)
            {
                sql = "select top " + sqlOrTop + " * from " + eName + "  order by  " + id + " DESC";
                NewGrid.DataSource = ExcelHelper.GetDataSet(sql);
            }
            else
            {
                NewGrid.DataSource = ExcelHelper.GetDataSet(sqlOrTop);
            }
           
            NewGrid.AutoGenerateColumns = false;
            NewGrid.DataBind();


        }
        #endregion


    }

    public enum BindType
    {
        label, checkbok, editor, delete
    }


}

    public enum BindType
    {
        label, checkbok, editor, delete
    }

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="ShowList.aspx.cs" Inherits="ExcelToSqlserver.ShowList" %>

<!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>
    <script type="text/javascript" src="Scripts/jquery-1.8.2.min.js"></script>
</head>
<body>
    <form id="form1" runat="server">
        <div>
            <p>当前界面：<label id="lblTitle" runat="server">XXX台账</label></p>
            关键字查询：<input type="text" id="txtKey" runat="server" /><asp:Button ID="btnSech" runat="server" Text="查询" OnClick="btnSech_Click" />
            <br />
            <br />
            <div>
          <input type="hidden"  id="hiddcName" runat="server" />
          <input type="hidden" id="hiddeName" runat="server" />
          <input  type
              ="hidden" id="hiddcmd" runat="server" />
          <a id="a_Add" runat="server">添加数据</a>    &nbsp;&nbsp;
        <a id="a_Del" href="#" runat="server">删除数据</a>
                <br />
         
      </div>
        </div>
        <div>
            <asp:GridView ID="gridView" runat="server">
                <Columns></Columns>
            </asp:GridView>
        </div>
                <div style="width: 600px; margin-top: 10px; text-align: center;">
                        <asp:Button ID="shouye" runat="server" Text="首页" OnClick="shouye_Click" />
                        <asp:Button ID="btnUpPage" runat="server" Text="上一页" OnClick="btnUpPage_Click" />
                        <asp:Button ID="btnNextPage" runat="server" Text="下一页" OnClick="btnNextPage_Click" />
                        <asp:Button ID="weiye" runat="server" Text="尾页" OnClick="weiye_Click" />
                        共<asp:Label ID="lbl_courrentPage" runat="server" Text="1"></asp:Label>
                        页&nbsp; 第
                <input id="currentpage" type="text" runat="server" style="width: 32px; height: 15px;" />页
                <asp:Button ID="tiaozhuan" runat="server" Text="跳转" OnClick="tiaozhuan_Click" />
                        &nbsp;每页<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" Height="22px"
                            Width="39px" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged">
                            <asp:ListItem Value="10">10</asp:ListItem>
                            <asp:ListItem>20</asp:ListItem>
                            <asp:ListItem>30</asp:ListItem>
                        </asp:DropDownList>
                        个
                    </div>
    </form>
</body>
</html>
<script type="text/javascript">
    $(function () {
        //全选择 全部不选择
        $(".heck_box").click(function () {
            var t = $(this).attr("checked");
            if (t) {
                $(".CheckBox").attr("checked", t);
            } else {
                $(".CheckBox").attr("checked", false);
            }
        });
        //删除数据隐藏行
        $(".A_DelBind").click(function () {
            $(this).parent("td").parent("tr").hide();
        });
        //删除事件
        $("#a_Del").click(function () {

            //获取表明
            var eName = $("#hiddeName").val();
            var cName = $("#hiddcName").val();
            var id = "";
            //获取主键ID
            $(".CheckBox").each(function () {
                var t = $(this).attr("checked");
                if (t) {
                    id += $(this).val() + ",";
                }
            });
            if (id == "") {
                alert("没有选中删除数据！");
                return false;
            }
            if (id.length > 2) {
                id = id.substring(0, id.length - 1);
            }
            var con = confirm("即将删除数据，删除后不能恢复！");
            if (con) {
                $.get("Ajax/AjaxDateToSql.ashx", { cmd: "delete", id: id, cName: cName, eName: eName }, function () {
                    history.go(0);


                });
            }

        });

    });
</script>

/*2014-3-3
 * email:imei8service@gmail.com
 * 动态显示数据
 * 生成查询方法
 * 自动分页
 * 
 * **/

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
//
using CommonLib;

namespace ExcelToSqlserver
{
    public partial class ShowList : System.Web.UI.Page
    {
        XMLBase xb = new XMLBase();
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                shouye.Enabled = false;
                btnUpPage.Enabled = false;
                btnNextPage.Enabled = false;
                weiye.Enabled = false;
                ViewState["pageIndex"] = 1;
                ViewState["pageSize"] = 10;
                ViewState["pageCount"] = 0;
                ViewState["where"] = "";
                ViewState["cName"] =Request.QueryString["cName"].ToString();
                ViewState["eName"] =Request.QueryString["eName"].ToString();
                a_Add.Attributes.Add("href", "InsertInfo.aspx?cName=" + ViewState["cName"].ToString() + "&eName=" + ViewState["eName"].ToString() + "&cmd=insert");
                hiddcmd.Value = ViewState["cName"].ToString();
                hiddeName.Value = ViewState["eName"].ToString();
                lblTitle.InnerHtml = ViewState["cName"].ToString();
                selctInfo();
            }


        }
        /// <summary>
        ///查询方法
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void btnSech_Click(object sender, EventArgs e)
        {
            xb.LoadDome();

            string[] keowo = xb.Check(ViewState["eName"].ToString(), ViewState["cName"].ToString()).Split(‘|‘)[0].Split(‘,‘);
            string sql ="";
            string key = txtKey.Value;
            if (key != "")
            {
                for (int i = 0; i < keowo.Length; i++)
                {
                    if (i==keowo.Length-1)
                    {
                        sql += "  " + keowo[i] + "  like  ‘%" + key + "%‘";
                    }
                    else
                    {
                        sql += "  " + keowo[i] + "  like  ‘%" + key + "%‘" + " or";
                    }
                    
                }
                sql = sql.Trim().Substring(0, sql.Length - 2);
                ViewState["where"] = sql;
            }
            else
            {
                ViewState["where"] = "";
            }
            selctInfo();
        }
        private void ControlManager(int index, int count)
        {

            if (index == 1 && count == 1) return; ;//总页数未一，当前页第一页
            if (index >= 1 && index < count)//第一页不是尾页
            {

                shouye.Enabled = false;
                btnUpPage.Enabled = false;
                btnNextPage.Enabled = true;
                weiye.Enabled = true;
                tiaozhuan.Enabled = true;
            }
            if (index >= 2 && index < count)//不是首页不是尾页
            {

                shouye.Enabled = true;
                btnUpPage.Enabled = true;
                btnNextPage.Enabled = true;
                weiye.Enabled = true;
                tiaozhuan.Enabled = true;
            }
            if (index >= 2 && index == count)
            {
                shouye.Enabled = true;
                btnUpPage.Enabled = true;
                btnNextPage.Enabled = false;
                weiye.Enabled = false;
            }



        }

        #region 页面控制
        //首页
        protected void shouye_Click(object sender, EventArgs e)
        {
            ViewState["pageIndex"] = 1;

            selctInfo();

            this.btnUpPage.Enabled = false;
            btnNextPage.Enabled = true;

        }
        //尾页
        protected void weiye_Click(object sender, EventArgs e)
        {
            ViewState["pageIndex"] = ViewState["pageCount"];

            selctInfo();

            this.btnUpPage.Enabled = true;
            btnNextPage.Enabled = false;
        }
        //跳转
        protected void tiaozhuan_Click(object sender, EventArgs e)
        {
            int page = Convert.ToInt32(currentpage.Value);
            int pageCount = Convert.ToInt32(ViewState["pageCount"]);
            if (page > pageCount)
            {
                currentpage.Value = pageCount.ToString();
                ViewState["pageIndex"] = pageCount;
                selctInfo();

            }
            else
            {

                ViewState["pageIndex"] = page;
                selctInfo();
            }
        }
        //显示页项目
        protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
        {
            ViewState["pageSize"] = DropDownList1.SelectedValue;
            ViewState["pageIndex"] = 1;
            selctInfo();
        }
        //上页
        protected void btnUpPage_Click(object sender, EventArgs e)
        {
            int pageindex = Convert.ToInt32(ViewState["pageIndex"]);
            ViewState["pageIndex"] = pageindex - 1;
            if ((pageindex - 1) <= 1)
            {
                ViewState["pageIndex"] = 1;
                this.btnUpPage.Enabled = false;


                selctInfo();
            }
            else
            {
                selctInfo();
            }
            btnNextPage.Enabled = true;


        }
        //下页
        protected void btnNextPage_Click(object sender, EventArgs e)
        {

            int pageIndex = Convert.ToInt32(ViewState["pageIndex"]) + 1;
            if (pageIndex == Convert.ToInt32(ViewState["pageCount"]) || pageIndex > Convert.ToInt32(ViewState["pageCount"]))
            {

                ViewState["pageIndex"] = ViewState["pageCount"];
                btnNextPage.Enabled = false;

                selctInfo();
            }
            else
            {
                ViewState["pageIndex"] = pageIndex;
                selctInfo();
            }
            this.btnUpPage.Enabled = true;

        }

        #endregion

        /// <summary>
        /// 加载数据
        /// </summary>
        private void selctInfo()
        {
            //ViewState["cName"]
            //ViewState["eName"]
            //      ViewState["where"]
            //得到查询总数据条数的Sql
            string sql = ExcelHelper.GetCountQueryString(ViewState["eName"].ToString(), ViewState["where"].ToString());
            //获取分页插叙语句
            xb.LoadDome();
            string identity = xb.GetIdentity(ViewState["eName"].ToString(), ViewState["cName"].ToString());
            string sqlPage = ExcelHelper.GetPageQueryStrong(ViewState["eName"].ToString(), ViewState["cName"].ToString(), ViewState["where"].ToString(), identity, Convert.ToInt32(ViewState["pageIndex"]), Convert.ToInt32(ViewState["pageSize"]));
            int recordCount = ExcelHelper.ExecSclaer(sql);
            new GridViewTemplate().LoadInfo(this.gridView, ViewState["eName"].ToString(), ViewState["cName"].ToString(), sqlPage);
            int pageIndex = Convert.ToInt32(ViewState["pageIndex"]);
            int pageSize = Convert.ToInt32(ViewState["pageSize"]);
            ViewState["pageCount"] = recordCount % pageSize == 0 ? recordCount / pageSize : (recordCount / pageSize) + 1;
            lbl_courrentPage.Text = ViewState["pageCount"].ToString();
            currentpage.Value = pageIndex.ToString();

            ControlManager(pageIndex, Convert.ToInt32(ViewState["pageCount"]));
        }

    }
}

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="InsertInfo.aspx.cs" Inherits="ExcelToSqlserver.InsertInfo" %>

<!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>
    <style type="text/css">
         li {
        display: inline;
        list-style: none;
         display: inline;
        list-style: none;
        padding-left: 15px;
    }
        
    </style>
    <script type="text/javascript" src="Scripts/jquery-1.8.2.min.js"></script>
   
</head>
<body>
    <form id="form1" runat="server">
        <div>
            <ul>
                <li>手动录入数据</li>
                <li>
                    <asp:Button ID="btnEnterExcel" runat="server" Text="批量导入数据" OnClick="btnEnterExcel_Click" /></li>

            </ul>
        </div>
        <br />
        <input type="hidden" runat="server" id="hiddEname" />
        <input type="hidden" runat="server" id="hiddCname" />
         <input type="hidden" runat="server" id="hiddCmd" />
        <input type="hidden" runat="server" id="hiddRecordId" />

        <div>
            <table>
                <tbody id="tbody" runat="server">
                </tbody>
                <tfoot>
                    <tr>
                        <td>
                            <input type="reset" id="reset" value="取消" /></td>
                        <td style="margin-left: 30px;">
                            <input type="button" runat="server" id="btnOK" value="添加" />&nbsp;</td>
                    </tr>
                </tfoot>
            </table>
        </div>
    </form>
</body>
</html>
<script type="text/javascript">

    var Values = "";
    //检查数据录入是否正常
    function checkInput() {
        $(".txtVal").each(function () {
            var val = $(this).val();
            if (val == "") {
                $(this).parent("td").next(".mess").css("color", "red").html("录入信息不能为为空");
                return false;
            } else {
                $(this).parent("td").next(".mess").css("color", "green").html("已录入信息");
                Values += "‘" + $(this).val() + "‘,";
                return true;
            }
        });
    }

    $(function () {
        checkInput();
        $(".txtVal").blur(function () {
            var va = $(this).val();
            if (va == "") {
                $(this).parent("td").next(".mess").css("color", "red").html("信息不能为空");

                return false;
            } else {
                $(this).parent("td").next(".mess").css("color", "green").html("已录入信息");
            }
        });
        $("#reset").click(function () {
            $(".mess").html("");
        });

        $("#btnOK").click(function () {

            //判断数据完整性
            var i = 1 * 1;
            var values = "";
            var res =true;
            $(".mess").each(function () {
                var t = $(this).html().trim();
                if (t != "已录入信息") {
                    var ask = confirm("第" + i + "项数据还未填写");
                    res = false;
                    return;
                  
                }
                i++;
            });

            //获取数据
            $(".txtVal").each(function () {
                values += "‘" + $(this).val() + "‘ |";//防止出现逗号用特殊符号分割
            });

            //分解数据
            if (values != "") {
                values = values.substring(0, values.length - 1);
            }
            //异步提交
            //获取值
            var eName = $("#hiddEname").val();
            var cName = $("#hiddCname").val();
            var cmd = $("#hiddCmd").val();
            var id = $("#hiddRecordId").val();
            if (!res) 
                return;
            $.get("Ajax/AjaxDateToSql.ashx", { eName: eName, cName: cName, values: values,id:id,cmd: cmd }, function (date) {
                if (date != "NO") {
                    alert(date);
                    $("#reset").click();
                } else {
                    alert("添加失败！请检查数据");
                }
            });

        });
    });
</script>

/*2014-02-27
 * 动态生成界面控件接受参数录入。
 * 提供手动录入数据
 * **/
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
//
using CommonLib;

namespace ExcelToSqlserver
{
    public partial class InsertInfo : System.Web.UI.Page
    {
        XMLBase xBase = new XMLBase();
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                string eName = Request.QueryString["eName"].ToString();
                string cName = Request.QueryString["cName"].ToString();
                string cmd = Request.QueryString["cmd"].ToString();
                hiddCmd.Value = cmd;
                hiddEname.Value = eName;
                hiddCname.Value = cName;
                if (Request.QueryString["id"]!=null)
                {
                    hiddRecordId.Value = Request.QueryString["id"].ToString();
                    //加载数据
                    LoadDocument(eName, cName, hiddRecordId.Value);
                }
                else
                {
                    LoadDocument(eName, cName, "");
                }
               
            }
        }
        /// <summary>
        /// 动态创建页面控件n 
        /// </summary>
        /// <param name="eName"></param>
        /// <param name="cName"></param>
        private void LoadDocument(string eName, string cName, string id)
        {
            xBase.LoadDome();
            string che = xBase.Check(eName, cName);
            string[] colums = che.Split(‘|‘)[0].Split(‘,‘);
            string[] showInfo = che.Split(‘|‘)[1].Split(‘[‘);

            //新添加
            if (id == "")
            {
                for (int i = 0; i < showInfo.Length; i++)
                {
                    string tr = "<tr> <td style=‘text-align:right;‘>" + showInfo[i] + "：</td> <td><input class=‘txtVal‘ type=‘text‘ /></td> <td class=‘mess‘></td><td><input class=‘colu‘ type=‘hidden‘ value=‘" + colums[i] + "‘ /></td> </tr>";
                   
                    tbody.InnerHtml += tr;

                }
            }
            else if (id != "")
            {
                //获取数据值
                string values = GetModel(eName, cName, id);
                string[] info = values.Split(‘|‘);
                btnOK.Value = "确定修改";
                for (int i = 0; i < showInfo.Length; i++)
                {
                    string tr = "<tr> <td style=‘text-align:right;‘>" + showInfo[i] + "：</td> <td><input class=‘txtVal‘ type=‘text‘  value=‘" + info[i + 1] + "‘/></td> <td class=‘mess‘></td><td><input class=‘colu‘ type=‘hidden‘ value=‘" + colums[i] + "‘ /></td> </tr>";
                    tbody.InnerHtml += tr;

                }
            }


        }


        private string GetModel(string eName, string cName, string id)
        {
            string value = "";
            //获取查询语句
            string sql = ExcelHelper.GetModelQueryString(eName, cName, Convert.ToInt32(id));
            value = ExcelHelper.SelectToSqlModel(sql);
            return value;
        }

        protected void btnEnterExcel_Click(object sender, EventArgs e)
        {
           string eName= hiddEname.Value;
           string cName = hiddCname.Value; ;
           string url = "EnterExcel.aspx?eName=" + eName + "&cName=" + cName ;
            Response.Redirect(url);
        }

    }
}