旧版报表、仓库
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 
 
 
 

434 lines
16 KiB

using System;
using System.Collections.Generic;
using System.Linq;
using System.Net;
using System.Net.Http;
using System.Web.Http;
using Warehouse.DAL.Order;
using OfficeOpenXml;
using System.Data;
using Warehouse.WebApi.Model;
namespace Warehouse.WebApi
{
public class OrdersController : BaseController
{
Order order = new Order();
[Route("api/Orders/ORDER")]
[HttpPost]
public IHttpActionResult ORDERS(dynamic para)
{
string OrderId = para.orderid;
var res = order.GETorder(OrderId);
var ress = order.Getworkorder(OrderId);
double b=0;
double a=0;
//res peopleList = new People(peopleArray);
//foreach (Person p in peopleList)
// Console.WriteLine(p.firstName + " " + p.lastName);! foreach (var i in res)
foreach (var j in res)
{
b=res.First().count;
}
for (int i = 0; i < ress.Count(); i++)
{
a += ress.ElementAt(i).plan_qyt;
}
double wcl = (b / a * 100);
var WCL= wcl.ToString("0.00");
//var sa = Convert.ToInt32(res.Select(a => a.count)) / Convert.ToInt32(ress.Select(a => a.planqty));
//var resss =(res.Select(a=>a.count)/ress.Select(a=>a.plan_qyt));
//return Json(res.Select(a => new { a.plan_qty}).Concat(res));
return Json(res.Concat(ress));
}
[Route("api/Orders/ORDERs")]
[HttpPost]
public IHttpActionResult qbdd(dynamic para)
{
//string workshop = string.Empty;
//if (para != null)
//{
// workshop = para.workshop;
//}
//string res = String.Format("保存成功qbdd:{0} {0:d}", para.workshop);
string workshop = para.workshop;
var res = order.QueryStockInfoByPallet(workshop);
//res peopleList = new People(peopleArray);
//foreach (Person p in peopleList)
// Console.WriteLine(p.firstName + " " + p.lastName);! foreach (var i in res)
// var sa = Convert.ToInt32(res.Select(a => a.count)) / Convert.ToInt32(ress.Select(a => a.planqty));
//var resss = (res.Select(a => a.count) / ress.Select(a => a.plan_qyt));
//return Json(res.Select(a => new { a.plan_qty }).Concat(res));
//var res =workshop;
return Json(res);
}
[Route("api/Orders/ORDERsL6")]
[HttpPost]
public IHttpActionResult Qbdd()
{
var res = order.QueryStockInfoByPalletL6();
return Json(res);
}
//查询车间
[Route("api/Orders/QueryWorkshop")]
[HttpPost]
public IHttpActionResult QueryWorkshop()
{
return Json(new { info = order.QueryWorkshop() });
}
//查询车间对应的工单
[Route("api/Orders/QueryWorkorder")]
[HttpPost]
public IHttpActionResult QueryWorkorder(dynamic para)
{
string workshop = para.workshop;
var info = order.QueryWorkorder(workshop);
return Json(new { info });
}
//查询工单对应的最终等级
[Route("api/Orders/QueryFinalGrade")]
[HttpPost]
public IHttpActionResult QueryFinalGrade(dynamic para)
{
string workorder = para.workorder;
var info = order.QueryFinalGrade(workorder);
return Json(new { info });
}
//查询工单对应的最终等级
[Route("api/Orders/QueryPowerGrade")]
[HttpPost]
public IHttpActionResult QueryPowerGrade()
{
var info = order.QueryPowerGrade();
return Json(new { info });
}
//查询车间新
[Route("api/Orders/QueryWorkshopNew")]
[HttpPost]
public IHttpActionResult QueryWorkshopNew()
{
var res = order.QueryWorkshop();
var keyList = new List<dynamic>();
keyList.Add(new
{
name = "选择车间",
id = ""
});
res.ForEach(x =>
{
keyList.Add(new
{
name = x.descriptions,
id = x.area_code
});
});
return Success(new
{
keyList
});
// return Json(new { info = order.QueryWorkshop() });
}
//查询车间机台号
[Route("api/Orders/QueryMachine")]
[HttpPost]
public IHttpActionResult QueryMachine(dynamic para)
{
dynamic areacode = para.areacode;
return Json(new { info = order.QueryMachine(areacode) });
}
//查询班次
[Route("api/Orders/QueryWorkTime")]
[HttpPost]
public IHttpActionResult QueryWorkTime()
{
return Json(new { info = order.QueryWorkTime() });
}
//查询站点机台
[Route("api/Orders/QueryMachineByStatus")]
[HttpPost]
public IHttpActionResult QueryMachineByStatus(dynamic para)
{
string processcode = para.processcode;
string areacode = para.areacode;
return Json(new { info = order.QueryMachineByStatus(processcode,areacode) });
}
//查询站点机台新
[Route("api/Orders/QueryMachineByStatusNew")]
[HttpPost]
public IHttpActionResult QueryMachineByStatusNew(QueryMachineByStatusModel model)
{
var res = order.QueryMachineByStatus(model.Station, model.WorkShop);
var keyList = new List<dynamic>();
keyList.Add(new
{
name = "选择机台",
id = ""
});
res.ForEach(x =>
{
keyList.Add(new
{
name = x.wks_desc,
id = x.wks_id
});
});
return Success(new
{
keyList
});
}
//查询车间机台号新
[Route("api/Orders/QueryMachineNew")]
[HttpPost]
public IHttpActionResult QueryMachineNew(QueryMachineModel model)
{
var res = order.QueryMachine(model.WorkShop);
var keyList = new List<dynamic>();
keyList.Add(new
{
name = "选择机台",
id = ""
});
res.ForEach(x =>
{
keyList.Add(new
{
name = x.wks_desc,
id = x.wks_id
});
});
return Success(new
{
keyList
});
}
[Route("api/Orders/StationInfos")]
[HttpPost]
public IHttpActionResult StationInfos(dynamic para)
{
string station = para.station;
string bt = para.bt;
string et = para.et;
string workshop = para.workshop;
string line = para.line;
var res = order.StationInfos(station,bt,et,workshop,line);
return Json(new { info = res });
}
[Route("api/Orders/IVtest")]
[HttpPost]
public IHttpActionResult IVtest(dynamic para)
{
string bt = para.bt;
string et = para.et;
string workshop = para.workshop;
string line = para.line;
var res = order.IVtest( bt, et, workshop, line);
return Json(new { info = res });
}
[Route("api/Orders/ELtest")]
[HttpPost]
public IHttpActionResult ELtest(dynamic para)
{
string bt = para.bt;
string et = para.et;
string workshop = para.workshop;
string line = para.line;
var res = order.ELtest(bt, et, workshop, line);
return Json(new { info = res });
}
[Route("api/Orders/Inspection")]
[HttpPost]
public IHttpActionResult Inspection(dynamic para)
{
string bt = para.bt;
string et = para.et;
string workshop = para.workshop;
string line = para.line;
var res = order.Inspection(bt, et, workshop, line);
return Json(new { info = res });
}
//插入标准产能数据
[Route("api/Orders/SiteCapacityStand")]
[HttpPost]
public IHttpActionResult SiteCapacityStand(dynamic para)
{
dynamic Stand = para.stand;
var createtime = System.DateTime.Now;
Stand.Add(System.Web.HttpContext.Current.Request.Cookies["userid"].Value);
Stand.Add(createtime.ToString());
var res = order.SiteCapacityStand(Stand);
return Json(new { result = "success" });
}
[Route("api/Orders/SearchLine")]
[HttpPost]
public IHttpActionResult SearchLine(dynamic para)
{
string workshop = para.workshop;
var res = order.SearchLine(workshop);
return Json(res);
}
[Route("api/Orders/Twohours")]
[HttpPost]
public IHttpActionResult Twohours(dynamic para)
{
string Workshop = Convert.ToString(para.workshop);
var all = order.TwohoursHJ(Workshop);
List<dynamic> weldObj = new List<dynamic>();
List<dynamic> laminationObj = new List<dynamic>();
List<dynamic> CYZDObj = new List<dynamic>();
List<dynamic> CYHJYObj = new List<dynamic>();
List<dynamic> ZKZDObj = new List<dynamic>();
List<dynamic> QXZDObj = new List<dynamic>();
List<dynamic> QJZDObj = new List<dynamic>();
List<dynamic> IVZDObj = new List<dynamic>();
List<dynamic> ELZDObj = new List<dynamic>();
//dynamic tempObj = new System.Dynamic.ExpandoObject();
//dynamic stationObj = new System.Dynamic.ExpandoObject();
foreach (var item in all)
{
//tempObj.qty = item.焊接;
//tempObj.times = item.times;
weldObj.Add(new { qty= item.,times=item.times });
//weldObj.Add(tempObj);
//tempObj.qty = item.叠层;
laminationObj.Add(new { qty = item.,times = item.times});
CYZDObj.Add(new { qty = item., times = item.times });
CYHJYObj.Add(new { qty = item., times = item.times });
ZKZDObj.Add(new { qty = item., times = item.times });
QXZDObj.Add(new { qty = item., times = item.times });
QJZDObj.Add(new { qty = item., times = item.times });
ELZDObj.Add(new { qty = item.el, times = item.times });
IVZDObj.Add(new { qty = item.iv, times = item.times });
}
List<dynamic> returnObj = new List<dynamic>();
//stationObj.station = "weld";
//stationObj.res = weldObj;
returnObj.Add(new { station = "weld",res = weldObj});//焊接
//stationObj.staiton = "lamination";
//stationObj.res = laminationObj;
returnObj.Add(new { station = "lamination",res = laminationObj});//叠层
returnObj.Add(new { station = "layup", res = CYZDObj });//层压
returnObj.Add(new { station = "inspectionafterlayup", res = CYHJYObj });//层压后检验
returnObj.Add(new { station = "frame", res = ZKZDObj });
returnObj.Add(new { station = "clean", res = QXZDObj });
returnObj.Add(new { station = "fullinspection", res = QJZDObj });
returnObj.Add(new { station = "IV", res = IVZDObj });
returnObj.Add(new { station = "EL", res = ELZDObj });
return Json(returnObj);
}
[Route("api/Orders/TwohoursLine")]
[HttpPost]
public IHttpActionResult TwohoursLine(dynamic para)
{
string Workshop = Convert.ToString(para.workshop);
string Line = Convert.ToString(para.line);
var all = order.TwohoursLine(Workshop, Line);
List<dynamic> weldObj = new List<dynamic>();
List<dynamic> laminationObj = new List<dynamic>();
List<dynamic> CYZDObj = new List<dynamic>();
List<dynamic> CYHJYObj = new List<dynamic>();
List<dynamic> ZKZDObj = new List<dynamic>();
List<dynamic> QXZDObj = new List<dynamic>();
List<dynamic> QJZDObj = new List<dynamic>();
List<dynamic> IVZDObj = new List<dynamic>();
List<dynamic> ELZDObj = new List<dynamic>();
//dynamic tempObj = new System.Dynamic.ExpandoObject();
//dynamic stationObj = new System.Dynamic.ExpandoObject();
foreach (var item in all)
{
//tempObj.qty = item.焊接;
//tempObj.times = item.times;
weldObj.Add(new { qty = item., times = item.times });
//weldObj.Add(tempObj);
//tempObj.qty = item.叠层;
laminationObj.Add(new { qty = item., times = item.times });
CYZDObj.Add(new { qty = item., times = item.times });
CYHJYObj.Add(new { qty = item., times = item.times });
ZKZDObj.Add(new { qty = item., times = item.times });
QXZDObj.Add(new { qty = item., times = item.times });
QJZDObj.Add(new { qty = item., times = item.times });
ELZDObj.Add(new { qty = item.el, times = item.times });
IVZDObj.Add(new { qty = item.iv, times = item.times });
}
List<dynamic> returnObj = new List<dynamic>();
//stationObj.station = "weld";
//stationObj.res = weldObj;
returnObj.Add(new { station = "weld", res = weldObj });//焊接
//stationObj.staiton = "lamination";
//stationObj.res = laminationObj;
returnObj.Add(new { station = "lamination", res = laminationObj });//叠层
returnObj.Add(new { station = "layup", res = CYZDObj });//层压
returnObj.Add(new { station = "inspectionafterlayup", res = CYHJYObj });//层压后检验
returnObj.Add(new { station = "frame", res = ZKZDObj });
returnObj.Add(new { station = "clean", res = QXZDObj });
returnObj.Add(new { station = "fullinspection", res = QJZDObj });
returnObj.Add(new { station = "IV", res = IVZDObj });
returnObj.Add(new { station = "EL", res = ELZDObj });
return Json(returnObj);
}
[Route("api/Orders/FoursHours")]
[HttpPost]
public IHttpActionResult FourHours(dynamic para)
{
string WorkShop = para.workshop;
string Weld = para.weld;
string Lamin = para.lamin;
string Lamination = para.lamination;
string LaminationQC = para.laminationQC;
string Frame = para.frame;
string Clean = para.clean;
string IV = para.iv;
string EL = para.el;
string Complete = para.complete;
string Pack = para.pack;
//string EndTime = para.endtime;
//string Projected_Qty = para.Projected_Qty;
//var all = order.FourHours(WorkShop,BeginTime,EndTime, Projected_Qty);
var all = order.FourHours(WorkShop,Weld, Lamin, Lamination, LaminationQC,Frame,Clean,IV,EL,Complete, Pack);
return Json(all);
}
[Route("api/Orders/QueryProvider")]
[HttpPost]
public IHttpActionResult QueryProvider()
{
return Json(new { info = order.QueryProvider() });
}
}
}