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