ajax|原创

简单介绍：
1.完全无刷实现，客户端主要实现生成条件选择或录入控件，并进行录入控制；

2.将字段信息存放于XML文件，便于数据移植

3.通过js脚本，ajax框架引擎获取字段信息

4.通过js脚本生成组合条件；

 
5.运行效果：

下面是代码和实现效果：
1.AjaxSeachMethod.cs

using System;
using System.Xml;
using System.Data;
using System.Data.SqlClient;
 
namespace WebUI.AjaxSearchSystem
{
    /**//// <summary>
    /// SearchMethod 的摘要说明。
    /// </summary>
    public class AjaxSearchMethod
    {
        private string[] CHAR_OP    = new string[]{"等于|=","不等于|<>","相似于|Like","不相似于|Not Like"};
        private string[] NUM_OP        = new string[]{"大于|>","大于或等于|>=","等于|=","不等于|<>","小于|<","小于或等于|<="};    
        private string[] DATE_OP    = new string[]{"等于|=","不等于|<>","先于|<","后于|>"};    
 
        public AjaxSearchMethod()
        {}
 
        /**//// <summary>
        /// 根据表名获取包含的字段
        /// </summary>
        /// <param name="table">表名</param>
        /// <returns></returns>
        [AjaxPro.AjaxMethod]
        public string[] GetFields(string table)
        {
            string[] strArrFields = null;
 
            try
            {
                XmlDocument xd = LoadXml("\AjaxSearchDataCollection.xml");
                XmlElement    xe  =xd.DocumentElement;
                XmlNode        xn = xe.SelectSingleNode("descendant::Table[value='"+table+"']");
                XmlNodeList xnl = xn.ChildNodes;
                int iLen = xnl.Count;
                strArrFields = new string[iLen];
 
                int iIndex = 0;
 
                foreach(XmlNode xnField in xnl)
                {
                    strArrFields[iIndex] = xnField.Attributes["Name"].InnerText + "|" + xnField.Attributes["Value"].InnerText;
                    iIndex ++;
                }
            }
            catch(Exception ee)
            {
                throw new ArgumentOutOfRangeException("AjaxSearchDataCollection.xml","/Table[value='"+table+"']：指定的接点不存在，请重新定义XML文档！");
            }
            return strArrFields;
        }
 
        /**//// <summary>
        /// 根据字段获取对应的操作符列表
        /// </summary>
        /// <param name="field"></param>
        /// <returns></returns>
        [AjaxPro.AjaxMethod]
        public string[] GetOpts(string table,string field)
        {
            string strTypeofField = GetTypeofField(table,field);
 
            switch(strTypeofField)
            {
                case "char":
                    return CHAR_OP;
                    break;
                case "int":
                    if(GetEnumField(table,field)==null)
                    {
                        return NUM_OP;
                    }
                    else
                    {
                        return (new string[]{"是|=","不是|<>"});
                    }
                    
                    break;
                case "decimal":
                    return NUM_OP;
                    break;
                case "datetime":
                    return DATE_OP;
                    break;
                default:
                    return (new string[]{"等于|="});
                    break;
            }
        }
 
        /**//// <summary>
        /// 根据字段获取对应的可能存在的枚举值列表
        /// </summary>
        /// <param name="field"></param>
        /// <returns></returns>
        [AjaxPro.AjaxMethod]
        public string[] GetEnums(string table,string field)
        {
            string strTypeofField = GetTypeofField(table,field);
            string[] enums = GetEnumField(table,field);
 
            int iLen = enums==null?0:enums.Length;
 
            string[] result = new string[iLen+1];
 
            result[0] = strTypeofField;
 
            if (iLen == 0)
            {
                return result;
            }
 
            int iIndex = 1;
 
            foreach(string str in enums)
            {
                result[iIndex] = str;
                iIndex ++;
            }
 
            return result;
 
        }
 
        内部支持脚本#region 内部支持脚本
        //装载XML文档
        private XmlDocument LoadXml(string xmlPath)
        {
            XmlDocument xd = new XmlDocument();
 
            try
            {
                xd.Load(System.Web.HttpContext.Current.Request.PhysicalApplicationPath+xmlPath);
            }
            catch(XmlException ee)
            {
                throw new ArgumentOutOfRangeException(ee.Message,"读取条件编辑信息失败，请检查XML文档路径设置是否正确！");
            }
 
            return xd;
        }
 
        //获取字段的数据类型
        private string GetTypeofField(string table,string field)
        {
            string strTypeofField = string.Empty;
            try
            {
                XmlDocument xd = LoadXml("\\AjaxSearchDataCollection.xml");
                XmlElement    xe  =xd.DocumentElement;
                XmlNode        xn = xe.SelectSingleNode("descendant::Table[value='"+table+"']");
                xn = xn.SelectSingleNode("descendant::Field[Value='"+field+"']");
                
                strTypeofField = xn.Attributes["DataType"].InnerText;
                
            }
            catch(Exception ee)
            {
                throw new ArgumentOutOfRangeException("AjaxSearchDataCollection.xml","/Field[Value='"+field+"']：指定的接点不存在，请重新定义XML文档！");
            }
 
            return strTypeofField.ToLower();
        }
 
        //获取字段的数据类型
        private string[] GetEnumField(string table,string field)
        {
            string strTypeofField = string.Empty;
            string strEnumSqlSyntax = string.Empty;
            string strTextField = string.Empty;
            string strValueField = string.Empty;
 
            try
            {
                XmlDocument xd = LoadXml("\AjaxSearchDataCollection.xml");
                XmlElement    xe  =xd.DocumentElement;
                XmlNode        xn = xe.SelectSingleNode("descendant::Table[value='"+table+"']");
                xn = xn.SelectSingleNode("descendant::Field[Value='"+field+"']");
                xn = xn.ChildNodes[0];
 
                if (xn == null)
                {
                    return null;
                }
                else
                {
                    strEnumSqlSyntax = xn.Attributes["SqlSyntax"]==null?"":xn.Attributes["SqlSyntax"].InnerText;
                    strTextField = xn.Attributes["TextField"]==null?"":xn.Attributes["TextField"].InnerText;
                    strValueField = xn.Attributes["ValueField"]==null?"":xn.Attributes["ValueField"].InnerText;
                }
 
                return GetEnumField(strEnumSqlSyntax,strTextField,strValueField);
            }
            catch(NullReferenceException ee)
            {
                throw new ArgumentOutOfRangeException("AjaxSearchDataCollection.xml","/Field[Value='"+field+"']：指定的接点不存在，请重新定义XML文档！");
            }
        }
 
        private string[] GetEnumField(string sqlSyntax,string text,string value)
        {
 
            if (sqlSyntax.Length == 0 || text.Length==0 || value.Length==0)
            {
                return null;
            }
 
            DataSet ds = new DataSet();
 
            try
            {
                SqlConnection sc = new SqlConnection("server=OY-M;User ID=sa;Password=DBCs%1+ZhLx;database=pubs;Connection Reset=FALSE;Connect Timeout=6");
                sc.Open();
                SqlCommand scmd = new SqlCommand(sqlSyntax,sc);
                SqlDataAdapter da = new SqlDataAdapter();
                da.SelectCommand = scmd;
                da.Fill(ds);
            }
            catch(SqlException ee)
            {
                throw ee;
            }
 
            DataTable dt = ds.Tables[0];
 
            if (dt == null)
            {
                return null;
            }
 
            DataRowCollection drc = dt.Rows;
            
            string[] enumFields = new string[drc.Count];
            int iIndex = 0;
 
            foreach(DataRow dr in drc)
            {
                enumFields[iIndex] = dr[text].ToString().Trim() +"|"+dr[value].ToString().Trim();
                iIndex ++;
            }
 
            return enumFields;
        }
        #endregion
    }
}