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