public void binddata()
{
BLLmessage bllmessage = new BLLmessage();
DataSet ds = bllmessage.h_select(AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1), AspNetPager1.PageSize, "message");
GridView1.DataSource = ds;
GridView1.DataBind();
}
protected void Button3_Click(object sender, EventArgs e)
{
for (int i = 0; i < GridView1.Rows.Count; i++)
{
CheckBox cb = (CheckBox)GridView1.Rows[i].FindControl("CheckBox1");
if (cb.Checked)
{
int id = Convert.ToInt32(GridView1.DataKeys[i].Value);
message mes = new message();
mes.id = id;
mes.state = 1;
BLLmessage bllmessage = new BLLmessage();
int result = bllmessage.p_update(mes);
if (result > 0)
{
Response.Write("<script>alert('批量审核成功');location.href='../message.aspx'</script>");
}
else
{
Common.MessageAlert.Alert(Page, "alert('批量审核失败');");
}
}
}
}
public void bindmes()
{
string title = Request.QueryString["_title"].ToString();
BLLmessage bllmessage = new BLLmessage();
DataSet ds = bllmessage.messelect(AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1), AspNetPager1.PageSize, "info", title);
GridView1.DataSource = ds;
GridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
//BLLmessage bllmessage = new BLLmessage();
//DataSet ds = bllmessage.select();
//DataList1.DataSource = ds;
//DataList1.DataBind();
if (!IsPostBack)
{
BLLmessage bllmessage = new BLLmessage();
int result = bllmessage.message_state();
AspNetPager1.RecordCount = result;
AspNetPager1.PageSize = 5;
binddata();
}
}
protected void Page_Load(object sender, EventArgs e)
{
int id = Convert.ToInt32(Request.QueryString["_id"]);
message mes = new message();
mes.id = id;
BLLmessage bllmessage = new BLLmessage();
MySqlDataReader sdr = bllmessage.readmessage(mes);
if (sdr.Read())
{
Label1.Text = sdr["_title"].ToString();
TextBox1.Text = sdr["_content"].ToString();
Label3.Text = sdr["_posttime"].ToString();
}
sdr.Close();
}
protected void Button1_Click(object sender, EventArgs e)
{
message mes = new message();
mes.id = Convert.ToInt32(Request.QueryString["_id"]);
mes.reply = TextBox2.Text;
mes.state = 1;
BLLmessage bllmessage = new BLLmessage();
int result = bllmessage.reply(mes);
if (result > 0)
{
Response.Write("<script>alert('回复留言成功');location.href='../message.aspx'</script>");
}
else
{
Response.Write("<script>alert('回复留言失败');</script>");
}
}
public string insert(string title, string content)
{
Model.message mes = new Model.message();
mes.title = title;
mes.content = content;
mes.ip = Request.UserHostAddress;
BLL.BLLmessage bllmessage = new BLL.BLLmessage();
int result = bllmessage.post(mes);
if (result > 0)
{
return("1");
}
else
{
return("0");
}
}
public string insert(string title,string content)
{
Model.message mes = new Model.message();
mes.title = title;
mes.content = content;
mes.ip = Request.UserHostAddress;
BLL.BLLmessage bllmessage = new BLL.BLLmessage();
int result = bllmessage.post(mes);
if (result > 0)
{
return "1";
}
else
{
return "0";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BLLmessage bllmessage = new BLLmessage();
int result = bllmessage.messageCount();
AspNetPager1.RecordCount = result;
AspNetPager1.PageSize = 10;
binddata();
}
}
protected void Page_Load(object sender, EventArgs e)
{
string title = Request.QueryString["_title"].ToString();
if (!IsPostBack)
{
BLLmessage bllmessage = new BLLmessage();
int result = bllmessage.mes_select(title);
AspNetPager1.RecordCount = result;
if (result > 0)
{
AspNetPager1.PageSize = 5;
bindmes();
Label1.Visible = false;
}
else
{
Button1.Visible = false;
Button2.Visible = false;
Button3.Visible = false;
Button4.Visible = false;
Button5.Visible = false;
Button6.Visible = false;
Button7.Visible = false;
txt_search.Visible = false;
Label1.Text = "对不起，没有搜索的相关信息";
Label1.Visible = true;
AspNetPager1.Visible = false;
}
}
}
