//主动封号
public bool blockUser(AdminOperate ao)
{
bool result = false;
User u = new User();
u.User_Id = ao.User_Id;
//判断用户是否存在
if (new UserSql().isExistUser(u))
{
//改用户状态
string sql = string.Format("Update FFTX_User set user_state = 0 where user_id = {0}", ao.User_Id);
int r = SqlDB.ExecuteNonQuery(sql);
//执行失败
if (r != 1)
{
return(false);
}
//添加一条 处理数据
string sql2 = string.Format("INSERT INTO FFTX_Admin_Operate (admin_id,user_id,operate_time,operate_reason) VALUES ('{0}','{1}','{2}','{3}')",
ao.Admin_Id, ao.User_Id, ao.Operate_Time, ao.Operate_Reason);
r = SqlDB.ExecuteNonQuery(sql2);
//添加数据失败
if (r != 1)
{
return(false);
}
return(true);
}
return(result);
}
//封禁用户
public ActionResult blockUser(AdminOperate ao)
{
ao.Admin_Id = ((Admin)Session["Admin"]).Admin_Id;
ao.Operate_Time = DateTime.Now;
AdminSql ads = new AdminSql();
if (ads.blockUser(ao))
{
//封号成功
}
///
return(RedirectToAction("index"));
}
public AdminOperate getAdminOperateByuid(User u)
{
AdminOperate ao = new AdminOperate();
string sql = string.Format("select top 1 * from FFTX_Admin_Operate where user_id = {0} order by operate_id", u.User_Id);
SqlDataReader sqldr = SqlDB.ExecuteReader(sql);
if (sqldr != null && sqldr.HasRows)
{
sqldr.Read();
ao.Admin_Id = sqldr.GetValue(1) + "";
ao.User_Id = sqldr.GetValue(2) + "";
ao.Operate_Time = sqldr.GetDateTime(3);
ao.Operate_Reason = sqldr.GetValue(4) + "";
return(ao);
}
return(null);
}
public ActionResult searchReason()
{
string uid = Request.QueryString["user_id"];
//获取被封用户详细信息
User u = new User();
u.User_Id = uid;
UserSql us = new UserSql();
u = us.getUserInfo(u);
ViewBag.blockUser = u;
//获取封号原因
AdminOperate ao = new AdminOperate();
AdminSql asl = new AdminSql();
ao = asl.getAdminOperateByuid(u);
ViewBag.operate = ao;
return(View());
}
