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