public TKS_FAS_News Get(string id)
{
var res = new TKS_FAS_News();
using (this.cnn = GetConnection())
{
try
{
string sql = @"select * from tks_fas_news where id=@Id";
var data = cnn.QueryFirstOrDefault <TKS_FAS_News>(sql, new { Id = id });
return(data);
}
catch (Exception ex)
{
throw ex;
}
}
}
public TKS_FAS_News Save(TKS_FAS_News data, string token)
{
using (cnn = GetConnection())
{
var ts = cnn.BeginTransaction();
try
{
var user = UserInfoGetButAccount(token, ts);
if (string.IsNullOrEmpty(data.id))
{
data.id = DateTime.Now.ToString("yyyyMMddHHmmssfff");
data.post_id = DateTime.Now.ToString("yyyyMMddHHmmss");
data.created_at = DateTime.Now;
//data.type = "news";
data.author_name = user.User.TrueName;
if (data.status == 1)
{
data.published_at = data.created_at;
}
cnn.Insert <TKS_FAS_News>(data, ts);
}
else
{
string sql = @"update TKS_FAS_News set
title=@Title,summary=@Summary,content=@Content,Sort=@Sort where Id=@Id";
if (data.status == 1)
{
sql = @"update TKS_FAS_News set
title=@Title,summary=@Summary,content=@Content,published_at=@published_at,Sort=@Sort where Id=@Id";
cnn.Execute(sql, new
{
Title = data.title,
Summary = data.summary,
Content = data.content,
published_at = DateTime.Now,
Id = data.id,
Sort = data.Sort
}, ts);
}
else
{
cnn.Execute(sql, new
{
Title = data.title,
Summary = data.summary,
Content = data.content,
Id = data.id,
Sort = data.Sort
}, ts);
}
}
ts.Commit();
return(data);
}
catch (Exception ex)
{
ts.Rollback();
throw ex;
}
}
}
