public void ProcessRequest(HttpContext context)
{
var projectName = context.Request.Form["projectName"];
using (JDJS_WMS_DB_USEREntities entities = new JDJS_WMS_DB_USEREntities()) {
var row = from order in entities.JDJS_WMS_Order_Entry_Table.Where(r => r.ProjectName == projectName)
from guide in entities.JDJS_WMS_Order_Guide_Schedu_Table
where order.Order_ID == guide.OrderID
select new
{
order.Order_Leader,
guide.ClientName
};
if (row.Count() > 0)
{
var model = new { Order_Leader = row.First().Order_Leader, clientName = row.First().ClientName };
var json = ser.Serialize(model);
context.Response.Write(json);
}
else
{
var model = new { Order_Leader = "", clientName = "" };
var json = ser.Serialize(model);
context.Response.Write(json);
}
}
}
public void ProcessRequest(HttpContext context)
{
try
{
var orderId = int.Parse(context.Request.Form["orderId"]);
var time = Convert.ToDateTime(context.Request.Form["time"]);
var loginID = Convert.ToInt32(context.Session["id"]);
using (JDJS_WMS_DB_USEREntities wms = new JDJS_WMS_DB_USEREntities())
{
var order = wms.JDJS_WMS_Order_Machine_Scheduing_Time_Table.Where(r => r.OrderID == orderId).FirstOrDefault();
if (order == null)
{
JDJS_WMS_Order_Machine_Scheduing_Time_Table jd = new JDJS_WMS_Order_Machine_Scheduing_Time_Table()
{
OrderID = orderId,
PlanPersonID = loginID,
PlanEndTime = time
};
wms.JDJS_WMS_Order_Machine_Scheduing_Time_Table.Add(jd);
}
else
{
order.PlanEndTime = time;
order.PlanPersonID = loginID;
}
wms.SaveChanges();
}
context.Response.Write("ok");
}
catch (Exception ex)
{
context.Response.Write(ex.Message);
}
}
public void ProcessRequest(HttpContext context)
{
System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
using (JDJS_WMS_DB_USEREntities entities = new JDJS_WMS_DB_USEREntities())
{
//var rows = from orderQueue in entities.JDJS_WMS_Order_Queue_Table
// from orderNumber in entities.JDJS_WMS_Order_Entry_Table
// from process in entities.JDJS_WMS_Order_Process_Info_Table
// where orderQueue.OrderID == orderNumber.Order_ID & process.toolPreparation != -1 & orderNumber.Order_ID == process.OrderID
// select new
// {
// orderNumber.Order_Number,
// orderNumber.Order_ID
// };
var rows =
from orderNumber in entities.JDJS_WMS_Order_Entry_Table
from process in entities.JDJS_WMS_Order_Process_Info_Table
where orderNumber.Order_ID == process.OrderID
select new
{
orderNumber.Order_Number,
orderNumber.Order_ID
};
if (rows.Count() > 0)
{
var json = serializer.Serialize(rows);
context.Response.Write(json);
}
}
}
public void ProcessRequest(HttpContext context)
{
using (JDJS_WMS_DB_USEREntities entities = new JDJS_WMS_DB_USEREntities())
{
using (System.Data.Entity.DbContextTransaction db = entities.Database.BeginTransaction())
{
try
{
var form = context.Request.Form;
for (int i = 0; i < form.Count; i++)
{
var id = int.Parse(form[i]);
var row = entities.JDJS_WMS_Quality_ManualInput_Measurement_Table.Where(r => r.ID == id);
if (row.Count() > 0)
{
entities.JDJS_WMS_Quality_ManualInput_Measurement_Table.Remove(row.FirstOrDefault());
}
}
entities.SaveChanges();
db.Commit();
context.Response.Write("ok");
}
catch (Exception ex)
{
db.Rollback();
context.Response.Write(ex.Message);
}
}
}
}
public void ProcessRequest(HttpContext context)
{
var id = context.Request["id"];
int PlanID = int.Parse(id);
using (JDJS_WMS_DB_USEREntities JDJS_WMS_Device_Info = new JDJS_WMS_DB_USEREntities())
{
var plan = from planm in JDJS_WMS_Device_Info.JDJS_WMS_Maintenance_Plan_Table
where planm.ID == PlanID
select new
{
planm.MaintenanceContence,
planm.MaintenanceTime,
planm.isFlag,
planm.CncID,
planm.TimeStr,
planm.ID,
planm.MaintenanceName
};
System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
var jsonplan = new { MaintenanceContence = plan.First().MaintenanceContence,
MaintenanceTime = plan.First().MaintenanceTime.ToString().Replace('/', '-'),
CncID = plan.First().CncID, Cycle = plan.First().TimeStr.Substring(0, plan.First().TimeStr.Length - 1),
Format = plan.First().TimeStr.Substring(plan.First().TimeStr.Length - 1),
id = plan.FirstOrDefault().ID,
MaintenanceName = plan.FirstOrDefault().MaintenanceName };
var json = serializer.Serialize(jsonplan);
context.Response.Write(json);
}
}
public void ProcessRequest(HttpContext context)
{
int LocationID = int.Parse(context.Request["workId"]);
int FixingNum = 0;
int FixOverWaitConfirmNum = 0;
using (JDJS_WMS_DB_USEREntities wms = new JDJS_WMS_DB_USEREntities())
{
var Status11Code = wms.JDJS_WMS_Device_Maintenance_Status.Where(r => r.DescID == 11).First();
var Status14Code = wms.JDJS_WMS_Device_Maintenance_Status.Where(r => r.DescID == 14).First();
var Status16Code = wms.JDJS_WMS_Device_Maintenance_Status.Where(r => r.DescID == 16).First();
var Status19Code = wms.JDJS_WMS_Device_Maintenance_Status.Where(r => r.DescID == 19).First();
var Status1Code = wms.JDJS_WMS_Device_Maintenance_Status.Where(r => r.DescID == 1).First();
var Status0Code = wms.JDJS_WMS_Device_Maintenance_Status.Where(r => r.DescID == 0).First();
var devices = wms.JDJS_WMS_Device_Info.Where(r => r.Position == LocationID);
foreach (var item in devices)
{
int cncID = Convert.ToInt32(item.ID);
var repairInfo = wms.JDJS_WMS_Device_Alarm_Repair.Where(r => r.CncID == cncID && r.AlarmStateID != Status0Code.ID && r.AlarmStateID != Status19Code.ID);
if (repairInfo.Count() > 0)
{
FixingNum++;
}
var repairConfirm = wms.JDJS_WMS_Device_Alarm_Repair.Where(r => r.CncID == cncID && r.AlarmStateID == Status19Code.ID);
if (repairConfirm.Count() > 0)
{
FixOverWaitConfirmNum++;
}
}
}
var json = (FixingNum.ToString() + ',' + FixOverWaitConfirmNum.ToString());
context.Response.Write("data:" + json + "\n\n");
context.Response.ContentType = "text/event-stream";
}
public void ProcessRequest(HttpContext context)
{
// "id":11,
//"name":"Java",
//"size":"",
//"date":"01/13/2010",
var cncType = context.Request["cncType"];
context.Response.ContentType = "text/plain";
List <NodeJson> jsons = new List <NodeJson>();
System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
using (JDJS_WMS_DB_USEREntities JDJS_WMS_Device_Info = new JDJS_WMS_DB_USEREntities())
{
var TypeID = JDJS_WMS_Device_Info.JDJS_WMS_Device_Type_Info.Where(r => r.Type == cncType).FirstOrDefault();
if (TypeID != null)
{
AddNodes(jsons, JDJS_WMS_Device_Info.JDJS_WMS_Location_Info.ToList(), JDJS_WMS_Device_Info.JDJS_WMS_Device_Info.Where(r => r.MachType == TypeID.ID).ToList(), JDJS_WMS_Device_Info.JDJS_WMS_Tool_LifeTime_Management.ToList(), cncType);;
}
}
//NodeState(jsons);
for (int i = 0; i < jsons.Count(); i++)
{
if (jsons[i].children.Count() > 1)
{
jsons[i].children = paixu(jsons[i].children);
}
}
string json = serializer.Serialize(jsons);
context.Response.Write(json);
}
public void ProcessRequest(HttpContext context)
{
//y语音播报
string VoiceStr = "";
using (JDJS_WMS_DB_USEREntities wms = new JDJS_WMS_DB_USEREntities())
{
var Status11Code = wms.JDJS_WMS_Device_Maintenance_Status.Where(r => r.DescID == 11).First();
var Status14Code = wms.JDJS_WMS_Device_Maintenance_Status.Where(r => r.DescID == 14).First();
var Status16Code = wms.JDJS_WMS_Device_Maintenance_Status.Where(r => r.DescID == 16).First();
var Status19Code = wms.JDJS_WMS_Device_Maintenance_Status.Where(r => r.DescID == 19).First();
var Status1Code = wms.JDJS_WMS_Device_Maintenance_Status.Where(r => r.DescID == 1).First();
var Status0Code = wms.JDJS_WMS_Device_Maintenance_Status.Where(r => r.DescID == 0).First();
var devices = wms.JDJS_WMS_Device_Info.ToList();
foreach (var item in devices)
{
int cncID = item.ID;
string cncNum = item.MachNum;
var alarmInfo = wms.JDJS_WMS_Device_Alarm_Repair.Where(r => r.CncID == cncID && r.AlarmStateID == Status19Code.ID);
if (alarmInfo.Count() > 0)
{
VoiceStr += (cncNum + "机床维修完成，请尽快确认");
}
}
}
VoiceStr = VoiceStr.Replace("-", "杠").Replace("#", "号");
context.Response.Write(VoiceStr);
}
public void ProcessRequest(HttpContext context)
{
List <int> id = new List <int>();
var ordernum = context.Request["orderNumber"];
using (JDJS_WMS_DB_USEREntities jdjs = new JDJS_WMS_DB_USEREntities())
{
int orderId = 0;;
var order = jdjs.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == ordernum);
if (order.Count() > 0)
{
orderId = order.First().Order_ID;
}
var Data = jdjs.JDJS_WMS_Quality_Onmachine_Measurement_Data.Where(r => r.OrderID == orderId);
foreach (var item in Data)
{
if (id.Contains(Convert.ToInt32(item.SerialNumber)))
{
}
else
{
id.Add(Convert.ToInt32(item.SerialNumber));
}
}
}
System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
var json = serializer.Serialize(id);
context.Response.Write(json);
}
public void ProcessRequest(HttpContext context)
{
好的 = "1";
{
List <string> ProcessTable = new List <string>();
List <int> id = new List <int>();
int max = -1;
using (JDJS_WMS_DB_USEREntities wms = new JDJS_WMS_DB_USEREntities())
{
var processs = wms.JDJS_WMS_Order_Process_Info_Table.Where(r => r.sign != 0);
foreach (var item in processs)
{
if (!id.Contains(Convert.ToInt32(item.ProcessID)))
{
id.Add(Convert.ToInt32(item.ProcessID));
}
}
max = id.Max();
}
for (int i = 1; i <= max; i++)
{
ProcessTable.Add("工序" + i.ToString());
}
for (int i = 0; i < ProcessTable.Count(); i++)
{
ProcessTable[i] = ProcessTable[i].Replace('1', '一').Replace('2', '二').Replace('3', '三').Replace('4', '四').Replace('5', '五').Replace('6', '六').Replace('7', '七').Replace('8', '八').Replace('9', '九').Replace('0', '零');
}
System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
var json = serializer.Serialize(ProcessTable);
context.Response.Write(json);
}
}
public void ProcessRequest(HttpContext context)
{
try
{
int id = int.Parse(context.Request["id"]);//处理的申请主键ID
var files = context.Request.Files;
string path = "";
using (JDJS_WMS_DB_USEREntities wms = new JDJS_WMS_DB_USEREntities())
{
var inspect = wms.JDJS_WMS_Quality_Apply_Measure_Table.Where(r => r.ID == id).FirstOrDefault();
if (inspect == null)
{
context.Response.Write("该送检申请不存在，请确认后再试！");
return;
}
path = inspect.SavePath;
}
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
for (int i = 0; i < files.Count; i++)
{
files[i].SaveAs(path + "//" + files[i].FileName);
}
context.Response.Write("ok");
}
catch (Exception ex)
{
context.Response.Write(ex.Message);
return;
}
}
public void ProcessRequest(HttpContext context)
{
List <string> str = new List <string>();
List <string> names = new List <string>();
using (JDJS_WMS_DB_USEREntities wms = new JDJS_WMS_DB_USEREntities())
{
var desc = wms.JDJS_WMS_Maintenance_Plan_Table.ToList();
foreach (var item in desc)
{
if (!str.Contains(item.MaintenanceContence))
{
str.Add(item.MaintenanceContence);
}
if (!names.Contains(item.MaintenanceName))
{
names.Add(item.MaintenanceName);
}
}
}
System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
var json = serializer.Serialize(new { name = names, content = str });
context.Response.Write(json);
}
public void ProcessRequest(HttpContext context)
{
//机外测量异常
List <string> infos = new List <string>();
using (JDJS_WMS_DB_USEREntities wms = new JDJS_WMS_DB_USEREntities())
{
var measures = wms.JDJS_WMS_Quality_ManualInput_Measurement_Table;
foreach (var item in measures)
{
double min = Convert.ToDouble(item.StandardValue + item.ToleranceRangeMin);
double max = Convert.ToDouble(item.StandardValue + item.ToleranceRangeMax);
double mea = Convert.ToDouble(item.Measurements);
if (mea > max || mea < min)
{
int orderID = Convert.ToInt32(item.OrderID);
var orderInfo = wms.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_ID == orderID);
string orderNum = orderInfo.FirstOrDefault().Order_Number;
string sizeName = item.SizeName.ToString();
string sizeNum = item.SizeNumber.ToString();
string str = orderNum + " " + "尺寸" + sizeNum + "-" + sizeName + "超差，公差（" + item.ToleranceRangeMin.ToString() + "," + item.ToleranceRangeMax.ToString() + "），实际" + (item.Measurements - item.StandardValue).ToString();
infos.Add(str);
}
}
}
System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
var json = serializer.Serialize(infos);
context.Response.Write(json);
}
public void ProcessRequest(HttpContext context)
{
//品质历史
List <QualtityHistory> qualtityHistories = new List <QualtityHistory>();
List <string> times = new List <string>();
using (JDJS_WMS_DB_USEREntities wms = new JDJS_WMS_DB_USEREntities())
{
var qualtity = wms.JDJS_WMS_Quality_Confirmation_History_Table;
foreach (var item in qualtity)
{
DateTime operateTime = Convert.ToDateTime(item.OperateTime);
string timeStr = operateTime.Year.ToString() + "-" + operateTime.Month.ToString() + "-" + operateTime.Day.ToString();
if (times.Contains(timeStr))
{
var history = qualtityHistories.Where(r => r.time == timeStr);
history.FirstOrDefault().good += Convert.ToInt32(item.GoodNum);
history.FirstOrDefault().pool += Convert.ToInt32(item.PoolNum);
}
else
{
times.Add(timeStr);
QualtityHistory history = new QualtityHistory();
history.time = timeStr;
history.good = Convert.ToInt32(item.GoodNum);
history.pool = Convert.ToInt32(item.PoolNum);
qualtityHistories.Add(history);
}
}
}
System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
var json = serializer.Serialize(qualtityHistories);
context.Response.Write(json);
}
public void ProcessRequest(HttpContext context)
{
using (JDJS_WMS_DB_USEREntities entities = new JDJS_WMS_DB_USEREntities())
{
var rows = entities.JDJS_WMS_Tool_Shank_Table.Where(r => r.CncID != null & r.ToolID != null);
int redNumber = 0, yellowNumber = 0;
foreach (var item in rows)
{
var toolId = item.ToolID;
if (entities.JDJS_WMS_ToolHolder_ToolLife_History_Table.Where(r => r.ToolID == toolId).Count() > 0)
{
var now = Convert.ToDouble(entities.JDJS_WMS_ToolHolder_ToolLife_History_Table.Where(r => r.ToolID == toolId).OrderByDescending(r => r.Time).First().ToolCurrLife);
var max = Convert.ToDouble(entities.JDJS_WMS_ToolHolder_ToolLife_History_Table.Where(r => r.ToolID == toolId).OrderByDescending(r => r.Time).First().ToolMaxLife);
if (now >= max & max > 0)
{
redNumber++;
}
else if (now >= max * 0.8 & max > 0)
{
yellowNumber++;
}
}
}
var model = new { yellowNumber, redNumber };
System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
var json = serializer.Serialize(model);
context.Response.Write(json);
}
}
public void ProcessRequest(HttpContext context)
{
List <ToolInfos> infos = new List <ToolInfos>();
using (JDJS_WMS_DB_USEREntities wms = new JDJS_WMS_DB_USEREntities())
{
var devcices = wms.JDJS_WMS_Device_Info;
foreach (var cnc in devcices)
{
var work = wms.JDJS_WMS_Order_Process_Scheduling_Table.Where(r => r.CncID == cnc.ID && r.isFlag == 3).OrderByDescending(r => r.EndTime).FirstOrDefault();
if (work != null)
{
var order = wms.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_ID == work.OrderID).FirstOrDefault();
if (order != null)
{
if (order.Intention != 4)
{
ToolInfos info = new ToolInfos();
info.IsDownTool = true;
info.IsOver = true;
info.MachNum = cnc.MachNum;
info.OrderName = order.Product_Name;
info.OrderNum = order.Order_Number;
infos.Add(info);
}
}
}
}
}
System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
var json = serializer.Serialize(infos);
context.Response.ContentType = "text/event-stream";
context.Response.Write("data:" + json + "\n\n");
}
public void ProcessRequest(HttpContext context)
{
int PlanId = int.Parse(context.Request["MaintenacneID"]);
int enable = int.Parse(context.Request["MaintenanceEnable"]);
using (JDJS_WMS_DB_USEREntities wms = new JDJS_WMS_DB_USEREntities())
{
using (System.Data.Entity.DbContextTransaction mytran = wms.Database.BeginTransaction())
{
try
{
var plan = wms.JDJS_WMS_Device_Accuracy_Verification_Plan.Where(r => r.ID == PlanId);
foreach (var item in plan)
{
item.isFlag = enable;
}
wms.SaveChanges();
mytran.Commit();
}
catch
{
mytran.Rollback();
}
}
}
context.Response.Write("ok");
}
public void ProcessRequest(HttpContext context)
{
try
{
System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
int orderId = int.Parse(context.Request["orderId"]);//订单ID
using (JDJS_WMS_DB_USEREntities model = new JDJS_WMS_DB_USEREntities())
{
var order = model.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_ID == orderId).FirstOrDefault();
if (order != null)
{
var result = new { state = order.AuditResult, advice = order.AuditAdvice };
var str = new { msg = "", code = 0, count = 1, data = result };
var json = serializer.Serialize(str);
context.Response.Write(json);
return;
}
}
context.Response.Write("未知异常");
}
catch (Exception ex)
{
context.Response.Write(ex.Message);
}
}
public void ProcessRequest(HttpContext context)
{
List <string> OrderCncNum = new List <string>();
var ordernumCnc = context.Request["orderNumber"];
var Serial = int.Parse(context.Request["serialNumber"]);
using (JDJS_WMS_DB_USEREntities jdjs = new JDJS_WMS_DB_USEREntities())
{
int orderIdCnc = 0;
var orderCnc = jdjs.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == ordernumCnc);
if (orderCnc.Count() > 0)
{
orderIdCnc = orderCnc.First().Order_ID;
}
var Cnc = jdjs.JDJS_WMS_Quality_Onmachine_Measurement_Data.Where(r => r.OrderID == orderIdCnc && r.SerialNumber == Serial);
foreach (var item in Cnc)
{
var CncNum = jdjs.JDJS_WMS_Device_Info.Where(r => r.ID == item.CncID);
foreach (var real in CncNum)
{
if (!OrderCncNum.Contains(real.MachNum))
{
OrderCncNum.Add(real.MachNum);
}
}
}
}
System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
var json = serializer.Serialize(OrderCncNum);
context.Response.Write(json);
}
public void ProcessRequest(HttpContext context)
{
string brand = context.Request["brand"];
context.Response.ContentType = "text/plain";
System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
using (JDJS_WMS_DB_USEREntities pm1 = new JDJS_WMS_DB_USEREntities())
{
var use2 =
from brand1 in pm1.JDJS_WMS_Device_Brand_Info
from type in pm1.JDJS_WMS_Device_Type_Info
where type.BrandID == brand1.ID && brand1.Brand == brand
select new
{
type.Type
};
//var user2 = pm1.JDJS_WMS_Device_Type_Info.Where(r => r.BrandID ==1);
string json = serializer.Serialize(use2);
context.Response.Write(json);
}
}
public void ProcessRequest(HttpContext context)
{
System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
var form = context.Request["form"];
var orderId = int.Parse(context.Request["orderId"]);
var workpieceNumber = int.Parse(context.Request["workpieceNumber"]);
var obj = serializer.Deserialize <AddSize>(form);
using (JDJS_WMS_DB_USEREntities entities = new JDJS_WMS_DB_USEREntities())
{
var row = new JDJS_WMS_Quality_ManualInput_Measurement_Table
{
OrderID = orderId,
WorkpieceNumber = workpieceNumber,
SizeNumber = int.Parse(obj.SizeNumber),
SizeName = obj.SizeName,
StandardValue = double.Parse(obj.StandardValue),
ToleranceRangeMin = double.Parse(obj.ToleranceRangeMin),
ToleranceRangeMax = double.Parse(obj.ToleranceRangeMax),
Measurements = double.Parse(obj.Measurements),
};
entities.JDJS_WMS_Quality_ManualInput_Measurement_Table.Add(row);
entities.SaveChanges();
context.Response.Write("ok");
}
}
public void ProcessRequest(HttpContext context)
{
try {
var orderId = int.Parse(context.Request.QueryString["orderId"]);
using (JDJS_WMS_DB_USEREntities entities = new JDJS_WMS_DB_USEREntities())
{
var rows = entities.JDJS_WMS_Order_Process_Info_Table.Where(r => r.OrderID == orderId & r.sign == -1);
if (rows.Count() < 1)
{
context.Response.Write("暂无需提交审核工序");
return;
}
foreach (var item in entities.JDJS_WMS_Order_Process_Info_Table.Where(r => r.OrderID == orderId && r.sign != 0))
{
item.sign = -2;
}
entities.SaveChanges();
context.Response.Write("ok");
}
}
catch (Exception ex)
{
context.Response.Write(ex.Message);
}
}
/// <summary>
/// 治具异常报备
/// </summary>
/// <param name="id">工序id</param>
/// <returns></returns>
public bool AbnormalSubmit(int id, ref string errMsg)
{
try
{
using (JDJS_WMS_DB_USEREntities wms = new JDJS_WMS_DB_USEREntities())
{
var processes = wms.JDJS_WMS_Order_Fixture_Manager_Table.Where(r => r.ProcessID == id);
using (System.Data.Entity.DbContextTransaction mytran = wms.Database.BeginTransaction())
{
try
{
foreach (var item in processes)
{
item.FixtureFinishPerpareNumber = 0;
}
wms.SaveChanges();
errMsg = "ok";
mytran.Commit();
return(true);
}
catch (Exception ex)
{
mytran.Rollback();
errMsg = ex.Message;
return(false);
}
}
}
}
catch (Exception ex)
{
errMsg = ex.Message;
return(false);
}
}
public void ProcessRequest(HttpContext context)
{
using (JDJS_WMS_DB_USEREntities entities = new JDJS_WMS_DB_USEREntities())
{
var rows = entities.JDJS_WMS_Device_Info;
List <Option> options = new List <Option>();
System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
foreach (var item in rows)
{
Option option = new Option();
option.number = item.MachNum;
options.Add(option);
}
;
var rowsWork = entities.JDJS_WMS_Location_Info;
foreach (var item in rowsWork)
{
Option option = new Option();
option.number = item.Name;
options.Add(option);
}
var data = options.Where((r, i) => options.FindIndex(p => p.number == r.number) == i);
var sort = data.OrderBy(r => r.number);
var json = serializer.Serialize(sort);
context.Response.Write(json);
}
}
public void ProcessRequest(HttpContext context)
{
using (JDJS_WMS_DB_USEREntities entities = new JDJS_WMS_DB_USEREntities())
{
var rows = entities.JDJS_WMS_Tool_LifeTime_Management;
int redNumber = 0, yellowNumber = 0;
foreach (var item in rows)
{
var now = item.ToolCurrTime;
var max = item.ToolMaxTime;
if (now >= max & max > 0)
{
redNumber++;
}
else if (now >= max * 0.8 & max > 0)
{
yellowNumber++;
}
}
var model = new { yellowNumber, redNumber };
System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
var json = serializer.Serialize(model);
context.Response.Write(json);
}
}
public void ProcessRequest(HttpContext context)
{
using (JDJS_WMS_DB_USEREntities entities = new JDJS_WMS_DB_USEREntities())
{
var rows =
from shank in entities.JDJS_WMS_Tool_Shank_Table
from cnc in entities.JDJS_WMS_Device_Info
from location in entities.JDJS_WMS_Location_Info
from toolTable in entities.JDJS_WMS_ToolHolder_Tool_Table
from toolS in entities.JDJS_WMS_Tool_Stock_History
from toolLife in entities.JDJS_WMS_Tool_LifeTime_Management
where toolLife.CncID == cnc.ID & cnc.Position == location.id && shank.CncID == cnc.ID && toolTable.ID == shank.ToolID && toolS.Id == toolTable.ToolSpecifications
select new
{
toolLife.CncID,
toolLife.ToolID,
toolS.KnifeName,
toolS.KnifeSpecifications,
toolLife.ToolCurrTime,
toolLife.ToolMaxTime,
cnc.MachNum,
//toolLife.Time,
//toolLife.ToolID,
location.Name
};
var rowsList = rows.OrderBy(r => (r.ToolMaxTime - r.ToolCurrTime)).ToList();
rowsList = rowsList.Where((x, i) => rowsList.FindIndex(p => p.ToolID == x.ToolID) == i).ToList();
var json = Serializer.Serialize(new { data = rowsList.Take(5), count = rowsList.Count });
context.Response.Write("data:" + json + "\n\n");
context.Response.ContentType = "text/event-stream";
}
}
public void ProcessRequest(HttpContext context)
{
{
int OrderID = int.Parse(context.Request["orderId"]);
System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
List <string> str = new List <string>();
using (JDJS_WMS_DB_USEREntities wms = new JDJS_WMS_DB_USEREntities())
{
using (System.Data.Entity.DbContextTransaction date = wms.Database.BeginTransaction())
{
try
{
List <int> processid = new List <int>();
var process = wms.JDJS_WMS_Order_Process_Info_Table.Where(r => r.OrderID == OrderID && r.sign != 0);
foreach (var item in process)
{
if (!processid.Contains(Convert.ToInt32(item.ProcessID)))
{
processid.Add(Convert.ToInt32(item.ProcessID));
}
}
processid.Sort();
List <int> ProcessId = new List <int>();
foreach (var item in processid)
{
var processed = wms.JDJS_WMS_Order_Process_Info_Table.Where(r => r.OrderID == OrderID && r.sign != 0 && r.ProcessID == item);
ProcessId.Add(Convert.ToInt32(processed.FirstOrDefault().ID));
}
foreach (var item in ProcessId)
{
List <int> CncID = new List <int>();
var mach = wms.JDJS_WMS_Order_Process_Scheduling_Table.Where(r => r.ProcessID == item && r.isFlag != 0);
foreach (var real in mach)
{
if (!CncID.Contains(Convert.ToInt32(real.CncID)))
{
CncID.Add(Convert.ToInt32(real.CncID));
}
}
var fix = wms.JDJS_WMS_Order_Fixture_Manager_Table.Where(r => r.ProcessID == item);
fix.FirstOrDefault().FixtureNumber = CncID.Count();
wms.SaveChanges();
str.Add(CncID.Count().ToString());
}
wms.SaveChanges();
date.Commit();
}
catch (Exception ex)
{
date.Rollback();
context.Response.Write(ex.Message);
}
}
}
var json = serializer.Serialize(str);
context.Response.Write("ok");
}
}
public void ProcessRequest(HttpContext context)
{
var page = int.Parse(context.Request["page"]);
var limit = int.Parse(context.Request["limit"]);
{
int CncID = int.Parse(context.Request["id"]);
List <AlarmRead> alarmReads = new List <AlarmRead>();
System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
using (JDJS_WMS_DB_USEREntities wms = new JDJS_WMS_DB_USEREntities())
{
var alarmList = wms.JDJS_WMS_Device_Alarm_History_Table.Where(r => r.CncID == CncID).OrderBy(r => r.StartTime);
foreach (var alarm in alarmList)
{
AlarmRead alarmRead = new AlarmRead();
alarmRead.errCode = alarm.ErrCode.ToString();
alarmRead.errDesc = alarm.ErrDesc.ToString();
alarmRead.alarmTime = alarm.StartTime.ToString();
alarmReads.Add(alarmRead);
}
}
var order1 = alarmReads.Skip((page - 1) * limit).Take(limit);
var order2 = order1.ToList();
var model = new { code = 0, msg = "", count = alarmReads.Count(), data = order2 };
string json = serializer.Serialize(model);
context.Response.Write(json);
}
}
public void ProcessRequest(HttpContext context)
{
var id = int.Parse(context.Request["id"]);
using (JDJS_WMS_DB_USEREntities entities = new JDJS_WMS_DB_USEREntities())
{
var row = from size in entities.JDJS_WMS_Quality_ManualInput_Measurement_Table
where size.ID == id
select new {
size.ID,
size.SizeName,
size.SizeNumber,
size.StandardValue,
size.ToleranceRangeMin,
size.ToleranceRangeMax,
size.Measurements
};
if (row.Count() > 0)
{
System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
var json = serializer.Serialize(row);
context.Response.Write(json);
}
}
}
public void ProcessRequest(HttpContext context)
{
{
List <deviceToolInfo> deviceToolInfos = new List <deviceToolInfo>();
using (JDJS_WMS_DB_USEREntities wms = new JDJS_WMS_DB_USEREntities())
{
var devices = wms.JDJS_WMS_Device_Info;
foreach (var item in devices)
{
deviceToolInfo deviceTool = new deviceToolInfo();
deviceTool.CncID = item.ID.ToString();
deviceTool.flag = "0";
var toollist = wms.JDJS_WMS_Tool_LifeTime_Management.Where(r => r.CncID == item.ID);
int error = 0;
foreach (var real in toollist)
{
if (real.ToolCurrTime > real.ToolMaxTime * 0.8 && real.ToolCurrTime < real.ToolMaxTime && real.ToolMaxTime > 0)
{
error = 1;
deviceTool.flag = "1";
}
if (real.ToolCurrTime >= real.ToolMaxTime && real.ToolMaxTime > 0)
{
error = 2;
deviceTool.flag = "2";
break;
}
}
deviceToolInfos.Add(deviceTool);
}
}
var json = Serializer.Serialize(deviceToolInfos);
context.Response.Write(json);
}
}
