//添加点击率
public void addClickSum()
{
try
{
string sql = "update tb_Video set [ClickSum]=[ClickSum]+1 where [VideoID]=" + Request.QueryString["VideoID"].ToString();
mydo.updateData(sql);
}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
}
}
//添加点击率
public void addClickSum()
{
try
{
string sql = "update tb_Sound set ClickSum=ClickSum+1 where SoundID=" + Request.QueryString["SoundID"];
mydo.updateData(sql);
}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
}
}
protected void Page_Load(object sender, EventArgs e)
{
string id = Request.QueryString["id"].ToString();
string sql = "select Lock from tb_login where ID=" + id;
OleDbDataReader odr = mydo.row(sql);
odr.Read();
int i = Convert.ToInt32(odr["Lock"]);
if (i == 0)
{
string upsql = "update tb_Login set Lock=1 where ID=" + id;
mydo.updateData(upsql);
}
else
{
string upsql = "update tb_Login set Lock=0 where ID=" + id;
mydo.updateData(upsql);
}
Response.Redirect("manage_user.aspx");
}