public void ProcessRequest(HttpContext context) { var loginUserID = Convert.ToInt32(context.Session["id"]); var loginName = context.Session["UserName"].ToString(); string str = context.Request.Form["flag"];//下推or撤销 using (JDJS_WMS_DB_USEREntities entities = new JDJS_WMS_DB_USEREntities()) { var form = context.Request.Form; for (int i = 0; i < form.Count - 4; i++) { var orderId = int.Parse(form[i]); if (str == "下推") { DateTime time = Convert.ToDateTime(context.Request.Form["time"]);//下推or撤销 var output = Convert.ToInt32(context.Request.Form["Product_Output"]); var pattern = int.Parse(context.Request.Form["pattern"]); var row = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_ID == orderId); //if (row.FirstOrDefault().Order_Leader != loginName /*&& row.FirstOrDefault().CtratPersonID != loginUserID*/) //{ // context.Response.Write(String.Format("该订单负责人为{0},当前登录用户没有修改订单权限!", row.FirstOrDefault().Order_Leader)); // return; //} int outputOld = row.First().Product_Output; string pattonOld = (Convert.ToInt32(row.First().ProofingORProduct)) == -1?"大批量":"小批量"; string pattonNew = (pattern) == -1 ? "大批量" : "小批量"; int rowID = row.FirstOrDefault().Order_ID; if (row.First().Intention == 3) { context.Response.Write("已下推"); return; } row.First().AuditResult = "待审核"; row.First().Order_Plan_End_Time = time; row.First().Intention = 3; row.First().Product_Output = output; row.First().ProofingORProduct = pattern; row.First().Engine_Program_ManagerId = null; var virtualProgPersId = row.First().virtualProgPersId; if (entities.JDJS_WMS_Staff_Info.Where(r => r.id == virtualProgPersId).Count() == 0) { context.Response.Write("虚拟方案未完成不可下推"); return; } var name = entities.JDJS_WMS_Staff_Info.Where(r => r.id == virtualProgPersId).First().staff; row.First().Engine_Program_Manager = null; var his = entities.JDJS_WMS_Order_Intention_History_Table.Where(r => r.OrderID == rowID).FirstOrDefault(); if (his != null) { his.CraftPersonID = virtualProgPersId; his.LastAlterPersonID = loginUserID; his.LastAlterTime = DateTime.Now; } JDJS_WMS_Order_Alter_History_Table jd = new JDJS_WMS_Order_Alter_History_Table() { AlterDecs = String.Format("下推订单,订单数量由{0}修改为{1},{2}修改为{3}", outputOld, output, pattonOld, pattonNew), CreatPersonID = loginUserID, CreatTime = DateTime.Now, OrderID = orderId }; entities.JDJS_WMS_Order_Alter_History_Table.Add(jd); } else { var row = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_ID == orderId); int rowID = row.FirstOrDefault().Order_ID; if (row.First().Intention == -2) { context.Response.Write("已撤销"); return; } row.First().Intention = -2; var virtualProgPersId = row.First().virtualProgPersId; var name = entities.JDJS_WMS_Staff_Info.Where(r => r.id == virtualProgPersId).First().staff; JDJS_WMS_Order_Alter_History_Table jd = new JDJS_WMS_Order_Alter_History_Table() { AlterDecs = "撤销订单", CreatPersonID = loginUserID, CreatTime = DateTime.Now, OrderID = orderId }; entities.JDJS_WMS_Order_Alter_History_Table.Add(jd); } } entities.SaveChanges(); } context.Response.Write("ok"); }
public void ProcessRequest(HttpContext context) { var loginUserID = Convert.ToInt32(context.Session["id"]); var loginName = context.Session["UserName"]; int priorityNew = Convert.ToInt32(context.Request.Form["Priority"]); int priorityOld = 1; 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; var intention = form["intention"]; var orderId = int.Parse(form["orderId"]); var Order_Number = form["Order_Number"]; var Order_Leader = form["Order_Leader"]; var Product_Name = form["Product_Name"]; var Product_Material = form["Product_Material"]; var Product_Output = int.Parse(form["Product_Output"]); var ProjectName = form["ProjectName"]; var ClientName = form["ClientName"]; var remark = form["remark"]; var planEndTime = Convert.ToDateTime(form["planEndTime"]); var rows = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == Order_Number); foreach (var item in rows) { if (item.Order_ID != orderId) { context.Response.Write("该订单已存在"); return; } } var row1 = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_ID == orderId); priorityOld = Convert.ToInt32(row1.FirstOrDefault().Priority); if (priorityNew != priorityOld && priorityNew != 0) { var person = entities.JDJS_WMS_Staff_Info.Where(r => r.id == loginUserID).FirstOrDefault(); if (person != null) { if (!person.limit.Split(',').Contains("优先级修改")) { row1.FirstOrDefault().Priority = priorityNew; } } if (row1.Count() > 0) { if (row1.FirstOrDefault().Order_Leader == loginName || row1.FirstOrDefault().CtratPersonID == loginUserID) { //context.Response.Write(String.Format("该订单负责人为{0},当前登录用户没有修改订单权限!", loginName)); if (intention == "5") { row1.FirstOrDefault().Remark = remark; row1.FirstOrDefault().IntentionPlanEndTime = planEndTime; row1.FirstOrDefault().Order_Number = Order_Number; row1.FirstOrDefault().Order_Leader = Order_Leader; row1.FirstOrDefault().Product_Name = Product_Name; row1.FirstOrDefault().Product_Material = Product_Material; row1.FirstOrDefault().Product_Output = Product_Output; row1.FirstOrDefault().ProjectName = ProjectName; var guide = entities.JDJS_WMS_Order_Guide_Schedu_Table.Where(r => r.OrderID == orderId).FirstOrDefault(); if (guide != null) { guide.ClientName = ClientName; } entities.SaveChanges(); context.Response.Write("ok"); } else if (intention == "6") { row1.FirstOrDefault().Remark = remark; row1.FirstOrDefault().IntentionPlanEndTime = planEndTime; row1.FirstOrDefault().Order_Number = Order_Number; row1.FirstOrDefault().Order_Leader = Order_Leader; row1.FirstOrDefault().Product_Output = Product_Output; row1.FirstOrDefault().Product_Output = Product_Output; row1.FirstOrDefault().ProjectName = ProjectName; var guide = entities.JDJS_WMS_Order_Guide_Schedu_Table.Where(r => r.OrderID == orderId).FirstOrDefault(); if (guide != null) { guide.ClientName = ClientName; } entities.SaveChanges(); context.Response.Write("ok"); } else if (intention == "1") { row1.FirstOrDefault().Remark = remark; row1.FirstOrDefault().IntentionPlanEndTime = planEndTime; row1.FirstOrDefault().Product_Output = Product_Output; entities.SaveChanges(); context.Response.Write("ok"); } JDJS_WMS_Order_Alter_History_Table jd = new JDJS_WMS_Order_Alter_History_Table() { AlterDecs = "修改优先级", CreatPersonID = loginUserID, CreatTime = DateTime.Now, OrderID = orderId }; entities.JDJS_WMS_Order_Alter_History_Table.Add(jd); } } } else { if (row1.Count() > 0) { if (row1.FirstOrDefault().Order_Leader != loginName && row1.FirstOrDefault().CtratPersonID != loginUserID) { context.Response.Write(String.Format("该订单负责人为{0},当前登录用户没有修改订单权限!", row1.FirstOrDefault().Order_Leader)); return; } } if (intention == "5") { var row = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_ID == orderId); row.FirstOrDefault().Remark = remark; row.FirstOrDefault().IntentionPlanEndTime = planEndTime; row.FirstOrDefault().Order_Number = Order_Number; row.FirstOrDefault().Order_Leader = Order_Leader; row.FirstOrDefault().Product_Name = Product_Name; row.FirstOrDefault().Product_Material = Product_Material; row.FirstOrDefault().Product_Output = Product_Output; row.FirstOrDefault().Product_Output = Product_Output; row.FirstOrDefault().ProjectName = ProjectName; var guide = entities.JDJS_WMS_Order_Guide_Schedu_Table.Where(r => r.OrderID == orderId).FirstOrDefault(); if (guide != null) { guide.ClientName = ClientName; } entities.SaveChanges(); context.Response.Write("ok"); } else if (intention == "6") { var row = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_ID == orderId); row.FirstOrDefault().Remark = remark; row.FirstOrDefault().IntentionPlanEndTime = planEndTime; row.FirstOrDefault().Order_Number = Order_Number; row.FirstOrDefault().Order_Leader = Order_Leader; row.FirstOrDefault().Product_Output = Product_Output; row.FirstOrDefault().Product_Output = Product_Output; row.FirstOrDefault().ProjectName = ProjectName; var guide = entities.JDJS_WMS_Order_Guide_Schedu_Table.Where(r => r.OrderID == orderId).FirstOrDefault(); if (guide != null) { guide.ClientName = ClientName; } entities.SaveChanges(); context.Response.Write("ok"); } else if (intention == "1") { var row = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_ID == orderId); row.FirstOrDefault().Remark = remark; row.FirstOrDefault().IntentionPlanEndTime = planEndTime; row.FirstOrDefault().Product_Output = Product_Output; entities.SaveChanges(); context.Response.Write("ok"); } JDJS_WMS_Order_Alter_History_Table jd = new JDJS_WMS_Order_Alter_History_Table() { AlterDecs = "修改订单数量", CreatPersonID = loginUserID, CreatTime = DateTime.Now, OrderID = orderId }; entities.JDJS_WMS_Order_Alter_History_Table.Add(jd); } db.Commit(); } catch (Exception ex) { db.Rollback(); context.Response.Write(ex.Message); } } } }