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"];
}
}
}
