public ActionResult Index()
{
SNewsModel SModels = new SNewsModel();
SModels.TypeDroList = NSer.GetNewTypeDrolist(SModels.TypeId);
return(View(SModels));
}
public List <NewsModel> GetWebPageList(SNewsModel SModel, int Type)
{
using (var db = new HTJKEntities())
{
var List = (from p in db.A_News.Where(k => k.State == true && k.CheckedStatus == 1 && k.A_NewsType.Type == Type)
where !string.IsNullOrEmpty(SModel.Name) ? p.Name.Contains(SModel.Name) : true
where SModel.TypeId > 0 ? p.TypeId == SModel.TypeId : true
orderby p.CreateTime descending
select new NewsModel
{
Id = p.Id,
Name = p.Name,
TypeId = p.TypeId,
TypeName = p.A_NewsType.Name,
Remarks = p.Remarks,
CreateTime = p.CreateTime,
HitTimes = p.HitTimes,
ConvertImg = p.ConvertPic,
EidtAuthorName = p.EidtName,
CheckedStatus = p.CheckedStatus,
UpTime = p.UpTime,
SalePrice = p.SalePrices
}).Skip(SModel.PageSize * SModel.PageIndex).Take(SModel.PageSize).ToList();
return(List);
}
}
public ActionResult PageList(SNewsModel SModel, int?Type, int?PageSize)
{
SModel.PageSize = PageSize ?? 9;
var models = NSer.GetWebPageList(SModel, Type ?? 2);
return(View(models));
}
public List <NewsModel> GetPageList(SNewsModel SModel)
{
try { return(IDal.GetPageList(SModel)); }
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public List <NewsModel> GetNewsTypeList(SNewsModel SModel, int Type)
{
try { return(IDal.GetNewsTypeList(SModel, Type)); }
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
//用户自己的内容
public ActionResult UserIndex()
{
SNewsModel SModels = new SNewsModel();
SModels.UploadAuthorId = GetUser().Id;
SModels.TypeDroList = NSer.GetNewTypeDrolist(SModels.TypeId);
return(View(SModels));
}
public ActionResult PageList(SNewsModel SRmodels)
{
var PageList = NSer.GetPageList(SRmodels);
return(new ContentResult
{
Content = new JavaScriptSerializer {
MaxJsonLength = Int32.MaxValue
}.Serialize(PageList),
ContentType = "application/json"
});
}
public List <NewsModel> GetPageList(SNewsModel SModel)
{
DateTime StartTime = Convert.ToDateTime("1900-01-01");
DateTime EndTime = Convert.ToDateTime("2900-12-30");
if (!string.IsNullOrEmpty(SModel.StartTime))
{
StartTime = Convert.ToDateTime(SModel.StartTime);
}
if (!string.IsNullOrEmpty(SModel.EndTime))
{
EndTime = Convert.ToDateTime(SModel.EndTime);
}
using (var db = new HTJKEntities())
{
var List = (from p in db.A_News.Where(k => k.State == true)
where !string.IsNullOrEmpty(SModel.Name) ? p.Name.Contains(SModel.Name) : true
where SModel.TypeId != null && SModel.TypeId > 0 ? p.TypeId == SModel.TypeId : true
where SModel.CheckedStatus >= 0 ? p.CheckedStatus == SModel.CheckedStatus : true
where SModel.UploadAuthorId > 0 ? p.UploadAuthorId == SModel.UploadAuthorId : true
where p.CreateTime >= StartTime
where p.CreateTime < EndTime
orderby p.CreateTime descending
select new NewsModel
{
Id = p.Id,
Name = p.Name,
TypeId = p.TypeId,
TypeName = p.A_NewsType.Name,
Remarks = p.Remarks,
CreateTime = p.CreateTime,
HitTimes = p.HitTimes,
UploadName = p.UploadName,
EidtAuthorName = p.EidtName,
CheckedStatus = p.CheckedStatus,
}).ToList();
return(List);
}
}
