62,041
社区成员
发帖
与我相关
我的任务
分享
public Rollback(string id,string t,string obj)
{
string p;
string sql;
HttpContext context;
getSQL(t, out p, out sql, out context);
if (sql != ""&&p!="")
{
con = new DataBaseConnector(p).CreateConnection();
OleDbCommand com = new OleDbCommand(sql, con);
com.Parameters.Add("@ID", int.Parse(obj));
con.Open();
com.ExecuteNonQuery();
con.Close();
com.Parameters.Clear();
com.CommandText = "DELECT FROM [operation] WHERE ID=@id";
com.Parameters.Add("@id", id);
con = new DataBaseConnector(context.Server.MapPath(@"数据库路径,你懂得")).CreateConnection();
con.Open();
com.ExecuteNonQuery();
com.Dispose();
con.Close();
}
}
private static void getSQL(string t, out string p, out string sql, out HttpContext context)
{
context = System.Web.HttpContext.Current;
switch (t)
{
case "主题":
p = context.Server.MapPath(@"数据库路径,你懂得");
sql = "UPDATE [article] SET [ADelected]='0' WHERE ID=@id";
break;
case "回复":
p = context.Server.MapPath(@"数据库路径,你懂得");
sql = "UPDATE [re] SET [Delected]=0 WHERE ID=@id";
break;
case "投票回复":
p = context.Server.MapPath(@"数据库路径,你懂得");
sql = "UPDATE [re] SET [delected]=0 WHERE ID=@id";
break;
case "投票":
p = context.Server.MapPath(@"App_Data\4sdr564gb.mdb");
sql = "UPDATE [article] SET [delected]=0 WHERE ID=@id";
break;
case "用户":
p = context.Server.MapPath(@"数据库路径,你懂得");
sql = "UPDATE [user] SET [valid]='2001/1/1' WHERE ID=@id";
break;
default:
p = "";
sql = "";
break;
}
}
UPDATE [article] SET [ADelected]='0' WHERE [ID]=@id