在管理系统中常用的 文本框弹出选择框 自定义控件（1）

在管理系统中常用的 文本框弹出选择框 自定义控件（1）

图：

要求：

1，弹出框可以是定义好的样式，如上图，有搜索板面和被选择列表，也可以是自由页面

2，显示的列数据为可配置

3，搜索的列数据为可配置

4，可以在弹出框中进行查询

5，在弹出框中的列表进行分页

6，选中后返回TEXT/VALUE键值对

7，选中后可以返回同页面其它控件需要的值

8，弹出框里的数据为可配置

9，支持jquery表单验证插件

10，支持在选中后触发客户端事件

11，支持在选中后触发服务器端事件

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.ComponentModel;
using System.Security.Permissions;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Drawing;
namespace CustomControl
{
    [
    AspNetHostingPermission(SecurityAction.Demand,
        Level = AspNetHostingPermissionLevel.Minimal),
    AspNetHostingPermission(SecurityAction.InheritanceDemand, 
        Level=AspNetHostingPermissionLevel.Minimal),
    DefaultProperty("Text"),
    ToolboxData("<{0}:TextBoxSelect runat=\"server\"> </{0}:TextBoxSelect>")    
    ]
    [ToolboxBitmap(@"G:\承接项目\南宁雨龙塑业有限公司\YLERP\CustomControl\Resources\Icons\TextBoxSelect.png")]
    
    public class TextBoxSelect : CompositeControl
    {
        #region Value Property
        /// <summary>
        /// Control Text
        /// </summary>
        public string Text
        {
            get
            {
                if (txt == null)
                    return String.Empty;
                return txt.Text;
            }
            set { txt.Text = value; }
        }
        /// <summary>
        /// Control Value
        /// </summary>
        public string Value
        {
            get
            {
                if (hidden == null)
                    return String.Empty;
                return hidden.Value;
            }
            set { hidden.Value = value; }
        }
        #endregion
        #region Appearance Property
        /// <summary>
        /// TextBox Css
        /// </summary>
        public string TextBoxClass
        {
            get
            {
                object o = ViewState["TextBoxClass"];
                if (o == null)
                    return String.Empty;
                return (string)o;
            }
            set { ViewState["TextBoxClass"] = value; }
        }
        /// <summary>
        /// Image Button Css
        /// </summary>
        public string ImageButtonClass
        {
            get
            {
                object o = ViewState["ImageButtonClass"];
                if (o == null)
                    return String.Empty;
                return (string)o;
            }
            set { ViewState["ImageButtonClass"] = value; }
        }
        #endregion
        #region OpenWindow Property
        /// <summary>
        /// Dialog Mode Default or Custom
        /// </summary>
        public DialogModes DialogMode
        {
            get
            {
                object o = ViewState["DialogMode"];
                if (o == null)
                    return DialogModes.Default;
                return (DialogModes)o;
            }
            set { ViewState["DialogMode"] = value; }
        }
        /// <summary>
        /// Dialog Url(If DialogMode equal Default then the url is /UserControl/TextBoxSelectDialogDefault.aspx
        /// else is the value of this property)
        /// </summary>
        public string DialogUrl
        {
            get
            {
                object o = ViewState["DialogUrl"];
                if (o == null)
                    return string.Empty;
                return (string)o;
            }
            set { ViewState["DialogUrl"] = value; }
        }
        /// <summary>
        /// XML DataKey
        /// </summary>
        public string DataKey
        {
            get
            {
                object o = ViewState["DataKey"];
                if (o == null)
                    return string.Empty;
                return (string)o;
            }
            set { ViewState["DataKey"] = value; }
        }
        /// <summary>
        /// Being set value controls's ID separates with ","
        /// Note: the control has to contain "value" property in the HTML DOM
        /// </summary>
        public string SetValueControlIDList
        {
            get
            {
                object o = ViewState["SetValueControlIDList"];
                if (o == null)
                    return string.Empty;
                return (string)o;
            }
            set { ViewState["SetValueControlIDList"] = value; }
        }
        /// <summary>
        /// The field in database data will be set to controls,which separate with ","
        /// </summary>
        public string SetValueControlFieldList
        {
            get
            {
                object o = ViewState["SetValueControlFieldList"];
                if (o == null)
                    return string.Empty;
                return (string)o;
            }
            set { ViewState["SetValueControlFieldList"] = value; }
        }
        #endregion
        #region Validation Property
        public RegexEnum ValType
        {
            get
            {
                object o = ViewState["ValType"];
                if (o == null)
                    return RegexEnum.Null;
                return (RegexEnum)o;
            }
            set { ViewState["ValType"] = value; }
        }
        public string ValMsg
        {
            get
            {
                object o = ViewState["ValMsg"];
                if (o == null)
                    return string.Empty;
                return (string)o;
            }
            set { ViewState["ValMsg"] = value; }
        }
        #endregion
        public TextBoxSelect()
        {
            txt = new TextBox();
            hidden = new HiddenField();
            
        }
        protected override void OnPreRender(EventArgs e)
        {
            base.OnPreRender(e);
            Page.ClientScript.RegisterClientScriptResource(this.GetType(), "CustomControl.Resources.Scripts.TextBoxSelect.js");
            Style.Add(HtmlTextWriterStyle.WhiteSpace, "nowrap");
            if (!DesignMode)
            Page.Trace.Write("OnPreRender");
        }
        protected override void CreateChildControls()
        {
            Controls.Clear();
            CreateControlHierarchy();
            ClearChildViewState();
        }
        private HiddenField hidden;
        private TextBox txt;
        protected virtual void CreateControlHierarchy()
        {
            
            Panel container = new Panel();
            
            txt.ID = "text";
            txt.Text = this.Text;
            if (TextBoxClass != string.Empty)
            {
                txt.CssClass = TextBoxClass;
            }
            else
            {
                txt.CssClass = "textbox";
            }
            if (Width != 0) txt.Width = Width;

            
            hidden.Value = Value;
            hidden.ID = "value";
            Button btn = new Button();
            btn.Text = "...";
            btn.ID = "btn";
            string strJS = string.Empty;
            if (DialogMode == DialogModes.Default)
            {
                //function ShowDialog(url,SetValueControlIDList, SetValueControlFieldList,this.ClientID) 
                strJS = string.Format("javascript:return ShowDialog('{0}?key={1}','{2}','{3}','{4}');",
                   "/UserControl/TextBoxSelectDialogDefault.aspx", DataKey, SetValueControlIDList, SetValueControlFieldList, this.ClientID);
            }
            else if (DialogMode == DialogModes.Custom)
            {
                strJS = string.Format("javascript:return ShowDialog('{0}','{1}','{2}','{4}');",
                                     DialogUrl, DataKey, SetValueControlIDList, SetValueControlFieldList,this.ClientID);
            }
            btn.OnClientClick = strJS;
            if (ValType != RegexEnum.Null && ValMsg!=string.Empty)
            {
                txt.Attributes.Add("ValType", ValType.ToString());
                txt.Attributes.Add("ValMsg", ValMsg);
            }
            txt.Attributes.Add("ondblclick", strJS);
            txt.Attributes.Add("onkeydown", "return false;");
            txt.Attributes.Add("onpaste", "return false;");
            if (ImageButtonClass != string.Empty)
            {
                btn.CssClass = ImageButtonClass;
            }
            else
            {
                btn.CssClass = "TextBoxSelectImage";
            }
            Controls.Add(txt);
            Controls.Add(hidden);
            Controls.Add(btn);
            if(!DesignMode )
            Page.Trace.Write("CreateChildControls");
        }
    }
    public enum DialogModes { Default, Custom }
    public enum RegexEnum { Null, NotNull, Int, IntOrNull, Num, NumOrNull, Date, Email, QQ, Chinese }
}

function ShowDialog(Url, SetValueControlIDList, SetValueControlFieldList,controlID) {
//SetValueControlIDList:要设置的其它控件ID，以“，”分隔
//SetValueControlFieldList:控件数据的数据库表字段名，以“，”分隔
    if (Url == undefined || Url == "") { alert("Url为空或者不存在检查DialogUrl属性!"); return false; }
    var idArray;
    var fieldArry;
    if (SetValueControlIDList != "" && SetValueControlFieldList != "") {
        idArray = SetValueControlIDList.split(",");
        fieldArry = SetValueControlFieldList.split(",");
        if (idArray.length != fieldArry.length) {
            alert("要设置的控件ID数和数据库字段数不同，请检查！");
            return false;
        }
    }
    var arguments = {};
    arguments.url = Url;
    arguments.setValueControlFieldList = SetValueControlFieldList;
    var returnValue = window.showModalDialog("/UserControl/TextBoxSelectDialogDefaultFrame.aspx", arguments,
    "scroll:yes;center:yes;help:no;resizable:yes;status:no;dialogWidth:530px;dialogHeight:490px");
    if (!returnValue) { alert("returnValue is null!"); return; }
    $("#" + controlID + "_value").attr("value", returnValue[0]);
    $("#" + controlID + "_text").attr("value", returnValue[1]);
    if (idArray) {
        if (idArray.length == returnValue.length - 2) {
            for (var i = 0; i < idArray.length; i++) {
                $("#" + idArray[i]).attr("value", returnValue[i + 2]);
            }
        }
        else {
            alert("Return columns number was not correct!" + idArray.length + returnValue.length);
        }
    }
    return false;
}

这是前一篇里嵌入的JS资源文件源码

因为在showModalDialog中的超链和回发都会弹出自己本身的窗体，所以加个IFRAME页面：TextBoxSelectDialogDefaultFrame.aspx
无后台代码

<iframe name="mainIFrame" id="mainIFrame" height="490px" width="100%" border="0" frameborder="0">
</iframe>
<script type="text/jscript">
    var p = window.dialogArguments;
    $("#mainIFrame").attr("src", p.url);
</script>

IFRAME里装载的才是真正的弹出窗页面：

    <asp:Panel runat="server" ID="panelSearch">
        <table cellspacing="1" align="center" class="Table">
            <tr>
                <td width="10%" class="TDTitle">
                    搜索关键字:
                </td>
                <td width="20%" class="TDCtrl">
                    <asp:TextBox ID="txtKeyWord" CssClass="textbox" runat="server"></asp:TextBox>
                </td>
                <td class="TDNote">
                    <asp:Label runat="server" ID="lbDescription" Text="解释"></asp:Label>
                </td>
            </tr>
            <tr>
                <td class="TDCtrl" style="padding: 5px 0px 5px 10px;" colspan="3">
                    <asp:Button ID="btnSearch" runat="server" CssClass="button" Text="查询" OnClick="btnSearch_Click" />
                </td>
            </tr>
        </table>
    </asp:Panel>
    <br />
    <asp:GridView runat="server" ID="GridView1" AllowPaging="false" AutoGenerateColumns="false"
        Width="99%" BorderWidth="0" CellPadding="0" CellSpacing="1" BackColor="#c0de98"
        HorizontalAlign="Center" OnRowDataBound="GridView1_RowDataBound">
    </asp:GridView>
    <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr>
            <td align="center" valign="bottom" height="30px">
                <div style="width: 95%;" class="STYLE1">
                    <webdiyer:AspNetPager CssClass="aspnetpager" ID="AspNetPager1" HorizontalAlign="Right"
                        OnPageChanging="AspNetPager1_PageChanging" runat="server" ShowPageIndex="false"
                        ShowPageIndexBox="Always" SubmitButtonImageUrl="../Resources/Images/AspNetPager/go.gif"
                        AlwaysShow="true" ImagePath="../Resources/Images/AspNetPager/" ButtonImageNameExtension="n"
                        ButtonImageExtension=".gif" DisabledButtonImageNameExtension="g" CpiButtonImageNameExtension="r"
                        PagingButtonType="Image" PageIndexBoxClass="indexbox" CustomInfoHTML="共%RecordCount%条纪录，当前第%CurrentPageIndex%/%PageCount%页,每页%PageSize%条记录"
                        ShowCustomInfoSection="Left" CustomInfoTextAlign="Left">
                    </webdiyer:AspNetPager>
                </div>
            </td>
        </tr>
    </table>
    <script type="text/jscript">
        var selectedRow;
        function SelectRow(id) {
            var tbl = $(id)[0];
            if (tbl) {
                for (var i = 1; i < tbl.rows.length; i++) {
                    tbl.rows[i].onmouseover = function () {
                        if (this != selectedRow) {
                            for (var j = 0; j < this.cells.length; j++) {
                                this.cells[j].style.backgroundColor = "#EDF1E8";
                            }
                        }
                    }
                    tbl.rows[i].onmouseout = function () {
                        if (this != selectedRow) {
                            for (var j = 0; j < this.cells.length; j++) {
                                this.cells[j].style.backgroundColor = "#FFFFFF";
                            }
                        }
                    }
                    tbl.rows[i].onclick = function () {
                        if (selectedRow) {
                            for (var j = 0; j < selectedRow.cells.length; j++) {
                                selectedRow.cells[j].style.backgroundColor = "#FFFFFF";
                            }
                        }
                        for (var j = 0; j < this.cells.length; j++) {
                            this.cells[j].style.backgroundColor = "#86A752";
                        }
                        selectedRow = this;
                    }
                    tbl.rows[i].ondblclick = function () {
                        var fields = "<%=xmlModel.ValueTextFields %>";
                        if (window.parent.p.setValueControlFieldList != "") {
                            fields = fields + ',' + window.parent.p.setValueControlFieldList;
                        }
                        var fieldArray = fields.split(',');
                        var idPre = "<%=GridView1.ClientID %>_";
                        var resArray = new Array();
                        for (var i = 0; i < fieldArray.length; i++) {
                            for (var j = 0; j < this.cells.length; j++) {
                                if (idPre + fieldArray[i] == tbl.rows[0].cells[j].id) {
                                    resArray.push(i.toString() + ":\"" + this.cells[j].innerText + "\"");
                                    break;
                                }
                                if (j == this.cells.length - 1) {
                                    alert("The field of " + fieldArray[i] + " was not found!");
                                    return;
                                }
                            }
                        }

                        window.parent.returnValue = eval('({' + resArray.join(',') + '})');
                        window.parent.returnValue.length = resArray.length;
//                        debugger;
                        window.parent.close();
                    }
                }
            }
        }
        $(document).ready(function () {
            SelectRow("#<%=GridView1.ClientID %>");
        }); 
        
    </script>

 public partial class TextBoxSelectDialogDefault : PageBase
    {
        protected string dataKey = string.Empty;
        //protected TextBoxSelectXmlModel xmlModel = null;
        #region ViewState Property
        protected TextBoxSelectXmlModel xmlModel
        {
            set
            {
                ViewState["xmlModel"] = value;
            }
            get
            {
                if (ViewState["xmlModel"] == null)
                {
                    return new TextBoxSelectXmlModel();
                }
                else
                {
                    return (TextBoxSelectXmlModel)ViewState["xmlModel"];
                }
            }
        }
        private int StartHiddenIndex
        {
            set
            {
                ViewState["StartHiddenIndex"] = value;
            }
            get
            {
                if (ViewState["StartHiddenIndex"] == null)
                {
                    return 0;
                }
                else
                {
                    return (int)ViewState["StartHiddenIndex"];
                }
            }
        }
        #endregion
        protected void Page_Load(object sender, EventArgs e)
        {
            dataKey = Request.QueryString["key"];
            if (!IsPostBack)
            {
                GetXmlData();
                SetSearchForm();
                SetGridColumn();
                InitList(0);
            }
        }
        #region Get XML Data
        private void GetXmlData()
        {
            if (dataKey != string.Empty)
            {
                xmlModel = new XmlAnalyze().GetXmlModel(this, dataKey) as TextBoxSelectXmlModel;
                if (xmlModel == null)
                {
                    WriteError(string.Format("The xml file is null,or the DataKey '{0}' has not finded!", dataKey));
                }
            }
        }
        #endregion
        #region Set Grid Column And Appearance
        private void SetGridColumn()
        {
            string[] showFieldArray = xmlModel.ShowFields.Split(',');
            string[] showFieldHeaderArray = xmlModel.ShowFieldsHeader.Split(',');
            string[] fieldWidthArray = xmlModel.FieldWidth.Split(',');
            if (showFieldArray.Length != showFieldHeaderArray.Length || showFieldHeaderArray.Length != fieldWidthArray.Length)
                WriteError("FieldWidth,ShowFields or ShowFieldsHeader's Columns are not equal! ");
            string[] hiddenFieldArray = xmlModel.HiddenFields.Split(',');
            for (int i = 0; i < showFieldArray.Length; i++)
            {
                BoundField col = new BoundField();
                col.HeaderText = showFieldHeaderArray[i];
                //col.AccessibleHeaderText = showFieldArray[i];
                col.DataField = showFieldArray[i];
                col.HeaderStyle.Width = new Unit(fieldWidthArray[i]);
                GridView1.Columns.Add(col);
            }
            StartHiddenIndex = showFieldArray.Length;

            foreach (string hf in hiddenFieldArray)
            {
                BoundField colHidden = new BoundField();
                colHidden.DataField = hf;
                GridView1.Columns.Add(colHidden);
            }
        }
        protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            if ((e.Row.RowType == DataControlRowType.DataRow) || (e.Row.RowType == DataControlRowType.Header) || (e.Row.RowType == DataControlRowType.Footer))
            {
                for (int i = StartHiddenIndex; i < e.Row.Cells.Count; i++)
                {
                    e.Row.Cells[i].Style.Add(HtmlTextWriterStyle.Display, "none");
                }
            }
            if (e.Row.RowType == DataControlRowType.Header)
            {
                string[] allFields= string.Format("{0},{1}", xmlModel.ShowFields, xmlModel.HiddenFields).Split(',');
                
                for (int i = 0; i < e.Row.Cells.Count; i++)
                {
                    e.Row.Cells[i].ID = allFields[i];
                    e.Row.Cells[i].CssClass = "TableHeader";
                }
            }
            if (e.Row.RowType == DataControlRowType.DataRow)
            {
                foreach (TableCell tc in e.Row.Cells)
                {
                    tc.CssClass = "TableItem";
                }
            }
        }
        #endregion
        #region Set Search Form Appearance
        private void SetSearchForm()
        {
            if (xmlModel.SearchFields == string.Empty)
            {
                panelSearch.Visible = false;
                return;
            }
            hiddenParams.Value = xmlModel.CallBackParams;
            lbDescription.Text = xmlModel.SearchFieldsHeader;

        }
        #endregion
        #region Search Event
        protected void btnSearch_Click(object o, EventArgs e)
        {
            //GetXmlData();
            string[] searchFieldsArray = xmlModel.SearchFields.Split(',');
            StringBuilder sbWhere = new StringBuilder();
            if (txtKeyWord.Text.Trim() != string.Empty)
            {
                sbWhere.Append(" and ");
                foreach (string field in searchFieldsArray)
                {
                    sbWhere.Append(string.Format("{0} like '%{1}%' or ", field, txtKeyWord.Text.Trim()));
                }
                sbWhere.Remove(sbWhere.Length - 4, 4);
                ViewState[WhereStr] = sbWhere.ToString();
            }
            else
            {
                ViewState[WhereStr] = null;
            }
            InitList(1);
        }
        #endregion
        #region Init List
        private void InitList(int currentPage)
        {
            int recordCount = 0;
            DataTable dt = new DataTable();
            StringBuilder sbWhere = new StringBuilder();
            if (ViewState[WhereStr] != null)
            {
                sbWhere.Append(ViewState[WhereStr].ToString());
            }
            if (xmlModel.Where != string.Empty)
            {
                sbWhere.Append(" and ");
                sbWhere.Append(xmlModel.Where);
            }
            Paged.GetPagedData(xmlModel.TableName,
                xmlModel.HiddenFields != string.Empty ? string.Format("{0},{1}", xmlModel.ShowFields, xmlModel.HiddenFields) : xmlModel.ShowFields,
                PageSize, currentPage,
                xmlModel.Order, sbWhere.ToString(), out recordCount, ref dt);
            this.GridView1.DataSource = dt.DefaultView;
            this.GridView1.DataBind();
            AspNetPager1.CurrentPageIndex = currentPage;
            AspNetPager1.RecordCount = recordCount;
            AspNetPager1.PageSize = PageSize;
        }
        #endregion
        #region Change Page Index
        protected void AspNetPager1_PageChanging(object o, Wuqi.Webdiyer.PageChangingEventArgs e)
        {
            //GetXmlData();
            InitList(e.NewPageIndex);
        }
        #endregion

 public interface IXmlAnalyze
    {
        object GetXmlModel(Page page, string dataKey);
    }
    public class XmlAnalyze : IXmlAnalyze
    {
        public static DataSet XmlDataSet = new DataSet("XmlDataSet");
        private string filePath = string.Empty;
        public XmlAnalyze()
        {
            filePath = "/Resources/XML/TextBoxSelect.xml";
        }
        /// <summary>
        /// Relative path
        /// </summary>
        /// <param name="filePath"></param>
        public XmlAnalyze(string filePath)
        {
            this.filePath = filePath;
        }
        protected void LoadXMLData(Page page)
        {
            string fileAbsPath = page.Server.MapPath(filePath);
            //xmlDoc.Load(fileAbsPath);
            XmlDataSet.ReadXml(fileAbsPath,XmlReadMode.ReadSchema);
        }
        public virtual object GetXmlModel(Page page, string dataKey)
        {
            if (!XmlDataSet.Tables.Contains("TextBoxSelect"))
            {
                LoadXMLData(page);
            }
            if (!XmlDataSet.Tables.Contains("TextBoxSelect")) return null;
            foreach (DataRow dr in XmlDataSet.Tables["TextBoxSelect"].Rows)
            {
                if (dr["DataKey"].ToString().ToLower() == dataKey.ToLower())
                {
                    TextBoxSelectXmlModel model = new TextBoxSelectXmlModel();
                    model.DataKey = dataKey;
                    model.TableName = dr["TableName"].ToString();
                    model.ShowFields = dr["ShowFields"].ToString();
                    model.Title = dr["Title"].ToString();
                    model.ShowFieldsHeader = dr["ShowFieldsHeader"].ToString();
                    model.ValueTextFields = dr["ValueTextFields"].ToString();
                    model.FieldWidth = dr["FieldWidth"].ToString();
                    model.HiddenFields = dr["HiddenFields"].ToString();
                    model.SearchFields = dr["SearchFields"].ToString();
                    model.SearchFieldsHeader = dr["SearchFieldsHeader"].ToString();
                    model.Where = dr["Where"].ToString();
                    model.Order = dr["Order"].ToString();
                    model.CallBackParams = dr["CallBackParams"].ToString();
                    
                    return model;
                }
            }
            return null;
        }
    }


    [Serializable]
    public class TextBoxSelectXmlModel
    {
        public string DataKey { get; set; }
        public string TableName { get; set; }
        public string Title { get; set; }
        public string ShowFields { get; set; }
        public string ShowFieldsHeader { get; set; }
        public string ValueTextFields { get; set; }
        public string FieldWidth { get; set; }
        public string HiddenFields { get; set; }
        public string SearchFields { get; set; }
        public string SearchFieldsHeader { get; set; }
        public string Where { get; set; }
        public string Order { get; set; }
        public string CallBackParams { get; set; }
    }

这是XML文件的分析工具

<?xml version="1.0" encoding="utf-8" ?>
<TextBoxSelectXML>
    <xs:schema id="TextBoxSelectXML" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
        <xs:element name="TextBoxSelectXML" msdata:IsDataSet="true" msdata:Locale="en-US">
            <xs:complexType>
                <xs:choice minOccurs="0" maxOccurs="unbounded">
                    <xs:element name="TextBoxSelect">
                        <xs:complexType>
                            <xs:sequence>
                                <xs:element name="DataKey" type="xs:string" minOccurs="0" />
                                <xs:element name="TableName" type="xs:string" minOccurs="0" />
                                <xs:element name="Title" type="xs:string" minOccurs="0" />
                                <xs:element name="ShowFields" type="xs:string" minOccurs="0" />
                                <xs:element name="ShowFieldsHeader" type="xs:string" minOccurs="0" />
                                <xs:element name="ValueTextFields" type="xs:string" minOccurs="0" />
                                <xs:element name="FieldWidth" type="xs:string" minOccurs="0" />
                                <xs:element name="HiddenFields" type="xs:string" minOccurs="0" />
                                <xs:element name="SearchFields" type="xs:string" minOccurs="0" />
                                <xs:element name="SearchFieldsHeader" type="xs:string" minOccurs="0" />
                                <xs:element name="Where" type="xs:string" minOccurs="0" />
                                <xs:element name="Order" type="xs:string" minOccurs="0" />
                                <xs:element name="CallBackParams" type="xs:string" minOccurs="0" />
                            </xs:sequence>
                        </xs:complexType>
                    </xs:element>
                </xs:choice>
            </xs:complexType>
        </xs:element>
    </xs:schema>
    <TextBoxSelect>
        <DataKey>UserRole</DataKey>
        <TableName>UserRole</TableName><!--必须-->
        <Title>角色信息</Title><!--必须-->
        <ShowFields>RoleID,RoleName</ShowFields><!--必须-->
        <ShowFieldsHeader>角色编号,角色名称</ShowFieldsHeader><!--必须-->
        <ValueTextFields>RoleID,RoleName</ValueTextFields><!--必须-->
        <FieldWidth>30%,70%</FieldWidth>
        <HiddenFields></HiddenFields>
        <SearchFields>RoleName</SearchFields>
        <SearchFieldsHeader>角色名称</SearchFieldsHeader><!--必须(这不是头，是关键字解释)-->
        <Where></Where>
        <Order>RoleID desc</Order><!--必须-->
        <CallBackParams></CallBackParams><!--这是需要回CallBackFunction时的参数-->
    </TextBoxSelect>
</TextBoxSelectXML>\



******************表行变色*************************/
function ShowRowColor(id) {
    var tbl = $(id)[0];
    if (tbl) {
        for (var i = 1; i < tbl.rows.length; i++) {
            tbl.rows[i].onmouseover = function () {
                for (var j = 0; j < this.cells.length; j++) {
                    this.cells[j].style.backgroundColor = "#EDF1E8";
                }
            }
            tbl.rows[i].onmouseout = function () {
                for (var j = 0; j < this.cells.length; j++) {
                    this.cells[j].style.backgroundColor = "#FFFFFF";
                }
            }
        }
    }
}
/******************表行变色*************************/

这个是行变色，是在弹出框页面中调用

        /// <summary>
        /// 获取分页数据
        /// </summary>
        /// <param name="tableName"></param>
        /// <param name="colName"></param>
        /// <param name="pageSize"></param>
        /// <param name="currentPage"></param>
        /// <param name="orderStr"></param>
        /// <param name="whereStr"></param>
        /// <param name="recordCount"></param>
        /// <param name="returnDT"></param>
        public static void GetPagedData(string tableName, string colName, int pageSize, int currentPage,
            string orderStr, string whereStr, out int recordCount,ref DataTable returnDT)
        {
            SqlParameter paramCount = new SqlParameter("@recordCount", SqlDbType.Int);
            paramCount.Direction = ParameterDirection.Output;
            SqlParameter[] paramArray = {
                                            new SqlParameter("@tableName", tableName),
                                            new SqlParameter("@colName", colName),
                                            new SqlParameter("@pageSize", pageSize),
                                            new SqlParameter("@currentPage", currentPage),
                                            new SqlParameter("@orderStr", orderStr),
                                            new SqlParameter("@whereStr", whereStr),
                                            paramCount
                                        };
            returnDT = DbHelper.DbHelperSQL.RunProcedureForList("usp_pagination", paramArray);
            recordCount = int.Parse(paramCount.Value.ToString());
        }
        public static void GetPagedData(string tableName, int currentPage,
            string orderStr, out int recordCount,ref DataTable returnDT)
        {
            int pageSize = 10;
            string whereStr = string.Empty;
            string colName = "*";
            GetPagedData(tableName, colName, pageSize, currentPage,
             orderStr, whereStr, out recordCount,ref returnDT);
        }

这是弹出框显示列表数据时调用的分页代码\

t ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go




-- =============================================
-- Author:        <Anncesky>
-- Create date: <2008/3/16>
-- Description:    <Paged>
-- =============================================
ALTER PROCEDURE [dbo].[usp_pagination]
    @tableName    varchar(255),       -- 表名
    @colName      varchar(255)='*',   -- 字段名串
    @pageSize     int = 10,           -- 页尺寸
    @currentPage  int = 1,            -- 页码
    @orderStr     varchar(255) = '',-- 排序类型字段串（不带order by,带asc,desc,必须的）
    @whereStr     varchar(255) = '',-- 查询条件 （注意: 不要加 where）
    @recordCount  int output
AS
BEGIN
    SET NOCOUNT ON;
    declare @sql nvarchar(4000)
    declare @TotalPages int   

    --计算总记录数及总页数     
    set @sql = 'select @recordCount = count(*) from ' + @tableName + ' where 1=1 ' + @whereStr
    exec sp_executesql @sql,N'@recordCount int output',@recordCount output
    select @TotalPages=CEILING((@recordCount+0.0)/@PageSize)

    --处理页数超出范围情况
    if @currentPage<=0 
        set @currentPage = 1
    if @currentPage>@TotalPages
        set @currentPage = @TotalPages
    set @sql = 'select '+ @colName + ' from (select top(@currentPage*@pageSize) ' + @colName + ',row_number() over(order by ' + @orderStr + ') as rowNumber from ' + @tableName + ' where 1=1 ' + @whereStr + ') t where t.rowNumber >= ((@currentPage-1)*@pageSize+1)'
    
    --print @Sql   
    exec sp_executesql @sql,N'@currentPage int, @pageSize int',@currentPage,@pageSize  
END

分页存储过程