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