ASP.NET中的DataGrid控件示例

ASP.NET中的DataGrid控件示例 Powered By:记得忘记

关于DataGrid 的几点简单应用:
1、有关checkbox的几个功能：全部选种、取消选种、没选中操作的检测等，这几个均使用js脚本实现。
2、根据主键关键字进行查询，如果条件输入为空，则检索所有数据
3、显示页面状态，第几页总共几页
4、DataGrid 分页、根据输入的数字跳转到指定页
5、DataGrid的正反双向排序
6、DataGrid的删除、根据主键进行删除
7、DataGrid的编辑、点击后弹出更新、取消按钮
8、插入数据操作、通用BLL层实现
9、DataGrid 根据复选框删除对应记录

  1namespace WebUI.Modules.BaseData
  2{
  3    using System;
  4    using System.Data;
  5    using System.Drawing;
  6    using System.Web;
  7    using System.Web.UI.WebControls;
  8    using System.Web.UI.HtmlControls;
  9    using BLL.Modules.BaseData;    
 10    using Common.Modules.BaseData;
 11    using System.IO;
 12
 13    /**//// <summary>
 14    ///        SugarcaneClassInfo 的摘要说明。
 15    /// </summary>
 16    public class SugarcaneClassInfo : System.Web.UI.UserControl
 17    {
 18        protected System.Web.UI.WebControls.DataGrid DataGrid1;
 19        protected System.Web.UI.WebControls.TextBox txtClassID;
 20        protected System.Web.UI.WebControls.ImageButton ibtnAdd;
 21        protected System.Web.UI.WebControls.LinkButton btnLast;
 22        protected System.Web.UI.WebControls.LinkButton btnNext;
 23        protected System.Web.UI.WebControls.LinkButton btnPrev;
 24        protected System.Web.UI.WebControls.LinkButton btnFirst;
 25        protected System.Web.UI.WebControls.Label lblCurrentIndex;
 26        protected System.Web.UI.WebControls.Label lblPageCount;
 27        protected System.Web.UI.WebControls.TextBox go;
 28        protected System.Web.UI.WebControls.Label Label1;
 29        TSugarcaneClassBiz tSugarcaneClass = new TSugarcaneClassBiz();
 30        protected System.Web.UI.WebControls.ImageButton ibtnSearch;
 31        protected System.Web.UI.WebControls.TextBox txtClassName;
 32        protected System.Web.UI.WebControls.TextBox txtPrice;
 33        protected System.Web.UI.WebControls.TextBox txtRemark;
 34        protected System.Web.UI.WebControls.ImageButton ibtnCancel;
 35        protected System.Web.UI.WebControls.ImageButton ibtnDel;
 36        TSugarcaneClassData tSugarcaneClassData = new TSugarcaneClassData();
 37        /**//// <summary>
 38        /// 页面加载初始化工作
 39        /// Powered By:CHENQP
 40        /// </summary>
 41        /// <param name="sender"></param>
 42        /// <param name="e"></param>
 43        private void Page_Load(object sender, System.EventArgs e)
 44        {
 45            // 在此处放置用户代码以初始化页面
 46            this.ibtnDel.Attributes.Add("onclick","javascript:return DelRec();");
 47            btnFirst.Text = "首页";
 48            btnPrev.Text = "前一页";
 49            btnNext.Text = "下一页";
 50            btnLast.Text = "尾页";
 51            if(this.DataGrid1.Attributes["SortExpression"]==null) 
 52            {
 53                this.DataGrid1.Attributes["SortExpression"]="ClassID"; 
 54                this.DataGrid1.Attributes["SortDirection"]="ASC"; 
 55            }
 56            SetBind(this.DataSource());
 57            ShowStats();
 58        }
 59
 60        /**//// <summary>
 61        /// 得到数据列表、通过BLL层返回数据
 62        /// Powered By:CHENQP
 63        /// </summary>
 64        /// <returns></returns>
 65        protected DataView DataSource()
 66        {
 67            DataTable dt = tSugarcaneClass.SelectAll();
 68            return dt.DefaultView;
 69        }
 70
 71        /**//// <summary>
 72        /// 绑定数据源，同时考虑排序条件
 73        /// Powered By:CHENQP
 74        /// </summary>
 75        /// <param name="dv"></param>
 76        private void SetBind(DataView dv)
 77        {
 78            string SortExpression=this.DataGrid1.Attributes["SortExpression"];
 79            string SortDirection=this.DataGrid1.Attributes["SortDirection"];
 80            dv.Sort=SortExpression+" "+SortDirection; //指定视图的排序方式;
 81            try
 82            {
 83                this.DataGrid1.DataSource=dv;
 84                this.DataGrid1.DataBind();
 85            }
 86            catch
 87            {
 88                DataGrid1.CurrentPageIndex = 0;
 89                this.DataGrid1.DataSource=dv;
 90                this.DataGrid1.DataBind();
 91            }
 92            
 93        }
 94
 95        Web 窗体设计器生成的代码#region Web 窗体设计器生成的代码
 96        override protected void OnInit(EventArgs e)
 97        {
 98            //
 99            // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
100            //
101            InitializeComponent();
102            base.OnInit(e);
103        }
104        
105        /**//// <summary>
106        ///        设计器支持所需的方法 - 不要使用代码编辑器
107        ///        修改此方法的内容。
108        /// </summary>
109        private void InitializeComponent()
110        {
111            this.ibtnSearch.Click += new System.Web.UI.ImageClickEventHandler(this.ibtnSearch_Click);
112            this.ibtnAdd.Click += new System.Web.UI.ImageClickEventHandler(this.ibtnAdd_Click);
113            this.ibtnDel.Click += new System.Web.UI.ImageClickEventHandler(this.ibtnDel_Click);
114            this.ibtnCancel.Click += new System.Web.UI.ImageClickEventHandler(this.ibtnCancel_Click);
115            this.DataGrid1.ItemCreated += new System.Web.UI.WebControls.DataGridItemEventHandler(this.DataGrid1_ItemCreated);
116            this.DataGrid1.CancelCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_CancelCommand);
117            this.DataGrid1.EditCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_EditCommand);
118            this.DataGrid1.SortCommand += new System.Web.UI.WebControls.DataGridSortCommandEventHandler(this.DataGrid1_SortCommand);
119            this.DataGrid1.UpdateCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_UpdateCommand);
120            this.DataGrid1.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_DeleteCommand);
121            this.Load += new System.EventHandler(this.Page_Load);
122
123        }
124        #endregion
125        /**//// <summary>
126        /// 选中DataGridJ时改变颜色，通过JS实现
127        /// Powered By:CHENQP
128        /// </summary>
129        /// <param name="sender"></param>
130        /// <param name="e"></param>
131        private void DataGrid1_ItemCreated(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
132        {
133            if(e.Item.ItemType==ListItemType.Item||e.Item.ItemType==ListItemType.AlternatingItem)
134            {
135                e.Item.Attributes.Add("id","row"+e.Item.ItemIndex);
136                e.Item.Attributes.Add("onclick","javascript:return SelectRow("+e.Item.ItemIndex+");");
137            }
138        }
139
140        /**//// <summary>
141        /// 根据主键关键字进行查询，如果条件输入为空，则检索所有数据
142        /// Powered By:CHENQP
143        /// </summary>
144        /// <param name="sender"></param>
145        /// <param name="e"></param>
146        private void ibtnSearch_Click(object sender, System.Web.UI.ImageClickEventArgs e)
147        {
148            string strClassID = txtClassID.Text;
149            strClassID = strClassID.ToString().Trim();
150            if (strClassID.Length == 0)
151            {
152            }
153            else
154            {
155                DataTable dt = tSugarcaneClass.SelectByClassID(strClassID);
156                SetBind(dt.DefaultView);
157            }
158        }
159
160        /**//// <summary>
161        /// 显示页面状态，第几页总共几页
162        /// Powered By:CHENQP
163        /// </summary>
164        private void ShowStats()
165        {
166            lblCurrentIndex.Text = "第 " + (this.DataGrid1.CurrentPageIndex + 1).ToString() + " 页";
167            lblPageCount.Text = "总共 " + this.DataGrid1.PageCount.ToString() + " 页";
168        }
169
170        /**//// <summary>
171        /// DataGrid 分页
172        /// Powered By:CHENQP
173        /// </summary>
174        /// <param name="sender"></param>
175        /// <param name="e"></param>
176        public void PagerButtonClick(object sender, EventArgs e)
177        {
178            string arg = ((LinkButton)sender).CommandArgument.ToString();
179            switch(arg)
180            {
181                case "next":
182                    if (this.DataGrid1.CurrentPageIndex < (this.DataGrid1.PageCount - 1))
183                    {
184                        this.DataGrid1.CurrentPageIndex += 1;
185                    }
186                    break;
187                case "prev":
188                    if (this.DataGrid1.CurrentPageIndex > 0)
189                    {
190                        this.DataGrid1.CurrentPageIndex -= 1;
191                    }
192                    break;
193                case "last":
194                    this.DataGrid1.CurrentPageIndex = (this.DataGrid1.PageCount - 1);
195                    break;
196                default:
197                    this.DataGrid1.CurrentPageIndex = System.Convert.ToInt32(arg);
198                    break;
199            }
200            SetBind(this.DataSource());
201            ShowStats();
202        }
203
204        /**//// <summary>
205        /// 判断输入的跳转页是否为数字
206        /// Powered By:CHENQP
207        /// </summary>
208        /// <param name="oText"></param>
209        /// <returns></returns>
210        private bool IsNumberic(string oText)
211        {
212            try
213            {
214                int var1=Convert.ToInt32 (oText);
215                return true;
216            }
217            catch
218            {
219                return false;
220            }
221        }
222
223        /**//// <summary>
224        /// 根据输入的数字跳转到指定页
225        /// Powered By:CHENQP
226        /// </summary>
227        /// <param name="obj"></param>
228        /// <param name="e"></param>
229        public void goClick(object obj,EventArgs e)
230        {
231            if(go.Text.Trim()!=""&&this.IsNumberic(go.Text.Trim()))
232            {
233                int index=Int32.Parse(go.Text.Trim())-1;
234                if(index>=0 && index<this.DataGrid1.PageCount)
235                {
236                    this.DataGrid1.CurrentPageIndex=index;
237                }
238                SetBind(this.DataSource());
239                ShowStats();
240            }
241            else
242            {
243                Response.Write("<script>alert(\'跳转不能为空且必须为数字\')</script>");
244            }
245        }
246
247        /**//// <summary>
248        /// DataGrid的正反双向排序 
249        /// Powered By:CHENQP
250        /// </summary>
251        /// <param name="source"></param>
252        /// <param name="e"></param>
253        private void DataGrid1_SortCommand(object source, System.Web.UI.WebControls.DataGridSortCommandEventArgs e)
254        {
255            string SortExpression=e.SortExpression.ToString();  //获得当前排序表达式
256            string SortDirection="ASC"; //为排序方向变量赋初值
257            if(SortExpression==this.DataGrid1.Attributes["SortExpression"])  //如果为当前排序列
258            {
259                SortDirection=(this.DataGrid1.Attributes["SortDirection"].ToString()==SortDirection?"DESC":"ASC");     //获得下一次的排序状态
260
261            }
262            this.DataGrid1.Attributes["SortExpression"]=SortExpression;
263            this.DataGrid1.Attributes["SortDirection"]=SortDirection;
264            SetBind(this.DataSource());
265        }
266
267        /**//// <summary>
268        /// DataGrid的删除、根据主键进行删除
269        /// Powered By:CHENQP
270        /// </summary>
271        /// <param name="source"></param>
272        /// <param name="e"></param>
273        private void DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
274        {
275            string strClassID = e.Item.Cells[2].Text;
276            strClassID = strClassID.Trim();
277            if(strClassID=="")
278            {
279            }
280            else
281            {    
282                try
283                {
284                    if (tSugarcaneClass.Delete(strClassID))
285                    {
286                        BaseClass.MessageBox.Show(this.Page,"删除数据操作成功");
287                    }
288                    else
289                    {
290                    }
291                }
292                catch(Exception ex)
293                {
294                    throw ex;
295                }
296        
297                this.DataGrid1.EditItemIndex=-1;
298                SetBind(this.DataSource());
299            }
300        }
301
302        /**//// <summary>
303        /// DataGrid的编辑、点击后弹出更新、取消按钮
304        /// Powered By:CHENQP
305        /// </summary>
306        /// <param name="source"></param>
307        /// <param name="e"></param>
308        private void DataGrid1_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
309        {
310            this.DataGrid1.EditItemIndex = e.Item.ItemIndex;
311            SetBind(this.DataSource());
312        }
313
314        /**//// <summary>
315        /// DataGrid的编辑、取消按钮
316        /// Powered By:CHENQP
317        /// </summary>
318        /// <param name="source"></param>
319        /// <param name="e"></param>
320        private void DataGrid1_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
321        {
322                
323            this.DataGrid1.EditItemIndex = -1;
324            SetBind(this.DataSource());
325        }
326
327        /**//// <summary>
328        /// DataGrid的编辑、更新按钮、根据主键进行更新、主键不能更改
329        /// Powered By:CHENQP
330        /// </summary>
331        /// <param name="source"></param>
332        /// <param name="e"></param>
333        private void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
334        {
335            if(e.CommandName.ToString() == "Update" )
336            {
337                string strClassID = ((TextBox)e.Item.Cells[2].Controls[0]).Text;
338                string strClassName = ((TextBox)e.Item.Cells[3].Controls[0]).Text;
339                string strPrice = ((TextBox)e.Item.Cells[4].Controls[0]).Text;
340                decimal decPrice = Decimal.Parse(strPrice); 
341                string strRemark = ((TextBox)e.Item.Cells[5].Controls[0]).Text; 
342                tSugarcaneClassData.ClassID=strClassID.Trim();
343                tSugarcaneClassData.ClassName=strClassName.Trim();
344                tSugarcaneClassData.Price=decPrice;
345                tSugarcaneClassData.Type="";
346                tSugarcaneClassData.Remark=strRemark.Trim();
347                tSugarcaneClassData.PonderType="";
348
349                tSugarcaneClass.Update(tSugarcaneClassData);
350                this.DataGrid1.EditItemIndex = -1;
351                SetBind(this.DataSource());
352            }            
353        }
354
355        /**//// <summary>
356        /// 页面取消按钮:把相关文本框的值清空
357        /// Powered by:CHENQP
358        /// </summary>
359        /// <param name="sender"></param>
360        /// <param name="e"></param>
361        private void ibtnCancel_Click(object sender, System.Web.UI.ImageClickEventArgs e)
362        {
363            txtClassID.Text="";
364            txtClassName.Text="";
365            txtPrice.Text="";
366            txtRemark.Text="";                    
367        }
368
369        /**//// <summary>
370        /// 插入数据操作、通用BLL层实现
371        /// Powered By:CHENQP
372        /// </summary>
373        /// <param name="sender"></param>
374        /// <param name="e"></param>
375        private void ibtnAdd_Click(object sender, System.Web.UI.ImageClickEventArgs e)
376        {
377            string strClassID = txtClassID.Text.ToString().Trim();
378            string strClassName = txtClassName.Text.ToString().Trim();
379            string strPrice = txtPrice.Text.ToString().Trim();
380            decimal decPrice = Decimal.Parse(strPrice); //或者Convert.ToDecimal(strPrice)两种写法
381            string strRemark = txtRemark.Text.ToString().Trim();
382
383            tSugarcaneClassData.ClassID=strClassID.Trim();
384            tSugarcaneClassData.ClassName=strClassName.Trim();
385            tSugarcaneClassData.Price=decPrice;
386            tSugarcaneClassData.Type="";
387            tSugarcaneClassData.Remark=strRemark.Trim();
388            tSugarcaneClassData.PonderType="";
389            if (tSugarcaneClass.Insert(tSugarcaneClassData))
390            {
391                BaseClass.MessageBox.Show(this.Page,"增加数据操作成功");
392            }
393            else
394            {
395            };
396            SetBind(this.DataSource());
397        }
398
399        /**//// <summary>
400        /// DataGrid 根据复选框删除对应记录
401        /// Powered By:CHENQP
402        /// </summary>
403        /// <param name="sender"></param>
404        /// <param name="e"></param>
405        private void ibtnDel_Click(object sender, System.Web.UI.ImageClickEventArgs e)
406        {
407            string strClassID="";
408            for(int i=0;i<DataGrid1.Items.Count;i++)
409            {
410                CheckBox h;
411                h=(CheckBox)DataGrid1.Items[i].Cells[0].Controls[1];
412                if(h.Checked == true)
413                { 
414                    //取得已选取的主键
415                    strClassID = DataGrid1.Items[i].Cells[2].Text.ToString().Trim();
416                    try
417                    {
418                        if (tSugarcaneClass.Delete(strClassID))
419                        {                                    
420                        }
421                        else
422                        {
423                        }
424                    }
425                    catch(Exception ex)
426                    {
427                        throw ex;
428                    }
429                }
430            }
431            BaseClass.MessageBox.Show(this.Page,"删除数据操作成功");
432            SetBind(this.DataSource());
433        }
434    }
435}
436

SugarcaneClassInfo.ascx:

  1<%@ Register TagPrefix="cc1" Namespace="BaseComponent" Assembly="BaseComponent" %>
  2<%@ Control Language="c#" AutoEventWireup="false" Codebehind="SugarcaneClassInfo.ascx.cs" Inherits="WebUI.Modules.BaseData.SugarcaneClassInfo" TargetSchema="http://schemas.microsoft.com/intellisense/ie5"%>
  3<script>
  4        //DataGrid单击行时改变颜色
  5        var oldrow;
  6        var newColor='#BDBD00';
  7        var oldColor;
  8
  9        function SelectRow(rowno)
 10        {    
 11        if (oldrow == null)
 12        {
 13        oldColor = document.all('row'+rowno).style.backgroundColor;
 14        document.all('row'+rowno).style.backgroundColor = newColor;
 15        }
 16        else
 17        {
 18        oldrow.style.backgroundColor = oldColor;
 19        oldColor = document.all('row'+rowno).style.backgroundColor;
 20        document.all('row'+rowno).style.backgroundColor = newColor;
 21        }
 22                
 23        oldrow = document.all('row'+rowno);
 24        }
 25        
 26        var checkFlag = true;
 27　　　　function ChooseAll()
 28　　　　{
 29 　　　　　　//if( !document.all("CheckAll").Checked ) // 全选　
 30 　　　　　　if( checkFlag ) // 全选　
 31　　　　　　{
 32  　　　　　　　　var inputs = document.all.tags("INPUT");
 33  　　　　　　　　for (var i=0; i < inputs.length; i++) // 遍历页面上所有的 input 
 34  　　　　　　　　{
 35  　　　　　　　　　　if (inputs[i].type == "checkbox" && inputs[i].id != "CheckAll" )
 36   　　　　　　　　　　{
 37    　　　　　　　　　　　　inputs[i].checked = true;
 38   　　　　　　　　　　}     
 39  　　　　　　　　}
 40  　　　　　　　　checkFlag = false;
 41 　　　　　　}
 42 　　　　　　else  // 取消全选
 43 　　　　　　{
 44  　　　　　　　　var inputs = document.all.tags("INPUT");
 45  　　　　　　　　for (var i=0; i < inputs.length; i++) // 遍历页面上所有的 input 
 46  　　　　　　　　{
 47   　　　　　　　　　　if (inputs[i].type == "checkbox" && inputs[i].id != "CheckAll" )
 48   　　　　　　　　　　{
 49    　　　　　　　　　　　　inputs[i].checked = false;
 50   　　　　　　　　　　}     
 51  　　　　　　　　}
 52  　　　　　　　　checkFlag = true;
 53 　　　　　　}
 54　　　　}
 55
 56        // <summary>
 57　　　　// 让用户加以确认删除数据。
 58　　　　// </summary>
 59　　　　function DelRec()
 60　　　　{
 61 　　　　　　var inputs = document.all.tags("input");
 62 　　　　　　var selectedLen = 0;
 63 　　　　　　for( var i=0;i < inputs.length; i ++)
 64 　　　　　　{
 65  　　　　　　　　if(inputs[i].type == "checkbox")
 66  　　　　　　　　{
 67   　　　　　　　　　　if( inputs[i].checked )
 68   　　　　　　　　　　{
 69    　　　　　　　　　　　　if(inputs[i].id != "CheckAll")
 70    　　　　　　　　　　　　{
 71     　　　　　　　　　　　　　　selectedLen ++;
 72    　　　　　　　　　　　　}
 73   　　　　　　　　　　}
 74  　　　　　　　　}
 75 　　　　　　}
 76 　　　　　　if( selectedLen == 0 )
 77 　　　　　　{
 78  　　　　　　　　alert("请先选择您要删除的数据！");
 79   　　　　　　}
 80 　　　　　　else
 81 　　　　　　{
 82  　　　　　　　　var flag = confirm("您确定要删除所选择的这 " + selectedLen + " 条数据吗？");
 83  　　　　　　　　if(flag)
 84  　　　　　　　　{
 85   　　　　　　　　　　document.all("ibtnDel").click();  
 86  　　　　　　　　}
 87 　　　　　　}
 88　　　　}
 89
 90
 91</script>
 92<P><FONT face="宋体">
 93        <TABLE class="TABLE" id="Table1" style="WIDTH: 771px; HEIGHT: 248px" cellSpacing="1" cellPadding="1"
 94            width="771" align="center" border="0">
 95            <TR>
 96                <TD>
 97                    <P>
 98                        <HR color="background" SIZE="1">
 99                        编号关键字:
100                        <asp:textbox id="txtClassID" runat="server"></asp:textbox><asp:imagebutton id="ibtnSearch" runat="server" ImageUrl="../../Images/button_search.GIF"></asp:imagebutton>
101                    【按编号关键字进行搜索】
102                </TD>
103            </TR>
104            <TR>
105                <TD style="HEIGHT: 16px">
106                    <P align="left">&nbsp;&nbsp; 品种名称:
107                        <asp:textbox id="txtClassName" runat="server"></asp:textbox>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
108                        价格:
109                        <asp:textbox id="txtPrice" runat="server"></asp:textbox>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;备注:
110                        <asp:textbox id="txtRemark" runat="server"></asp:textbox></P>
111                </TD>
112            </TR>
113            <TR>
114                <TD style="HEIGHT: 25px">
115                    <P align="right"><asp:imagebutton id="ibtnAdd" runat="server" ImageUrl="../../Images/button_add.gif"></asp:imagebutton><asp:imagebutton id="ibtnDel" runat="server" ImageUrl="../../Images/button_del.gif"></asp:imagebutton><asp:imagebutton id="ibtnCancel" runat="server" ImageUrl="../../Images/button_cancel.gif"></asp:imagebutton></P>
116                </TD>
117            </TR>
118            <TR>
119                <TD vAlign="top">
120                    <DIV align="center"><asp:datagrid id="DataGrid1" runat="server" AllowSorting="True" AllowPaging="True" HorizontalAlign="Center"
121                            PageSize="15" Width="100%" AutoGenerateColumns="False" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px"
122                            BackColor="White" CellPadding="3">
123                            <SelectedItemStyle Font-Bold="True" ForeColor="White" BackColor="#669999"></SelectedItemStyle>
124                            <ItemStyle ForeColor="Black"></ItemStyle>
125                            <HeaderStyle Font-Bold="True" HorizontalAlign="Center" ForeColor="White" BackColor="#6766CC"></HeaderStyle>
126                            <FooterStyle ForeColor="#000066" BackColor="#6766CC"></FooterStyle>
127                            <Columns>
128                                <asp:TemplateColumn>
129                                    <ItemStyle HorizontalAlign="Center"></ItemStyle>
130                                    <HeaderTemplate>
131                                        <INPUT id="CheckAll" onclick="ChooseAll()" type="checkbox" name="CheckAll">
132                                    </HeaderTemplate>
133                                    <ItemTemplate>
134                                        <asp:CheckBox id="chkDel" runat="server"></asp:CheckBox>
135                                    </ItemTemplate>
136                                </asp:TemplateColumn>
137                                <asp:HyperLinkColumn Target="_self" DataNavigateUrlField="ClassID" DataNavigateUrlFormatString="Default.aspx?Module=SugarcaneClassInfoDetail&amp;ClassID={0}&amp;Mode=edit"
138                                    DataTextField="ClassID" SortExpression="ClassID" HeaderText="编号">
139                                    <HeaderStyle Width="10%" CssClass="HEADERSTYLE"></HeaderStyle>
140                                    <ItemStyle CssClass="ITEMSTYLEHYPERLINK"></ItemStyle>
141                                </asp:HyperLinkColumn>
142                                <asp:BoundColumn Visible="False" DataField="ClassID" SortExpression="ClassID" HeaderText="编号"></asp:BoundColumn>
143                                <asp:BoundColumn DataField="ClassName" SortExpression="ClassName" HeaderText="品种名称">
144                                    <HeaderStyle Width="30%"></HeaderStyle>
145                                </asp:BoundColumn>
146                                <asp:BoundColumn DataField="Price" SortExpression="Price" HeaderText="价格" DataFormatString="{0:F2}">
147                                    <HeaderStyle Width="10%"></HeaderStyle>
148                                </asp:BoundColumn>
149                                <asp:BoundColumn DataField="Remark" HeaderText="备注">
150                                    <HeaderStyle Width="28%"></HeaderStyle>
151                                </asp:BoundColumn>
152                                <asp:EditCommandColumn ButtonType="LinkButton" UpdateText="更新" CancelText="取消" EditText="编辑">
153                                    <HeaderStyle Width="12%"></HeaderStyle>
154                                </asp:EditCommandColumn>
155                                <asp:ButtonColumn Text="&lt;div onclick=&quot;javascript:return confirm('确定删除吗？')&quot;&gt;删除&lt;/div&gt;"
156                                    CommandName="Delete">
157                                    <HeaderStyle Width="10%"></HeaderStyle>
158                                </asp:ButtonColumn>
159                            </Columns>
160                            <PagerStyle Visible="False" HorizontalAlign="Left" ForeColor="#000066" BackColor="#EAEAEA" Mode="NumericPages"></PagerStyle>
161                        </asp:datagrid></DIV>
162                </TD>
163            </TR>
164            <TR>
165                <TD><asp:label id="lblPageCount" runat="server"></asp:label><asp:label id="lblCurrentIndex" runat="server" Width="104px"></asp:label><asp:linkbutton id="btnFirst" onclick="PagerButtonClick" runat="server" Font-Name="verdana" Font-size="8pt"
166                        CommandArgument="0" ForeColor="navy"></asp:linkbutton><asp:linkbutton id="btnPrev" onclick="PagerButtonClick" runat="server" Font-Name="verdana" Font-size="8pt"
167                        CommandArgument="prev" ForeColor="navy"></asp:linkbutton><asp:linkbutton id="btnNext" onclick="PagerButtonClick" runat="server" Font-Name="verdana" Font-size="8pt"
168                        CommandArgument="next" ForeColor="navy"></asp:linkbutton><asp:linkbutton id="btnLast" onclick="PagerButtonClick" runat="server" Font-Name="verdana" Font-size="8pt"
169                        CommandArgument="last" ForeColor="navy"></asp:linkbutton><asp:label id="Label1" runat="server">跳转：</asp:label><asp:textbox id="go" Width="20px" BorderColor="#9999FF" BorderWidth="1px" BackColor="White" AutoPostBack="True"
170                        OnTextChanged="goClick" Runat="server"></asp:textbox></TD>
171            </TR>
172        </TABLE>
173    </FONT>
174</P>
175