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