info.aspx.cs

来自「这也是关于论坛的一个源代码」· CS 代码 · 共 447 行 · 第 1/2 页

                    this.characterx.Text = dts.Rows[0]["character"].ToString();//性格
                    this.UserFanx.Text = dts.Rows[0]["UserFan"].ToString();//用户爱好
                    this.educationx.Text = dts.Rows[0]["education"].ToString();//学历
                    this.Lastschoolx.Text = dts.Rows[0]["Lastschool"].ToString();//毕业学校
                    this.Addressx.Text = dts.Rows[0]["Address"].ToString();//地址
                    this.Postcodex.Text = dts.Rows[0]["Postcode"].ToString();	//邮政编码
                    this.FaTelx.Text = dts.Rows[0]["FaTel"].ToString(); 	//家庭联系电话
                    this.WorkTelx.Text = dts.Rows[0]["WorkTel"].ToString();	//工作单位联系电话
                    this.Faxx.Text = dts.Rows[0]["Fax"].ToString();	//传真
                    this.QQx.Text = dts.Rows[0]["QQ"].ToString(); 	//QQ
                    this.MSNx.Text = dts.Rows[0]["MSN"].ToString(); 	//MSN号
                }
                dts.Clear();
                dts.Dispose();
            }
            #endregion
        }
    }

    protected string getlevels(int ipoint)
    {
        string _Str = "";
        DataTable dt = rd.getleves();
        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(Foosun.Common.Input.Filter(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", Foosun.Common.Input.Filter(ClassID));
            dt = Foosun.CMS.Pagination.GetPage("user_ShowUser_1_aspx", PageIndex, 20, out i, out j, st);
        }
        else
        {
            SQLConditionInfo st = new SQLConditionInfo("@UserNum", UserNumID);
            dt = Foosun.CMS.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++)
            {
                dt.Rows[s]["cNames"] = con.sel_cName(dt.Rows[s]["ClassID"].ToString());
                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.getConstrClass(UserNum);
        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(Foosun.Common.Input.Filter(UserNum.ToString()));
        }
        SQLConditionInfo st = new SQLConditionInfo("@UserNum", UserNumID);
        int i, j;
        DataTable dt = Foosun.CMS.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 = Foosun.Config.UIConfig.dirDumm;
                    if (_dirDumm.Trim() != ""){_dirDumm = _dirDumm + "/";}
                    dt.Rows[s]["picnum"] = "(" + sel_picnumber + ")";
                    PicURL = rd.sel_pic(dt.Rows[s]["PhotoalbumID"].ToString()).Replace("{@userdirfile}", _dirDumm + Foosun.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", Foosun.Common.Input.Filter(UserNum.ToString()));
        DataTable cjlistdts = Foosun.CMS.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_22();
            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()
    {
        Info ud = new Info();
        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(Foosun.Common.Input.Filter(_uid.ToString()));
            DataTable dt = ud.getflist(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.getflist(0, userNum);
            if (dt1 != null && dt1.Rows.Count > 0)
            {
                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() + "\" 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;
    }
 
}