public IHttpActionResult editorClass(editorClassData ecd)
{
results res = new results();
string userid = new MyApi.SqlHelper().IfLogin();
if (userid == "")
{
res.result = 0;
return(Ok(res));
}
if (!new MyApi.SqlHelper().IfYouHaveAcess(-1, userid))
{
res.result = 2;//权限不够
return(Ok(res));
}
using (var db = new oucfreetalkEntities())
{
var searchName = (from it in db.postclass
where it.id == ecd.classid
select it).ToList();
if (searchName.Count == 0)
{
res.result = 4;//该板块不存在
return(Ok(res));
}
try
{
postclass ptc = db.postclass.FirstOrDefault(a => a.id == ecd.classid);
ptc.name = ecd.newname;
if (db.SaveChanges() == 0)
{
res.result = 5;//服务器错误
return(Ok(res));
}
else
{
res.result = 1;//修改成功
return(Ok(res));
}
}
catch
{
res.result = 3;//服务器错误
return(Ok(res));
}
}
}
public IHttpActionResult addClass(AddClassData acd)
{
results res = new results();
string userid = new MyApi.SqlHelper().IfLogin();
if (userid == "")
{
res.result = 0;//未登录
return(Ok(res));
}
using (var db = new oucfreetalkEntities())
{
if (!new MyApi.SqlHelper().IfYouHaveAcess(-1, userid))
{
res.result = 2;//权限不够
return(Ok(res));
}
if (new MyApi.SqlHelper().IfClassExist(acd.classname))
{
res.result = 4;//该板块已存在
return(Ok(res));
}
try
{
postclass pcs = new postclass();
pcs.name = acd.classname;
pcs.state = true;//未删除
db.postclass.Add(pcs);
if (db.SaveChanges() == 0)
{
res.result = 5;//服务器错误
return(Ok(res));
}
else
{
res.result = 1;//添加成功
return(Ok(res));
}
}
catch
{
res.result = 3;//服务器错误
return(Ok(res));
}
}
}
public IHttpActionResult deleteClass(removeClassData rcd)
{
results res = new results();
string userid = new MyApi.SqlHelper().IfLogin();
if (userid == "")
{
res.result = 0;
return(Ok(res));
}
using (var db = new oucfreetalkEntities())
{
var searchaccess = (from it in db.accountaccess
where it.classid == -1
select it).ToList();
if (searchaccess.Count == 0)
{
res.result = 2;//权限不够
return(Ok(res));
}
var searchName = (from it in db.postclass
where it.id == rcd.classid
select it).ToList();
if (searchName.Count == 0)
{
res.result = 4;//该板块不存在
return(Ok(res));
}
try
{
postclass ptc = db.postclass.FirstOrDefault(a => a.id == rcd.classid);//删除
var search_post = (from it in db.posts
where it.postclass == ptc
select it).ToList();//查找该板块的帖子
for (int i = 0; i < search_post.Count; i++)
{
var search_comm = (from it in db.postc
where it.ownpost == search_post[i].id
select it).ToList();//查找帖子的楼层
for (int j = 0; j < search_comm.Count; j++)
{
var search_reply = (from it in db.postreply
where it.ownlocation == search_comm[i].id
select it).ToList();
for (int ij = 0; ij < search_reply.Count; ij++)
{
search_reply[ij].state = false; //循环删除回复
}
search_comm[j].state = false; //循环删除楼层
}
search_post[i].state = false; //循环删除帖子
}
var search_access = (from it in db.accountaccess
where it.classid == rcd.classid
select it).ToList();
for (int i = 0; i < search_access.Count; i++)
{
db.accountaccess.Remove(search_access[i]); //循环删除版主
}
db.postclass.Remove(ptc); //删除板块
if (db.SaveChanges() == 0)
{
res.result = 5;//服务器错误
return(Ok(res));
}
else
{
res.result = 1;//成功
return(Ok(res));
}
}
catch
{
res.result = 3;//服务器错误
return(Ok(res));
}
}
}
