首页 > 技术文章 > 后台设置GridView列

suflowers1700218 2018-05-28 17:09 原文

    protected void BindGVJFView()
    {
        //初始化GridView
        int num = this.GVJF.Columns.Count;
        for (int i = 0; i < num; i++)
        {
            this.GVJF.Columns.RemoveAt(0);
        }
        //将部分数据转为超链接
        DataTable dtGV = StoreSNDAL.GetJF(this.txtKeywords.Text, GetPKStore(), this.ddlYear.SelectedValue).Copy();
        //处理DataTable中的数据
        //遍历行
        for (int i = 0; i < dtGV.Rows.Count; i++)
        {
            string aPKStoreUser = dtGV.Rows[i][0].ToString().Trim();
            string a1 = "<a href='javascript:void(0);' onclick=" + '"' + "window.open('StoreMonthSN.aspx?PK_StoreUser=" + aPKStoreUser + "&intMonth=0','StoreMonthSN','height=800, width=1000, top=30, left=500, toolbar=no, menubar=no, scrollbars=no, resizable=no, location=no, status=no')" + '"' + ">" + dtGV.Rows[i]["StoreUserName"] + "</a>";
            dtGV.Rows[i]["StoreUserName"] = a1;
            //遍历列
            for (int j = 5; j < dtGV.Columns.Count; j++)
            {
                string mon = GetMonth(dtGV.Columns[j].ColumnName.ToString());//获取月份
                string p = dtGV.Rows[i][j].ToString().Trim();
                string a2 = "<a href='javascript:void(0);' onclick=" + '"' + "window.open('StoreMonthSN.aspx?PK_StoreUser=" + aPKStoreUser + "&intMonth=" + mon + "','StoreMonthSN','height=800, width=1000, top=30, left=500, toolbar=no, menubar=no, scrollbars=no, resizable=no, location=no, status=no')" + '"' + ">" + p + "</a>";
                dtGV.Rows[i][j] = a2;
            }
        }
        //添加列
        BindJFColumn("店员姓名", "StoreUserName", 0);
        BindJFColumn("手机号", "UserPhone", 1);
        BindJFColumn("是否在职", "UserState", 2);
        BindJFColumn("员工类型", "UserType", 3);
        for (int i = 5; i < dtGV.Columns.Count; i++)
        {
            BindJFColumn(dtGV.Columns[i].ColumnName.ToString(), dtGV.Columns[i].ColumnName.ToString(), i - 1);
        }
        this.GVJF.DataSource = dtGV;
        this.GVJF.DataBind();
    }

 

    /// <summary>
    /// 绑定GridView的列
    /// </summary>
    /// <param name="HeaderText">列名</param>
    /// <param name="DataField">列值</param>
    /// <param name="num">索引位置</param>
    protected void BindJFColumn(string HeaderText, string DataField, int num)
    {
        BoundField column = new BoundField();
        column.HeaderText = HeaderText;
        column.DataField = DataField;
        column.HtmlEncode = false;//将超链接转为Html标签
        GVJF.Columns.Insert(num, column);
    }

  

 

推荐阅读