protected override void InitializePager(GridViewRow row, int columnSpan, PagedDataSource pagedDataSource)
 {
     if (UseCustomPager)
         CreateCustomPager(row, columnSpan, pagedDataSource);
     else
         base.InitializePager(row, columnSpan, pagedDataSource);
 }

        protected void SummaryReportGridView_OnDataBound(object sender, EventArgs e)
        {
            GridViewRow row = new GridViewRow(0, 0, DataControlRowType.Header, DataControlRowState.Normal);
            TableHeaderCell cell = new TableHeaderCell();
            cell.Text = "";
            cell.ColumnSpan = 2;
            row.Controls.Add(cell);

            row.BackColor = ColorTranslator.FromHtml("#9e1b34");
            row.ForeColor = ColorTranslator.FromHtml("White");

            SummaryReportGridView.Rows[7].Style.Add(HtmlTextWriterStyle.FontWeight, "Bold");

            row.HorizontalAlign = HorizontalAlign.Center;

            foreach (GridViewRow row2 in SummaryReportGridView.Rows)
            {
                LinkButton lb = (LinkButton)row2.Cells[0].Controls[0];
                lb.ForeColor = ColorTranslator.FromHtml("#0000EE");

            }

            LinkButton lb2 = (LinkButton)SummaryReportGridView.Rows[7].Cells[0].Controls[0];
            lb2.Enabled = false;
            lb2.ControlStyle.Font.Underline = false;
            lb2.ForeColor = ColorTranslator.FromHtml("Black");
            lb2.ControlStyle.Font.Bold = true;
        }

        /// <summary>
        /// Sets the pager button states.
        /// </summary>
        /// <param name="gridView">The grid view.</param>
        /// <param name="gvPagerRow">The gv pager row.</param>
        /// <param name="page">The page.</param>
        public static void SetPagerButtonStates(GridView gridView, GridViewRow gvPagerRow, Page page)
        {
            int pageIndex = gridView.PageIndex;
            int pageCount = gridView.PageCount;

            ImageButton btnFirst = (ImageButton)gvPagerRow.FindControl("btnFirst");
            ImageButton btnPrevious = (ImageButton)gvPagerRow.FindControl("btnPrevious");
            ImageButton btnNext = (ImageButton)gvPagerRow.FindControl("btnNext");
            ImageButton btnLast = (ImageButton)gvPagerRow.FindControl("btnLast");

            btnFirst.Enabled = btnPrevious.Enabled = (pageIndex != 0);
            btnNext.Enabled = btnLast.Enabled = (pageIndex < (pageCount - 1));

            DropDownList ddlPageSelector = (DropDownList)gvPagerRow.FindControl("ddlPages");
            ddlPageSelector.Items.Clear();
            for (int i = 1; i <= gridView.PageCount; i++)
            {
                ddlPageSelector.Items.Add(i.ToString());
            }

            ddlPageSelector.SelectedIndex = pageIndex;

            Label lblPageCount = (Label)gvPagerRow.FindControl("lblPageCount");
            lblPageCount.Text = pageCount.ToString();

            //ddlPageSelector.SelectedIndexChanged += delegate
            //{
            //    gridView.PageIndex = ddlPageSelector.SelectedIndex;
            //    gridView.DataBind();
            //};
        }

        /// <summary>
        /// Sets the sort image states.
        /// </summary>
        /// <param name="gridView">The grid view.</param>
        /// <param name="row">The row.</param>
        /// <param name="sortField">The sort field.</param>
        /// <param name="sortAscending">if set to <c>true</c> [sort ascending].</param>
        public static void SetSortImageStates(GridView gridView, GridViewRow row,int columnStartIndex, string sortField, bool sortAscending)
        {
            for (int i = columnStartIndex; i < row.Cells.Count; i++)
            {
                TableCell tc = row.Cells[i];
                if (tc.HasControls())
                {
                    // search for the header link
                    LinkButton lnk = (LinkButton)tc.Controls[0];
                    if (lnk != null)
                    {
                        // initialize a new image
                        System.Web.UI.WebControls.Image img = new System.Web.UI.WebControls.Image();
                        // setting the dynamically URL of the image
                        img.ImageUrl = "~/images/" + (sortAscending ? "bullet_arrow_up" : "bullet_arrow_down") + ".png";
                        img.CssClass = "icon";
                        // checking if the header link is the user's choice
                        if (sortField == lnk.CommandArgument)
                        {
                            // adding a space and the image to the header link
                            //tc.Controls.Add(new LiteralControl(" "));
                            tc.Controls.Add(img);
                        }

                    }
                }
            }
        }

 protected override void OnInit(EventArgs e)
 {
     base.OnInit(e);
     Grid = Parent.Parent.Parent.Parent as GridView;
     Row = Parent.Parent as GridViewRow;
     Grid.DataBound += new EventHandler(Grid_DataBound);
 }

        protected override int CreateChildControls(System.Collections.IEnumerable dataSource, bool dataBinding)
        {
            int numRows = base.CreateChildControls(dataSource, dataBinding);

            //no data rows created, create empty table if enabled
            if (numRows == 0 && ShowEmptyTable)
            {
                //create table
                Table table = new Table();
                table.ID = this.ID;

                //create a new header row
                GridViewRow row = base.CreateRow(-1, -1, DataControlRowType.Header, DataControlRowState.Normal);

                //convert the exisiting columns into an array and initialize
                DataControlField[] fields = new DataControlField[this.Columns.Count];
                this.Columns.CopyTo(fields, 0);
                this.InitializeRow(row, fields);
                table.Rows.Add(row);

                //create the empty row
                row = new GridViewRow(-1, -1, DataControlRowType.DataRow, DataControlRowState.Normal);
                TableCell cell = new TableCell();
                cell.ColumnSpan = this.Columns.Count;
                cell.Width = Unit.Percentage(100);
                cell.Controls.Add(new LiteralControl(EmptyTableRowText));
                row.Cells.Add(cell);
                table.Rows.Add(row);

                this.Controls.Add(table);
            }

            return numRows;
        }

        /// <summary>
        /// Sets the sort image states.
        /// </summary>
        /// <param name="gridView">The grid view.</param>
        /// <param name="row">The row.</param>
        /// <param name="columnStartIndex"> </param>
        /// <param name="sortField">The sort field.</param>
        /// <param name="sortAscending">if set to <c>true</c> [sort ascending].</param>
        public static void SetSortImageStates(GridView gridView, GridViewRow row,int columnStartIndex, string sortField, bool sortAscending)
        {
            for (var i = columnStartIndex; i < row.Cells.Count; i++)
            {
                var tc = row.Cells[i];
                if (!tc.HasControls()) continue;

                // search for the header link  
                var lnk = tc.Controls[0] as LinkButton;
                if (lnk == null) continue;

                // initialize a new image
                var img = new Image
                {
                    ImageUrl = string.Format("~/images/{0}.png", (sortAscending ? "bullet_arrow_up" : "bullet_arrow_down")),
                    CssClass = "icon"
                };

                // setting the dynamically URL of the image
                // checking if the header link is the user's choice
                if (sortField == lnk.CommandArgument)
                {
                    // adding a space and the image to the header link
                    //tc.Controls.Add(new LiteralControl(" "));
                    tc.Controls.Add(img);
                }
            }
        }

        public static int GetGridViewInt(GridViewRow gvr, int columnIndex)
        {
            int returnValue = -1;

            returnValue = int.Parse(gvr.Cells[columnIndex].Text);

            return returnValue;
        }

        protected void gvLoaiHangMucDetails_RowCreated(object sender, GridViewRowEventArgs e)
        {
            if (e.Row.RowType == DataControlRowType.Header)
            {
                //Headerow number
                GridViewRow HeaderRowNumber = new GridViewRow(0, 0, DataControlRowType.Header, DataControlRowState.Insert);

                TableCell HeaderCellNumber = new TableCell();
                HeaderCellNumber.Text = "1";
                HeaderRowNumber.Cells.Add(HeaderCellNumber);

                HeaderCellNumber = new TableCell();
                HeaderCellNumber.Text = "2";
                HeaderRowNumber.Cells.Add(HeaderCellNumber);

                HeaderCellNumber = new TableCell();
                HeaderCellNumber.Text = "3";
                HeaderRowNumber.Cells.Add(HeaderCellNumber);

                HeaderCellNumber = new TableCell();
                HeaderCellNumber.Text = "4";
                HeaderRowNumber.Cells.Add(HeaderCellNumber);

                HeaderCellNumber = new TableCell();
                HeaderCellNumber.Text = "5";
                HeaderRowNumber.Cells.Add(HeaderCellNumber);

                gvLoaiHangMucDetails.Controls[0].Controls.AddAt(0, HeaderRowNumber);

                GridViewRow HeaderRowTitle = new GridViewRow(0, 0, DataControlRowType.Header, DataControlRowState.Insert);

                TableCell HeaderCellTitle = new TableCell();
                HeaderCellTitle.Text = "No. <br/>(stt)";
                HeaderCellTitle.Width = 30;
                HeaderRowTitle.Cells.Add(HeaderCellTitle);

                HeaderCellTitle = new TableCell();
                HeaderCellTitle.Text = "DESCRIPTION<br/> (Diễn giải)";
                HeaderRowTitle.Cells.Add(HeaderCellTitle);

                HeaderCellTitle = new TableCell();
                HeaderCellTitle.Text = "Q.TY<br/>(Số lượng)";
                HeaderRowTitle.Cells.Add(HeaderCellTitle);

                HeaderCellTitle = new TableCell();
                HeaderCellTitle.Text = "UNIT.<br/>(ĐVT)";
                HeaderRowTitle.Cells.Add(HeaderCellTitle);

                HeaderCellTitle = new TableCell();
                HeaderCellTitle.Text = "L.A's Remark<br/>(GDV ghi chú)";
                HeaderRowTitle.Cells.Add(HeaderCellTitle);

                gvLoaiHangMucDetails.Controls[0].Controls.AddAt(1, HeaderRowTitle);

                HeaderRowTitle.Attributes.Add("class", "header");
                HeaderRowNumber.Attributes.Add("class", "header_number");
            }
        }

        protected virtual void CreateCustomPager(GridViewRow row, int columnSpan, PagedDataSource pagedDataSource)
        {
            int pageCount = pagedDataSource.PageCount;
            int pageIndex = pagedDataSource.CurrentPageIndex + 1;
            int pageButtonCount = PagerSettings.PageButtonCount;

            TableCell cell = new TableCell();
            row.Cells.Add(cell);
            if (columnSpan > 1) cell.ColumnSpan = columnSpan;

            if (pageCount > 1)
            {
                HtmlGenericControl pager = new HtmlGenericControl("div");
                pager.Attributes["class"] = "pagination";
                cell.Controls.Add(pager);

                int min = pageIndex - pageButtonCount;
                int max = pageIndex + pageButtonCount;

                if (max > pageCount)
                    min -= max - pageCount;
                else if (min < 1)
                    max += 1 - min;

                // Create "previous" button
                Control page = pageIndex > 1
                                ? BuildLinkButton(pageIndex - 2, PagerSettings.PreviousPageText, "Page", "Prev")
                                : BuildSpan(PagerSettings.PreviousPageText, "disabled");
                pager.Controls.Add(page);

                // Create page buttons
                bool needDiv = false;
                for (int i = 1; i <= pageCount; i++)
                {
                    if (i <= 2 || i > pageCount - 2 || (min <= i && i <= max))
                    {
                        string text = i.ToString(NumberFormatInfo.InvariantInfo);
                        page = i == pageIndex
                                ? BuildSpan(text, "current")
                                : BuildLinkButton(i - 1, text, "Page", text);
                        pager.Controls.Add(page);
                        needDiv = true;
                    }
                    else if (needDiv)
                    {
                        page = BuildSpan("&hellip;", null);
                        pager.Controls.Add(page);
                        needDiv = false;
                    }
                }

                // Create "next" button
                page = pageIndex < pageCount
                        ? BuildLinkButton(pageIndex, PagerSettings.NextPageText, "Page", "Next")
                        : BuildSpan(PagerSettings.NextPageText, "disabled");
                pager.Controls.Add(page);
            }
        }

 /**/
 /// <summary>
 /// 构造函数
 /// </summary>
 /// <param name="dt">List(数据源)</param>
 /// <param name="title">List(Excel显示标题)</param>
 public ExcelMoreBook(List<DataTable> dt, List<string> title)
 {
     Page page = (Page)HttpContext.Current.Handler;
     if (dt.Count == 0)
     {
         throw new Exception("数据源为空");
     }
     _dataTable = dt;
     _title = title;
     _page = page;
 }
 /**/
 /// <summary>
 /// 以GridView的Head为标题
 /// </summary>
 /// <param name="row">GridView表头行对象</param>
 public void SetColumnNameFromGridViewHeadRow(GridViewRow row)
 {
     ExcelColumnCollection excelcols = new ExcelColumnCollection();
     _columnNamesCollection.Add(excelcols);
     foreach (TableCell cell in row.Cells)
     {
         excelcols.Add(new ExcelColumn(cell.Text));
     }
 }

 protected override void OnRowCreated(GridViewRowEventArgs e)
 {
     base.OnRowCreated(e);
     if (DesignMode)
         return;
     //Get a handle for the pager row
     if (e.Row.RowType == DataControlRowType.Pager)
         PagerRow = e.Row;
 }

		public void GridViewRow_DefaultProperty ()
		{
			GridViewRow row = new GridViewRow(0, 0, DataControlRowType.DataRow, DataControlRowState.Normal);
			Assert.AreEqual (null, row.DataItem, "DataItem");
			Assert.AreEqual (0, row.DataItemIndex, "DataItemIndex"); //This value assigned into constractor
			Assert.AreEqual (0, row.RowIndex, "RowIndex");		 //This value assigned into constractor
			Assert.AreEqual (DataControlRowType.DataRow, row.RowType, "RowType");   //This value assigned into constractor
			Assert.AreEqual (DataControlRowState.Normal, row.RowState, "RowState"); //This value assigned into constractor
		}

 public static String GetCellValue(GridViewRow r,String col)
 {
     foreach (DataControlFieldCell cell in r.Cells)
     {
         if (cell.ContainingField is BoundField)
             if (((BoundField)cell.ContainingField).DataField.Equals(col))
                 return HttpUtility.HtmlDecode(cell.Text);
     }
     return "";
 }

        /// <summary>
        /// Gets the value that should be exported to Excel
        /// </summary>
        /// <param name="row">The row.</param>
        /// <returns></returns>
        public virtual object GetExportValue( GridViewRow row )
        {
            if ( row.DataItem is System.Data.DataRowView )
            {
                var dataRow = ( (System.Data.DataRowView)row.DataItem ).Row;
                return dataRow[this.DataField];
            }

            return row.DataItem.GetPropertyValue( this.DataField );
        }

        protected void gvDSincome_RowCreated(object sender, GridViewRowEventArgs e)
        {
            if (e.Row.RowType == DataControlRowType.Header)
            {
                GridViewRow HeaderRow = new GridViewRow(0, 0, DataControlRowType.Header, DataControlRowState.Insert);

                TableCell HeaderCell = new TableCell();
                HeaderCell.Text = "No.";
                HeaderCell.Width = 30;
                HeaderRow.Cells.Add(HeaderCell);

                HeaderCell = new TableCell();
                HeaderCell.Text = "Update Date";
                HeaderRow.Cells.Add(HeaderCell);
                HeaderCell.Width = 150;

                HeaderCell = new TableCell();
                HeaderCell.Text = "Date";
                HeaderRow.Cells.Add(HeaderCell);
                HeaderCell.Width = 80;

                HeaderCell = new TableCell();
                HeaderCell.Text = "Description";
                HeaderRow.Cells.Add(HeaderCell);
                HeaderCell.Width = 300;

                HeaderCell = new TableCell();
                HeaderCell.Text = "Time-spent";
                HeaderRow.Cells.Add(HeaderCell);
                HeaderCell.Width = 50;
                HeaderCell = new TableCell();
                HeaderCell.Text = "Rate";
                HeaderRow.Cells.Add(HeaderCell);
                HeaderCell.Width = 100;

                HeaderCell = new TableCell();
                HeaderCell.Text = "Cyber Income";
                HeaderRow.Cells.Add(HeaderCell);
                HeaderCell.Width = 150;

                HeaderCell = new TableCell();
                HeaderCell.Text = "Real Income";
                HeaderRow.Cells.Add(HeaderCell);
                HeaderCell.Width = 100;

                HeaderCell = new TableCell();
                HeaderCell.Text = "Remark";
                HeaderRow.Cells.Add(HeaderCell);
                HeaderCell.Width = 80;

                gvDSincome.Controls[0].Controls.AddAt(0, HeaderRow);
                HeaderRow.Attributes.Add("class", "header nodrop nodrag");
                //HeaderRow2.Attributes.Add("class", "header nodrop nodrag");
            }
        }

 public static string GetText(GridViewRow row, string fieldName)
 {
     GridView grd = row.NamingContainer as GridView;
     if (grd != null)
     {
         int index = GetIndex(grd, fieldName);
         if (index != -1)
             return row.Cells[index].Text;
     }
     return "";
 }

		/// <summary>
		/// 设置未读条目样式
		/// </summary>
		/// <param name="row"></param>
		internal static void SetUnreadItemBold(GridViewRow row)
		{
			//由于ORMMapping入库时会把NULL或DataTime.MinValue存成NULL，如果直接从库取值再赋值，会把READ_TIME置成1900-01-01 00:00:00.000
			//为了防止其他意外情况发生，这里再加一个1900年的判断
			//沈峥说不用，这个责任该归到写的人身上，于是去掉了--080516
			//if (((UserTask)row.DataItem).ReadTime < new DateTime(1949, 10, 1, 0, 0, 0))
			if (((UserTask)row.DataItem).ReadTime == DateTime.MinValue)
			{
				row.Style["font-weight"] = "bold";
			}
		}

        public static IOrderedDictionary GetValues(GridViewRow row)
        {
            IOrderedDictionary values = new OrderedDictionary();
            foreach (DataControlFieldCell cell in row.Cells.Cast<DataControlFieldCell>().Where(cell => cell.Visible))
            {
                // Extract values from the cell.
                cell.ContainingField.ExtractValuesFromCell(values, cell, row.RowState, true);
            }

            return values;
        }

 public object GetValue(GridViewRow row)
 {
     foreach (TableCell cell in row.Cells)
     {
         if (cell.Attributes["colname"] != null && cell.Attributes["colname"] == this.DataField)
         {
             return this.GetValue(cell.FindControl(this.ControlID));
         }
     }
     return null;
 }