EP ep = new EP();//实例化一个对象 protected void Page_Load(object sender, EventArgs e) { if (Session["UserName"] != null || Session["UserPwd"] != null) { this.LblInfo.Text = "您好! " + Session["UserName"].ToString() + " 欢迎您登录本网站!"; Panel2.Visible = true; Panel1.Visible = false; } else { Panel2.Visible = false; Panel1.Visible = true; } ep.EXECDataList(dlSoftIntro, "select top 4 * from tb_Tools order by UPTime desc", "Id"); }
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) { ep.EXECDataList(DlNew, "select top 5 * from tb_New order by PublishTime desc", "Id");//显示网站新闻 }
EP ep = new EP();//实例化一个对象 protected void Page_Load(object sender, EventArgs e) { ep.EXECDataList(DLGongGao, "select top 5 * from tb_gonggao order by gtime desc", "id"); //显示网站公告 ep.EXECDataList(DlToolsDownLoad, "select top 5 * from tb_tools where Type='软件' order by point desc", "Id"); //显示软件下载排行 ep.EXECDataList(DataList2, "select top 3 * from tb_tools where Type='补丁' order by point desc", "Id"); //显示补丁下载排行 }
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"]; } } }