public ActionResult addTitle(TitleExt model)
{
if (model != null)
{
reflectModel.setValues(model);
int res = 0;
DateTime dt = DateTime.Now;
try
{
var u = (user)Session["user"];
title t = new title()
{
uid = u.id, addtime = dt, art_title = model.art_title, keywords = model.keywords, state = 1, sort = 100, top = false
};
TransactionOptions transOpt = new TransactionOptions();
//设置事务隔离级别
transOpt.IsolationLevel = IsolationLevel.ReadCommitted;
// 设置事务超时时间为60秒
transOpt.Timeout = new TimeSpan(0, 0, 60);
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, transOpt))
{
using (WeiQingEntities db = new WeiQingEntities())
{
db.title.Add(t);
res = db.SaveChanges(); // 保存帖子标题
if (res > 0)
{
var tid = db.title.Where(x => x.uid == u.id).Max(x => x.id);
tiezi tz = new tiezi()
{
tid = tid, addtime = dt, uid = u.id, content = model.content, floor = 1, state = 1, uname = u.nick_name
};
db.tiezi.Add(tz);
res = db.SaveChanges(); // 保存帖子的内容,一楼
if (res > 0)
{
scope.Complete();
return(Content(res.ToString()));
}
}
}
}
}
catch (Exception ex)
{
return(Content(ex.Message));
}
}
return(Content("0"));
}
public ActionResult huitie(tiezi model)
{
if (model != null && model.tid > 0 && model.content != null && model.content.Length > 0)
{
model.addtime = DateTime.Now;
var user = (user)Session["user"];
model.uid = user.id;
model.state = 1;
model.uname = user.nick_name;
// 获取楼层
using (WeiQingEntities db = new WeiQingEntities())
{
var floor = db.tiezi.Where(x => x.tid == model.tid).Max(x => x.floor);
model.floor = floor + 1; // 当前楼层加1
db.tiezi.Add(model);
return(Content(db.SaveChanges().ToString()));
}
}
return(Content("-1"));
}
