public void ProcessRequest(HttpContext context) { try { int id = int.Parse(context.Request["id"]);//id using (FixtureModel model = new FixtureModel()) { var fx = model.JDJS_WMS_Fixture_System_Table.Where(r => r.Id == id).FirstOrDefault(); if (fx == null) { context.Response.Write("该治具不存在!"); return; } using (System.Data.Entity.DbContextTransaction mytran = model.Database.BeginTransaction()) { try { model.JDJS_WMS_Fixture_System_Table.Remove(fx); model.SaveChanges(); mytran.Commit(); PathInfo info = new PathInfo(); if (System.IO.File.Exists(System.IO.Path.Combine(info.GetFixtrue_SurfMillFilePath(), fx.FileName))) { System.IO.File.Delete(System.IO.Path.Combine(info.GetFixtrue_SurfMillFilePath(), fx.FileName)); } using (JDJS_WMS_DB_USEREntities wms = new JDJS_WMS_DB_USEREntities()) { var status = wms.JDJS_WMS_Device_Status_Table.Where(r => r.SystemId == id).FirstOrDefault(); if (status != null) { wms.JDJS_WMS_Device_Status_Table.Remove(status); } wms.SaveChanges(); } string str = ""; Fixture_SurfMill.DeleteChildJIG(fx.Name, fx.Desc, fx.StockAllNum.ToString(), fx.StockCurrNum.ToString(), ref str); context.Response.Write(str); return; } catch (Exception ex) { mytran.Rollback(); context.Response.Write(ex.Message); return; } } } } catch (Exception ex) { context.Response.Write(ex.Message); return; } }
public void ProcessRequest(HttpContext context) { try { string typeName = context.Request["typeName"]; using (FixtureModel model = new FixtureModel()) { var type = model.JDJS_WMS_Fixture_Type_Table.Where(r => r.Type == typeName).FirstOrDefault(); if (type != null) { context.Response.Write("该治具种类已存在!"); return; } using (System.Data.Entity.DbContextTransaction mytran = model.Database.BeginTransaction()) { try { JDJS_WMS_Fixture_Type_Table jd = new JDJS_WMS_Fixture_Type_Table() { Type = typeName }; model.JDJS_WMS_Fixture_Type_Table.Add(jd); model.SaveChanges(); mytran.Commit(); context.Response.Write("ok"); return; } catch (Exception ex) { mytran.Rollback(); context.Response.Write(ex.Message); return; } } } } catch (Exception ex) { context.Response.Write(ex.Message); return; } }
public void ProcessRequest(HttpContext context) { try { int id = int.Parse(context.Request["id"]); using (FixtureModel model = new FixtureModel()) { var fx = model.JDJS_WMS_Fixture_Type_Table.Where(r => r.Id == id).FirstOrDefault(); if (fx == null) { context.Response.Write("该治具种类不存在!"); return; } using (System.Data.Entity.DbContextTransaction mytran = model.Database.BeginTransaction()) { try { model.JDJS_WMS_Fixture_Type_Table.Remove(fx); model.SaveChanges(); mytran.Commit(); context.Response.Write("ok"); return; } catch (Exception ex) { mytran.Rollback(); context.Response.Write(ex.Message); return; } } } } catch (Exception ex) { context.Response.Write(ex.Message); return; } }
public void ProcessRequest(HttpContext context) { try { int typeId = int.Parse(context.Request["typeId"]); //治具种类id int temFixId = int.Parse(context.Request["temFixId"]); //临时治具ID string fixOrderNum = context.Request["fixOrderNum"]; //治具订单编号 string name = context.Request["name"]; //治具名称//唯一 string venderName = context.Request["venderName"]; //厂家名称,默认给"JD" string desc = context.Request["desc"]; //描述 string remark = context.Request["remark"]; //备注 int currCount = int.Parse(context.Request["currCount"]); //当前库存 int allCount = int.Parse(context.Request["allCount"]); //库存总量 var file = context.Request.Files; //文件 using (FixtureModel model = new FixtureModel()) { var fx = model.JDJS_WMS_Fixture_System_Table.Where(r => r.Name == name).FirstOrDefault(); if (fx != null) { context.Response.Write("该治具名称已存在!"); return; } if (file.Count < 1) { context.Response.Write("请输入文件!"); return; } int fxNum = 1; fx = model.JDJS_WMS_Fixture_System_Table.Where(r => r.FXNum == fxNum).FirstOrDefault(); while (fx != null) { fxNum++; fx = model.JDJS_WMS_Fixture_System_Table.Where(r => r.FXNum == fxNum).FirstOrDefault(); } using (System.Data.Entity.DbContextTransaction mytran = model.Database.BeginTransaction()) { try { var temfx = model.JDJS_WMS_Fixture_Temporary_Table.Where(r => r.Id == temFixId).FirstOrDefault(); if (temfx != null) { model.JDJS_WMS_Fixture_Temporary_Table.Remove(temfx); } JDJS_WMS_Fixture_System_Table jd = new JDJS_WMS_Fixture_System_Table() { AlterTime = DateTime.Now, CreateTime = DateTime.Now, Desc = desc, FileName = file[0].FileName, FixtureOrderNum = fixOrderNum, FXNum = fxNum, Name = name, Remark = remark, SerialCode = fxNum.ToString(), StockAllNum = allCount, StockCurrNum = currCount, TypeId = typeId, VenderName = venderName }; model.JDJS_WMS_Fixture_System_Table.Add(jd); model.SaveChanges(); mytran.Commit(); PathInfo info = new PathInfo(); for (int i = 0; i < file.Count; i++) { file[i].SaveAs(System.IO.Path.Combine(info.GetFixtrue_SurfMillFilePath(), file[i].FileName)); } string str = ""; Fixture_SurfMill.AddChildJIG(name, desc, file[0].FileName, allCount.ToString(), currCount.ToString(), ref str, venderName, fxNum.ToString()); using (JDJS_WMS_DB_USEREntities wms = new JDJS_WMS_DB_USEREntities()) { JDJS_WMS_Device_Status_Table ststus = new JDJS_WMS_Device_Status_Table() { explain = desc, Status = name, SystemId = jd.Id }; wms.JDJS_WMS_Device_Status_Table.Add(ststus); wms.SaveChanges(); } context.Response.Write(str); return; } catch (Exception ex) { mytran.Rollback(); context.Response.Write(ex.Message); return; } } } } catch (Exception ex) { context.Response.Write(ex.Message); return; } }
public void ProcessRequest(HttpContext context) { var orderId = int.Parse(context.Request["orderId"]); var warehousingNumber = int.Parse(context.Request["warehousingNumber"]); var defectiveProductNumber = int.Parse(context.Request["defectiveProductNumber"]); var loginUserId = Convert.ToInt32(context.Session["id"]); using (JDJS_WMS_DB_USEREntities entities = new JDJS_WMS_DB_USEREntities()) { var row = entities.JDJS_WMS_Finished_Product_Manager.Where(r => r.OrderID == orderId); if (row.Count() > 0) { var count = Convert.ToInt32(row.FirstOrDefault().warehousingNumber); count += warehousingNumber; row.FirstOrDefault().waitForWarehousing -= (warehousingNumber + defectiveProductNumber); //待入库数 row.FirstOrDefault().warehousingNumber += warehousingNumber; //入库数 row.FirstOrDefault().stock += warehousingNumber; //库存数 row.FirstOrDefault().warehousingTime = DateTime.Now; row.FirstOrDefault().DefectiveProductNumber += defectiveProductNumber; JDJS_WMS_Finished_Product_In_History_Manager jDJS_WMS_Finished_Product_In_History_Manager = new JDJS_WMS_Finished_Product_In_History_Manager() { Num = warehousingNumber, OrderID = orderId, Time = DateTime.Now }; entities.JDJS_WMS_Finished_Product_In_History_Manager.Add(jDJS_WMS_Finished_Product_In_History_Manager); JDJS_WMS_Finished_Defective_Product_In_History_Manager jd = new JDJS_WMS_Finished_Defective_Product_In_History_Manager() { CreatPersonID = loginUserId, CreatTime = DateTime.Now, InNumber = defectiveProductNumber, OrderID = orderId, Time = DateTime.Now }; entities.JDJS_WMS_Finished_Defective_Product_In_History_Manager.Add(jd); entities.SaveChanges(); var order = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_ID == orderId).FirstOrDefault(); if (order != null) { if (count >= order.Product_Output) { order.Intention = 4; order.Order_Actual_End_Time = DateTime.Now; //检测是否为特殊治具订单,是的话将其填入临时治具库 if (order.Order_Number.StartsWith("FX")) { string str = ""; var info = entities.JDJS_WMS_Fixture_Manage_Demand_Table.Where(r => r.FixtureOrderNum == order.Order_Number).FirstOrDefault(); if (info != null) { str = info.FixtureSpecification; } //加入临时治具库 using (FixtureModel model = new FixtureModel()) { JDJS_WMS_Fixture_Temporary_Table jdTem = new JDJS_WMS_Fixture_Temporary_Table() { Name = order.Product_Name, Remark = "", FixtureOrderNum = order.Order_Number, FixtureSpecification = str, InTime = DateTime.Now, StockNum = row.FirstOrDefault().warehousingNumber }; model.JDJS_WMS_Fixture_Temporary_Table.Add(jdTem); model.SaveChanges(); } } } } } entities.SaveChanges(); context.Response.Write("ok"); } }
public void ProcessRequest(HttpContext context) { try { int id = int.Parse(context.Request["id"]); //治具种类id int typeId = int.Parse(context.Request["typeId"]); //治具种类id string name = context.Request["name"]; //治具名称//唯一 string venderName = context.Request["venderName"]; //厂家名称,默认给"JD" string desc = context.Request["desc"]; //描述 string remark = context.Request["remark"]; //备注 int currCount = int.Parse(context.Request["currCount"]); //当前库存 int allCount = int.Parse(context.Request["allCount"]); //库存总量 var file = context.Request.Files; //文件 using (FixtureModel model = new FixtureModel()) { var fx = model.JDJS_WMS_Fixture_System_Table.Where(r => r.Name == name && r.Id != id).FirstOrDefault(); if (fx != null) { context.Response.Write("该治具名称已存在!"); return; } fx = model.JDJS_WMS_Fixture_System_Table.Where(r => r.Id == id).FirstOrDefault(); using (System.Data.Entity.DbContextTransaction mytran = model.Database.BeginTransaction()) { try { fx.AlterTime = DateTime.Now; fx.Desc = desc; fx.Name = name; fx.Remark = remark; fx.StockAllNum = allCount; fx.StockCurrNum = currCount; fx.TypeId = typeId; fx.VenderName = venderName; string fileName = fx.FileName; if (file != null && file.Count > 0) { PathInfo info1 = new PathInfo(); if (System.IO.File.Exists(System.IO.Path.Combine(info1.GetFixtrue_SurfMillFilePath(), fileName))) { System.IO.File.Delete(System.IO.Path.Combine(info1.GetFixtrue_SurfMillFilePath(), fileName)); } for (int i = 0; i < file.Count; i++) { file[i].SaveAs(System.IO.Path.Combine(info1.GetFixtrue_SurfMillFilePath(), file[i].FileName)); fileName = file[i].FileName; } } model.SaveChanges(); mytran.Commit(); using (JDJS_WMS_DB_USEREntities wms = new JDJS_WMS_DB_USEREntities()) { var status = wms.JDJS_WMS_Device_Status_Table.Where(r => r.SystemId == id).FirstOrDefault(); if (status != null) { status.Status = name; status.explain = desc; } wms.SaveChanges(); } PathInfo info = new PathInfo(); for (int i = 0; i < file.Count; i++) { file[i].SaveAs(System.IO.Path.Combine(info.GetFixtrue_SurfMillFilePath(), file[i].FileName)); } string str = ""; Fixture_SurfMill.AlterChildJIG(name, desc, fileName, allCount.ToString(), currCount.ToString(), ref str, venderName, fx.SerialCode.ToString()); context.Response.Write(str); return; } catch (Exception ex) { mytran.Rollback(); context.Response.Write(ex.Message); return; } } } } catch (Exception ex) { context.Response.Write(ex.Message); return; } }