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) { if (!IsPostBack) { string SqlStr = "select * from tb_Image";//查询头像信息表 //调用ep类对象的EXECDropDownList方法,将ImagePhone字段绑定到DropDownList控件中 ep.EXECDropDownList(ddlPhoto, SqlStr, "ImagePhone"); //将从DropDownList控件中选择的图片路径显示在Image控件中 imgPhoto.ImageUrl = ddlPhoto.SelectedValue; } }
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) { string SqlStr = "select * from tb_uptools"; //查询下载工具 ep.EXECDropDownList(DDLTools, SqlStr, "tools"); string SqlLb = "select * from tb_leibie"; //查询类别信息表 ep.EXECDropDownList(ddllb, SqlLb, "name"); string Sql = "select * from tb_toolsimage"; //查询头像信息表 ep.EXECDropDownList(DDlToolsImage, Sql, "image"); this.ImgSoft.ImageUrl = DDlToolsImage.SelectedValue; } } }
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) { if (!IsPostBack) { //判断用户是否登录,如果没登录跳转到登录页面中 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"); this.bindGridView(); //调用用户自定义方法 } } }
EP ep = new EP();//实例化一个对象 protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //使用Session判断管理员是否已成功登录 if (Session["AdminUserName"] == null && Session["AdminPassWord"] == null) { //将页面跳转到管理员登录页面中 Response.Redirect("~/AdminLogin.aspx"); } else { string SqlStr = "select * from tb_Image";//查询头像信息表 //调用EP类中的EXECDropDownList方法将字段ImagePhone中的内容绑定到ddlPhoto控件中 ep.EXECDropDownList(ddlPhoto, SqlStr, "ImagePhone"); imgPhoto.ImageUrl = ddlPhoto.SelectedValue; } } }
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"]; } } }