crazy_1892
شنبه 24 تیر 1391, 22:53 عصر
سلام دوستان این برای نمایش لیست خبر ها از کد های زیر استفاده میکنم
private AzadSysEntities db = new AzadSysEntities();
//
// GET: /NEws/
public ViewResult Index(int? Page,int? GroupId)
{
ViewBag.NewsGroup = db.Tbl_NewsGroup.ToList();
const int inPage = 3;
ViewData["inPage"] = inPage;
ViewData["GroupId"] = GroupId;
IQueryable<AZADSYSTEM.Areas.Admin.Models.Tbl_News> News;
if (GroupId != null)
{
News = db
.Tbl_News
.Where(r => r.Fld_GroupNews == GroupId)
.OrderByDescending(r=>r.Fld_Date);
}
else
{
News = db
.Tbl_News
.OrderByDescending(r => r.Fld_Date);
}
int skip = 0;
ViewData["page"] = 1;
if (Page != null)
{
skip = inPage * (Page.Value - 1);
ViewData["page"] = Page.Value;
}
ViewData["pages"] = (News.Count() / inPage) + 1;
News = News.Skip(skip).Take(inPage);
return View(News);
//var tbl_news = db.Tbl_News.Include("Tbl_admin").Include("Tbl_NewsGroup");
//return View(tbl_news.ToList());
}
//
// GET: /NEws/Details/5
public ViewResult Show(int id)
{
Tbl_News tbl_news = db.Tbl_News.Single(t => t.Fld_Id == id);
return View(tbl_news);
}
وبخش view به صورت زیر است
@model IEnumerable<AZADSYSTEM.Areas.Admin.Models.Tbl_News>
@{
ViewBag.Title = "Index";
Layout = "~/Views/Shared/_Master.cshtml";
}
@{
string js = "";
int page = (int)ViewData["page"];
int pages = (int)ViewData["pages"];
}
@foreach (var item in Model)
{
<div class="DivNewsShowList">
<div class="DivShowNewsSub">
</div>
@Html.DisplayFor(modelItem => item.Fld_Id)
<br />
@Html.DisplayFor(modelItem => item.Fld_Sub)
</div>
@Html.DisplayFor(modelItem => item.Fld_Descrip)
<div class="DivShowNewsDate">
@Html.DisplayFor(modelItem => item.Fld_Date)
</div>
<div class="DivShowNewsClick">
@Html.ActionLink("ادامه خبر", "Show", new { id = item.Fld_Id })
</div>
}
<br />
<br />
<div class="Paging">صفحه:@page از @pages
<br />
@if (page < pages)
{
<a href="@Url.Action("Index", "News", new { area = "", page = page + 1, GroupId = ViewData["GroupId"] })"><img src=@Url.Content("~/Content/Images/forward.png") alt="بعدی" title="بعدی"/></a>
}
@if(page>1)
{
<a href="@Url.Action("Index", "News", new { area = "", page = page -1, GroupId = ViewData["GroupId"] })"><img src=@Url.Content("~/Content/Images/back.png") alt="قبلی" title="قبلی"/></a>
}
</div>
<script type="text/javascript">
$(function () {
js
});
</script>
حالا من میخوام یک dropdownlist به این صفحه اضافه کنم که با یک جدول دیگه که بخش گروه بندی اخبار است رابظه داشته باشه
از partial استفاده می کنم حواب نمیده
private AzadSysEntities db = new AzadSysEntities();
//
// GET: /NEws/
public ViewResult Index(int? Page,int? GroupId)
{
ViewBag.NewsGroup = db.Tbl_NewsGroup.ToList();
const int inPage = 3;
ViewData["inPage"] = inPage;
ViewData["GroupId"] = GroupId;
IQueryable<AZADSYSTEM.Areas.Admin.Models.Tbl_News> News;
if (GroupId != null)
{
News = db
.Tbl_News
.Where(r => r.Fld_GroupNews == GroupId)
.OrderByDescending(r=>r.Fld_Date);
}
else
{
News = db
.Tbl_News
.OrderByDescending(r => r.Fld_Date);
}
int skip = 0;
ViewData["page"] = 1;
if (Page != null)
{
skip = inPage * (Page.Value - 1);
ViewData["page"] = Page.Value;
}
ViewData["pages"] = (News.Count() / inPage) + 1;
News = News.Skip(skip).Take(inPage);
return View(News);
//var tbl_news = db.Tbl_News.Include("Tbl_admin").Include("Tbl_NewsGroup");
//return View(tbl_news.ToList());
}
//
// GET: /NEws/Details/5
public ViewResult Show(int id)
{
Tbl_News tbl_news = db.Tbl_News.Single(t => t.Fld_Id == id);
return View(tbl_news);
}
وبخش view به صورت زیر است
@model IEnumerable<AZADSYSTEM.Areas.Admin.Models.Tbl_News>
@{
ViewBag.Title = "Index";
Layout = "~/Views/Shared/_Master.cshtml";
}
@{
string js = "";
int page = (int)ViewData["page"];
int pages = (int)ViewData["pages"];
}
@foreach (var item in Model)
{
<div class="DivNewsShowList">
<div class="DivShowNewsSub">
</div>
@Html.DisplayFor(modelItem => item.Fld_Id)
<br />
@Html.DisplayFor(modelItem => item.Fld_Sub)
</div>
@Html.DisplayFor(modelItem => item.Fld_Descrip)
<div class="DivShowNewsDate">
@Html.DisplayFor(modelItem => item.Fld_Date)
</div>
<div class="DivShowNewsClick">
@Html.ActionLink("ادامه خبر", "Show", new { id = item.Fld_Id })
</div>
}
<br />
<br />
<div class="Paging">صفحه:@page از @pages
<br />
@if (page < pages)
{
<a href="@Url.Action("Index", "News", new { area = "", page = page + 1, GroupId = ViewData["GroupId"] })"><img src=@Url.Content("~/Content/Images/forward.png") alt="بعدی" title="بعدی"/></a>
}
@if(page>1)
{
<a href="@Url.Action("Index", "News", new { area = "", page = page -1, GroupId = ViewData["GroupId"] })"><img src=@Url.Content("~/Content/Images/back.png") alt="قبلی" title="قبلی"/></a>
}
</div>
<script type="text/javascript">
$(function () {
js
});
</script>
حالا من میخوام یک dropdownlist به این صفحه اضافه کنم که با یک جدول دیگه که بخش گروه بندی اخبار است رابظه داشته باشه
از partial استفاده می کنم حواب نمیده