EP ep = new EP();//实例化对象 protected void Page_Load(object sender, EventArgs e) { if (Session["UserName"] == null && Session["UserPwd"] == null) { //弹出对话框显示“对不起!您还没有登录”提示信息,并且将页面跳转到用户登录页面中 Response.Write("<script lanuage='javaScript'>alert('对不起!您还没有登录!');location='UserLogin.aspx'</script>"); } else { if (Request["gonggaoid"] != null) { DataSet ds = ep.ReturnDataSet("select * from tb_gonggao where id='" + Request["gonggaoid"] + "'", "tb_gonggao"); DataRowView rv = ds.Tables["tb_gonggao"].DefaultView[0]; LblTitle.Text = rv["title"].ToString(); lblContent.Text = rv["content"].ToString(); } if (Request["newid"] != null) { DataSet ds = ep.ReturnDataSet("select * from tb_New where id='" + Request["newid"] + "'", "tb_New"); DataRowView rv = ds.Tables["tb_New"].DefaultView[0]; LblTitle.Text = rv["title"].ToString(); lblContent.Text = rv["content"].ToString(); } DataSet ds1 = ep.ReturnDataSet("select * from tb_Tools order by UPTime desc", "tb_Tools"); DataList1.DataSource = ds1; DataList1.DataBind(); } }
EP ep = new EP();//实例化对象 protected void Page_Load(object sender, EventArgs e) { //使用Session判断管理员是否已成功登录 if (Session["AdminUserName"] == null && Session["AdminPassWord"] == null) { Response.Redirect("~/AdminLogin.aspx"); } else { if (!IsPostBack) { if (Request["UserId"] != null) { DataSet ds = ep.ReturnDataSet("select * from tb_UserLogin where UserId='" + Request["UserId"] + "'", "tb_UserLogin"); DataRowView rv = ds.Tables["tb_UserLogin"].DefaultView[0]; this.LblUserId.Text = rv["UserId"].ToString(); this.lblUserName.Text = rv["UserName"].ToString(); this.Lblrole.Text = rv["role"].ToString(); this.lblSex.Text = rv["Sex"].ToString(); this.LblAge.Text = rv["Age"].ToString(); this.lblphone.Text = rv["phone"].ToString(); this.lblEmail.Text = rv["Email"].ToString(); this.lblQQ.Text = rv["QQ"].ToString(); this.lblAddress.Text = rv["Address"].ToString(); this.lblhomepage.Text = rv["homepage"].ToString(); this.LblIntro.Text = rv["Intro"].ToString(); this.Img.ImageUrl = rv["Image"].ToString(); } } } }
EP ep = new EP();//实例化一个对象 protected void Page_Load(object sender, EventArgs e) { //判断用户是否登录,如果没登录跳转到登录页面中 if (Session["UserName"] == null && Session["UserPwd"] == null) { //弹出对话框显示“对不起!您还没有登录”提示信息,并且将页面跳转到用户登录页面中 Response.Write("<script lanuage='javaScript'>alert('对不起!您还没有登录!');location='UserLogin.aspx'</script>"); } else { if (!this.IsPostBack) { if (Request["id"] != null) { DataSet ds = ep.ReturnDataSet("select * from tb_LeaveWord where id='" + Request["id"] + "'", "tb_LeaveWord"); DataRowView rv = ds.Tables["tb_LeaveWord"].DefaultView[0]; this.LblTitle.Text = rv["title"].ToString(); this.LblTime.Text = rv["lTime"].ToString(); this.LblPerson.Text = rv["person"].ToString(); this.TxtContent.Text = rv["Content"].ToString(); this.TxtReply.Text = rv["RevertContent"].ToString(); } } } }
EP ep = new EP();//实例化对象 protected void Page_Load(object sender, EventArgs e) { //使用Session判断管理员是否已成功登录 if (Session["AdminUserName"] == null && Session["AdminPassWord"] == null) { Response.Redirect("~/AdminLogin.aspx"); } else { if (!this.IsPostBack) { if (Request["id"] != null) { DataSet ds = ep.ReturnDataSet("select * from tb_New where id='" + Request["id"] + "'", "tb_New"); DataRowView rv = ds.Tables["tb_New"].DefaultView[0]; this.TextBox1.Text = rv["id"].ToString(); this.TextBox2.Text = rv["title"].ToString(); this.TxtContent.Text = rv["content"].ToString(); this.TxtTime.Text = Convert.ToDateTime(rv["PublishTime"].ToString()).ToShortDateString(); this.TxtPerson.Text = rv["PublishPerson"].ToString(); this.TxtComeFrom.Text = rv["ComeFrom"].ToString(); } } } }
EP ep = new EP();//实例化一个对象 protected void Page_Load(object sender, EventArgs e) { if (!this.IsPostBack) { //使用Session判断管理员是否已成功登录 if (Session["AdminUserName"] == null && Session["AdminPassWord"] == null) { Response.Redirect("~/AdminLogin.aspx"); } else { string SqlStr = "select * from tb_FriendLink";//查询头像信息表 ep.EXECDropDownList(ddlPhoto, SqlStr, "LinkImage"); imgPhoto.ImageUrl = ddlPhoto.SelectedValue; if (Request["id"] != null) { DataSet ds = ep.ReturnDataSet("select * from tb_FriendLink where id='" + Request["id"] + "'", "tb_FriendLink"); DataRowView rv = ds.Tables["tb_FriendLink"].DefaultView[0]; this.TxtTime.Text = Convert.ToDateTime(rv["AddTime"].ToString()).ToShortDateString(); this.txtAddress.Text = rv["LinkAddress"].ToString(); this.imgPhoto.ImageUrl = rv["LinkImage"].ToString(); } } } }
EP ep = new EP();//实例化对象 protected void Page_Load(object sender, EventArgs e) { if (!this.IsPostBack) { //使用Session判断管理员是否已成功登录 if (Session["AdminUserName"] == null && Session["AdminPassWord"] == null) { Response.Redirect("~/AdminLogin.aspx"); } else { string SqlStr = "select * from tb_image";//查询头像 ep.EXECDropDownList(this.ddlPhoto, SqlStr, "ImagePhone"); if (Request["UserId"] != null) { DataSet ds = ep.ReturnDataSet("select * from tb_UserLogin where UserId='" + Request["UserId"] + "'", "tb_UserLogin"); DataRowView rv = ds.Tables["tb_UserLogin"].DefaultView[0]; this.TxtUserName.Text = rv["UserName"].ToString(); this.DdlRole.SelectedItem.Text = rv["role"].ToString(); this.TxtTrueName.Text = rv["TrueName"].ToString(); this.TxtRetakePwd.Text = rv["RetakePassword"].ToString(); this.txtAnswerPassWord.Text = rv["AnswerPassWord"].ToString(); this.ddlSex.SelectedValue = rv["sex"].ToString(); this.TxtAge.Text = rv["Age"].ToString(); this.TxtTel.Text = rv["phone"].ToString(); this.TxtEmail.Text = rv["Email"].ToString(); this.TxtQQ.Text = rv["QQ"].ToString(); this.TxtAddress.Text = rv["Address"].ToString(); this.Txthomepage.Text = rv["homepage"].ToString(); this.TxtIntro.Text = rv["Intro"].ToString(); this.imgPhoto.ImageUrl = rv["Image"].ToString(); } } } }
EP ep = new EP();//实例化一个对象 protected void Page_Load(object sender, EventArgs e) { DataSet ds = null; ds = ep.ReturnDataSet("select * from tb_Tools order by UPTime desc", "tb_Tools"); DataList1.DataSource = ds; DataList1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (Request["id"] == null) { Response.Write("没有大图片"); } else { string id = Request["id"].ToString();//接收Default.aspx页面传递过来的“id”值 DataSet ds1 = null; ds1 = ep.ReturnDataSet("select * from tb_tools where id='" + Request["id"] + "'", "tb_tools"); DataRowView rv1 = ds1.Tables["tb_tools"].DefaultView[0]; this.Image1.ImageUrl = rv1["Image"].ToString(); } }
EP ep = new EP();//实例化一个对象 protected void Page_Load(object sender, EventArgs e) { if (!this.IsPostBack) { if (Request["id"] != null) { DataSet ds = ep.ReturnDataSet("select * from tb_LeaveWord where id='" + Request["id"] + "'", "tb_LeaveWord"); DataRowView rv = ds.Tables["tb_LeaveWord"].DefaultView[0]; this.TexTitle.Text = rv["Title"].ToString(); this.TexTime.Text = Convert.ToDateTime(rv["lTime"].ToString()).ToShortDateString(); this.TexPerson.Text = rv["person"].ToString(); this.TexContent.Text = rv["Content"].ToString(); this.TxtReply.Text = rv["RevertContent"].ToString(); } } }
EP ep = new EP();//实例化一个对象 protected void Page_Load(object sender, EventArgs e) { //判断用户是否登录,如果没登录跳转到登录页面中 if (Session["UserName"] == null && Session["UserPwd"] == null) { //弹出对话框显示“对不起!您还没有登录”提示信息,并且将页面跳转到用户登录页面中 Response.Write("<script lanuage='javaScript'>alert('对不起!您还没有登录!');location='UserLogin.aspx'</script>"); } else { ep.EXECDataList(this.DlLeibie, "select top 10 * from tb_leibie ", "id");//显示类别信息 if (Request["id"] != null) { DataSet ds = null; ds = ep.ReturnDataSet("select * from tb_leibie where id='" + Request["id"] + "'", "tb_leibie"); DataRowView rv = ds.Tables["tb_leibie"].DefaultView[0]; this.LblLeiBie.Text = rv["name"].ToString(); } this.bindGridView();//调用绑定方法 } }
EP ep = new EP();//实例化一个对象 protected void Page_Load(object sender, EventArgs e) { //使用Session判断管理员是否已成功登录 if (Session["AdminUserName"] == null && Session["AdminPassWord"] == null) { Response.Redirect("~/AdminLogin.aspx"); } else { if (!this.IsPostBack) { if (Request["id"] != null) { DataSet ds = ep.ReturnDataSet("select * from tb_leibie where id='" + Request["id"] + "'", "tb_leibie"); DataRowView rv = ds.Tables["tb_leibie"].DefaultView[0]; this.TxtName.Text = rv["name"].ToString(); this.TxtTime.Text = rv["ADDTime"].ToString(); } } } }
protected void Page_Load(object sender, EventArgs e) { //使用Session判断管理员是否已成功登录 if (Session["AdminUserName"] == null && Session["AdminPassWord"] == null) { Response.Redirect("~/AdminLogin.aspx"); } else { if (!IsPostBack) { string SqlStr = "select * from tb_uptools"; //查询下载工具 ep.EXECDropDownList(DDLTools, SqlStr, "tools"); string Sql = "select * from tb_toolsimage"; //查询头像信息表 ep.EXECDropDownList(DDlToolsImage, Sql, "image"); this.ImgSoft.ImageUrl = DDlToolsImage.SelectedValue; if (Request["id"] != null) { DataSet ds = ep.ReturnDataSet("select * from tb_tools where id='" + Request["id"] + "'", "tb_tools"); DataRowView rv = ds.Tables["tb_tools"].DefaultView[0]; this.TxtName.Text = rv["Name"].ToString(); this.TxtEdition.Text = rv["Edition"].ToString(); this.TxtCondition.Text = rv["Condition"].ToString(); this.TxtPrice.Text = rv["Price"].ToString(); this.TxtIntroEdition.Text = rv["EditionIntro"].ToString(); this.Txtleibie.Text = rv["LeiBie"].ToString(); this.ddlType.SelectedItem.Text = rv["Type"].ToString(); this.TxtSize.Text = rv["ToolSize"].ToString(); this.TxtPoint.Text = rv["point"].ToString(); this.TxtTime.Text = Convert.ToDateTime(rv["UpTime"].ToString()).ToShortDateString(); this.TxtIntro.Text = rv["Intro"].ToString(); this.DDLTools.SelectedItem.Text = rv["download"].ToString(); this.ImgSoft.ImageUrl = rv["Image"].ToString(); } } } }
EP ep = new EP();//实例化一个对象 protected void Page_Load(object sender, EventArgs e) { //使用Session判断管理员是否已成功登录 if (Session["AdminUserName"] == null && Session["AdminPassWord"] == null) { Response.Redirect("~/AdminLogin.aspx"); } else { if (!this.IsPostBack) { if (Request["id"] != null) { DataSet ds = ep.ReturnDataSet("select * from tb_LeaveWord where id='" + Request["id"] + "'", "tb_New"); DataRowView rv = ds.Tables["tb_LeaveWord"].DefaultView[0]; this.LblTitle.Text = rv["title"].ToString(); this.LblTime.Text = rv["lTime"].ToString(); this.LblPerson.Text = rv["person"].ToString(); this.LblContent.Text = rv["Content"].ToString(); this.TxtReply.Text = rv["RevertContent"].ToString(); } } } }
EP ep = new EP();//实例化对象 protected void Page_Load(object sender, EventArgs e) { //判断用户是否登录,如果没登录跳转到登录页面中 if (Session["UserName"] == null && Session["UserPwd"] == null) { //弹出对话框显示“对不起!您还没有登录”提示信息,并且将页面跳转到用户登录页面中 Response.Write("<script lanuage='javaScript'>alert('对不起!您还没有登录!');location='UserLogin.aspx'</script>"); } else { string SqlStr = "select * from tb_leibie"; //查询类别信息表 ep.EXECDropDownList(this.DDlLeibie, SqlStr, "name"); ep.EXECDataList(this.DlLeibie, "select top 10 * from tb_leibie order by ADDTime desc", "id"); //显示类别信息 if (Request["IdToolsDownLoad"] != null) { DataSet ds = null; ds = ep.ReturnDataSet("select * from tb_tools where id='" + Request["IdToolsDownLoad"] + "'", "tb_tools"); DataRowView rv = ds.Tables["tb_tools"].DefaultView[0]; this.lblName.Text = rv["name"].ToString(); //显示产品名称 this.lblEdition.Text = rv["Edition"].ToString(); //显示产品版本 this.lblCondition.Text = rv["condition"].ToString(); //显示运行环境 this.lblPrice.Text = rv["Price"].ToString(); //显示产品价格 this.lblIntroEdition.Text = rv["EditionIntro"].ToString(); //显示版本说明信息 this.DDlLeibie.SelectedItem.Text = rv["LeiBie"].ToString(); //显示产品类别 this.LblType.Text = rv["Type"].ToString(); //显示产品类型 this.lblSize.Text = rv["ToolSize"].ToString(); //显示文件大小 this.lblpoint.Text = rv["Point"].ToString(); //显示下载次数 this.ImgSoft.ImageUrl = rv["Image"].ToString(); //显示产品图片 this.LblIntro.Text = rv["UpTime"].ToString(); //显示上传时间 this.LblID.Text = rv["id"].ToString(); //显示产品编号 this.LblIntro.Text = rv["Intro"].ToString(); //显示产品说明 this.LblProduct.Text = Request["IdToolsDownLoad"]; } if (Request["downloadid"] != null) { DataSet ds = null; ds = ep.ReturnDataSet("select * from tb_tools where id='" + Request["downloadid"] + "'", "tb_tools"); DataRowView rv = ds.Tables["tb_tools"].DefaultView[0]; this.lblName.Text = rv["name"].ToString(); //显示产品名称 this.lblEdition.Text = rv["Edition"].ToString(); //显示产品版本 this.lblCondition.Text = rv["condition"].ToString(); //显示运行环境 this.lblPrice.Text = rv["Price"].ToString(); //显示产品价格 this.lblIntroEdition.Text = rv["EditionIntro"].ToString(); //显示版本说明信息 this.DDlLeibie.SelectedItem.Text = rv["LeiBie"].ToString(); //显示产品类别 this.LblType.Text = rv["Type"].ToString(); //显示产品类型 this.lblSize.Text = rv["ToolSize"].ToString(); //显示文件大小 this.lblpoint.Text = rv["Point"].ToString(); //显示下载次数 this.ImgSoft.ImageUrl = rv["Image"].ToString(); //显示产品图片 this.LblIntro.Text = rv["UpTime"].ToString(); //显示上传时间 this.LblID.Text = rv["id"].ToString(); //显示产品编号 this.LblIntro.Text = rv["Intro"].ToString(); //显示产品说明 this.LblProduct.Text = Request["downloadid"]; } if (Request["Mendid"] != null) { DataSet ds = null; ds = ep.ReturnDataSet("select * from tb_tools where id='" + Request["Mendid"] + "'", "tb_tools"); DataRowView rv = ds.Tables["tb_tools"].DefaultView[0]; this.lblName.Text = rv["name"].ToString(); //显示产品名称 this.lblEdition.Text = rv["Edition"].ToString(); //显示产品版本 this.lblCondition.Text = rv["condition"].ToString(); //显示运行环境 this.lblPrice.Text = rv["Price"].ToString(); //显示产品价格 this.lblIntroEdition.Text = rv["EditionIntro"].ToString(); //显示版本说明信息 this.DDlLeibie.SelectedItem.Text = rv["LeiBie"].ToString(); //显示产品类别 this.LblType.Text = rv["Type"].ToString(); //显示产品类型 this.lblSize.Text = rv["ToolSize"].ToString(); //显示文件大小 this.lblpoint.Text = rv["Point"].ToString(); //显示下载次数 this.ImgSoft.ImageUrl = rv["Image"].ToString(); //显示产品图片 this.LblIntro.Text = rv["UpTime"].ToString(); //显示上传时间 this.LblID.Text = rv["id"].ToString(); //显示产品编号 this.LblIntro.Text = rv["Intro"].ToString(); //显示产品说明 this.LblProduct.Text = Request["Mendid"]; } if (Request["IdToolsMend"] != null) { DataSet ds = null; ds = ep.ReturnDataSet("select * from tb_tools where id='" + Request["IdToolsMend"] + "'", "tb_tools"); DataRowView rv = ds.Tables["tb_tools"].DefaultView[0]; this.lblName.Text = rv["name"].ToString(); //显示产品名称 this.lblEdition.Text = rv["Edition"].ToString(); //显示产品版本 this.lblCondition.Text = rv["condition"].ToString(); //显示运行环境 this.lblPrice.Text = rv["Price"].ToString(); //显示产品价格 this.lblIntroEdition.Text = rv["EditionIntro"].ToString(); //显示版本说明信息 this.DDlLeibie.SelectedItem.Text = rv["LeiBie"].ToString(); //显示产品类别 this.LblType.Text = rv["Type"].ToString(); //显示产品类型 this.lblSize.Text = rv["ToolSize"].ToString(); //显示文件大小 this.lblpoint.Text = rv["Point"].ToString(); //显示下载次数 this.ImgSoft.ImageUrl = rv["Image"].ToString(); //显示产品图片 this.LblIntro.Text = rv["UpTime"].ToString(); //显示上传时间 this.LblID.Text = rv["id"].ToString(); //显示产品编号 this.LblIntro.Text = rv["Intro"].ToString(); //显示产品说明 this.LblProduct.Text = Request["IdToolsMend"]; } if (Request["ID"] != null) { DataSet ds = null; ds = ep.ReturnDataSet("select * from tb_tools where id='" + Request["ID"] + "'", "tb_tools"); DataRowView rv = ds.Tables["tb_tools"].DefaultView[0]; this.lblName.Text = rv["name"].ToString(); //显示产品名称 this.lblEdition.Text = rv["Edition"].ToString(); //显示产品版本 this.lblCondition.Text = rv["condition"].ToString(); //显示运行环境 this.lblPrice.Text = rv["Price"].ToString(); //显示产品价格 this.lblIntroEdition.Text = rv["EditionIntro"].ToString(); //显示版本说明信息 this.DDlLeibie.SelectedItem.Text = rv["LeiBie"].ToString(); //显示产品类别 this.LblType.Text = rv["Type"].ToString(); //显示产品类型 this.lblSize.Text = rv["ToolSize"].ToString(); //显示文件大小 this.lblpoint.Text = rv["Point"].ToString(); //显示下载次数 this.ImgSoft.ImageUrl = rv["Image"].ToString(); //显示产品图片 this.LblIntro.Text = rv["UpTime"].ToString(); //显示上传时间 this.LblID.Text = rv["id"].ToString(); //显示产品编号 this.LblIntro.Text = rv["Intro"].ToString(); //显示产品说明 this.LblProduct.Text = Request["ID"]; } } }