public ActionResult StaffProduction() { int[] rooms = roomControl.GetRoomsForUser(Convert.ToInt32(Session["UserID"])); string strStartDate = Common.getStartDate(Request["startDate"]), strEndDate = Common.getEndDate(Request["endDate"]); DateTime startDate = DateTime.Parse(strStartDate), endDate = DateTime.Parse(strEndDate).AddDays(1); string strSql = @"SELECT RoomName, StaffName, OrderNumber, SUM(FinishCount) AS Finish, SUM(ValidCount) AS Valid, SUM(ExceptionCount) AS Exception FROM dbo.StatisticInfoes WHERE DateOut >= {0} AND DateOut <= {1} GROUP BY RoomName, StaffName, OrderNumber"; object model = db.Database.SqlQuery <VS_StaffProduction>(strSql, startDate, endDate);; ViewData["startDate"] = strStartDate; ViewData["endDate"] = strEndDate; return(View(model)); }
// // GET: /Order/ public ActionResult Index() { int[] rooms = roomControl.GetRoomsForUser(Convert.ToInt32(Session["UserID"])); using (var t = new TransactionScope(TransactionScopeOption.Required, new TransactionOptions { IsolationLevel = System.Transactions.IsolationLevel.ReadUncommitted })) { var orders = (from item in db.Orders where rooms.Contains(item.RoomId) orderby item.Status ascending, item.OrderId descending select item).ToList(); return(View(orders)); } }
public ActionResult Create() { int userId = Convert.ToInt32(Session["UserID"]); RoomController roomControl = new RoomController(); int[] roomIds = roomControl.GetRoomsForUser(userId); IEnumerable <FactoryRoom> roomList = from item in db.FactoryRoom where roomIds.Contains(item.RoomID) select item; List <SelectListItem> roomInfos = new List <SelectListItem>(); foreach (FactoryRoom item in roomList) { roomInfos.Add(new SelectListItem { Text = string.Format("{0}({1})", item.RoomName, item.RoomNumber), Value = item.RoomID.ToString() }); } ViewData["roomList"] = roomInfos; return(View()); }
public ActionResult Index() { string machine = Request["machine"], order = Request["order"], room = Request["room"], strStartDate = Request["startDate"], strEndDate = Request["endDate"]; //设备列表 显示 int[] rooms = roomControl.GetRoomsForUser(Convert.ToInt32(Session["UserID"])); List <SelectListItem> machineSelectList = new List <SelectListItem>(); IEnumerable <Machines> machineList = from item in db.Machines where rooms.Contains(item.RoomID) select item; machineSelectList.Add(new SelectListItem() { Text = "请选择车间设备", Value = "", Selected = true }); foreach (Machines item in machineList) { machineSelectList.Add(new SelectListItem() { Text = item.Name + "(" + item.RoomName + ")", Value = item.ID.ToString(), Selected = false }); } ViewData["machines"] = machineSelectList; //整理查询条件(起止时间) DateTime dateStart, dateEnd; if (strStartDate == null || strStartDate == string.Empty) { strStartDate = DateTime.Now.AddDays(-1 * (DateTime.Now.Day - 1)).ToString(App_Start.Constants.DATE_FORMAT); } if (strEndDate == null || strEndDate == string.Empty) { strEndDate = DateTime.Now.ToString(App_Start.Constants.DATE_FORMAT); } ViewData["startDate"] = strStartDate; ViewData["endDate"] = strEndDate; dateStart = DateTime.Parse(strStartDate); dateEnd = DateTime.Parse(strEndDate).AddDays(1); int intRoom = Convert.ToInt32(room), intMachine = Convert.ToInt32(machine); //执行查询 using (var t = new TransactionScope(TransactionScopeOption.Required, new TransactionOptions { IsolationLevel = System.Transactions.IsolationLevel.ReadUncommitted })) { var schedules = (from item in db.Schedules where rooms.Contains(item.RoomId) && item.DateLastUpdate >= dateStart && item.DateLastUpdate <= dateEnd && (order == null || item.OrderNumber == order) && (room == null || item.RoomId == intRoom) && (machine == null || item.MachineId == intMachine) orderby item.Status ascending, item.DateLastUpdate descending select item).ToList(); if (schedules == null) { return(HttpNotFound()); } return(View(schedules)); } }