guestbook.aspx

NET环境 /access环境的单页留言板

<%@ Page Language="C#" ContentType="text/html" ResponseEncoding="gb2312" Debug=true validateRequest=false %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<%@ Register TagPrefix="asahi" TagName="head" Src="head.ascx" %>
<script runat="server">
string sql;
//string strcon="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source="+Server.MapPath("../cn/wangwei/ly.mdb");
//
//寒冰冷水 留言版 V1.0
//
//单页面完成
//
//开发工具  DW 2004
//
//还有好多不完善的地方请大家，一起改进完成！
//
//QQ：19919716
//MSN：[e-mail]
//HTTP://www.zyline.com.cn
public void sess()
{
		if(Session["lyadmin"]!=null && Session["lyadmin"]!="")
		{
			sys.Text="退出管理";
		}
}
public void isid()
{
	if(Request.QueryString["id"]!=null && Request.QueryString["id"]!="")
	{
//		if(Request.QueryString["action"]="del")
		if(Session["lyadmin"]!=null && Session["lyadmin"]!="")
		{
			sys.Text="退出管理";
			switch (Request.QueryString["action"].ToString())
			{
			case "del":
			lbdel();
			break;
			case "ref":
			lbref();
			break;
			default:
			list();
			break;
			}
		}
		else
		{
			admin.Visible=true;
			lk.Visible=false;
		}
	}
	else
	{
		list();
	}
}
protected void Page_Load(Object Src, EventArgs E)
{
  if (!IsPostBack) 
  {
  DataBind();
  xie.Visible=false;
  panrel.Visible=false;
  for(int i=1;i<23;i++)
  {
  DroLog.Items.Add(new ListItem("形象"+i,i+".gif"));
  }
  //DroLog.ListItem.add()="hahah";
  //判断是否登陆了
  sess();
  //判断是否 有 ID 存在
  isid();
  }
//  HB_Del.Attributes.Add("onclick","javascript:return confirm('您确定要删除吗?');"); //为按钮空间帮定事件
}
public void list()
{
	sql="select * from ly order by sj desc";
	OleDbConnection con=new OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source="+Server.MapPath("ly.mdb"));
	OleDbCommand cmd=new OleDbCommand(sql,con);
	try
	{
	con.Open();
	OleDbDataReader rs=cmd.ExecuteReader();
	dg.DataSource=rs;
	dg.DataBind();
	////////////////Repeater 空间 连接方式
	OleDbDataAdapter da=new OleDbDataAdapter(sql,"PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source="+Server.MapPath("ly.mdb"));
	DataSet ds=new DataSet();
	da.Fill(ds,"list");
	if(ds.Tables["list"].Rows .Count >0)
	{
	PagedDataSource objPds = new PagedDataSource();
	objPds.DataSource = ds.Tables[0].DefaultView;
	objPds.AllowPaging = true;
	objPds.PageSize = 5;
	int CurPage;
	if (Request.QueryString["Page"] != null)
	CurPage=Convert.ToInt32(Request.QueryString["Page"]);
	else
	CurPage=1;

	objPds.CurrentPageIndex = CurPage-1;
	lblCurrentPage.Text = "当前页：" + CurPage.ToString();
	
	if (!objPds.IsFirstPage)
	lnkPrev.NavigateUrl=Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage-1);
	
	if (!objPds.IsLastPage)
	lnkNext.NavigateUrl=Request.CurrentExecutionFilePath+ "?Page=" + Convert.ToString(CurPage+1);
	
	//Repeater1.DataSource=objPds;
	//Repeater1.DataBind();
	dglist.DataSource=objPds;
//	dglist.DataSource=ds.Tables["list"].DefaultView;///原来的直接帮定就可以了 没有分页功能
	dglist.DataBind();
	lblnull.Visible=false;
	}
	}
	catch
	{
//		Response.Write("数据库错误!");
		xxx.Text="数据库错误!";
	}
	finally
	{
		con.Close();
	}
}
public void Logclick(Object Src, EventArgs E)
{
	string url;
	url=DroLog.SelectedItem.Value;
//	url=DroLog.Text;
//	url=DroLog.Value;
	imglog.ImageUrl="images/"+url;
}
public void ButOk_Click(Object Src, EventArgs E)
{
	OleDbConnection con=new OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source="+Server.MapPath("ly.mdb"));
	try
	{
	string txtip=Request.UserHostAddress;
	int qq;
	//qq=Convert.Int(txtOicq.Text);
	if(txtOicq.Text==null || txtOicq.Text=="")qq=0;
	else
	{
		qq=Convert.ToInt32(txtOicq.Text);
	}
	string addsql="insert into ly (name,oicq,http,mail,ip,logo,biaoti,content) values ('"+txtName.Text+"','"+qq+"','"+txtHttp.Text+"','"+txtMail.Text+"','"+txtip+"','images/"+DroLog.SelectedItem.Value+"','"+txtObj.Text+"','"+txtContent.Text+"')";
		con.Open();
		OleDbCommand cmd=new OleDbCommand(addsql,con);
		cmd.ExecuteNonQuery();
		Response.Redirect("guestbook.aspx");
	}
	catch (Exception ex)
	{
		//Response.Write(ex.ToString());
		xxx.Text=ex.ToString();
	}
	finally
	{
		con.Close();
	}
}
public void butclick(Object Src,CommandEventArgs E)
{
	string argName =E.CommandName;
	//string argArg = look.CommandArgument;
	//Response.Write("您选中的动作为:<font color=red>"+argName+"</font>,动作目标是：<font color=red>"+argArg+"</font>");
	switch (argName)
	{
	case "lk":
	Response.Redirect("guestbook.aspx");
	xie.Visible=false;
	lk.Visible=true;
	//Response.Write(argName);
	break;
	case "qx":
	xie.Visible=true;
	lk.Visible=false;
	panrel.Visible=false;
	//Response.Write(argName);	
	break;
	default:
	xie.Visible=false;
	lk.Visible=true;
	break;
	}
}
public void look_click(Object Src,EventArgs e)
{
	Response.Redirect("guestbook.aspx");
}
public void qxie_click(Object Src,EventArgs e)
{
//	Response.Redirect("guestbook.aspx");
	xie.Visible=true;
	lk.Visible=false;
	panrel.Visible=false;
	admin.Visible=false;
}
public void sys_click(Object Src,EventArgs e)
{
	if(Session["lyadmin"]!=null && Session["lyadmin"]!="")
	{
		Session["lyadmin"]=null;
		sys.Text="留言管理";
	}
	else
	{
//	Response.Redirect("guestbook.aspx");
	admin.Visible=true;
	xie.Visible=false;
	lk.Visible=false;
	panrel.Visible=false;
	}
}
public void lbdel()
{
	string delsql="delete from ly where id="+Request.QueryString["id"];
	OleDbConnection con=new OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source="+Server.MapPath("ly.mdb"));
	OleDbCommand cmd=new OleDbCommand(delsql,con);
	try
	{	
		//打开数据库连接
		con.Open();
		//执行删除命令
		cmd.ExecuteNonQuery();
		///地址转向 
		Response.Redirect("guestbook.aspx"); 
		///操作成功提示！
		Response.Write("<script>alert('删除留言成功！');location.href='guestbook.aspx';<"+"/"+"script>");
		Response.End();
//		Response.Write(delsql);
	}
	catch
	{
		Response.Write("<script>alert('删除留言失败！');location.href='guestbook.aspx';<"+"/"+"script>");
		Response.End();
	}
	finally
	{
		con.Close();
	}
}
public void dglist_click(Object Src,RepeaterCommandEventArgs E)
{
	Response.Write(((LinkButton)E.CommandSource).Text);
	//Response.Write(E.DataMember);
}