protected void add_Click(object sender, EventArgs e)
{
try
{
string stringSql = "select * from tb_User where Name='" + this.username.Text.Trim() + "' and PassWord='******'";
string sqlstring = "insert into tb_User (Name,PassWord,Level) values('" + this.username.Text.Trim() + "','" + this.pwd.Text.Trim() + "','" + "2" + "')";
SqlDataReader dr = da.ExecuteRead(stringSql);
dr.Read();
if (dr.HasRows)
{
this.lblMessage.Text = "该用户已存在";
dr.Close();
}
else
{
dr.Close();
SqlDataReader sdr = da.ExecuteRead(sqlstring);
this.lblMessage.Text = "用户添加成功";
Response.Redirect("~/Default.aspx");
}
}
catch
{
this.lblMessage.Text = "添加失败";
}
}
protected void gvEditAdmin_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int id = Convert.ToInt32(gdvUserManage.DataKeys[e.RowIndex].Value.ToString());
SqlDataReader sdr = da.ExecuteRead("Delete from tb_User where ID='" + id + "'");
sdr.Close();
Bind();
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
string sqlstring = " UPDATE tb_News SET Title = '" + this.txtNewsTitle.Text + "', Content = '" + this.txtNewsContent.Text + "', Categories = '" + this.labTitle.Text.Trim() + "', Type = '" + this.dlstNewsType.SelectedValue.ToString() + "' WHERE ID = '" + Request.QueryString["id"] + "'";
SqlDataReader sdr = da.ExecuteRead(sqlstring);
lblMessage.Text = "新闻修改成功！";
}
public static SqlDataReader GetDataReader(string sqlstr)
{
SqlData sql = new SqlData();
SqlDataReader reader = sql.ExecuteRead(sqlstr);
return(reader);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
string sqlstring = "INSERT INTO tb_News( Title, Content, Categories, Type, IssueDate)VALUES ('" + this.txtNewsTitle.Text.Trim() + "', '" + this.txtNewsContent.Text.Trim() + "', '" + this.labTitle.Text.Trim() + "', '" + this.dlstNewsType.SelectedValue.ToString() + "', '" + DateTime.Now.ToString("yyyy-MM-dd") + "')";
SqlDataReader sdr = da.ExecuteRead(sqlstring);
this.lblMessage.Text = "新闻添加成功！";
}
protected void btnAdd_Click(object sender, EventArgs e)
{
string fn = this.FileUpload1.FileName;
string url = "~/accessory/" + fn;
this.FileUpload1.PostedFile.SaveAs(Server.MapPath(url));
string sqlstring = "INSERT INTO tb_News( Title, Content, Categories, Type, IssueDate, url)VALUES ('" + this.txtNewsTitle.Text.Trim() + "', '" + this.txtNewsContent.Text.Trim() + "', '" + this.labTitle.Text.Trim() + "', '" + this.dlstNewsType.SelectedValue.ToString() + "', '" + DateTime.Now.ToString("yyyy-MM-dd") + "', '" + url + "')";
SqlDataReader sdr = da.ExecuteRead(sqlstring);
this.lblMessage.Text = "新闻添加成功！";
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
string fn = this.FileUpload1.FileName;
string url = "~/accessory/" + fn;
this.FileUpload1.PostedFile.SaveAs(Server.MapPath(url));
string sqlstring = " UPDATE tb_News SET Title = '" + this.txtNewsTitle.Text + "', url = '" + url + "', Content = '" + this.txtNewsContent.Text + "', Categories = '" + this.labTitle.Text.Trim() + "', Type = '" + this.dlstNewsType.SelectedValue.ToString() + "' WHERE ID = '" + Request.QueryString["id"] + "'";
SqlDataReader sdr = da.ExecuteRead(sqlstring);
lblMessage.Text = "新闻修改成功！";
}
protected void gvdNews_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
SqlDataReader sdr = da.ExecuteRead("delete from tb_News where id='" + this.gvdNews.DataKeys[e.RowIndex].Value.ToString() + "'");
sdr.Close();
if (number == 1)
{
this.SelectBind();
}
else
{
bind();
}
}
protected void submit_Click(object sender, EventArgs e)
{
string sqlstring = "select * from tb_User where Name='" + this.username.Text.Trim() + "' and PassWord='******'";
SqlDataReader sdr = da.ExecuteRead(sqlstring);
sdr.Read();
if (sdr.HasRows)
{
if (this.checkCode.Text.Trim() == this.verifyCode.Text.Trim())
{
Response.Redirect("Default.aspx?validate=1");
}
else
{
Response.Write("<script>alert('输入的验证码错误!')</script>");
}
}
else
{
Response.Write("<script>alert('输入的姓名或密码错误误！请重新输入')</script>");
Server.Transfer("Login.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
SqlData da = new SqlData();
string strShiShi = "select top 5 * from tb_News where Categories='时事新闻' order by issueDate desc";
string strEconomic = "select top 5 * from tb_News where Categories='环球经济' order by issueDate desc";
string strMilitary = "select top 5 * from tb_News where Categories='军事世界' order by issueDate desc";
string strScience = "select top 5 * from tb_News where Categories='科学技术' order by issueDate desc";
string strSocial = "select top 5 * from tb_News where Categories='社会百态' order by issueDate desc";
string strSports = "select top 5 * from tb_News where Categories='世界体育' order by issueDate desc";
string strFun = "select top 5 * from tb_News where Categories='娱乐综艺' order by issueDate desc";
string strLife = "select top 5 * from tb_News where Categories='生活理财' order by issueDate desc";
SqlDataReader dar = da.ExecuteRead(strShiShi);
dlstShiShi.DataSource = dar;
dlstShiShi.DataKeyField = "id";
dlstShiShi.DataBind();
dar.Close();
SqlDataReader sdrEco = da.ExecuteRead(strEconomic);
dlstEconomic.DataSource = sdrEco;
dlstEconomic.DataKeyField = "id";
dlstEconomic.DataBind();
sdrEco.Close();
SqlDataReader sdrM = da.ExecuteRead(strMilitary);
dlstMilitary.DataSource = sdrM;
dlstMilitary.DataKeyField = "id";
dlstMilitary.DataBind();
sdrM.Close();
SqlDataReader sdrS = da.ExecuteRead(strScience);
dlstScience.DataSource = sdrS;
dlstScience.DataKeyField = "id";
dlstScience.DataBind();
sdrS.Close();
SqlDataReader sdrSoc = da.ExecuteRead(strSocial);
dlstSocial.DataSource = sdrSoc;
dlstSocial.DataKeyField = "id";
dlstSocial.DataBind();
sdrSoc.Close();
SqlDataReader sdrSp = da.ExecuteRead(strSports);
dlstSports.DataSource = sdrSp;
dlstSports.DataKeyField = "id";
dlstSports.DataBind();
sdrSp.Close();
SqlDataReader sdrFun = da.ExecuteRead(strFun);
dlstFun.DataSource = sdrFun;
dlstFun.DataKeyField = "id";
dlstFun.DataBind();
sdrFun.Close();
SqlDataReader sdrLife = da.ExecuteRead(strLife);
dlstLife.DataSource = sdrLife;
dlstLife.DataKeyField = "id";
dlstLife.DataBind();
sdrLife.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
object validate = Request.QueryString["validate"];
if (validate == null || !validate.ToString().Trim().Equals("1"))
{
this.login_flag.Text = "please login";
return;
}
SqlData da = new SqlData();
string strShiShi = "select top 5 * from tb_News where Categories='时事新闻' order by issueDate desc";
string strEconomic = "select top 5 * from tb_News where Categories='环球经济' order by issueDate desc";
string strMilitary = "select top 5 * from tb_News where Categories='军事世界' order by issueDate desc";
string strScience = "select top 5 * from tb_News where Categories='科学技术' order by issueDate desc";
string strSocial = "select top 5 * from tb_News where Categories='社会百态' order by issueDate desc";
string strSports = "select top 5 * from tb_News where Categories='世界体育' order by issueDate desc";
string strFun = "select top 5 * from tb_News where Categories='娱乐综艺' order by issueDate desc";
string strLife = "select top 5 * from tb_News where Categories='生活理财' order by issueDate desc";
SqlDataReader dar = da.ExecuteRead(strShiShi);
dlstShiShi.DataSource = dar;
dlstShiShi.DataKeyField = "id";
dlstShiShi.DataBind();
dar.Close();
SqlDataReader sdrEco = da.ExecuteRead(strEconomic);
dlstEconomic.DataSource = sdrEco;
dlstEconomic.DataKeyField = "id";
dlstEconomic.DataBind();
sdrEco.Close();
SqlDataReader sdrM = da.ExecuteRead(strMilitary);
dlstMilitary.DataSource = sdrM;
dlstMilitary.DataKeyField = "id";
dlstMilitary.DataBind();
sdrM.Close();
SqlDataReader sdrS = da.ExecuteRead(strScience);
dlstScience.DataSource = sdrS;
dlstScience.DataKeyField = "id";
dlstScience.DataBind();
sdrS.Close();
SqlDataReader sdrSoc = da.ExecuteRead(strSocial);
dlstSocial.DataSource = sdrSoc;
dlstSocial.DataKeyField = "id";
dlstSocial.DataBind();
sdrSoc.Close();
SqlDataReader sdrSp = da.ExecuteRead(strSports);
dlstSports.DataSource = sdrSp;
dlstSports.DataKeyField = "id";
dlstSports.DataBind();
sdrSp.Close();
SqlDataReader sdrFun = da.ExecuteRead(strFun);
dlstFun.DataSource = sdrFun;
dlstFun.DataKeyField = "id";
dlstFun.DataBind();
sdrFun.Close();
SqlDataReader sdrLife = da.ExecuteRead(strLife);
dlstLife.DataSource = sdrLife;
dlstLife.DataKeyField = "id";
dlstLife.DataBind();
sdrLife.Close();
}
