public IActionResult ShowInfo(int id)
{
//新闻信息
NewsInfoModel singleOrDefault = this.dbContext.NewsInfoModel.SingleOrDefault(item => item.Id == id);
return(View(singleOrDefault));
}
public IActionResult NewsUpdate(NewsInfoModel model)
{
NewsInfoModel newModel = base.News_Update(model);
return(Redirect("/Admin/NewsIndex"));
return(View(newModel));
}
/// <summary>
/// 编辑更新
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
protected NewsInfoModel News_Update(int?id)
{
NewsInfoModel newModel = null;
if (id > 0)
{
newModel = this.dbContext.NewsInfoModel.SingleOrDefault(item => item.Id == id);
}
return(newModel);
}
public IActionResult Modify(int?id, int type = NewsConfig.TYPE_GL)
{
NewsInfoModel newModel = base.News_Update(id);
//判断空
if (newModel == null)
{
newModel = new NewsInfoModel();
}
newModel.type = type;
return(View(newModel));
}
public IActionResult Modify(NewsInfoModel model)
{
//类型
//model.type = type;
//状态
model.state = 1;
//用户
model.username = this.User.Identity.Name;
NewsInfoModel newModel = base.News_Update(model);
return(Redirect("/News/Index?type=" + model.type.ToString()));
}
/// <summary>
/// 查询新闻
/// </summary>
/// <returns></returns>
public List <NewsInfoModel> selectNews()
{
List <NewsInfoModel> list = new List <NewsInfoModel>();
string sql = "select *from NewsInfo";
SqlDataReader reader = SqlHelper.GetSqlDataReader(sql);
while (reader.Read())
{
NewsInfoModel news = new NewsInfoModel(reader);
list.Add(news);
}
reader.Close();
return(list);
}
public NewsPageViewModel(INavigationService navigationService,
INewsService newsService,
IDialogService dialogService
) : base(navigationService, dialogService)
{
_navigationService = navigationService;
_dialogService = dialogService;
_newsService = newsService;
Title = "促销活动";
this.Load = NewsInfosLoader.Load(async() =>
{
var pending = new List <NewsInfoModel>();
var result = await _newsService.GetNewsAsync(this.ForceRefresh, new System.Threading.CancellationToken());
if (result != null)
{
var ram = new Random();
pending = result.ToList();
pending.ForEach(r =>
{
r.ViewCount = ram.Next(100, 500);
r.HeartCount = ram.Next(50, 300);
});
NewsSeries = new ObservableCollection <NewsInfoModel>(pending);
}
return(pending);
});
this.WhenAnyValue(x => x.Selecter).Throttle(TimeSpan.FromMilliseconds(500))
.Skip(1)
.Where(x => x != null)
.SubOnMainThread(async item =>
{
if (item != null)
{
//注意参数：useModalNavigation
await this.NavigateAsync($"{nameof(NewsViewerPage)}", ("newsId", item.Id));
}
this.Selecter = null;
}).DisposeWith(DeactivateWith);
this.BindBusyCommand(Load);
}
/// <summary>
/// 查询相关文章，以及置顶评论
/// </summary>
/// <param name="PKID"></param>
/// <param name="Category"></param>
/// <param name="UserId"></param>
/// <param name="IsLikeNew"></param>
/// <returns></returns>
public static NewsInfoModel SelectNewsInfo(int PKID, int Category, string UserId = "", bool IsLikeNew = false)
{
try
{
var ds = Articles.SelectNewsInfo(PKID, Category);
if (ds != null && ds.Tables.Count == 2)
{
NewsInfoModel model = new NewsInfoModel();
if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
model.CommentItems = (List <tbl_CommentModel>)Helper.ModelConvertHelper <tbl_CommentModel> .ConvertToModel(ds.Tables[0]);
if (model.CommentItems != null && model.CommentItems.Count > 0)
{
model.CommentItems.ForEach(w => w.UserName = CommentHelper.GetCommentUserName(w.UserName, 0));
}
}
else
{
model.CommentItems = null;
}
if (ds.Tables[1] != null && ds.Tables[1].Rows.Count > 0)
{
model.ArticleItems = (List <tbl_ArticleModel>)Helper.ModelConvertHelper <tbl_ArticleModel> .ConvertToModel(ds.Tables[1]);
}
else
{
model.ArticleItems = null;
}
return(model);
}
return(null);
}
catch (Exception ex) { return(null); }
}
/// <summary>
/// 提交更新
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
protected NewsInfoModel News_Update(NewsInfoModel model)
{
NewsInfoModel newModel;
//编辑
if (model.Id > 0)
{
newModel = this.dbContext.NewsInfoModel.SingleOrDefault(item => item.Id == model.Id);
}
else//添加
{
newModel = new NewsInfoModel();
newModel.AddTime = DateTime.Now;
}
//赋值
newModel.name = model.name;
newModel.contents = model.contents;
newModel.type = model.type;
newModel.state = model.state;
newModel.Rank = model.Rank;
newModel.username = model.username;
//newModel.name = model.name;
//保存
if (model.Id > 0)
{
this.dbContext.NewsInfoModel.Update(newModel);
}
else
{
this.dbContext.NewsInfoModel.Add(newModel);
}
this.dbContext.SaveChanges();
return(newModel);
}
public IActionResult NewsUpdate(int?id)
{
NewsInfoModel newModel = base.News_Update(id);
return(View(newModel));
}
