info.aspx.cs

最好用的站点内容管理系统 全部源代码都有

    protected string getlevels(int ipoint)
    {
        string _Str = "";
        DataTable dt = rd.sel_GroupListStr(6);
        if (dt != null)
        {
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                if (ipoint >= int.Parse(dt.Rows[i]["iPoint"].ToString()))
                {
                    _Str = "&nbsp;&nbsp;等级:&nbsp;<img src=\"../../sysImages/face/" + dt.Rows[i]["Lpicurl"].ToString() + "\" border=\"0\" alt=\"" + dt.Rows[i]["LTitle"].ToString() + "\" />" + dt.Rows[i]["LTitle"].ToString() + "";
                }
            }
            dt.Clear(); dt.Dispose();
        }
        return _Str;
    }


    protected void PageNavigator1_PageChange(object sender, int PageIndex)
    {
        Contentlist(PageIndex);
    }
    protected void Contentlist(int PageIndex)
    {
        string UserNum = Request.QueryString["uid"];
        string ClassID = Request.QueryString["ClassID"];
        string UserNumID = "";
        if (UserNum != "" && UserNum != null)
        {
            UserNumID = pd.getUserNameUserNum(UserNum.ToString());
        }
        int i, j;
        DataTable dt = null;
        if (ClassID != null && ClassID != "")
        {
            SQLConditionInfo[] st = new SQLConditionInfo[2];
            st[0] = new SQLConditionInfo("@UserNum", UserNumID);
            st[1] = new SQLConditionInfo("@ClassID", ClassID);
            dt = NetCMS.Content.Pagination.GetPage("user_ShowUser_1_aspx", PageIndex, 20, out i, out j, st);
        }
        else
        {
            SQLConditionInfo st = new SQLConditionInfo("@UserNum", UserNumID);
            dt = NetCMS.Content.Pagination.GetPage("user_ShowUser_1_1_aspx", PageIndex, 20, out i, out j, st);
        }
        this.PageNavigator1.PageCount = j;
        this.PageNavigator1.PageIndex = PageIndex;
        this.PageNavigator1.RecordCount = i;
        if (dt != null && dt.Rows.Count != 0)
        {
            dt.Columns.Add("cNames", typeof(string));
            dt.Columns.Add("UserName", typeof(string));
            for (int s = 0; s < dt.Rows.Count; s++)
            {
                DataTable obj = con.sel_ConstrInfo(dt.Rows[s]["ClassID"].ToString(), 0);
                if (obj != null)
                {
                    if (obj.Rows.Count > 0)
                    {
                        dt.Rows[s]["cNames"] = obj.Rows[0]["cName"].ToString();
                    }
                    else
                    {
                        dt.Rows[s]["cNames"] = "";
                    }
                }
                else
                {
                    dt.Rows[s]["cNames"] = "";
                }
                dt.Rows[s]["UserName"] = UserNum;
            }
            DataList1.DataSource = dt;
            DataList1.DataBind();
        }
    }

    protected string cclass(string UserNum)
    {
        string _STR = "文章分类：<a class=\"list_link\" href=\"info.aspx?s=content&uid=" + Request.QueryString["uid"] + "\">全部</a>&nbsp;│&nbsp;";
        DataTable dt = rd.sel_Misc(UserNum,13);
        if (dt != null)
        {
            for (int i = 0; i < dt.Rows.Count;i++ )
            {
                _STR += "<a class=\"list_link\" href=\"info.aspx?s=content&uid="+Request.QueryString["uid"]+"&ClassID=" + dt.Rows[i]["Ccid"].ToString() + "\" title=\"" + dt.Rows[i]["Content"].ToString() + "\">" + dt.Rows[i]["cName"].ToString() + "</a>&nbsp;│&nbsp;";
            }
            dt.Clear(); dt.Dispose();
        }
        return _STR;
    }

    protected void PageNavigator2_PageChange(object sender, int PageIndex)
    {
        Photolists(PageIndex);
    }
    protected void Photolists(int PageIndex)
    {
        string UserNum = Request.QueryString["uid"];
        string UserNumID = "";
        if (UserNum != "" && UserNum != null)
        {
            UserNumID = pd.getUserNameUserNum(UserNum.ToString());
        }
        SQLConditionInfo st = new SQLConditionInfo("@UserNum", UserNumID);
        int i, j;
        DataTable dt = NetCMS.Content.Pagination.GetPage("user_ShowUser_2_aspx", PageIndex, 30, out i, out j, st);
        this.PageNavigator2.PageCount = j;
        this.PageNavigator2.PageIndex = PageIndex;
        this.PageNavigator2.RecordCount = i;
        if (dt != null && dt.Rows.Count != 0)
        {
            dt.Columns.Add("PhotoalbumNames", typeof(string));
            dt.Columns.Add("picnum", typeof(string));
            dt.Columns.Add("pwds", typeof(string));
            dt.Columns.Add("Pic", typeof(string));
            for (int s = 0; s < dt.Rows.Count; s++)
            {
                string PicURL = "";
                int sel_picnumber = rd.sel_picnum(dt.Rows[s]["PhotoalbumID"].ToString());
                if (sel_picnumber != 0)
                {
                    string _dirDumm = NetCMS.Config.UIConfig.dirDumm;
                    if (_dirDumm.Trim() != ""){_dirDumm = _dirDumm + "/";}
                    dt.Rows[s]["picnum"] = "(" + sel_picnumber + ")";
                    PicURL = rd.sel_userGroup(dt.Rows[s]["PhotoalbumID"].ToString(),1).ToLower().Replace("{@userdirfile}", _dirDumm + NetCMS.Config.UIConfig.UserdirFile);
                }
                else
                {
                    dt.Rows[s]["picnum"] = "(0)";
                    PicURL = "../../sysImages/user/nopic_supply.gif";
                }
                if (dt.Rows[s]["pwd"].ToString() != "")
                {
                    dt.Rows[s]["pwds"] = "<span class=\"tbie\" title=\"有密码\">(*)</span>";
                }
                else
                {
                    dt.Rows[s]["pwds"] = "";
                }

                dt.Rows[s]["Pic"] = "<a href=\"showphoto.aspx?PhotoalbumID=" + dt.Rows[s]["PhotoalbumID"].ToString() + "&uid=" + UserNum + "\" class=\"list_link\"><Img ID=\"PicImage\" border=\"0\" Height=\"90px\" Width=\"90px\" src=\"" + PicURL + "\" /></a>";
                dt.Rows[s]["PhotoalbumNames"] = "<a href=\"showphoto.aspx?PhotoalbumID=" + dt.Rows[s]["PhotoalbumID"].ToString() + "&uid=" + UserNum + "\" class=\"list_link\">" + dt.Rows[s]["PhotoalbumName"].ToString() + "</a>";

            }
            DataList2.DataSource = dt;
            DataList2.DataBind();
        }
    }

    protected void PageNavigator3_PageChange(object sender, int PageIndex)
    {
        grouplist(PageIndex);
    }
    protected void grouplist(int PageIndex)
    {
        string UserNum = Request.QueryString["uid"];
        int i, j;
        SQLConditionInfo sts = new SQLConditionInfo("@UserName", UserNum.ToString());
        DataTable cjlistdts = NetCMS.Content.Pagination.GetPage("user_discuss_discussManageestablish_list_aspx", PageIndex, 20, out i, out j, sts);
        this.PageNavigator3.PageCount = j;
        this.PageNavigator3.PageIndex = PageIndex;
        this.PageNavigator3.RecordCount = i;
        if (cjlistdts != null && cjlistdts.Rows.Count != 0)
        {
            cjlistdts.Columns.Add("cutDisID2", typeof(string));
            DataTable selectcjDisID = dis.sel_disTable(3);
            foreach (DataRow h in cjlistdts.Rows)
            {
                int v = (int)selectcjDisID.Compute("Count(DisID)", "DisID='" + h["DisID"].ToString() + "'");
                h["cutDisID2"] = v;
            }
            Repeater2.DataSource = cjlistdts;
            Repeater2.DataBind();
        }
    }

    /// <summary>
    /// 友情连接
    /// </summary>
    /// <returns></returns>
    protected string linkContent()
    {
        Ghistory ud = new Ghistory();
        string _uid = Request.QueryString["uid"];
        string listSTR = "<div style=\"padding-top:10px;font-weight:bold;height:20px;\">文字连接</div>";
        if (_uid != null && _uid != "")
        {
            string userNum = pd.getUserNameUserNum(_uid.ToString());
            DataTable dt = ud.sel_friendLink(1, userNum);
            if (dt != null && dt.Rows.Count > 0)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    listSTR += "<a title=\"" + dt.Rows[i]["Content"].ToString() + "\" href=\"" + dt.Rows[i]["URL"].ToString() + "\" class=\"list_link\" target=\"_blank\">" + dt.Rows[i]["Name"].ToString() + "</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;";
                }
                dt.Clear(); dt.Dispose();
            }
            listSTR += "<div style=\"padding-top:20px;font-weight:bold;height:20px;\">图片连接</div>";
            DataTable dt1 = ud.sel_friendLink(0, userNum);
            if (dt1 != null && dt1.Rows.Count > 0)
            {
                string _dirDumm1 = NetCMS.Config.UIConfig.dirDumm;
                for (int m = 0; m < dt1.Rows.Count; m++)
                {
                    listSTR += "<a href=\"" + dt1.Rows[m]["URL"].ToString() + "\" target=\"_blank\"><img src=\"" + dt1.Rows[m]["Picurl"].ToString().ToLower().Replace("{@userdirfile}", _dirDumm1 + NetCMS.Config.UIConfig.UserdirFile) + "\" title=\"" + dt1.Rows[m]["Content"].ToString() + "\" style=\"width:88px;height:31px;\" border=\"0\" /></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;";
                }
                dt1.Clear(); dt1.Dispose();
            }
        }
        else
        {
            PageError("错误的参数<li>参数传递有错误!</li>", "");
        }
        return listSTR;
    }


    //读取会员的所有自定义字段
    public void getDefine(string UserNum)
    {
        DataTable dts = tab.setDefineByNum(UserNum);
        _STR = "";
        if (dts != null)
        {
            if (dts.Rows.Count > 0)
            {
                for (int i = 0; i < dts.Rows.Count; i++)
                {
                    string _dValue = dts.Rows[i]["definevalue"].ToString();
                    string _defineColumns = dts.Rows[i]["defineColumns"].ToString();
                    string DsContent = dts.Rows[i]["DsContent"].ToString();
                    _STR += "<tr class=\"TR_BG_list\" >";

                    string inputSTR = "";
                    string isNullStr = "";
                    if (dts.Rows[i]["IsNull"].ToString() != "1")
                    {
                        isNullStr = "<span class=\"reshow\">(*)</span>";
                    }
                    string dvalue = dts.Rows[i]["definedValue"].ToString();
                    _STR += "<td class=\"list_link\" style=\"text-align: left;\">" + dts.Rows[i]["defineCname"] + "</td><td>" + DsContent + "</td></tr>\r";

                } dts.Clear(); dts.Dispose();
            }
        }
    }
 
}