public void ProcessRequest(HttpContext context) { int orderId = int.Parse(context.Request["orderId"]); //关联的订单主键ID int output = int.Parse(context.Request["output"]); //订单需求量 string Order_Leader = context.Request["Order_Leader"]; //订单负责人 string Product_Name = context.Request["Product_Name"]; //产品名称 string Project_Name = context.Request["Project_Name"]; //项目名称 string Order_State = context.Request["Order_State"]; //订单状态 var patternStr = (context.Request["pattern"] == null ? "-100" : context.Request["pattern"]); int pattern = int.Parse(patternStr); //生产模式 int loginID = Convert.ToInt32(context.Session["id"]); DateTime Order_Plan_End_Time = Convert.ToDateTime(context.Request["Order_Plan_End_Time"]); //计划结束时间 var Order_Plan_Start_Time = DateTime.Now; var Customer = context.Request["Customer"]; //客户名称 var remark = context.Request["remark"]; #region 订单号 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 = ""; using (JDJS_WMS_DB_USEREntities entities = new JDJS_WMS_DB_USEREntities()) { 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++; } } catch (Exception ex) { context.Response.Write(ex.Message); return; } var OldOrder = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_ID == orderId).FirstOrDefault(); if (OldOrder == null) { context.Response.Write("被关联订单不存在,请确认后再试!"); return; } var clientInfo = entities.JDJS_WMS_Order_Guide_Schedu_Table.Where(r => r.OrderID == orderId).FirstOrDefault(); Order_Leader = Order_Leader == null ? OldOrder.Order_Leader : Order_Leader; Product_Name = Product_Name == null? OldOrder.Product_Name : Product_Name; Project_Name = Project_Name == null? OldOrder.ProjectName : Project_Name; Order_State = Order_State == null ? OldOrder.Order_State : Order_State; Customer = Customer == null ?(clientInfo == null?"无": clientInfo.ClientName) : Customer; pattern = pattern == -100 ? ((int)(OldOrder.ProofingORProduct == null?-1: OldOrder.ProofingORProduct)) : pattern; using (System.Data.Entity.DbContextTransaction date = entities.Database.BeginTransaction()) { try { JDJS_WMS_Order_Entry_Table orderentry = new JDJS_WMS_Order_Entry_Table() { Order_Number = strOrderNum + flagStr, Order_Leader = Order_Leader, Product_Name = Product_Name, Product_Material = OldOrder.Product_Material, Product_Output = output, Order_Plan_Start_Time = Order_Plan_Start_Time, Order_Actual_Start_Time = null, Order_Actual_End_Time = null, Order_Plan_End_Time = Order_Plan_End_Time, Engine_Program_Manager = OldOrder.Engine_Program_Manager, Engine_Technology_Manager = OldOrder.Engine_Technology_Manager, Engine_Program_ManagerId = OldOrder.Engine_Program_ManagerId, Engine_Technology_ManagerId = OldOrder.Engine_Technology_ManagerId, Engine_Status = "未进行", Intention = 6, ProjectName = Project_Name, CreateTime = DateTime.Now, CreatePersonID = loginID, Order_State = Order_State, virtualProgPersId = OldOrder.virtualProgPersId, virtualReturnTime = OldOrder.virtualReturnTime, AuditResult = "待审核", CtratPersonID = loginID, //audit_Result = OldOrder.audit_Result, craftPerson = OldOrder.craftPerson, Priority = 1, craftPersonId = OldOrder.craftPersonId, ProofingORProduct = pattern, program_audit_result = null, ParentId = orderId, Remark = remark }; entities.JDJS_WMS_Order_Entry_Table.Add(orderentry); entities.SaveChanges(); int orderIdNew = orderentry.Order_ID; JDJS_WMS_Order_Guide_Schedu_Table guide = new JDJS_WMS_Order_Guide_Schedu_Table() { OrderID = orderIdNew, ClientName = Customer }; entities.JDJS_WMS_Order_Guide_Schedu_Table.Add(guide); entities.SaveChanges(); var queue = new JDJS_WMS_Order_Queue_Table { OrderID = orderIdNew, isFlag = 3 }; entities.JDJS_WMS_Order_Queue_Table.Add(queue); entities.SaveChanges(); date.Commit(); PathInfo pathInfo = new PathInfo(); var NewFolder = Path.Combine(pathInfo.upLoadPath(), strOrderNum + flagStr); var OldFolder = Path.Combine(pathInfo.upLoadPath(), OldOrder.Order_Number); List <string> srcPath = new List <string>(); string[] src = Directory.GetFileSystemEntries(OldFolder); foreach (var item in src) { copyDir(item, NewFolder, strOrderNum + flagStr); } context.Response.Write("ok"); return; } catch (Exception ex) { date.Rollback(); context.Response.Write(ex.Message); return; } } } #endregion }
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) { context.Response.ContentType = "text/plain"; var form = context.Request.Form; var file = context.Request.Files; var projectName = form["projectName"]; var intentionEndTime = Convert.ToDateTime(form["intentionEndTime"]); //预计评估完成时间 var remark = form["remark"]; //备注 var loginUserId = Convert.ToInt32(context.Session["id"]); int priority = 1; //优先级 // var folder = @"D:\服务器文件勿动\"+ form[0]; 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 = ""; 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 (int.Parse(form[0]) == 0) { var number = strOrderNum + flagStr; var Customer = form[6]; var judge = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == number); if (judge.Count() > 0) { context.Response.Write("该订单已存在"); return; } var row = new JDJS_WMS_Order_Entry_Table { Order_Number = strOrderNum + flagStr, Order_Leader = form[2], Product_Name = form[3], Product_Material = form[4], Product_Output = int.Parse(form[5]), ProjectName = projectName, CtratPersonID = loginUserId, Priority = priority, Intention = 5,//意向未提交 CreateTime = DateTime.Now, CreatePersonID = loginUserId, IntentionPlanEndTime = intentionEndTime, 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 == 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 newRow = new JDJS_WMS_Order_Intention_History_Table { OrderID = orderId, flag = 1, CreatPersonID = loginUserId, CreatTime = DateTime.Now, LastAlterPersonID = loginUserId, LastAlterTime = DateTime.Now }; entities.JDJS_WMS_Order_Intention_History_Table.Add(newRow); entities.SaveChanges(); //var orderNumber = form[0]; //var OrderID = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == orderNumber).First().Order_ID; //var flag = new JDJS_WMS_Order_Queue_Table //{ // OrderID = OrderID, // isFlag = 0 //}; //entities.JDJS_WMS_Order_Queue_Table.Add(flag); PathInfo pathInfo = new PathInfo(); var folder = Path.Combine(pathInfo.upLoadPath(), 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 { { System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer(); { //var form = context.Request.Form; //var file = context.Request.Files; //var folder = @"D:\服务器文件勿动\"+ form[0]; { { { PathInfo pathInfo = new PathInfo(); var NewOrderNumber = strOrderNum + flagStr; string Owner = form[2]; string OldOrderNumber = form[3]; string ProductName = form[4]; string ProductMater = form[5]; int OutPut = int.Parse(form[6]); var Customer = form[7]; var NewFolder = Path.Combine(pathInfo.upLoadPath(), NewOrderNumber); try { var number = NewOrderNumber; var judge = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == number); if (judge.Count() > 0) { Console.WriteLine("该订单已存在"); return; } var oldVirPerson = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == OldOrderNumber).FirstOrDefault().virtualProgPersId; var row = new JDJS_WMS_Order_Entry_Table { Order_Number = NewOrderNumber, Order_Leader = Owner, Product_Name = ProductName, Product_Material = ProductMater, Product_Output = OutPut, virtualProgPersId = oldVirPerson, ProjectName = projectName, Intention = 6, CtratPersonID = loginUserId, Priority = priority, CreateTime = DateTime.Now, CreatePersonID = loginUserId, IntentionPlanEndTime = intentionEndTime, 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 == number).FirstOrDefault().Order_ID; var newRow = new JDJS_WMS_Order_Intention_History_Table { OrderID = orderId }; entities.JDJS_WMS_Order_Intention_History_Table.Add(newRow); var newOrder = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == NewOrderNumber && r.Intention == 6).FirstOrDefault().Order_ID; JDJS_WMS_Order_Guide_Schedu_Table guide = new JDJS_WMS_Order_Guide_Schedu_Table() { OrderID = newOrder, ClientName = Customer }; entities.JDJS_WMS_Order_Guide_Schedu_Table.Add(guide); entities.SaveChanges(); var oldOrder = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == OldOrderNumber).FirstOrDefault(); int oldID = oldOrder.Order_ID; var oldprocess = entities.JDJS_WMS_Order_Process_Info_Table.Where(r => r.OrderID == oldID && r.sign == 0); foreach (var item in oldprocess) { JDJS_WMS_Order_Process_Info_Table info = new JDJS_WMS_Order_Process_Info_Table() { OrderID = newOrder, ProcessID = item.ProcessID, programName = item.programName, ProcessTime = item.ProcessTime, BlankNumber = item.BlankNumber, BlankSpecification = item.BlankSpecification, BlankType = item.BlankType, DeviceType = item.DeviceType, JigSpecification = item.JigSpecification, sign = 0, toolChartName = item.toolChartName, toolPreparation = item.toolPreparation }; entities.JDJS_WMS_Order_Process_Info_Table.Add(info); } entities.SaveChanges(); if (!Directory.Exists(NewFolder)) { Directory.CreateDirectory(NewFolder); } ; List <string> srcPath = new List <string>(); srcPath.Add(pathInfo.upLoadPath() + @"\" + OldOrderNumber + @"\" + @"客供图纸\"); srcPath.Add(pathInfo.upLoadPath() + @"\" + OldOrderNumber + @"\" + @"虚拟加工方案文档\"); foreach (var real in srcPath) { copyDir(real, NewFolder); } context.Response.Write("ok"); date.Commit(); } catch (Exception ex) { date.Rollback(); context.Response.Write(ex.Message); } } } } } { //string OrderNum = "1"; //List<string> Info = new List<string>(); //if (OrderNum != null && OrderNum != "") //{ // using (WmsAutoEntities wms = new WmsAutoEntities()) // { // var order = wms.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == OrderNum); // if (order.Count() > 0) // { // string name = order.First().Product_Name; // string material = order.First().Product_Material; // Info.Add(name); // Info.Add(material); // } // } //} //var json = serializer.Serialize(Info); } { //List<string> OrderNum = new List<string>(); //using (WmsAutoEntities wms = new WmsAutoEntities()) //{ // var Intention = wms.JDJS_WMS_Order_Intention_History_Table.ToList(); // foreach (var item in Intention) // { // int id = Convert.ToInt32(item.OrderID); // var order = wms.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_ID == id); // var str = order.First().Order_Number; // OrderNum.Add(str); // } //} //var json = serializer.Serialize(OrderNum); } } } } catch (Exception ex) { date.Rollback(); context.Response.Write(ex.Message); } } } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; var form = context.Request.Form; var file = context.Request.Files; PathInfo pathInfo = new PathInfo(); var folder = pathInfo.upLoadPath() + form[0]; using (JDJS_WMS_DB_USEREntities entities = new JDJS_WMS_DB_USEREntities()) { using (System.Data.Entity.DbContextTransaction date = entities.Database.BeginTransaction()) { try { var number = form[0]; var judge = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == number); if (judge.Count() > 0) { context.Response.Write("该订单已存在"); return; } var row = new JDJS_WMS_Order_Entry_Table { Order_Number = form[0], Order_Leader = form[1], Product_Name = form[2], Product_Material = form[3], Product_Output = int.Parse(form[4]), Order_Plan_End_Time = DateTime.Parse(form[5]), Order_State = form[6], Order_Plan_Start_Time = DateTime.Now }; entities.JDJS_WMS_Order_Entry_Table.Add(row); 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(); } catch (Exception ex) { date.Rollback(); context.Response.Write(ex.Message); } } } }
public void ProcessRequest(HttpContext context) { try { int fxDemandId = int.Parse(context.Request["fxDemandId"]); string remark = context.Request["remark"]; string productName = context.Request["productName"]; //产品名称 string projectName = context.Request["projectName"]; //项目名称 string clientName = context.Request["clientName"]; //客户名称 DateTime time = DateTime.Parse(context.Request["planEndTime"]); //计划完成时间 string leader = context.Request["leader"]; //订单责任人 int output = int.Parse(context.Request["output"]); //产量 int personId = int.Parse(context.Session["id"].ToString()); string personName = context.Session["UserName"].ToString(); using (JDJS_WMS_DB_USEREntities model = new JDJS_WMS_DB_USEREntities()) { var demand = model.JDJS_WMS_Fixture_Manage_Demand_Table.Where(r => r.ID == fxDemandId).FirstOrDefault(); if (demand == null) { context.Response.Write("该治具需求不存在"); return; } if (demand.State != "待审核") { context.Response.Write("该治具设计需求暂不支持审核"); return; } using (System.Data.Entity.DbContextTransaction mytran = model.Database.BeginTransaction()) { try { demand.State = "审核通过"; string str = demand.AuditRemark == null ? "" : demand.AuditRemark; demand.AuditRemark = str + DateTime.Now.ToString() + "</br>" + remark + "</br>"; demand.EndTime = DateTime.Now; //新建生产订单 JDJS_WMS_Order_Entry_Table jd = new JDJS_WMS_Order_Entry_Table() { Order_Leader = leader, Order_Number = demand.FixtureOrderNum, Product_Name = productName, Product_Material = demand.Material, Product_Output = output, Order_Plan_Start_Time = DateTime.Now, Order_Plan_End_Time = time, Order_State = "执行", ProofingORProduct = -1, Priority = 1, ProjectName = projectName, AuditResult = "审核通过", AuditAdvice = DateTime.Now.ToString() + ":" + "审核通过" + "\n", CreatePersonID = personId, craftPerson = personName, craftPersonId = personId, CtratPersonID = personId, CreateTime = DateTime.Now, Intention = 3, Remark = remark }; model.JDJS_WMS_Order_Entry_Table.Add(jd); model.SaveChanges(); var orderId = jd.Order_ID; JDJS_WMS_Order_Guide_Schedu_Table guide = new JDJS_WMS_Order_Guide_Schedu_Table() { OrderID = orderId, ClientName = clientName, }; model.JDJS_WMS_Order_Guide_Schedu_Table.Add(guide); model.SaveChanges(); mytran.Commit(); PathInfo pathInfo = new PathInfo(); var folder = Path.Combine(pathInfo.upLoadPath(), demand.FixtureOrderNum, @"客供图纸"); if (!Directory.Exists(folder)) { Directory.CreateDirectory(folder); } ; string path = System.IO.Path.Combine(pathInfo.upLoadPath(), @"特殊治具管理", demand.FixtureOrderNum, @"设计文件"); DirectoryInfo directoryInfo = new DirectoryInfo(path); foreach (var item in directoryInfo.GetFiles()) { item.CopyTo(Path.Combine(folder, item.Name), true); } context.Response.Write("ok"); return; } catch (Exception ex) { context.Response.Write(ex.Message); return; } } } } catch (Exception ex) { context.Response.Write(ex.Message); } }