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; } } }