public ActionResult ManPowergive()
{
ManPowerGroupViewModel mpgvm = new ManPowerGroupViewModel();
mpgvm.ManPower = new List <ManPowersViewModel>();
mpgvm.ManPowerClass = new List <ManPowersClassViewModel>();
var q = (from o in db.Cases
join g in db.ManPower on o.CaseID equals g.CaseID
where o.StatusID == 8
orderby g.MPID descending
select g).ToList();
foreach (ManPower mp in q)
{
ManPowersViewModel mpvm = new ManPowersViewModel()
{
CaseID = mp.CaseID,
MPName = mp.MPName,
MemberID = mp.Cases.MemberID,
MPNeedCount = mp.MPNeedCount,
MPActuralCount = mp.MPActuralCount,
NickName = mp.Cases.Member.NickName,
StatusName = db.CaseStatus.Find(db.Cases.Find(mp.CaseID).StatusID).StatusName,
CaseTitle = mp.Cases.CaseTitle,
MPClass1 = mp.MPSubClass.MPClass.MPClass1
};
mpgvm.ManPower.Add(mpvm);
}
IQueryable <string> gc = db.MPClass.Select(x => x.MPClass1).Distinct();
foreach (string GCdb in gc)
{
ManPowersClassViewModel mpcvm = new ManPowersClassViewModel();
mpcvm.MPClass1 = GCdb;
mpgvm.ManPowerClass.Add(mpcvm);
}
return(View(mpgvm));
}
public ActionResult ManPowerAll()
{
ManPowerGroupViewModel mpgvm = new ManPowerGroupViewModel();
mpgvm.ManPower = new List <ManPowersViewModel>();
mpgvm.ManPowerClass = new List <ManPowersClassViewModel>();
//List<ManPowersViewModel> caseall = new List<ManPowersViewModel>();
////挑選人力分享案件
//var cas = db.Cases.Where(p => p.StatusID == 8).ToList();
//List<int> items=new List<int>();
//foreach(var a in cas)
//{
// items.Add(a.CaseID);
//}
//int len = items.Count();
//List<ManPower> man = new List<ManPower>();
//for(int i=0;i<len;i++)
//{
// int t = items[i];
// var qwe= db.ManPower.Where(o => o.CaseID == t).First();
// man.Add(qwe);
//}
////人力分享案件數量
//ViewBag.give= man.Count();
////挑選人力需求案件
//var ncas = db.Cases.Where(p => p.StatusID == 7).ToList();
//List<int> nitems = new List<int>();
//foreach (var a in ncas)
//{
// nitems.Add(a.CaseID);
//}
//int nlen = nitems.Count();
//List<ManPower> nman = new List<ManPower>();
//for (int i = 0; i < nlen; i++)
//{
// int t = nitems[i];
// var qwe = db.ManPower.Where(o => o.CaseID == t).First();
// nman.Add(qwe);
//}
////人力需求案件數量
//ViewBag.need =nman.Count();
foreach (ManPower mp in db.ManPower.Where(o => o.MPActuralCount < o.MPNeedCount).OrderByDescending(o => o.MPID).ToList())
{
ManPowersViewModel mpvm = new ManPowersViewModel()
{
CaseID = mp.CaseID,
MPName = mp.MPName,
MemberID = mp.Cases.MemberID,
MPNeedCount = mp.MPNeedCount,
MPActuralCount = mp.MPActuralCount,
NickName = mp.Cases.Member.NickName,
StatusName = db.CaseStatus.Find(db.Cases.Find(mp.CaseID).StatusID).StatusName,
CaseTitle = mp.Cases.CaseTitle,
MPClass1 = mp.MPSubClass.MPClass.MPClass1
};
mpgvm.ManPower.Add(mpvm);
}
#region
//foreach (ManPower mp in (ManPowerDB.GetAll()).ToList())
//{
// ManPowersViewModel mpvm = new ManPowersViewModel()
// {
// CaseID = mp.CaseID,
// MPName = mp.MPName,
// MemberID = mp.Cases.MemberID,
// MPNeedCount = mp.MPNeedCount,
// MPActuralCount = mp.MPActuralCount,
// NickName = mp.Cases.Member.NickName,
// StatusName = db.CaseStatus.Find(db.Cases.Find(mp.CaseID).StatusID).StatusName,
// CaseTitle = mp.Cases.CaseTitle,
// MPClass1 = "全部案件"
// };
// mpgvm.ManPower.Add(mpvm);
// caseall.Add(mpvm);
//}
//ViewBag.allcase = caseall;
////總案件
//ViewBag.all = ViewBag.give+ ViewBag.need;
////把類別加進去人力分享案件內
//foreach (var q in man)
//{
// ManPowersViewModel mpvmm = new ManPowersViewModel()
// {
// CaseID = q.CaseID,
// MPName = q.MPName,
// MemberID = q.Cases.MemberID,
// MPNeedCount = q.MPNeedCount,
// MPActuralCount = q.MPActuralCount,
// NickName = q.Cases.Member.NickName,
// StatusName = db.CaseStatus.Find(db.Cases.Find(q.CaseID).StatusID).StatusName,
// CaseTitle = q.Cases.CaseTitle,
// MPClass1 = "人力分享"
// };
// mpgvm.ManPower.Add(mpvmm);
//}
////類別加進去人力需求案件內
//foreach (var q in nman)
//{
// ManPowersViewModel mpvmm = new ManPowersViewModel()
// {
// CaseID = q.CaseID,
// MPName = q.MPName,
// MemberID = q.Cases.MemberID,
// MPNeedCount = q.MPNeedCount,
// MPActuralCount = q.MPActuralCount,
// NickName = q.Cases.Member.NickName,
// StatusName = db.CaseStatus.Find(db.Cases.Find(q.CaseID).StatusID).StatusName,
// CaseTitle = q.Cases.CaseTitle,
// MPClass1 = "人力需求"
// };
// mpgvm.ManPower.Add(mpvmm);
//}
#endregion
IQueryable <string> gc = db.MPClass.Select(x => x.MPClass1).Distinct();
foreach (string GCdb in gc)
{
ManPowersClassViewModel mpcvm = new ManPowersClassViewModel();
mpcvm.MPClass1 = GCdb;
mpgvm.ManPowerClass.Add(mpcvm);
}
return(View(mpgvm));
}
