public void ProcessRequest(HttpContext context)
{
int orderId = int.Parse(context.Request["orderId"]); //关联的订单主键ID
int output = int.Parse(context.Request["output"]); //订单需求量
string Order_Leader = context.Request["Order_Leader"]; //订单负责人
string Product_Name = context.Request["Product_Name"]; //产品名称
string Project_Name = context.Request["Project_Name"]; //项目名称
string Order_State = context.Request["Order_State"]; //订单状态
var patternStr = (context.Request["pattern"] == null ? "-100" : context.Request["pattern"]);
int pattern = int.Parse(patternStr); //生产模式
int loginID = Convert.ToInt32(context.Session["id"]);
DateTime Order_Plan_End_Time = Convert.ToDateTime(context.Request["Order_Plan_End_Time"]); //计划结束时间
var Order_Plan_Start_Time = DateTime.Now;
var Customer = context.Request["Customer"]; //客户名称
var remark = context.Request["remark"];
#region 订单号
string year = DateTime.Now.Year.ToString().Substring(2, 2);
string month = DateTime.Now.Month.ToString();
while (month.Length < 2)
{
month = month.Insert(0, "0");
}
string day = DateTime.Now.Day.ToString();
while (day.Length < 2)
{
day = day.Insert(0, "0");
}
string strOrderNum = year + month + day;
int flag = 1;
string flagStr = "";
using (JDJS_WMS_DB_USEREntities entities = new JDJS_WMS_DB_USEREntities())
{
try
{
while (true)
{
flagStr = flag.ToString();
while (flagStr.Length < 5)
{
flagStr = flagStr.Insert(0, "0");
}
var order = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == strOrderNum + flagStr);
if (order.Count() < 1)
{
break;
}
flag++;
}
}
catch (Exception ex)
{
context.Response.Write(ex.Message);
return;
}
var OldOrder = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_ID == orderId).FirstOrDefault();
if (OldOrder == null)
{
context.Response.Write("被关联订单不存在，请确认后再试！");
return;
}
var clientInfo = entities.JDJS_WMS_Order_Guide_Schedu_Table.Where(r => r.OrderID == orderId).FirstOrDefault();
Order_Leader = Order_Leader == null ? OldOrder.Order_Leader : Order_Leader;
Product_Name = Product_Name == null? OldOrder.Product_Name : Product_Name;
Project_Name = Project_Name == null? OldOrder.ProjectName : Project_Name;
Order_State = Order_State == null ? OldOrder.Order_State : Order_State;
Customer = Customer == null ?(clientInfo == null?"无": clientInfo.ClientName) : Customer;
pattern = pattern == -100 ? ((int)(OldOrder.ProofingORProduct == null?-1: OldOrder.ProofingORProduct)) : pattern;
using (System.Data.Entity.DbContextTransaction date = entities.Database.BeginTransaction())
{
try
{
JDJS_WMS_Order_Entry_Table orderentry = new JDJS_WMS_Order_Entry_Table()
{
Order_Number = strOrderNum + flagStr,
Order_Leader = Order_Leader,
Product_Name = Product_Name,
Product_Material = OldOrder.Product_Material,
Product_Output = output,
Order_Plan_Start_Time = Order_Plan_Start_Time,
Order_Actual_Start_Time = null,
Order_Actual_End_Time = null,
Order_Plan_End_Time = Order_Plan_End_Time,
Engine_Program_Manager = OldOrder.Engine_Program_Manager,
Engine_Technology_Manager = OldOrder.Engine_Technology_Manager,
Engine_Program_ManagerId = OldOrder.Engine_Program_ManagerId,
Engine_Technology_ManagerId = OldOrder.Engine_Technology_ManagerId,
Engine_Status = "未进行",
Intention = 6,
ProjectName = Project_Name,
CreateTime = DateTime.Now,
CreatePersonID = loginID,
Order_State = Order_State,
virtualProgPersId = OldOrder.virtualProgPersId,
virtualReturnTime = OldOrder.virtualReturnTime,
AuditResult = "待审核",
CtratPersonID = loginID,
//audit_Result = OldOrder.audit_Result,
craftPerson = OldOrder.craftPerson,
Priority = 1,
craftPersonId = OldOrder.craftPersonId,
ProofingORProduct = pattern,
program_audit_result = null,
ParentId = orderId,
Remark = remark
};
entities.JDJS_WMS_Order_Entry_Table.Add(orderentry);
entities.SaveChanges();
int orderIdNew = orderentry.Order_ID;
JDJS_WMS_Order_Guide_Schedu_Table guide = new JDJS_WMS_Order_Guide_Schedu_Table()
{
OrderID = orderIdNew,
ClientName = Customer
};
entities.JDJS_WMS_Order_Guide_Schedu_Table.Add(guide);
entities.SaveChanges();
var queue = new JDJS_WMS_Order_Queue_Table {
OrderID = orderIdNew, isFlag = 3
};
entities.JDJS_WMS_Order_Queue_Table.Add(queue);
entities.SaveChanges();
date.Commit();
PathInfo pathInfo = new PathInfo();
var NewFolder = Path.Combine(pathInfo.upLoadPath(), strOrderNum + flagStr);
var OldFolder = Path.Combine(pathInfo.upLoadPath(), OldOrder.Order_Number);
List <string> srcPath = new List <string>();
string[] src = Directory.GetFileSystemEntries(OldFolder);
foreach (var item in src)
{
copyDir(item, NewFolder, strOrderNum + flagStr);
}
context.Response.Write("ok");
return;
}
catch (Exception ex)
{
date.Rollback();
context.Response.Write(ex.Message);
return;
}
}
}
#endregion
}
public void ProcessRequest(HttpContext context)
{
var form = context.Request.Form;
var file = context.Request.Files;
var projectName = form["projectName"];
var remark = form["remark"]; //备注
var loginID = Convert.ToInt32(context.Session["id"]);
int priority = 1; //优先级
string year = DateTime.Now.Year.ToString().Substring(2, 2);
string month = DateTime.Now.Month.ToString();
while (month.Length < 2)
{
month = month.Insert(0, "0");
}
string day = DateTime.Now.Day.ToString();
while (day.Length < 2)
{
day = day.Insert(0, "0");
}
string strOrderNum = year + month + day;
int flag = 1;
string flagStr = "";
// var folder = @"D:\服务器文件勿动\" + form[0];
using (JDJS_WMS_DB_USEREntities entities = new JDJS_WMS_DB_USEREntities())
{
using (System.Data.Entity.DbContextTransaction date = entities.Database.BeginTransaction())
{
try
{
while (true)
{
flagStr = flag.ToString();
while (flagStr.Length < 5)
{
flagStr = flagStr.Insert(0, "0");
}
var order = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == strOrderNum + flagStr);
if (order.Count() < 1)
{
break;
}
flag++;
}
if (form[0] == "0")
{
var Order_Number = strOrderNum + flagStr;
var Order_Leader = form[2];
var Product_Name = form[3];
var Product_Material = form[4];
var Product_Output = int.Parse(form[5]);
var Order_Plan_End_Time = DateTime.Parse(form[6]);
var Order_State = form[7];
var Order_Plan_Start_Time = DateTime.Now;
var Customer = form[8];
var pattern = int.Parse(form["pattern"]);
var judge = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == Order_Number);
if (judge.Count() > 0)
{
context.Response.Write("该订单已存在");
return;
}
var row = new JDJS_WMS_Order_Entry_Table
{
Order_Number = Order_Number,
Order_Leader = Order_Leader,
Product_Name = Product_Name,
Product_Material = Product_Material,
Product_Output = Product_Output,
Order_Plan_End_Time = Order_Plan_End_Time,
Order_State = Order_State,
Order_Plan_Start_Time = DateTime.Now,
Intention = 3,
ProjectName = projectName,
ProofingORProduct = pattern,
CtratPersonID = loginID,
Priority = priority,
CreateTime = DateTime.Now,
CreatePersonID = loginID,
AuditResult = "待审核",
Remark = remark
};
entities.JDJS_WMS_Order_Entry_Table.Add(row);
entities.SaveChanges();
var orderId = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == Order_Number).FirstOrDefault().Order_ID;
JDJS_WMS_Order_Guide_Schedu_Table guide = new JDJS_WMS_Order_Guide_Schedu_Table()
{
OrderID = orderId,
ClientName = Customer
};
entities.JDJS_WMS_Order_Guide_Schedu_Table.Add(guide);
entities.SaveChanges();
var queue = new JDJS_WMS_Order_Queue_Table {
OrderID = orderId, isFlag = 3
};
entities.JDJS_WMS_Order_Queue_Table.Add(queue);
entities.SaveChanges();
PathInfo pathInfo = new PathInfo();
var folder = Path.Combine(pathInfo.upLoadPath(), Order_Number, form[1], @"客供图纸");
if (!Directory.Exists(folder))
{
Directory.CreateDirectory(folder);
}
;
for (int i = 0; i < file.Count; i++)
{
var name = file[i].FileName;
var size = file[i].ContentLength;
string path = Path.Combine(folder, name);
file[i].SaveAs(path);
}
entities.SaveChanges();
context.Response.Write("ok");
date.Commit();
}
else
{
var Order_Number = strOrderNum + flagStr;
var Order_Leader = form[2];
var oldOrderNumber = form[3];
var Product_Name = form[4];
var Product_Material = form[5];
var Product_Output = int.Parse(form[6]);
var Order_Plan_End_Time = DateTime.Parse(form[7]);
var Order_State = form[8];
var Order_Plan_Start_Time = DateTime.Now;
var Customer = form[9];
{
string OrderNum = Order_Number;
string OrderOwener = Order_Leader;
string OldOrderNum = oldOrderNumber;
string ProductName = Product_Name;
string ProductMertial = Product_Material;
int ProductOutPut = Product_Output;
string OrderState = Order_State;
DateTime OverTime = DateTime.Now;
using (JDJS_WMS_DB_USEREntities wms = new JDJS_WMS_DB_USEREntities())
{
var orders = wms.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == OrderNum);
if (orders.Count() > 0)
{
Console.WriteLine("该订单号已存在");
return;
}
else
{
using (System.Data.Entity.DbContextTransaction mytran = wms.Database.BeginTransaction())
{
try
{
var OldOrderInfo = wms.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == OldOrderNum);
if (OldOrderInfo.Count() > 0)
{
JDJS_WMS_Order_Entry_Table orderentry = new JDJS_WMS_Order_Entry_Table()
{
Order_Number = OrderNum,
Order_Leader = OrderOwener,
Product_Name = ProductName,
Product_Material = ProductMertial,
Product_Output = ProductOutPut,
Order_Plan_Start_Time = null,
Order_Actual_Start_Time = null,
Order_Actual_End_Time = null,
Order_Plan_End_Time = Order_Plan_End_Time,
Engine_Program_Manager = OldOrderInfo.FirstOrDefault().Engine_Program_Manager,
Engine_Technology_Manager = OldOrderInfo.FirstOrDefault().Engine_Technology_Manager,
Engine_Program_ManagerId = OldOrderInfo.FirstOrDefault().Engine_Program_ManagerId,
Engine_Technology_ManagerId = OldOrderInfo.FirstOrDefault().Engine_Technology_ManagerId,
Engine_Status = "未进行",
Intention = 3,
ProjectName = projectName,
CreateTime = DateTime.Now,
CreatePersonID = loginID,
Order_State = OrderState,
virtualProgPersId = OldOrderInfo.FirstOrDefault().virtualProgPersId,
virtualReturnTime = OldOrderInfo.FirstOrDefault().virtualReturnTime,
// audit_Result = "待审核",
AuditResult = "待审核",
Remark = remark
};
wms.JDJS_WMS_Order_Entry_Table.Add(orderentry);
wms.SaveChanges();
mytran.Commit();
}
}
catch (Exception ex)
{
mytran.Rollback();
context.Response.Write(ex.Message);
return;
}
}
using (System.Data.Entity.DbContextTransaction mytran = wms.Database.BeginTransaction())
{
try
{
var newOlder = wms.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == OrderNum).FirstOrDefault();
JDJS_WMS_Order_Blank_Table blank = new JDJS_WMS_Order_Blank_Table()
{
OrderID = newOlder.Order_ID,
BlackNumber = newOlder.Product_Output,
BlankAddition = 0,
BlankSpecification = null,
BlankState = null,
BlanktotalPreparedNumber = 0,
BlankType = null,
};
wms.JDJS_WMS_Order_Blank_Table.Add(blank);
wms.SaveChanges();
JDJS_WMS_Order_Guide_Schedu_Table guide = new JDJS_WMS_Order_Guide_Schedu_Table()
{
OrderID = newOlder.Order_ID,
ClientName = Customer
};
entities.JDJS_WMS_Order_Guide_Schedu_Table.Add(guide);
entities.SaveChanges();
var oldOlder = wms.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == OldOrderNum).FirstOrDefault();
var oldProcessInfo = wms.JDJS_WMS_Order_Process_Info_Table.Where(r => r.OrderID == oldOlder.Order_ID && r.sign == 1);
foreach (var item in oldProcessInfo)
{
string oldprocessName = item.programName;
string[] str = oldprocessName.Split('-');
string NewProcessNum = "";
if (str.Length == 2)
{
NewProcessNum = OrderNum + "-" + str[1];
}
string oldToolName = item.toolChartName;
string[] toolStr = oldToolName.Split('-');
string NewToolNum = "";
if (toolStr.Length == 3)
{
NewToolNum = "T" + "-" + OrderNum + "-" + toolStr[2];
}
JDJS_WMS_Order_Process_Info_Table process = new JDJS_WMS_Order_Process_Info_Table()
{
OrderID = newOlder.Order_ID,
ProcessID = item.ProcessID,
BlankNumber = ProductOutPut,
BlankSpecification = item.BlankSpecification,
BlankType = item.BlankType,
DeviceType = item.DeviceType,
JigSpecification = item.JigSpecification,
ProcessTime = item.ProcessTime,
programName = NewProcessNum,
sign = item.sign,
toolChartName = NewToolNum,
toolPreparation = item.toolPreparation,
};
wms.JDJS_WMS_Order_Process_Info_Table.Add(process);
}
wms.SaveChanges();
mytran.Commit();
}
catch (Exception ex)
{
mytran.Rollback();
context.Response.Write(ex.Message);
return;
}
}
using (System.Data.Entity.DbContextTransaction mytran = wms.Database.BeginTransaction())
{
try
{
var newOlder = wms.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == OrderNum).FirstOrDefault();
var processes = wms.JDJS_WMS_Order_Process_Info_Table.Where(r => r.OrderID == newOlder.Order_ID && r.sign == 1);
foreach (var item in processes)
{
JDJS_WMS_Order_Fixture_Manager_Table fix = new JDJS_WMS_Order_Fixture_Manager_Table()
{
ProcessID = item.ID,
FixtureAdditionNumber = 0,
FixtureNumber = 0,
FixtureFinishPerpareNumber = 0,
};
wms.JDJS_WMS_Order_Fixture_Manager_Table.Add(fix);
}
//给每个工序添加治具一行
wms.SaveChanges();
mytran.Commit();
}
catch (Exception ex)
{
mytran.Rollback();
context.Response.Write(ex.Message);
return;
}
}
using (System.Data.Entity.DbContextTransaction mytran = wms.Database.BeginTransaction())
{
try
{
var newOlder = wms.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == OrderNum).FirstOrDefault();
var oldOlder = wms.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == OldOrderNum).FirstOrDefault();
var processes = wms.JDJS_WMS_Order_Process_Info_Table.Where(r => r.OrderID == newOlder.Order_ID && r.sign == 1);
foreach (var item in processes)
{
var oldProcess = wms.JDJS_WMS_Order_Process_Info_Table.Where(r => r.OrderID == oldOlder.Order_ID && r.ProcessID == item.ProcessID && r.sign == 1).FirstOrDefault();
var OldTool = wms.JDJS_WMS_Order_Process_Tool_Info_Table.Where(r => r.ProcessID == oldProcess.ID);
foreach (var real in OldTool)
{
JDJS_WMS_Order_Process_Tool_Info_Table tool = new JDJS_WMS_Order_Process_Tool_Info_Table()
{
ProcessID = item.ID,
PathName = real.PathName,
Shank = real.Shank,
ToolAroidance = real.ToolAroidance,
ToolDiameter = real.ToolDiameter,
ToolLength = real.ToolLength,
ToolName = real.ToolName,
ToolNO = real.ToolNO
};
wms.JDJS_WMS_Order_Process_Tool_Info_Table.Add(tool);
}
wms.SaveChanges();
}
wms.SaveChanges();
mytran.Commit();
}
catch (Exception ex)
{
mytran.Rollback();
context.Response.Write(ex.Message);
return;
}
}
{
PathInfo pathInfo = new PathInfo();
var NewFolder = Path.Combine(pathInfo.upLoadPath(), OrderNum);
var OldFolder = Path.Combine(pathInfo.upLoadPath(), OldOrderNum);
List <string> srcPath = new List <string>();
string[] src = Directory.GetFileSystemEntries(OldFolder);
foreach (var item in src)
{
copyDir(item, NewFolder, OrderNum);
}
context.Response.Write("ok");
return;
}
}
}
}
}
}
catch (Exception ex)
{
date.Rollback();
context.Response.Write(ex.Message);
}
}
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
var form = context.Request.Form;
var file = context.Request.Files;
var projectName = form["projectName"];
var intentionEndTime = Convert.ToDateTime(form["intentionEndTime"]); //预计评估完成时间
var remark = form["remark"]; //备注
var loginUserId = Convert.ToInt32(context.Session["id"]);
int priority = 1; //优先级
// var folder = @"D:\服务器文件勿动\"+ form[0];
string year = DateTime.Now.Year.ToString().Substring(2, 2);
string month = DateTime.Now.Month.ToString();
while (month.Length < 2)
{
month = month.Insert(0, "0");
}
string day = DateTime.Now.Day.ToString();
while (day.Length < 2)
{
day = day.Insert(0, "0");
}
string strOrderNum = year + month + day;
int flag = 1;
string flagStr = "";
using (JDJS_WMS_DB_USEREntities entities = new JDJS_WMS_DB_USEREntities())
{
using (System.Data.Entity.DbContextTransaction date = entities.Database.BeginTransaction())
{
try
{
while (true)
{
flagStr = flag.ToString();
while (flagStr.Length < 5)
{
flagStr = flagStr.Insert(0, "0");
}
var order = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == strOrderNum + flagStr);
if (order.Count() < 1)
{
break;
}
flag++;
}
if (int.Parse(form[0]) == 0)
{
var number = strOrderNum + flagStr;
var Customer = form[6];
var judge = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == number);
if (judge.Count() > 0)
{
context.Response.Write("该订单已存在");
return;
}
var row = new JDJS_WMS_Order_Entry_Table
{
Order_Number = strOrderNum + flagStr,
Order_Leader = form[2],
Product_Name = form[3],
Product_Material = form[4],
Product_Output = int.Parse(form[5]),
ProjectName = projectName,
CtratPersonID = loginUserId,
Priority = priority,
Intention = 5,//意向未提交
CreateTime = DateTime.Now,
CreatePersonID = loginUserId,
IntentionPlanEndTime = intentionEndTime,
Remark = remark
};
entities.JDJS_WMS_Order_Entry_Table.Add(row);
entities.SaveChanges();
var orderId = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == number).FirstOrDefault().Order_ID;
JDJS_WMS_Order_Guide_Schedu_Table guide = new JDJS_WMS_Order_Guide_Schedu_Table()
{
OrderID = orderId,
ClientName = Customer
};
entities.JDJS_WMS_Order_Guide_Schedu_Table.Add(guide);
entities.SaveChanges();
var newRow = new JDJS_WMS_Order_Intention_History_Table {
OrderID = orderId, flag = 1, CreatPersonID = loginUserId, CreatTime = DateTime.Now, LastAlterPersonID = loginUserId, LastAlterTime = DateTime.Now
};
entities.JDJS_WMS_Order_Intention_History_Table.Add(newRow);
entities.SaveChanges();
//var orderNumber = form[0];
//var OrderID = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == orderNumber).First().Order_ID;
//var flag = new JDJS_WMS_Order_Queue_Table
//{
// OrderID = OrderID,
// isFlag = 0
//};
//entities.JDJS_WMS_Order_Queue_Table.Add(flag);
PathInfo pathInfo = new PathInfo();
var folder = Path.Combine(pathInfo.upLoadPath(), number, form[1], @"客供图纸");
if (!Directory.Exists(folder))
{
Directory.CreateDirectory(folder);
}
;
for (int i = 0; i < file.Count; i++)
{
var name = file[i].FileName;
var size = file[i].ContentLength;
string path = Path.Combine(folder, name);
file[i].SaveAs(path);
}
entities.SaveChanges();
context.Response.Write("ok");
date.Commit();
}
else
{
{
System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
{
//var form = context.Request.Form;
//var file = context.Request.Files;
//var folder = @"D:\服务器文件勿动\"+ form[0];
{
{
{
PathInfo pathInfo = new PathInfo();
var NewOrderNumber = strOrderNum + flagStr;
string Owner = form[2];
string OldOrderNumber = form[3];
string ProductName = form[4];
string ProductMater = form[5];
int OutPut = int.Parse(form[6]);
var Customer = form[7];
var NewFolder = Path.Combine(pathInfo.upLoadPath(), NewOrderNumber);
try
{
var number = NewOrderNumber;
var judge = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == number);
if (judge.Count() > 0)
{
Console.WriteLine("该订单已存在");
return;
}
var oldVirPerson = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == OldOrderNumber).FirstOrDefault().virtualProgPersId;
var row = new JDJS_WMS_Order_Entry_Table
{
Order_Number = NewOrderNumber,
Order_Leader = Owner,
Product_Name = ProductName,
Product_Material = ProductMater,
Product_Output = OutPut,
virtualProgPersId = oldVirPerson,
ProjectName = projectName,
Intention = 6,
CtratPersonID = loginUserId,
Priority = priority,
CreateTime = DateTime.Now,
CreatePersonID = loginUserId,
IntentionPlanEndTime = intentionEndTime,
Remark = remark
};
entities.JDJS_WMS_Order_Entry_Table.Add(row);
entities.SaveChanges();
var orderId = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == number).FirstOrDefault().Order_ID;
var newRow = new JDJS_WMS_Order_Intention_History_Table {
OrderID = orderId
};
entities.JDJS_WMS_Order_Intention_History_Table.Add(newRow);
var newOrder = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == NewOrderNumber && r.Intention == 6).FirstOrDefault().Order_ID;
JDJS_WMS_Order_Guide_Schedu_Table guide = new JDJS_WMS_Order_Guide_Schedu_Table()
{
OrderID = newOrder,
ClientName = Customer
};
entities.JDJS_WMS_Order_Guide_Schedu_Table.Add(guide);
entities.SaveChanges();
var oldOrder = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == OldOrderNumber).FirstOrDefault();
int oldID = oldOrder.Order_ID;
var oldprocess = entities.JDJS_WMS_Order_Process_Info_Table.Where(r => r.OrderID == oldID && r.sign == 0);
foreach (var item in oldprocess)
{
JDJS_WMS_Order_Process_Info_Table info = new JDJS_WMS_Order_Process_Info_Table()
{
OrderID = newOrder,
ProcessID = item.ProcessID,
programName = item.programName,
ProcessTime = item.ProcessTime,
BlankNumber = item.BlankNumber,
BlankSpecification = item.BlankSpecification,
BlankType = item.BlankType,
DeviceType = item.DeviceType,
JigSpecification = item.JigSpecification,
sign = 0,
toolChartName = item.toolChartName,
toolPreparation = item.toolPreparation
};
entities.JDJS_WMS_Order_Process_Info_Table.Add(info);
}
entities.SaveChanges();
if (!Directory.Exists(NewFolder))
{
Directory.CreateDirectory(NewFolder);
}
;
List <string> srcPath = new List <string>();
srcPath.Add(pathInfo.upLoadPath() + @"\" + OldOrderNumber + @"\" + @"客供图纸\");
srcPath.Add(pathInfo.upLoadPath() + @"\" + OldOrderNumber + @"\" + @"虚拟加工方案文档\");
foreach (var real in srcPath)
{
copyDir(real, NewFolder);
}
context.Response.Write("ok");
date.Commit();
}
catch (Exception ex)
{
date.Rollback();
context.Response.Write(ex.Message);
}
}
}
}
}
{
//string OrderNum = "1";
//List<string> Info = new List<string>();
//if (OrderNum != null && OrderNum != "")
//{
// using (WmsAutoEntities wms = new WmsAutoEntities())
// {
// var order = wms.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == OrderNum);
// if (order.Count() > 0)
// {
// string name = order.First().Product_Name;
// string material = order.First().Product_Material;
// Info.Add(name);
// Info.Add(material);
// }
// }
//}
//var json = serializer.Serialize(Info);
}
{
//List<string> OrderNum = new List<string>();
//using (WmsAutoEntities wms = new WmsAutoEntities())
//{
// var Intention = wms.JDJS_WMS_Order_Intention_History_Table.ToList();
// foreach (var item in Intention)
// {
// int id = Convert.ToInt32(item.OrderID);
// var order = wms.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_ID == id);
// var str = order.First().Order_Number;
// OrderNum.Add(str);
// }
//}
//var json = serializer.Serialize(OrderNum);
}
}
}
}
catch (Exception ex)
{
date.Rollback();
context.Response.Write(ex.Message);
}
}
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
var form = context.Request.Form;
var file = context.Request.Files;
PathInfo pathInfo = new PathInfo();
var folder = pathInfo.upLoadPath() + form[0];
using (JDJS_WMS_DB_USEREntities entities = new JDJS_WMS_DB_USEREntities())
{
using (System.Data.Entity.DbContextTransaction date = entities.Database.BeginTransaction())
{
try
{
var number = form[0];
var judge = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == number);
if (judge.Count() > 0)
{
context.Response.Write("该订单已存在");
return;
}
var row = new JDJS_WMS_Order_Entry_Table
{
Order_Number = form[0],
Order_Leader = form[1],
Product_Name = form[2],
Product_Material = form[3],
Product_Output = int.Parse(form[4]),
Order_Plan_End_Time = DateTime.Parse(form[5]),
Order_State = form[6],
Order_Plan_Start_Time = DateTime.Now
};
entities.JDJS_WMS_Order_Entry_Table.Add(row);
if (!Directory.Exists(folder))
{
Directory.CreateDirectory(folder);
}
;
for (int i = 0; i < file.Count; i++)
{
var name = file[i].FileName;
var size = file[i].ContentLength;
string path = Path.Combine(folder, name);
file[i].SaveAs(path);
}
entities.SaveChanges();
context.Response.Write("ok");
date.Commit();
}
catch (Exception ex)
{
date.Rollback();
context.Response.Write(ex.Message);
}
}
}
}
public void ProcessRequest(HttpContext context)
{
try
{
int fxDemandId = int.Parse(context.Request["fxDemandId"]);
string remark = context.Request["remark"];
string productName = context.Request["productName"]; //产品名称
string projectName = context.Request["projectName"]; //项目名称
string clientName = context.Request["clientName"]; //客户名称
DateTime time = DateTime.Parse(context.Request["planEndTime"]); //计划完成时间
string leader = context.Request["leader"]; //订单责任人
int output = int.Parse(context.Request["output"]); //产量
int personId = int.Parse(context.Session["id"].ToString());
string personName = context.Session["UserName"].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.State != "待审核")
{
context.Response.Write("该治具设计需求暂不支持审核");
return;
}
using (System.Data.Entity.DbContextTransaction mytran = model.Database.BeginTransaction())
{
try
{
demand.State = "审核通过";
string str = demand.AuditRemark == null ? "" : demand.AuditRemark;
demand.AuditRemark = str + DateTime.Now.ToString() + "</br>" + remark + "</br>";
demand.EndTime = DateTime.Now;
//新建生产订单
JDJS_WMS_Order_Entry_Table jd = new JDJS_WMS_Order_Entry_Table()
{
Order_Leader = leader,
Order_Number = demand.FixtureOrderNum,
Product_Name = productName,
Product_Material = demand.Material,
Product_Output = output,
Order_Plan_Start_Time = DateTime.Now,
Order_Plan_End_Time = time,
Order_State = "执行",
ProofingORProduct = -1,
Priority = 1,
ProjectName = projectName,
AuditResult = "审核通过",
AuditAdvice = DateTime.Now.ToString() + "：" + "审核通过" + "\n",
CreatePersonID = personId,
craftPerson = personName,
craftPersonId = personId,
CtratPersonID = personId,
CreateTime = DateTime.Now,
Intention = 3,
Remark = remark
};
model.JDJS_WMS_Order_Entry_Table.Add(jd);
model.SaveChanges();
var orderId = jd.Order_ID;
JDJS_WMS_Order_Guide_Schedu_Table guide = new JDJS_WMS_Order_Guide_Schedu_Table()
{
OrderID = orderId,
ClientName = clientName,
};
model.JDJS_WMS_Order_Guide_Schedu_Table.Add(guide);
model.SaveChanges();
mytran.Commit();
PathInfo pathInfo = new PathInfo();
var folder = Path.Combine(pathInfo.upLoadPath(), demand.FixtureOrderNum, @"客供图纸");
if (!Directory.Exists(folder))
{
Directory.CreateDirectory(folder);
}
;
string path = System.IO.Path.Combine(pathInfo.upLoadPath(), @"特殊治具管理", demand.FixtureOrderNum, @"设计文件");
DirectoryInfo directoryInfo = new DirectoryInfo(path);
foreach (var item in directoryInfo.GetFiles())
{
item.CopyTo(Path.Combine(folder, item.Name), true);
}
context.Response.Write("ok");
return;
}
catch (Exception ex)
{
context.Response.Write(ex.Message);
return;
}
}
}
}
catch (Exception ex)
{
context.Response.Write(ex.Message);
}
}
