public ActionResult CountWoReq()
{
OrderReqDAC woreq = new OrderReqDAC();
ViewBag.CountWoReq = woreq.GetReqTotalCount();
return(PartialView());
}
// GET: Home
public ActionResult Index()
{
//작업지시별 불량률 확인 하고 리스트로 뿌려준다.
JobOrderDAC jobOrder = new JobOrderDAC();
JobOrderListView jobordermodel = new JobOrderListView // 작업지시 view만들고
{
JobOrders = jobOrder.GetWorkOrderFive(), // 진행중인 작업지시 조회
};
PrdUnitListView prdUnitmodel = new PrdUnitListView //
{
PrdUnits = jobOrder.GetUnitCount() //
};
ViewBag.Badrate = string.Format("{0:0.0}", jobOrder.GetBadrate()); // 불량률 뷰백
ViewBag.TotalmonthWOJS = jobOrder.GetWorkOrderTotalCount_month("제선");
ViewBag.TotalmonthWOJK = jobOrder.GetWorkOrderTotalCount_month("제강");
ViewBag.TotalmonthWOAY = jobOrder.GetWorkOrderTotalCount_month("압연");
ViewBag.TotalmonthWOJJ = jobOrder.GetWorkOrderTotalCount_month("적재");
ViewBag.TotalmonthWOPJ = jobOrder.GetWorkOrderTotalCount_month("포장");
//이번달 전체작업지시 뷰백
ViewBag.FinishmonthWOJS = jobOrder.GetWorkOrderFinishCount_month("제선");
ViewBag.FinishmonthWOJK = jobOrder.GetWorkOrderFinishCount_month("제강");
ViewBag.FinishmonthWOAY = jobOrder.GetWorkOrderFinishCount_month("압연");
ViewBag.FinishmonthWOJJ = jobOrder.GetWorkOrderFinishCount_month("적재");
ViewBag.FinishmonthWOPJ = jobOrder.GetWorkOrderFinishCount_month("포장");
//이번달 작업완료 뷰백
ViewBag.FinishtodayWOJS = jobOrder.GetWorkOrderFinishCount_today("제선");
ViewBag.FinishtodayWOJK = jobOrder.GetWorkOrderFinishCount_today("제강");
ViewBag.FinishtodayWOAY = jobOrder.GetWorkOrderFinishCount_today("압연");
ViewBag.FinishtodayWOJJ = jobOrder.GetWorkOrderFinishCount_today("적재");
ViewBag.FinishtodayWOPJ = jobOrder.GetWorkOrderFinishCount_today("포장");
//금일작업완료 뷰백
ViewBag.FinishWOJS = jobOrder.GetWorkOrderFinishCount("제선");
ViewBag.FinishWOJK = jobOrder.GetWorkOrderFinishCount("제강");
ViewBag.FinishWOAY = jobOrder.GetWorkOrderFinishCount("압연");
ViewBag.FinishWOJJ = jobOrder.GetWorkOrderFinishCount("적재");
ViewBag.FinishWOPJ = jobOrder.GetWorkOrderFinishCount("포장");
//누적작업완료 뷰백
ViewBag.TopFive = jobordermodel;
//작업지시 뷰백
ProductDAC workcenter = new ProductDAC();
ProductListView workcentermodel = new ProductListView
{
Products = workcenter.GetList(1, 10, null),
PagingInfo = new PagingInfo
{
CurrentPage = 1,
ItemsPerPage = 5,
TotalItems = workcenter.GetWorkCenterTotalCount(null)
},
CurrentCategory = null
};
ViewBag.TotalWCJS = workcenter.GetWorkCenterTotalCount("제선");
ViewBag.TotalWCJK = workcenter.GetWorkCenterTotalCount("제강");
ViewBag.TotalWCAY = workcenter.GetWorkCenterTotalCount("압연");
ViewBag.TotalWCJJ = workcenter.GetWorkCenterTotalCount("적재");
ViewBag.TotalWCPJ = workcenter.GetWorkCenterTotalCount("포장");
//전체 작업장수 뷰백
ViewBag.StoppingWCJS = workcenter.GetWorkCenterCountStop("제선");
ViewBag.StoppingWCJK = workcenter.GetWorkCenterCountStop("제강");
ViewBag.StoppingWCAY = workcenter.GetWorkCenterCountStop("압연");
ViewBag.StoppingWCJJ = workcenter.GetWorkCenterCountStop("적재");
ViewBag.StoppingWCPJ = workcenter.GetWorkCenterCountStop("포장");
//멈춘 작업장수 뷰백
ViewBag.WorkOrderList = workcentermodel; // 작업장 뷰백
OrderReqDAC woreq = new OrderReqDAC();
WoReqListView woreqmodel = new WoReqListView
{
WoReqs = woreq.GetWoReqTen()
};
ViewBag.WoReqList = woreqmodel; // 생산의뢰 뷰백
ViewBag.WoReqCount = woreq.GetReqTotalCount(); //누적 생산의뢰 뷰백
ViewBag.WoReqCountToday = woreq.GetReqTotalCount_Today(); //금일 생산의뢰 뷰백
MemberDAC memcnt = new MemberDAC();
MemcntListView memcntmodel = new MemcntListView
{
Members = memcnt.GetWorkerCount()
};
ViewBag.memcnt = memcntmodel;
//직책별 카운트 뷰백
ViewBag.gn1 = memcntmodel.Members[0].UserGroup_Name;
ViewBag.gn1cnt = memcntmodel.Members[0].UserCnt;
ViewBag.gn2 = memcntmodel.Members[1].UserGroup_Name;
ViewBag.gn2cnt = memcntmodel.Members[1].UserCnt;
ViewBag.gn3 = memcntmodel.Members[2].UserGroup_Name;
ViewBag.gn3cnt = memcntmodel.Members[2].UserCnt;
//직책별 차트데이터 뷰백
ViewBag.WorkTimeAVG = memcnt.GetWorkTimeAVG();
return(View());
}
