예제 #1
0
        protected void Page_Load(object sender, EventArgs e)
        {
            hkdb.VeriSess("4");

            if (Request.QueryString["typeId"] != null)
            {
                strtypeid = "&typeId=" + Request.QueryString["typeId"] + "";
                strsql    = " and FoldersID = '" + hkdb.GetStr(Server.UrlDecode(Request.QueryString["typeId"])) + "'";
            }
            else
            {
                strtypeid = "";
                strsql    = "";
            }

            if (!IsPostBack)
            {
                hkdb.PassTo("11310", "0");

                if (Request.QueryString["typeId"] != null)
                {
                    SqlDataReader dr = SqlHelper.ExecuteReader("select * from hk_Ygtxl_lb where id='" + int.Parse(Request.QueryString["typeid"]) + "' ");
                    if (dr.Read())
                    {
                        Namefile = dr["name"].ToString();
                    }
                    else
                    {
                        Namefile = "未选择类别";
                    }
                    dr.Close();
                }
                else
                {
                    Namefile = "未选择类别";
                }

                BindAttr();

                AspNetPager1.PageSize = int.Parse(Request.Cookies["haoke"].Values["pagecount"]);

                //页面绑定
                GridViewBind();
            }

            XMStr = null;
            SqlDataReader dr_jy = SqlHelper.ExecuteReader("select distinct substring(dbo.fun_getPY(name),1,1) as FYNAME from hk_Ygtxl");

            while (dr_jy.Read())
            {
                string SQL_GetCount = "select count(id) from hk_Ygtxl where substring(dbo.fun_getPY(name),1,1)='" + dr_jy["FYNAME"] + "'";
                string XMCount      = "" + hkdb.GetCount(SQL_GetCount) + "";
                XMStr += "<a href='ygtxl_r.aspx?XS=" + dr_jy["FYNAME"] + "" + strtypeid + "' class=gvlink>" + dr_jy["FYNAME"] + "(" + XMCount + ")</a>&nbsp;&nbsp;";
            }
            dr_jy.Close();
        }