public void ProcessRequest(HttpContext context)
{
var orderId = int.Parse(context.Request["orderId"]);
var time = Convert.ToDateTime(context.Request["time"]);
using (JDJS_WMS_DB_USEREntities wms = new JDJS_WMS_DB_USEREntities())
{
using (System.Data.Entity.DbContextTransaction mytran = wms.Database.BeginTransaction())
{
try
{
{
int OrderID = orderId;
var delayInfo = wms.JDJS_WMS_Order_Blank_Table.Where(r => r.OrderID == OrderID);
{
foreach (var item in delayInfo)
{
item.Expected_Completion_Time = time;
}
wms.SaveChanges();
}
}
wms.SaveChanges();
mytran.Commit();
context.Response.Write("ok");
}
catch (Exception ex)
{
mytran.Rollback();
context.Response.Write(ex.Message);
}
}
}
}
public void ProcessRequest(HttpContext context)
{
{
int OrderID = int.Parse(context.Request["orderId"]);
System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
List <string> str = new List <string>();
using (JDJS_WMS_DB_USEREntities wms = new JDJS_WMS_DB_USEREntities())
{
using (System.Data.Entity.DbContextTransaction date = wms.Database.BeginTransaction())
{
try
{
List <int> processid = new List <int>();
var process = wms.JDJS_WMS_Order_Process_Info_Table.Where(r => r.OrderID == OrderID && r.sign != 0);
foreach (var item in process)
{
if (!processid.Contains(Convert.ToInt32(item.ProcessID)))
{
processid.Add(Convert.ToInt32(item.ProcessID));
}
}
processid.Sort();
List <int> ProcessId = new List <int>();
foreach (var item in processid)
{
var processed = wms.JDJS_WMS_Order_Process_Info_Table.Where(r => r.OrderID == OrderID && r.sign != 0 && r.ProcessID == item);
ProcessId.Add(Convert.ToInt32(processed.FirstOrDefault().ID));
}
foreach (var item in ProcessId)
{
List <int> CncID = new List <int>();
var mach = wms.JDJS_WMS_Order_Process_Scheduling_Table.Where(r => r.ProcessID == item && r.isFlag != 0);
foreach (var real in mach)
{
if (!CncID.Contains(Convert.ToInt32(real.CncID)))
{
CncID.Add(Convert.ToInt32(real.CncID));
}
}
var fix = wms.JDJS_WMS_Order_Fixture_Manager_Table.Where(r => r.ProcessID == item);
fix.FirstOrDefault().FixtureNumber = CncID.Count();
wms.SaveChanges();
str.Add(CncID.Count().ToString());
}
wms.SaveChanges();
date.Commit();
}
catch (Exception ex)
{
date.Rollback();
context.Response.Write(ex.Message);
}
}
}
var json = serializer.Serialize(str);
context.Response.Write("ok");
}
}
public void ProcessRequest(HttpContext context)
{
try
{
var processId = int.Parse(context.Request["processId"]);
var process = int.Parse(context.Request["process"]);
var time = context.Request["time"];
var deviceType = context.Request["deviceType"];
var cncNumber = context.Request["cncNumber"];
using (JDJS_WMS_DB_USEREntities entities = new JDJS_WMS_DB_USEREntities())
{
var row = entities.JDJS_WMS_Order_Process_Info_Table.Where(r => r.ProcessID == process & r.sign == 0);
if (row.Count() > 0)
{
//if (row.First().ID != processId)
//{
// context.Response.Write("该工序已存在");
// return;
//}
}
var rowEdit = entities.JDJS_WMS_Order_Process_Info_Table.Where(r => r.ID == processId);
rowEdit.First().ProcessID = process;
rowEdit.First().ProcessTime = double.Parse(time);
rowEdit.First().DeviceType = int.Parse(deviceType);
rowEdit.First().MachNumber = int.Parse(cncNumber);
entities.SaveChanges();
context.Response.Write("ok");
}
}
catch (Exception ex)
{
context.Response.Write(ex.Message);
}
}
public void ProcessRequest(HttpContext context)
{
var data = context.Request["data"];
System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
var obj = serializer.Deserialize <SizeEditSub>(data);
using (JDJS_WMS_DB_USEREntities entities = new JDJS_WMS_DB_USEREntities())
{
var id = int.Parse(obj.ID);
var row = entities.JDJS_WMS_Quality_ManualInput_Measurement_Table.Where(r => r.ID == id);
if (row.Count() > 0)
{
row.First().Measurements = Convert.ToDouble(obj.Measurements);
row.First().SizeName = obj.SizeName;
row.First().SizeNumber = int.Parse(obj.SizeNumber);
row.First().StandardValue = Convert.ToDouble(obj.StandardValue);
row.First().ToleranceRangeMax = Convert.ToDouble(obj.ToleranceRangeMax);
row.First().ToleranceRangeMin = Convert.ToDouble(obj.ToleranceRangeMin);
}
entities.SaveChanges();
context.Response.Write("ok");
}
}
public void ProcessRequest(HttpContext context)
{
try {
var orderId = int.Parse(context.Request.QueryString["orderId"]);
using (JDJS_WMS_DB_USEREntities entities = new JDJS_WMS_DB_USEREntities())
{
var rows = entities.JDJS_WMS_Order_Process_Info_Table.Where(r => r.OrderID == orderId & r.sign == -1);
if (rows.Count() < 1)
{
context.Response.Write("暂无需提交审核工序");
return;
}
foreach (var item in entities.JDJS_WMS_Order_Process_Info_Table.Where(r => r.OrderID == orderId && r.sign != 0))
{
item.sign = -2;
}
entities.SaveChanges();
context.Response.Write("ok");
}
}
catch (Exception ex)
{
context.Response.Write(ex.Message);
}
}
public void ProcessRequest(HttpContext context)
{
int PlanId = int.Parse(context.Request["MaintenacneID"]);
int enable = int.Parse(context.Request["MaintenanceEnable"]);
using (JDJS_WMS_DB_USEREntities wms = new JDJS_WMS_DB_USEREntities())
{
using (System.Data.Entity.DbContextTransaction mytran = wms.Database.BeginTransaction())
{
try
{
var plan = wms.JDJS_WMS_Device_Accuracy_Verification_Plan.Where(r => r.ID == PlanId);
foreach (var item in plan)
{
item.isFlag = enable;
}
wms.SaveChanges();
mytran.Commit();
}
catch
{
mytran.Rollback();
}
}
}
context.Response.Write("ok");
}
/// <summary>
/// 治具异常报备
/// </summary>
/// <param name="id">工序id</param>
/// <returns></returns>
public bool AbnormalSubmit(int id, ref string errMsg)
{
try
{
using (JDJS_WMS_DB_USEREntities wms = new JDJS_WMS_DB_USEREntities())
{
var processes = wms.JDJS_WMS_Order_Fixture_Manager_Table.Where(r => r.ProcessID == id);
using (System.Data.Entity.DbContextTransaction mytran = wms.Database.BeginTransaction())
{
try
{
foreach (var item in processes)
{
item.FixtureFinishPerpareNumber = 0;
}
wms.SaveChanges();
errMsg = "ok";
mytran.Commit();
return(true);
}
catch (Exception ex)
{
mytran.Rollback();
errMsg = ex.Message;
return(false);
}
}
}
}
catch (Exception ex)
{
errMsg = ex.Message;
return(false);
}
}
public void ProcessRequest(HttpContext context)
{
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;
for (int i = 0; i < form.Count; i++)
{
var id = int.Parse(form[i]);
var row = entities.JDJS_WMS_Quality_ManualInput_Measurement_Table.Where(r => r.ID == id);
if (row.Count() > 0)
{
entities.JDJS_WMS_Quality_ManualInput_Measurement_Table.Remove(row.FirstOrDefault());
}
}
entities.SaveChanges();
db.Commit();
context.Response.Write("ok");
}
catch (Exception ex)
{
db.Rollback();
context.Response.Write(ex.Message);
}
}
}
}
public void ProcessRequest(HttpContext context)
{
System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
var form = context.Request["form"];
var orderId = int.Parse(context.Request["orderId"]);
var workpieceNumber = int.Parse(context.Request["workpieceNumber"]);
var obj = serializer.Deserialize <AddSize>(form);
using (JDJS_WMS_DB_USEREntities entities = new JDJS_WMS_DB_USEREntities())
{
var row = new JDJS_WMS_Quality_ManualInput_Measurement_Table
{
OrderID = orderId,
WorkpieceNumber = workpieceNumber,
SizeNumber = int.Parse(obj.SizeNumber),
SizeName = obj.SizeName,
StandardValue = double.Parse(obj.StandardValue),
ToleranceRangeMin = double.Parse(obj.ToleranceRangeMin),
ToleranceRangeMax = double.Parse(obj.ToleranceRangeMax),
Measurements = double.Parse(obj.Measurements),
};
entities.JDJS_WMS_Quality_ManualInput_Measurement_Table.Add(row);
entities.SaveChanges();
context.Response.Write("ok");
}
}
public void ProcessRequest(HttpContext context)
{
try
{
var orderId = int.Parse(context.Request.Form["orderId"]);
var time = Convert.ToDateTime(context.Request.Form["time"]);
var loginID = Convert.ToInt32(context.Session["id"]);
using (JDJS_WMS_DB_USEREntities wms = new JDJS_WMS_DB_USEREntities())
{
var order = wms.JDJS_WMS_Order_Machine_Scheduing_Time_Table.Where(r => r.OrderID == orderId).FirstOrDefault();
if (order == null)
{
JDJS_WMS_Order_Machine_Scheduing_Time_Table jd = new JDJS_WMS_Order_Machine_Scheduing_Time_Table()
{
OrderID = orderId,
PlanPersonID = loginID,
PlanEndTime = time
};
wms.JDJS_WMS_Order_Machine_Scheduing_Time_Table.Add(jd);
}
else
{
order.PlanEndTime = time;
order.PlanPersonID = loginID;
}
wms.SaveChanges();
}
context.Response.Write("ok");
}
catch (Exception ex)
{
context.Response.Write(ex.Message);
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
var brand = context.Request["brand"];
using (JDJS_WMS_DB_USEREntities data = new JDJS_WMS_DB_USEREntities())
{
var data2 =
from brands in data.JDJS_WMS_Device_Brand_Info
where brands.Brand == brand
select new
{
brands.Brand
};
System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
var data3 = serializer.Serialize(data2);
if (data3 == "[]")
{
var data4 = new JDJS_WMS_Device_Brand_Info()
{
Brand = brand
};
data.JDJS_WMS_Device_Brand_Info.Add(data4);
data.SaveChanges();
context.Response.Write("ok");
}
else
{
context.Response.Write("false");
}
}
}
public void ProcessRequest(HttpContext context)
{
var Id = int.Parse(context.Request.Form["Id"]);
string str = "";
try
{
using (JDJS_WMS_DB_USEREntities entities = new JDJS_WMS_DB_USEREntities())
{
var rows = entities.JDJS_WMS_Tool_Machine_Replaace_History_Table.Where(r => r.ID == Id);
if (rows.Count() > 0)
{
var userId = int.Parse(context.Session["id"].ToString());
rows.First().Flag = 1;
rows.First().AcceptPersonID = userId;
rows.First().AcceptPersonTime = DateTime.Now;
entities.SaveChanges();
str = "ok";
}
else
{
str = "该记录不存在";
}
}
}
catch (Exception ex)
{
str = ex.Message;
}
finally
{
context.Response.Write(str);
}
}
public void ProcessRequest(HttpContext context)
{
var processId = int.Parse(context.Request["processId"]);
var time = Convert.ToDateTime(context.Request["time"]);
using (JDJS_WMS_DB_USEREntities wms = new JDJS_WMS_DB_USEREntities())
{
using (System.Data.Entity.DbContextTransaction mytran = wms.Database.BeginTransaction())
{
try
{
var processInfo = wms.JDJS_WMS_Order_Process_Info_Table.Where(r => r.ID == processId).FirstOrDefault();
processInfo.Jig_Expected_Completion_Time = time;
wms.SaveChanges();
mytran.Commit();
context.Response.Write("ok");
}
catch (Exception ex)
{
mytran.Rollback();
context.Response.Write(ex.Message);
}
}
}
}
public void ProcessRequest(HttpContext context)
{
var orderId = int.Parse(context.Request["orderId"]);
var outputNumber = int.Parse(context.Request["outputNumber"]);
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)
{
if (row.First().stock >= outputNumber)
{
var order = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_ID == orderId);
int produstOUT = order.First().Product_Output;
int outnum = Convert.ToInt32(row.FirstOrDefault().outputNumber);
row.FirstOrDefault().stock -= outputNumber;
row.FirstOrDefault().outputNumber += outputNumber;
row.FirstOrDefault().outputTime = DateTime.Now;
JDJS_WMS_Finished_Product_OutPut_History_Manager jdjsout = new JDJS_WMS_Finished_Product_OutPut_History_Manager()
{
OrderID = orderId,
OutPutNum = outputNumber,
Time = DateTime.Now
};
entities.JDJS_WMS_Finished_Product_OutPut_History_Manager.Add(jdjsout);
entities.SaveChanges();
if (outnum + outputNumber >= produstOUT)
{
foreach (var item in order)
{
item.Intention = 4;
}
}
entities.SaveChanges();
}
else
{
context.Response.Write("库存不足");
return;
}
}
entities.SaveChanges();
context.Response.Write("ok");
}
}
public void ProcessRequest(HttpContext context)
{
var processId = int.Parse(context.Request["processId"]);
var time = Convert.ToDateTime(context.Request["time"]);
using (JDJS_WMS_DB_USEREntities wms = new JDJS_WMS_DB_USEREntities())
{
using (System.Data.Entity.DbContextTransaction mytran = wms.Database.BeginTransaction())
{
try
{
var processInfo = wms.JDJS_WMS_Order_Process_Info_Table.Where(r => r.ID == processId).FirstOrDefault();
if (processInfo != null)
{
int OrderID = Convert.ToInt32(processInfo.OrderID);
var delayInfo = wms.JDJS_WMS_Order_DelayTime_Table.Where(r => r.OrderID == OrderID);
if (delayInfo.Count() < 1)
{
JDJS_WMS_Order_DelayTime_Table delay = new JDJS_WMS_Order_DelayTime_Table()
{
OrderID = OrderID,
ToolTime = time,
};
wms.JDJS_WMS_Order_DelayTime_Table.Add(delay);
wms.SaveChanges();
}
else
{
foreach (var item in delayInfo)
{
item.ToolTime = time;
}
wms.SaveChanges();
}
}
wms.SaveChanges();
mytran.Commit();
context.Response.Write("ok");
}
catch (Exception ex)
{
mytran.Rollback();
context.Response.Write(ex.Message);
}
}
}
}
public void ProcessRequest(HttpContext context)
{
try
{
context.Response.ContentType = "text/plain";
var form = context.Request.Form;
var type = form["type"];
var numberId = int.Parse(form["id"]);
var progId = int.Parse(form["prog"]);
var progIdOld = int.Parse(form["progOld"]);
var techIdOld = int.Parse(form["techOld"]);
using (JDJS_WMS_DB_USEREntities entities = new JDJS_WMS_DB_USEREntities())
{
if (type == "生产订单")
{
entities.JDJS_WMS_Order_Guide_Schedu_Table.Where(r => r.OrderID == numberId).FirstOrDefault().FileDownTime = DateTime.Now;
entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_ID == numberId).First().Engine_Program_Manager =
entities.JDJS_WMS_Staff_Info.Where(r => r.id == progId).First().staff;
entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_ID == numberId).First().craftPerson =
entities.JDJS_WMS_Staff_Info.Where(r => r.id == progId).First().staff;
entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_ID == numberId).First().Engine_Program_ManagerId = progId;
entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_ID == numberId).First().virtualProgPersId = progId;
entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_ID == numberId).First().craftPersonId = progId;
entities.SaveChanges();
context.Response.Write("ok");
}
else
{
entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_ID == numberId).First().virtualProgPersId = progId;
entities.SaveChanges();
context.Response.Write("ok");
}
}
}
catch (Exception ex)
{
context.Response.Write(ex.Message);
}
}
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)
{
context.Response.ContentType = "text/plain";
var fileType = context.Request["fileType"];//"更新";"覆盖"
bool isUpdate = true;
if (fileType == "覆盖")
{
isUpdate = false;
}
int personId = int.Parse(context.Session["id"].ToString());
string personName = context.Session["UserName"].ToString();
var number = context.Request.Form[0];
var processId = int.Parse(context.Request.Form[1]);
var file = context.Request.Files;
using (JDJS_WMS_DB_USEREntities entities = new JDJS_WMS_DB_USEREntities())
{
var row = entities.JDJS_WMS_Order_Process_Info_Table.Where(r => r.ID == processId).FirstOrDefault();
var programName = row.programName;
PathInfo pathInfo = new PathInfo();
var root = pathInfo.upLoadPath();
var fileName = Path.GetFileNameWithoutExtension(programName) + Path.GetExtension(file[0].FileName);
var path = Path.Combine(root, number, "加工文件", fileName);
var Folder = Path.Combine(root, number, "加工文件");
if (System.IO.File.Exists(path))
{
if (!isUpdate)
{
System.IO.File.Delete(path);
}
else
{
int i = 1;
string oldPath = Path.Combine(root, number, "加工文件", Path.GetFileNameWithoutExtension(programName) + "-" + i.ToString() + Path.GetExtension(file[0].FileName));
while (System.IO.File.Exists(oldPath))
{
i++;
oldPath = Path.Combine(root, number, "加工文件", Path.GetFileNameWithoutExtension(programName) + "-" + i.ToString() + Path.GetExtension(file[0].FileName));
}
System.IO.File.Move(path, oldPath);
}
}
string str = "";
FileManage.UpdateFileToDB(Convert.ToInt32(row.OrderID), row.ID, personId, personName, FileType.加工文件, isUpdate, ref str);
file[0].SaveAs(path);
row.programName = fileName;
entities.SaveChanges();
context.Response.Write(str);
}
}
/// <summary>
/// 更新文件
/// </summary>
/// <param name="orderId">订单Id</param>
/// <param name="processId">工序Id</param>
/// <param name="personId">员工id</param>
/// <param name="personName">员工姓名</param>
/// <param name="fileType">文件类型</param>
/// <param name="isUpdate">是否更新</param>
/// <param name="errMsg">错误信息</param>
/// <returns></returns>
public static bool UpdateFileToDB(int orderId, int processId, int personId, string personName, FileType fileType, bool isUpdate, ref string errMsg)
{
try
{
string fileTypeStr = fileType.ToString();
using (JDJS_WMS_DB_USEREntities model = new JDJS_WMS_DB_USEREntities())
{
int max = 0;
if (model.JDJS_WMS_Order_Files_Manage_Table.Where(r => r.OrderId == orderId && r.ProcessId == processId && r.FileType == fileTypeStr).Count() > 0)
{
max = int.Parse(model.JDJS_WMS_Order_Files_Manage_Table.Where(r => r.OrderId == orderId && r.ProcessId == processId && r.FileType == fileTypeStr).Max <JDJS_WMS_Order_Files_Manage_Table>(r => r.VersonNum).ToString());
}
int verson = max;
string str = "覆盖";
if (isUpdate)
{
verson++;
str = "更新";
}
JDJS_WMS_Order_Files_Manage_Table jdf = new JDJS_WMS_Order_Files_Manage_Table()
{
OrderId = orderId,
CreateTime = DateTime.Now,
FileType = fileTypeStr,
PersonId = personId,
PersonName = personName,
ProcessId = processId,
VersonNum = verson,
UpdateOrCover = str
};
using (System.Data.Entity.DbContextTransaction mytran = model.Database.BeginTransaction())
{
try
{
model.JDJS_WMS_Order_Files_Manage_Table.Add(jdf);
model.SaveChanges();
mytran.Commit();
errMsg = "ok";
return(true);
}
catch (Exception ex)
{
mytran.Rollback();
errMsg = ex.Message;
return(false);
}
}
}
}
catch (Exception ex)
{
errMsg = ex.Message;
return(false);
}
}
public void ProcessRequest(HttpContext context)
{
var form = context.Request.Form;
var orderNumberId = int.Parse(form[0]);
var workNumber = 1;
var blankType = int.Parse(form[1]);
var blankSpecification = form[2];
using (JDJS_WMS_DB_USEREntities entities = new JDJS_WMS_DB_USEREntities())
{
using (System.Data.Entity.DbContextTransaction mytran = entities.Database.BeginTransaction())
{
try
{
{
var orderNumber = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_ID == orderNumberId).First().Order_Number;
var BlankNumber = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_ID == orderNumberId).First().Product_Output;
var judge = entities.JDJS_WMS_Order_Blank_Table.Where(r => r.OrderID == orderNumberId);
if (judge.Count() == 0)
{
var newRow = new JDJS_WMS_Order_Blank_Table
{
OrderID = orderNumberId,
BlankSpecification = blankSpecification + "#1#",
BlankType = blankType,
BlankState = "待备料",
BlanktotalPreparedNumber = 0,
BlackNumber = BlankNumber,
BlankAddition = 0
};
entities.JDJS_WMS_Order_Blank_Table.Add(newRow);
}
else
{
foreach (var item in judge)
{
item.BlankSpecification = blankSpecification + "#1#";
item.BlankType = blankType;
}
}
}
entities.SaveChanges();
mytran.Commit();
}
catch (Exception ex)
{
mytran.Rollback();
context.Response.Write(ex.Message);
return;
}
}
}
context.Response.Write("ok");
}
public void ProcessRequest(HttpContext context)
{
int PlanID = int.Parse(context.Request["MaintenacneID"]); //计划表中的主键ID
int staffID = int.Parse(context.Request["staffId"]); //员工中的主键ID
var data = Convert.ToDouble(context.Request["data"]);
using (JDJS_WMS_DB_USEREntities wms = new JDJS_WMS_DB_USEREntities())
{
using (System.Data.Entity.DbContextTransaction mytran = wms.Database.BeginTransaction())
{
try
{
var plan = wms.JDJS_WMS_Device_Accuracy_Verification_Plan.Where(r => r.ID == PlanID && r.isFlag == 1);
if (plan.Count() > 0)
{
foreach (var item in plan)
{
item.AccuracyVerificationTime = DateTime.Now;
}
wms.SaveChanges();
JDJS_WMS_Device_Accuracy_Verification_Data confirm = new JDJS_WMS_Device_Accuracy_Verification_Data()
{
RecordTime = DateTime.Now,
PlanID = PlanID,
StaffID = staffID,
Data = data
};
wms.JDJS_WMS_Device_Accuracy_Verification_Data.Add(confirm);
wms.SaveChanges();
}
mytran.Commit();
}
catch
{
mytran.Rollback();
}
}
}
context.Response.Write("ok");
}
public void ProcessRequest(HttpContext context)
{
try
{
int fxDemandId = int.Parse(context.Request["fxDemandId"]);
int personId = int.Parse(context.Session["id"].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.DesignPersonId != personId)
{
context.Response.Write("当前用户无此权限！");
return;
}
if (demand.State != "设计中")
{
context.Response.Write("该治具设计需求暂不支持提交审核");
return;
}
if (demand.Material == null)
{
context.Response.Write("请填写治具材料等相关信息！");
return;
}
using (System.Data.Entity.DbContextTransaction mytran = model.Database.BeginTransaction())
{
try
{
demand.State = "待审核";
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);
}
}
public void ProcessRequest(HttpContext context)
{
var brand = context.Request["brand"];
var type = context.Request["type"];
var tool_Location_Number = int.Parse(context.Request["tool_Location_Number"]);
context.Response.ContentType = "text/plain";
int id = int.Parse(context.Request["id"]);
using (JDJS_WMS_DB_USEREntities data = new JDJS_WMS_DB_USEREntities())
{
var data1 = from brands in data.JDJS_WMS_Device_Brand_Info
where brands.Brand == brand
select new
{
brands.ID
};
foreach (var item in data1)
{
n = item.ID;
}
var data2 = data.JDJS_WMS_Device_Type_Info.Where(p => p.ID != id);
//var data3 = data2.where(r => r.Type == type && r.BrandID == n);
var data3 = from r in data2
where r.Type == type && r.BrandID == n
select new
{
r.Type
};
System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
var data4 = serializer.Serialize(data3);
if (data4 == "[]")
{
var data5 = data.JDJS_WMS_Device_Type_Info.Where(r => r.ID == id);
foreach (var item in data5)
{
item.Type = type; item.BrandID = n; item.tool_Location_Number = tool_Location_Number;
}
data.SaveChanges();
context.Response.Write("ok");
}
else
{
context.Response.Write("false");
}
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
var limit = context.Request.Form[0];
var form = context.Request.Form[1];
var id = int.Parse(context.Request.Form[2]);
var obj = Serializer.Deserialize <Form>(form);
using (JDJS_WMS_DB_USEREntities entities1 = new JDJS_WMS_DB_USEREntities())
{
if (obj.user == "")
{
var row = new JDJS_WMS_Staff_Info
{
staff = obj.staffName,
position = obj.position,
tel = obj.tel,
parentId = id,
remark = obj.remark
};
entities1.JDJS_WMS_Staff_Info.Add(row);
}
else
{
var rows = entities1.JDJS_WMS_Staff_Info.Where(r => r.users == obj.user);
if (rows.Count() > 0)
{
context.Response.Write("登录账户已存在");
return;
}
else
{
var row = new JDJS_WMS_Staff_Info
{
staff = obj.staffName,
position = obj.position,
tel = obj.tel,
parentId = id,
users = obj.user,
password = "******",
limit = limit,
remark = obj.remark
};
entities1.JDJS_WMS_Staff_Info.Add(row);
}
}
entities1.SaveChanges();
}
context.Response.Write("ok");
}
public void ProcessRequest(HttpContext context)
{
try
{
int id = int.Parse(context.Request["id"]);//处理的申请主键ID
string path = "";
using (JDJS_WMS_DB_USEREntities model = new JDJS_WMS_DB_USEREntities())
{
var inspect = model.JDJS_WMS_Quality_Apply_Measure_Table.Where(r => r.ID == id).FirstOrDefault();
if (inspect == null)
{
context.Response.Write("该送检申请不存在，请确认后再试！");
return;
}
path = inspect.SavePath;
//if (inspect.State != Enum.GetName(typeof(InspectStateType), 1))
//{
// context.Response.Write("该测量记录状态不符，请确认后再试！");
// return;
//}
using (System.Data.Entity.DbContextTransaction mytran = model.Database.BeginTransaction())
{
try
{
model.JDJS_WMS_Quality_Apply_Measure_Table.Remove(inspect);
model.SaveChanges();
mytran.Commit();
if (!string.IsNullOrWhiteSpace(path))
{
if (System.IO.Directory.Exists(path))
{
System.IO.Directory.Delete(path, true);
}
}
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"]);//处理的申请主键ID
using (JDJS_WMS_DB_USEREntities model = new JDJS_WMS_DB_USEREntities())
{
var inspect = model.JDJS_WMS_Quality_Apply_Measure_Table.Where(r => r.ID == id).FirstOrDefault();
if (inspect == null)
{
context.Response.Write("该送检申请不存在，请确认后再试！");
return;
}
if (inspect.State != Enum.GetName(typeof(InspectStateType), 1))
{
context.Response.Write("该测量记录状态不符，请确认后再试！");
return;
}
if (inspect.MeasureResult == null)
{
context.Response.Write("该工件暂未填写测量结果，请确认后再试！");
return;
}
using (System.Data.Entity.DbContextTransaction mytran = model.Database.BeginTransaction())
{
try
{
inspect.State = Enum.GetName(typeof(InspectStateType), 2);
model.SaveChanges();
mytran.Commit();
PathInfo pathInfo = new PathInfo();
bool z = true;
SendTextToWechat sendTextToWechat = new CompanyWeChatRobotRemind();
sendTextToWechat.SendText(inspect.ApplyPersonName + "提交的工件：" + inspect.WorkPieceName + "的测量已完成。结果为" + inspect.MeasureResult + "。点击http://3x196w2589.qicp.vip/M/appointList.html", pathInfo.GetQualituInspectAuditRobot(), new List <string>(), out z);
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)
{
int PlanID = int.Parse(context.Request["MaintenacneID"]); //计划表中的主键ID
int staffID = int.Parse(context.Request["staffId"]); //员工中的主键ID
using (JDJS_WMS_DB_USEREntities wms = new JDJS_WMS_DB_USEREntities())
{
using (System.Data.Entity.DbContextTransaction mytran = wms.Database.BeginTransaction())
{
try
{
var plan = wms.JDJS_WMS_Maintenance_Plan_Table.Where(r => r.ID == PlanID && r.isFlag == 1);
if (plan.Count() > 0)
{
foreach (var item in plan)
{
item.MaintenanceTime = DateTime.Now;
}
wms.SaveChanges();
JDJS_WMS_Maintenance_Confirm_Table confirm = new JDJS_WMS_Maintenance_Confirm_Table()
{
ConfirmTime = DateTime.Now,
PlanID = PlanID,
StaffID = staffID,
};
wms.JDJS_WMS_Maintenance_Confirm_Table.Add(confirm);
wms.SaveChanges();
}
mytran.Commit();
}
catch
{
mytran.Rollback();
}
}
}
context.Response.Write("ok");
}
public void ProcessRequest(HttpContext context)
{
try {
var form = context.Request.Form;
var orderId = int.Parse(form["orderId"]);
using (JDJS_WMS_DB_USEREntities entities = new JDJS_WMS_DB_USEREntities())
{
var process = int.Parse(form["process"]);
var allTime = form["allTime"];
//var cncType = form["cncType"];
//var cncNumber = form["cncNumber"];
var cncType = "1";
var cncNumber = "1";
if (entities.JDJS_WMS_Order_Process_Info_Table.Where(r => r.OrderID == orderId & r.sign == 0 & r.ProcessID == process).Count() > 0)
{
context.Response.Write("该工序已存在");
return;
}
var row = new JDJS_WMS_Order_Process_Info_Table
{
OrderID = orderId,
ProcessID = process,
ProcessTime = int.Parse(allTime),
DeviceType = int.Parse(cncType),
MachNumber = int.Parse(cncNumber),
sign = 0
};
entities.JDJS_WMS_Order_Process_Info_Table.Add(row);
//var orderNumberRow = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_ID == orderId);
//var orderNumber = "";
//if (orderNumberRow.Count() > 0)
//{
// orderNumber = orderNumberRow.First().Order_Number;
//}
entities.SaveChanges();
context.Response.Write("ok");
}
}
catch (Exception ex)
{
context.Response.Write(ex.Message);
}
}
public void ProcessRequest(HttpContext context)
{
try
{
var ids = context.Request["ids"];//需要删除的尺寸主键ID列表，以逗号,分隔
List <string> idStrList = ids.Split(',').ToList();
List <int> idList = new List <int>();
foreach (var item in idStrList)
{
int value = 0;
value = int.TryParse(item, out value) ? value : 0;
idList.Add(value);
}
using (JDJS_WMS_DB_USEREntities model = new JDJS_WMS_DB_USEREntities())
{
using (System.Data.Entity.DbContextTransaction mytran = model.Database.BeginTransaction())
{
try
{
foreach (var item in idList)
{
var quality = model.JDJS_WMS_Quality_Detection_Measurement_Table.Where(r => r.ID == item);
foreach (var real in quality)
{
model.JDJS_WMS_Quality_Detection_Measurement_Table.Remove(real);
}
}
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;
}
context.Response.ContentType = "text/plain";
context.Response.Write("Hello World");
}
/// <summary>
/// 删除任务
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool DeleteTask(int id, ref string errMsg)
{
try
{
using (JDJS_WMS_DB_USEREntities wms = new JDJS_WMS_DB_USEREntities())
{
using (System.Data.Entity.DbContextTransaction mytran = wms.Database.BeginTransaction())
{
try
{
var work = wms.JDJS_WMS_Order_Process_Scheduling_Table.Where(r => r.ID == id).FirstOrDefault();
if (work == null)
{
mytran.Rollback();
errMsg = "该任务不存在";
return(false);
}
DateTime time = Convert.ToDateTime(work.StartTime);
TimeSpan timespan = Convert.ToDateTime(work.EndTime) - Convert.ToDateTime(work.StartTime);
var works = wms.JDJS_WMS_Order_Process_Scheduling_Table.Where(r => r.CncID == work.CncID && r.isFlag == 1 && r.StartTime > time);
foreach (var item in works)
{
DateTime startTime = Convert.ToDateTime(item.StartTime);
item.StartTime = startTime - timespan;
DateTime endTime = Convert.ToDateTime(item.EndTime);
item.EndTime = endTime - timespan;
}
wms.JDJS_WMS_Order_Process_Scheduling_Table.Remove(work);
wms.SaveChanges();
mytran.Commit();
errMsg = "ok";
return(true);
}
catch (Exception ex)
{
errMsg = ex.Message;
mytran.Rollback();
return(false);
}
}
}
}
catch (Exception ex)
{
errMsg = ex.Message;
return(false);
}
}
