//
// GET: /TargetMission/
public ActionResult Index(int year = 0, int TID = 0)
{
// 按照年份显示
if (year == 0)
{
year = DateTime.Now.Year;
}
//var ls = dbContext.Database.SqlQuery<TargetMissionQuery>("select tm.TMID, tm.TID, tm.PersonName, tm.Mission, tm.TargetPoint, t.TargetName from TargetMissions tm left join Targets t on tm.TID = t.TID where t.TargetYear = @p0", year);
var ls = from tm in dbContext.TargetMissions
join t in dbContext.Targets
on tm.TID equals t.TID
select new TargetMissionQuery
{
TMID = tm.TMID,
TID = tm.TID,
PersonID = tm.PersonID,
SidePerson = tm.SidePerson,
Mission = tm.Mission,
Stat = tm.Stat,
TargetName = t.TargetName,
TargetYear = t.TargetYear
};
// TID和year只能有一个有效
if (TID != 0)
{
ls = ls.Where(a => a.TID == TID);
}
else
{
ls = ls.Where(a => a.TargetYear == year);
}
// Admin：显示所有任务
// 本人：自己主办和协办的任务
List<TargetMissionQuery> hostLs = null;
List<TargetMissionQuery> sideLs = null;
List<TargetMissionPoint> pointLs = new List<TargetMissionPoint>();
if (!this.IsAdminNow())
{
User u = this.GetSessionCurrentUser();
hostLs = ls.Where(a => a.PersonID == u.UID).ToList();
sideLs = ls.Where(a => a.SidePerson.Contains(u.Realname)).ToList();
}
else
{
hostLs = ls.ToList();
}
TargetMissionResult result = new TargetMissionResult();
result.HostLs = hostLs;
result.SideLs = sideLs;
ViewBag.year = year;
ViewBag.IsAdmin = this.IsAdminNow();
return View(result);
}
//
// GET: /TargetMission/
public ActionResult Index(int year = 0, int TID = 0)
{
if (this.GetSessionCurrentUser() == null)
{
return(RedirectToAction("Login", "User", new { ReturnUrl = "/TargetMission" }));
}
// 按照年份显示
if (year == 0)
{
year = DateTime.Now.Year;
}
//var ls = dbContext.Database.SqlQuery<TargetMissionQuery>("select tm.TMID, tm.TID, tm.PersonName, tm.Mission, tm.TargetPoint, t.TargetName from TargetMissions tm left join Targets t on tm.TID = t.TID where t.TargetYear = @p0", year);
var ls = from tm in dbContext.TargetMissions
join t in dbContext.Targets
on tm.TID equals t.TID
select new TargetMissionQuery
{
TMID = tm.TMID,
TID = tm.TID,
PersonID = tm.PersonID,
SidePerson = tm.SidePerson,
Mission = tm.Mission,
Stat = tm.Stat,
TargetName = t.TargetName,
TargetYear = t.TargetYear
};
// TID和year只能有一个有效
if (TID != 0)
{
ls = ls.Where(a => a.TID == TID);
}
else
{
ls = ls.Where(a => a.TargetYear == year);
}
// Admin：显示所有任务
// 本人：自己主办和协办的任务
List <TargetMissionQuery> hostLs = null;
List <TargetMissionQuery> sideLs = null;
List <TargetMissionPoint> pointLs = new List <TargetMissionPoint>();
if (!this.IsAdminNow())
{
User u = this.GetSessionCurrentUser();
hostLs = ls.Where(a => a.PersonID == u.UID).ToList();
sideLs = ls.Where(a => a.SidePerson.Contains(u.Realname)).ToList();
}
else
{
hostLs = ls.ToList();
}
TargetMissionResult result = new TargetMissionResult();
result.HostLs = hostLs;
result.SideLs = sideLs;
ViewBag.year = year;
ViewBag.IsAdmin = this.IsAdminNow();
return(View(result));
}
