laopanzai 2014-12-23 08:59 采纳率: 0%
浏览 1790

麻烦看看有没有错的地方

public partial class lybnew : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
Title = "";
if (!this.IsPostBack)
{
string ToPage = Request.QueryString["ToPage"];
if (ToPage == null)
{
ToPage = "1";
}
if (!StrRegExp.IsID(ToPage))
{
ToPage = "1";
}
this.Bind_rptList(Convert.ToInt32(ToPage));
}
}
protected void addly_Click(object sender, EventArgs e)
{
book binbin = new book();
binbin.username = Server.HtmlEncode(this.username.Text);
binbin.email = this.email.Text;
binbin.qq = this.qq.Text;
binbin.homepage = this.homepage.Text;
if (this.Radboy.Checked)
{
binbin.sex = "男";
binbin.face = "boy";
}
else
{
binbin.sex = "女";
binbin.face = "gril";
}
binbin.body = this.lybody.Text;

    binbin.ishide = false;

    Label1.Text = binbin.ishide.ToString();
    if (saveinfo.savely(binbin))
    {
        Response.Write("lybnew.aspx");
    }
    else
    {
        Response.Write("<script>alert('留言失败,服务器错误!');location.herf='lybnew.aspx'");
    }
}
private void Bind_rptList(int ToPage)
{
    int CurrentPage = ToPage;
    int PageSize = 5;
    int PageCount;
    int RecordCount;
    string PageSQL;
    string DataTable = "book";
    string DataFiled = "ID";
    string DataFileds = "ID,UserName,Face,Sex,QQ,HomePage,Email,IsHidden,Adddate,body,isrely,rebody";
    string DataOrders = "ID Desc";
    SqlConnection Conn = DB.createdb();
    //  string connstring = ConfigurationManager.AppSettings["cn"];
    // SqlConnection Conn = new SqlConnection();
    //  Conn.ConnectionString = connstring;
    //  conn.Open();
    Conn.Open();
    //* 取得记录总数,计算总页数
    SqlCommand cmd = new SqlCommand("Select Count(" + DataFiled + ") From " + DataTable, Conn);
    RecordCount = Convert.ToInt32(cmd.ExecuteScalar());
    if ((RecordCount % PageSize) != 0)
    {
        PageCount = RecordCount / PageSize + 1;
    }
    else
    {
        PageCount = RecordCount / PageSize;
    }
    if (ToPage > PageCount)
    {
        CurrentPage = PageCount;
    }
    if (CurrentPage <= 1)
    {
        PageSQL = "Select Top " + PageSize + " " + DataFileds + " From " + DataTable + " Order By " + DataOrders;
    }
    else
    {
        PageSQL = "Select Top " + PageSize + " " + DataFileds + " From " + DataTable + " Where " + DataFiled + " Not In ( Select Top " + PageSize * (CurrentPage - 1) + " " + DataFiled + " From " + DataTable + " Order By " + DataOrders + " ) Order By " + DataOrders;
    }
    SqlDataAdapter oda = new SqlDataAdapter(PageSQL, Conn);
    DataSet ds = new DataSet();
    oda.Fill(ds, "infList");
    this.lbTotalPage.Text = Convert.ToString(PageCount);
    this.hlkFirstPage.NavigateUrl = "?ToPage=1";
    this.hlkLastPage.NavigateUrl = "?ToPage=" + PageCount;
    this.lbCurrentPage.Text = Convert.ToString(CurrentPage);
    if (CurrentPage <= 1)
    {
        this.hlkPrevPage.Enabled = false;
        CurrentPage = 1;
    }
    else
    {
        this.hlkPrevPage.Enabled = true;
        this.hlkPrevPage.NavigateUrl = "?ToPage=" + (ToPage - 1);
    }
    if (CurrentPage >= PageCount)
    {
        this.hlkNextPage.Enabled = false;
        CurrentPage = PageCount;
    }
    else
    {
        this.hlkNextPage.Enabled = true;
        this.hlkNextPage.NavigateUrl = "?ToPage=" + (ToPage + 1);
    }
    rpt1.DataSource = ds.Tables["infList"].DefaultView;
    rpt1.DataBind();
    Conn.Close();
}
protected string showrely(bool isrely, string rebody)
{
    if (isrely)
    {
        return "<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color='#2CB421'>管理员回复:&nbsp;&nbsp;</font><font color='#000099'>" + Server.HtmlEncode(rebody) + "</font>";
    }
    else
    {
        return null;
    }
}

protected string showbody(bool ishidden, string str_body)
{
    if (!ishidden || Session["admin"] != null)
    {
        return str_body.Replace("\r\n", "<br>");

    }

    else
    {
        return "<br>&nbsp;&nbsp;<font color=red>此留言为悄悄话!只有管理员可见!</font>";
    }
}

protected string show_admin(int id)
{
    if (Session["admin"] != null)
    {
        return "<a href=re.aspx?id=" + id + ">回复</a>" + "&nbsp;&nbsp;&nbsp;<a href=del.aspx?id=" + id + ">删除</a>";
    }
    else
    {
        return null;
    }
}
  • 写回答

2条回答

  • threenewbee 2014-12-23 10:15
    关注

    没有这样贴出一堆代码让人家看是否对错的。
    要么你贴出少量几行代码,并且指出错误信息是什么,要么你要说明你的程序运行有什么问题,或者你可以上传你完整的可以运行的程序,然后才可以帮你分析。

    评论

报告相同问题?

悬赏问题

  • ¥15 关于#hadoop#的问题
  • ¥15 (标签-Python|关键词-socket)
  • ¥15 keil里为什么main.c定义的函数在it.c调用不了
  • ¥50 切换TabTip键盘的输入法
  • ¥15 可否在不同线程中调用封装数据库操作的类
  • ¥15 微带串馈天线阵列每个阵元宽度计算
  • ¥15 keil的map文件中Image component sizes各项意思
  • ¥20 求个正点原子stm32f407开发版的贪吃蛇游戏
  • ¥15 划分vlan后,链路不通了?
  • ¥20 求各位懂行的人,注册表能不能看到usb使用得具体信息,干了什么,传输了什么数据