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));
}
}
