public void ProcessRequest(HttpContext context) { var orderId = int.Parse(context.Request["orderId"]); int oldOrderId = 0; using (JDJS_WMS_DB_USEREntities wms = new JDJS_WMS_DB_USEREntities()) { var order = wms.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_ID == orderId).FirstOrDefault(); if (order == null) { context.Response.Write("该订单不存在,请确认后再试!"); return; } if (order.ParentId == null) { context.Response.Write("该订单无关联订单,请确认后再试!"); return; } using (System.Data.Entity.DbContextTransaction mytran = wms.Database.BeginTransaction()) { try { oldOrderId = int.Parse(order.ParentId.ToString()); var blankInfo = wms.JDJS_WMS_Order_Blank_Table.Where(r => r.OrderID == oldOrderId).FirstOrDefault(); if (blankInfo != null) { JDJS_WMS_Order_Blank_Table jdBlank = new JDJS_WMS_Order_Blank_Table() { OrderID = orderId, BlackNumber = order.Product_Output, BlankAddition = 0, BlankSpecification = blankInfo.BlankSpecification.Contains("#1#")? blankInfo.BlankSpecification.Replace("#1#", "") : blankInfo.BlankSpecification, BlankState = "待备料", BlanktotalPreparedNumber = 0, BlankType = blankInfo.BlankType, Expected_Completion_Time = DateTime.Now }; wms.JDJS_WMS_Order_Blank_Table.Add(jdBlank); } JDJS_WMS_Quality_Confirmation_Table jdQuality = new JDJS_WMS_Quality_Confirmation_Table() { OrderID = orderId, DetectionNumber = 0, CurrFinishedProductNumber = 0, PassRate = 0, PefectiveProductNumber = 0, PendingNumber = 0, QualifiedProductNumber = 0 }; wms.JDJS_WMS_Quality_Confirmation_Table.Add(jdQuality); wms.SaveChanges(); JDJS_WMS_Finished_Product_Manager jdFinish = new JDJS_WMS_Finished_Product_Manager() { outputNumber = 0, DefectiveProductNumber = 0, OrderID = orderId, stock = 0, waitForWarehousing = 0, warehousingNumber = 0, }; wms.JDJS_WMS_Finished_Product_Manager.Add(jdFinish); wms.SaveChanges(); var guide = wms.JDJS_WMS_Order_Guide_Schedu_Table.Where(r => r.OrderID == orderId).FirstOrDefault(); if (guide != null) { guide.ExpectEndTime = DateTime.Now; guide.EndTime = DateTime.Now; wms.SaveChanges(); } var processes = wms.JDJS_WMS_Order_Process_Info_Table.Where(r => r.OrderID == oldOrderId && r.sign != 0); JDJS_WMS_Order_DelayTime_Table jdDelay = new JDJS_WMS_Order_DelayTime_Table() { OrderID = orderId, }; wms.JDJS_WMS_Order_DelayTime_Table.Add(jdDelay); foreach (var item in processes) { JDJS_WMS_Order_Process_Info_Table jd = new JDJS_WMS_Order_Process_Info_Table() { DeviceType = item.DeviceType, ProcessID = item.ProcessID, JigSpecification = item.JigSpecification.Contains("#1#")? item.JigSpecification.Replace("#1#", ""): item.JigSpecification, JigType = item.JigType, Jig_Expected_Completion_Time = DateTime.Now, BlankNumber = order.Product_Output, sign = 1, program_audit_sign = 1, programName = order.Order_Number + "-" + item.programName.Split('-')[1], ProcessTime = item.ProcessTime, BlankSpecification = item.BlankSpecification.Contains("#1#")?item.BlankSpecification.Replace("#1#", ""):item.BlankSpecification, BlankType = item.BlankType, MachNumber = item.MachNumber, Modulus = item.Modulus, NonCuttingTime = item.NonCuttingTime, toolChartName = "T-" + order.Order_Number + "-" + item.toolChartName.Split('-')[2], toolPreparation = 0, ProgramePassTime = DateTime.Now, OrderID = orderId }; wms.JDJS_WMS_Order_Process_Info_Table.Add(jd); order.audit_Result = "。" + DateTime.Now.ToString() + ":审核通过"; order.program_audit_result = "。" + DateTime.Now.ToString() + ":审核通过"; wms.SaveChanges(); int processId = jd.ID; var processInfo = wms.JDJS_WMS_Order_Process_Information_Table.Where(r => r.ProcessID == item.ID).FirstOrDefault(); if (processInfo != null) { JDJS_WMS_Order_Process_Information_Table jdInfo = new JDJS_WMS_Order_Process_Information_Table() { Note = processInfo.Note, ProcessID = processId, WorkMaterial = processInfo.WorkMaterial, XPoint = processInfo.XPoint, YPoint = processInfo.YPoint, ZPoint = processInfo.ZPoint }; wms.JDJS_WMS_Order_Process_Information_Table.Add(jdInfo); wms.SaveChanges(); } var tools = wms.JDJS_WMS_Order_Process_Tool_Info_Table.Where(r => r.ProcessID == item.ID); foreach (var tool in tools) { JDJS_WMS_Order_Process_Tool_Info_Table jdTool = new JDJS_WMS_Order_Process_Tool_Info_Table() { BladeLenth = tool.BladeLenth, EffectiveLength = tool.EffectiveLength, ProcessID = processId, ToolDiameter = tool.ToolDiameter, isFine = tool.isFine, Shank = tool.Shank, PathName = tool.PathName, ToolAroidance = tool.ToolAroidance, ToolLength = tool.ToolLength, ToolName = tool.ToolName, ToolNO = tool.ToolNO }; wms.JDJS_WMS_Order_Process_Tool_Info_Table.Add(jdTool); } wms.SaveChanges(); JDJS_WMS_Order_Fixture_Manager_Table jdFix = new JDJS_WMS_Order_Fixture_Manager_Table() { ProcessID = processId, FixtureAdditionNumber = 0, FixtureFinishPerpareNumber = 0, FixtureNumber = 0 }; wms.JDJS_WMS_Order_Fixture_Manager_Table.Add(jdFix); JDJS_WMS_Warehouse_InOut_History_Table jdInout = new JDJS_WMS_Warehouse_InOut_History_Table() { InNum = 0, OutNum = 0, ProcessId = processId }; wms.JDJS_WMS_Warehouse_InOut_History_Table.Add(jdInout); } order.Intention = 3; wms.SaveChanges(); mytran.Commit(); context.Response.Write("ok"); return; } catch (Exception ex) { mytran.Rollback(); context.Response.Write(ex.Message); return; } } } }
public void ProcessRequest(HttpContext context) { var form = context.Request.Form; var file = context.Request.Files; var projectName = form["projectName"]; var remark = form["remark"]; //备注 var loginID = Convert.ToInt32(context.Session["id"]); int priority = 1; //优先级 string year = DateTime.Now.Year.ToString().Substring(2, 2); string month = DateTime.Now.Month.ToString(); while (month.Length < 2) { month = month.Insert(0, "0"); } string day = DateTime.Now.Day.ToString(); while (day.Length < 2) { day = day.Insert(0, "0"); } string strOrderNum = year + month + day; int flag = 1; string flagStr = ""; // var folder = @"D:\服务器文件勿动\" + form[0]; using (JDJS_WMS_DB_USEREntities entities = new JDJS_WMS_DB_USEREntities()) { using (System.Data.Entity.DbContextTransaction date = entities.Database.BeginTransaction()) { try { while (true) { flagStr = flag.ToString(); while (flagStr.Length < 5) { flagStr = flagStr.Insert(0, "0"); } var order = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == strOrderNum + flagStr); if (order.Count() < 1) { break; } flag++; } if (form[0] == "0") { var Order_Number = strOrderNum + flagStr; var Order_Leader = form[2]; var Product_Name = form[3]; var Product_Material = form[4]; var Product_Output = int.Parse(form[5]); var Order_Plan_End_Time = DateTime.Parse(form[6]); var Order_State = form[7]; var Order_Plan_Start_Time = DateTime.Now; var Customer = form[8]; var pattern = int.Parse(form["pattern"]); var judge = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == Order_Number); if (judge.Count() > 0) { context.Response.Write("该订单已存在"); return; } var row = new JDJS_WMS_Order_Entry_Table { Order_Number = Order_Number, Order_Leader = Order_Leader, Product_Name = Product_Name, Product_Material = Product_Material, Product_Output = Product_Output, Order_Plan_End_Time = Order_Plan_End_Time, Order_State = Order_State, Order_Plan_Start_Time = DateTime.Now, Intention = 3, ProjectName = projectName, ProofingORProduct = pattern, CtratPersonID = loginID, Priority = priority, CreateTime = DateTime.Now, CreatePersonID = loginID, AuditResult = "待审核", Remark = remark }; entities.JDJS_WMS_Order_Entry_Table.Add(row); entities.SaveChanges(); var orderId = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == Order_Number).FirstOrDefault().Order_ID; JDJS_WMS_Order_Guide_Schedu_Table guide = new JDJS_WMS_Order_Guide_Schedu_Table() { OrderID = orderId, ClientName = Customer }; entities.JDJS_WMS_Order_Guide_Schedu_Table.Add(guide); entities.SaveChanges(); var queue = new JDJS_WMS_Order_Queue_Table { OrderID = orderId, isFlag = 3 }; entities.JDJS_WMS_Order_Queue_Table.Add(queue); entities.SaveChanges(); PathInfo pathInfo = new PathInfo(); var folder = Path.Combine(pathInfo.upLoadPath(), Order_Number, form[1], @"客供图纸"); if (!Directory.Exists(folder)) { Directory.CreateDirectory(folder); } ; for (int i = 0; i < file.Count; i++) { var name = file[i].FileName; var size = file[i].ContentLength; string path = Path.Combine(folder, name); file[i].SaveAs(path); } entities.SaveChanges(); context.Response.Write("ok"); date.Commit(); } else { var Order_Number = strOrderNum + flagStr; var Order_Leader = form[2]; var oldOrderNumber = form[3]; var Product_Name = form[4]; var Product_Material = form[5]; var Product_Output = int.Parse(form[6]); var Order_Plan_End_Time = DateTime.Parse(form[7]); var Order_State = form[8]; var Order_Plan_Start_Time = DateTime.Now; var Customer = form[9]; { string OrderNum = Order_Number; string OrderOwener = Order_Leader; string OldOrderNum = oldOrderNumber; string ProductName = Product_Name; string ProductMertial = Product_Material; int ProductOutPut = Product_Output; string OrderState = Order_State; DateTime OverTime = DateTime.Now; using (JDJS_WMS_DB_USEREntities wms = new JDJS_WMS_DB_USEREntities()) { var orders = wms.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == OrderNum); if (orders.Count() > 0) { Console.WriteLine("该订单号已存在"); return; } else { using (System.Data.Entity.DbContextTransaction mytran = wms.Database.BeginTransaction()) { try { var OldOrderInfo = wms.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == OldOrderNum); if (OldOrderInfo.Count() > 0) { JDJS_WMS_Order_Entry_Table orderentry = new JDJS_WMS_Order_Entry_Table() { Order_Number = OrderNum, Order_Leader = OrderOwener, Product_Name = ProductName, Product_Material = ProductMertial, Product_Output = ProductOutPut, Order_Plan_Start_Time = null, Order_Actual_Start_Time = null, Order_Actual_End_Time = null, Order_Plan_End_Time = Order_Plan_End_Time, Engine_Program_Manager = OldOrderInfo.FirstOrDefault().Engine_Program_Manager, Engine_Technology_Manager = OldOrderInfo.FirstOrDefault().Engine_Technology_Manager, Engine_Program_ManagerId = OldOrderInfo.FirstOrDefault().Engine_Program_ManagerId, Engine_Technology_ManagerId = OldOrderInfo.FirstOrDefault().Engine_Technology_ManagerId, Engine_Status = "未进行", Intention = 3, ProjectName = projectName, CreateTime = DateTime.Now, CreatePersonID = loginID, Order_State = OrderState, virtualProgPersId = OldOrderInfo.FirstOrDefault().virtualProgPersId, virtualReturnTime = OldOrderInfo.FirstOrDefault().virtualReturnTime, // audit_Result = "待审核", AuditResult = "待审核", Remark = remark }; wms.JDJS_WMS_Order_Entry_Table.Add(orderentry); wms.SaveChanges(); mytran.Commit(); } } catch (Exception ex) { mytran.Rollback(); context.Response.Write(ex.Message); return; } } using (System.Data.Entity.DbContextTransaction mytran = wms.Database.BeginTransaction()) { try { var newOlder = wms.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == OrderNum).FirstOrDefault(); JDJS_WMS_Order_Blank_Table blank = new JDJS_WMS_Order_Blank_Table() { OrderID = newOlder.Order_ID, BlackNumber = newOlder.Product_Output, BlankAddition = 0, BlankSpecification = null, BlankState = null, BlanktotalPreparedNumber = 0, BlankType = null, }; wms.JDJS_WMS_Order_Blank_Table.Add(blank); wms.SaveChanges(); JDJS_WMS_Order_Guide_Schedu_Table guide = new JDJS_WMS_Order_Guide_Schedu_Table() { OrderID = newOlder.Order_ID, ClientName = Customer }; entities.JDJS_WMS_Order_Guide_Schedu_Table.Add(guide); entities.SaveChanges(); var oldOlder = wms.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == OldOrderNum).FirstOrDefault(); var oldProcessInfo = wms.JDJS_WMS_Order_Process_Info_Table.Where(r => r.OrderID == oldOlder.Order_ID && r.sign == 1); foreach (var item in oldProcessInfo) { string oldprocessName = item.programName; string[] str = oldprocessName.Split('-'); string NewProcessNum = ""; if (str.Length == 2) { NewProcessNum = OrderNum + "-" + str[1]; } string oldToolName = item.toolChartName; string[] toolStr = oldToolName.Split('-'); string NewToolNum = ""; if (toolStr.Length == 3) { NewToolNum = "T" + "-" + OrderNum + "-" + toolStr[2]; } JDJS_WMS_Order_Process_Info_Table process = new JDJS_WMS_Order_Process_Info_Table() { OrderID = newOlder.Order_ID, ProcessID = item.ProcessID, BlankNumber = ProductOutPut, BlankSpecification = item.BlankSpecification, BlankType = item.BlankType, DeviceType = item.DeviceType, JigSpecification = item.JigSpecification, ProcessTime = item.ProcessTime, programName = NewProcessNum, sign = item.sign, toolChartName = NewToolNum, toolPreparation = item.toolPreparation, }; wms.JDJS_WMS_Order_Process_Info_Table.Add(process); } wms.SaveChanges(); mytran.Commit(); } catch (Exception ex) { mytran.Rollback(); context.Response.Write(ex.Message); return; } } using (System.Data.Entity.DbContextTransaction mytran = wms.Database.BeginTransaction()) { try { var newOlder = wms.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == OrderNum).FirstOrDefault(); var processes = wms.JDJS_WMS_Order_Process_Info_Table.Where(r => r.OrderID == newOlder.Order_ID && r.sign == 1); foreach (var item in processes) { JDJS_WMS_Order_Fixture_Manager_Table fix = new JDJS_WMS_Order_Fixture_Manager_Table() { ProcessID = item.ID, FixtureAdditionNumber = 0, FixtureNumber = 0, FixtureFinishPerpareNumber = 0, }; wms.JDJS_WMS_Order_Fixture_Manager_Table.Add(fix); } //给每个工序添加治具一行 wms.SaveChanges(); mytran.Commit(); } catch (Exception ex) { mytran.Rollback(); context.Response.Write(ex.Message); return; } } using (System.Data.Entity.DbContextTransaction mytran = wms.Database.BeginTransaction()) { try { var newOlder = wms.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == OrderNum).FirstOrDefault(); var oldOlder = wms.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == OldOrderNum).FirstOrDefault(); var processes = wms.JDJS_WMS_Order_Process_Info_Table.Where(r => r.OrderID == newOlder.Order_ID && r.sign == 1); foreach (var item in processes) { var oldProcess = wms.JDJS_WMS_Order_Process_Info_Table.Where(r => r.OrderID == oldOlder.Order_ID && r.ProcessID == item.ProcessID && r.sign == 1).FirstOrDefault(); var OldTool = wms.JDJS_WMS_Order_Process_Tool_Info_Table.Where(r => r.ProcessID == oldProcess.ID); foreach (var real in OldTool) { JDJS_WMS_Order_Process_Tool_Info_Table tool = new JDJS_WMS_Order_Process_Tool_Info_Table() { ProcessID = item.ID, PathName = real.PathName, Shank = real.Shank, ToolAroidance = real.ToolAroidance, ToolDiameter = real.ToolDiameter, ToolLength = real.ToolLength, ToolName = real.ToolName, ToolNO = real.ToolNO }; wms.JDJS_WMS_Order_Process_Tool_Info_Table.Add(tool); } wms.SaveChanges(); } wms.SaveChanges(); mytran.Commit(); } catch (Exception ex) { mytran.Rollback(); context.Response.Write(ex.Message); return; } } { PathInfo pathInfo = new PathInfo(); var NewFolder = Path.Combine(pathInfo.upLoadPath(), OrderNum); var OldFolder = Path.Combine(pathInfo.upLoadPath(), OldOrderNum); List <string> srcPath = new List <string>(); string[] src = Directory.GetFileSystemEntries(OldFolder); foreach (var item in src) { copyDir(item, NewFolder, OrderNum); } context.Response.Write("ok"); return; } } } } } } catch (Exception ex) { date.Rollback(); context.Response.Write(ex.Message); } } } }
public void ProcessRequest(HttpContext context) { var form = context.Request.Form; var files = context.Request.Files; var orderNumberId = int.Parse(form["orderId"]); //订单id var workNumber = int.Parse(form["workNumber"]); //工序号 var time = double.Parse(form[2]); //探测点个数 double ToolTime = 0.1666666666; //换刀时间 double ProcessTime = 0; //工序时间 double OnMachMea = 0.033333333333; //探测时间 int toolNum = 0; //换刀次数 int toolFlag = 1; string ToolNo = "0"; PathInfo pathInfo = new PathInfo(); using (JDJS_WMS_DB_USEREntities entities = new JDJS_WMS_DB_USEREntities()) { using (System.Data.Entity.DbContextTransaction mytran = entities.Database.BeginTransaction()) { try { if (entities.JDJS_WMS_Order_Process_Info_Table.Where(r => r.OrderID == orderNumberId & r.ProcessID == workNumber & r.sign == 1).Count() < 1) { context.Response.Write("该订单下工序不存在"); return; } var orderNumber = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_ID == orderNumberId).First().Order_Number; var name0 = files[0].FileName; var name1 = files[1].FileName; string last0 = Path.GetExtension(name0); string last1 = Path.GetExtension(name1); var program = orderNumber + "-P" + workNumber + last0; var toolChartName = "T-" + orderNumber + "-P" + workNumber + last1; var path0 = Path.Combine(pathInfo.upLoadPath(), orderNumber, "加工文件", program); DirectoryInfo directoryP = new DirectoryInfo(Path.Combine(pathInfo.upLoadPath(), orderNumber, "加工文件")); if (!directoryP.Exists) { directoryP.Create(); } files[0].SaveAs(path0); var path1 = Path.Combine(pathInfo.upLoadPath(), orderNumber, "刀具表", toolChartName); DirectoryInfo directoryT = new DirectoryInfo(Path.Combine(pathInfo.upLoadPath(), orderNumber, "刀具表")); if (!directoryT.Exists) { directoryT.Create(); } files[1].SaveAs(path1); { string FilePath = path1; string path = Path.GetFileNameWithoutExtension(FilePath); int ProcessID = 0; string[] str = path.Split('-'); string OrderNum = orderNumber; string Process = workNumber.ToString(); List <int> ToolNum = new List <int>(); List <ToolInfo> toolInfos = new List <ToolInfo>(); string fileSuffix = System.IO.Path.GetExtension(FilePath); if (fileSuffix == ".xls") { #region { DataTable dt = getData(FilePath).Tables[0]; dt.Columns[0].ColumnName = "序号"; dt.Columns[1].ColumnName = "路径名"; dt.Columns[2].ColumnName = "刀号"; dt.Columns[3].ColumnName = "刀具"; dt.Columns[4].ColumnName = "刀柄"; dt.Columns[5].ColumnName = "刀具伸出长度"; dt.Columns[6].ColumnName = "刃长"; dt.Columns[7].ColumnName = "粗中光"; dt.Columns[8].ColumnName = "加工时间"; for (int i = 0; i < dt.Rows.Count; i++) { if (i == 0 || i == 1 || i == 2 || i == 3 || i == 4 || i == 5 || i == 6 || i == 8) { //dt.Rows.Remove(dt.Rows[0]); } else if (i == 7) { ProcessTime = 0; } else { string toolnum = dt.Rows[i]["刀号"].ToString(); double _toolnum = 0; if (isNumberic(toolnum, out _toolnum)) { if (toolnum != ToolNo) { toolNum++; ToolNo = toolnum; } if (dt.Rows[i]["加工时间"].ToString() != "" && dt.Rows[i]["加工时间"] != null) { if (dt.Rows[i]["加工时间"].ToString().Contains(':')) { var timeInfo = dt.Rows[i]["加工时间"].ToString().Split(':'); int hT = Convert.ToInt32(timeInfo[0]); int minT = Convert.ToInt32(timeInfo[1]); int secT = Convert.ToInt32(timeInfo[2]); ProcessTime += (hT * 60 + minT + ((float)secT / 60)); } else if (dt.Rows[i]["加工时间"].ToString() == "---") { ProcessTime += 0; } else { ProcessTime += (Convert.ToDouble(dt.Rows[i]["加工时间"].ToString()) * 1440); } } if (!ToolNum.Contains(Convert.ToInt32(dt.Rows[i]["刀号"].ToString()))) { ToolNum.Add(Convert.ToInt32(dt.Rows[i]["刀号"].ToString())); ToolInfo tool = new ToolInfo(); tool.PathName = dt.Rows[i]["路径名"].ToString(); string toolno = dt.Rows[i]["刀号"].ToString(); double _toolno = 0; if (isNumberic(toolno, out _toolno)) { tool.ToolNO = Convert.ToInt32(dt.Rows[i]["刀号"].ToString()); } tool.ToolName = dt.Rows[i]["刀具"].ToString(); string tooll = dt.Rows[i]["刀具伸出长度"].ToString(); double _tooll = 0; if (isNumberic(tooll, out _tooll)) { tool.ToolLength = Convert.ToDouble(dt.Rows[i]["刀具伸出长度"].ToString()); } string ToolD = dt.Rows[i]["刃长"].ToString(); double _ToolD = 0; if (isNumberic(ToolD, out _ToolD)) { tool.ToolAroidance = Convert.ToDouble(dt.Rows[i]["刃长"].ToString()); } tool.Shank = dt.Rows[i]["刀柄"].ToString(); toolInfos.Add(tool); } } } } } #endregion } else { mytran.Rollback(); context.Response.Write("刀具表请输入xls格式文件"); return; } int DeviceTypeID = 0; var process = entities.JDJS_WMS_Order_Process_Info_Table.Where(r => r.OrderID == orderNumberId && r.ProcessID == workNumber && r.sign != 0).FirstOrDefault(); if (process != null) { DeviceTypeID = Convert.ToInt32(process.DeviceType); } //此处在查询特殊刀具时需要按照机床类型来找 var toolStand = entities.JDJS_WMS_Tool_Standard_Table.Where(r => r.MachTypeID == DeviceTypeID).ToList(); var CETOU = toolStand.Where(r => r.Name == "测头" || r.Name == "探针"); int cetouID = -1; if (CETOU.Count() > 0) { cetouID = Convert.ToInt32(CETOU.First().ToolID.Substring(1)); } List <string> toolStandNo = new List <string>(); foreach (var real in toolStand) { string strT = real.ToolID; toolStandNo.Add(strT); } foreach (var item in toolInfos) { //判断是否有特殊刀具,判断刀具是否在刀具标准表是否存在 if (!toolStandNo.Contains("T" + item.ToolNO.ToString())) { toolFlag = 0; break; } } double times = Math.Ceiling(OnMachMea * time + ToolTime * toolNum + ProcessTime); foreach (var item in entities.JDJS_WMS_Order_Process_Info_Table.Where(r => r.OrderID == orderNumberId & r.ProcessID == workNumber & r.sign == 1)) { item.ProcessTime = times; item.programName = program; item.toolChartName = toolChartName; } entities.SaveChanges(); var order = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == OrderNum); if (order.Count() > 0) { int orderid = order.First().Order_ID; double pros = 0; if (isNumberic(Process, out pros)) { int prose = Convert.ToInt32(Process); var pro = entities.JDJS_WMS_Order_Process_Info_Table.Where(r => r.OrderID == orderid && r.ProcessID == prose & r.sign == 1); if (pro.Count() > 0) { ProcessID = pro.First().ID; } } } foreach (var item in toolInfos) { if (item.ToolNO != cetouID) { JDJS_WMS_Order_Process_Tool_Info_Table tool = new JDJS_WMS_Order_Process_Tool_Info_Table() { ProcessID = ProcessID, PathName = item.PathName, ToolNO = item.ToolNO, ToolName = item.ToolName, ToolLength = item.ToolLength, //ToolDiameter = item.ToolDiameter, ToolAroidance = item.ToolAroidance, Shank = item.Shank }; entities.JDJS_WMS_Order_Process_Tool_Info_Table.Add(tool); } } entities.SaveChanges(); } entities.SaveChanges(); mytran.Commit(); } catch (Exception ex) { mytran.Rollback(); context.Response.Write(ex.Message); return; } context.Response.ContentType = "text/plain"; context.Response.Write("Hello World"); } } }