public void ProcessRequest(HttpContext context)
{
var loginUserID = Convert.ToInt32(context.Session["id"]);
var loginName = context.Session["UserName"].ToString();
string str = context.Request.Form["flag"];//下推or撤销
using (JDJS_WMS_DB_USEREntities entities = new JDJS_WMS_DB_USEREntities())
{
var form = context.Request.Form;
for (int i = 0; i < form.Count - 4; i++)
{
var orderId = int.Parse(form[i]);
if (str == "下推")
{
DateTime time = Convert.ToDateTime(context.Request.Form["time"]);//下推or撤销
var output = Convert.ToInt32(context.Request.Form["Product_Output"]);
var pattern = int.Parse(context.Request.Form["pattern"]);
var row = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_ID == orderId);
//if (row.FirstOrDefault().Order_Leader != loginName /*&& row.FirstOrDefault().CtratPersonID != loginUserID*/)
//{
// context.Response.Write(String.Format("该订单负责人为{0}，当前登录用户没有修改订单权限！", row.FirstOrDefault().Order_Leader));
// return;
//}
int outputOld = row.First().Product_Output;
string pattonOld = (Convert.ToInt32(row.First().ProofingORProduct)) == -1?"大批量":"小批量";
string pattonNew = (pattern) == -1 ? "大批量" : "小批量";
int rowID = row.FirstOrDefault().Order_ID;
if (row.First().Intention == 3)
{
context.Response.Write("已下推");
return;
}
row.First().AuditResult = "待审核";
row.First().Order_Plan_End_Time = time;
row.First().Intention = 3;
row.First().Product_Output = output;
row.First().ProofingORProduct = pattern;
row.First().Engine_Program_ManagerId = null;
var virtualProgPersId = row.First().virtualProgPersId;
if (entities.JDJS_WMS_Staff_Info.Where(r => r.id == virtualProgPersId).Count() == 0)
{
context.Response.Write("虚拟方案未完成不可下推");
return;
}
var name = entities.JDJS_WMS_Staff_Info.Where(r => r.id == virtualProgPersId).First().staff;
row.First().Engine_Program_Manager = null;
var his = entities.JDJS_WMS_Order_Intention_History_Table.Where(r => r.OrderID == rowID).FirstOrDefault();
if (his != null)
{
his.CraftPersonID = virtualProgPersId;
his.LastAlterPersonID = loginUserID;
his.LastAlterTime = DateTime.Now;
}
JDJS_WMS_Order_Alter_History_Table jd = new JDJS_WMS_Order_Alter_History_Table()
{
AlterDecs = String.Format("下推订单,订单数量由{0}修改为{1}，{2}修改为{3}", outputOld, output, pattonOld, pattonNew),
CreatPersonID = loginUserID,
CreatTime = DateTime.Now,
OrderID = orderId
};
entities.JDJS_WMS_Order_Alter_History_Table.Add(jd);
}
else
{
var row = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_ID == orderId);
int rowID = row.FirstOrDefault().Order_ID;
if (row.First().Intention == -2)
{
context.Response.Write("已撤销");
return;
}
row.First().Intention = -2;
var virtualProgPersId = row.First().virtualProgPersId;
var name = entities.JDJS_WMS_Staff_Info.Where(r => r.id == virtualProgPersId).First().staff;
JDJS_WMS_Order_Alter_History_Table jd = new JDJS_WMS_Order_Alter_History_Table()
{
AlterDecs = "撤销订单",
CreatPersonID = loginUserID,
CreatTime = DateTime.Now,
OrderID = orderId
};
entities.JDJS_WMS_Order_Alter_History_Table.Add(jd);
}
}
entities.SaveChanges();
}
context.Response.Write("ok");
}
public void ProcessRequest(HttpContext context)
{
var loginUserID = Convert.ToInt32(context.Session["id"]);
var loginName = context.Session["UserName"];
int priorityNew = Convert.ToInt32(context.Request.Form["Priority"]);
int priorityOld = 1;
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;
var intention = form["intention"];
var orderId = int.Parse(form["orderId"]);
var Order_Number = form["Order_Number"];
var Order_Leader = form["Order_Leader"];
var Product_Name = form["Product_Name"];
var Product_Material = form["Product_Material"];
var Product_Output = int.Parse(form["Product_Output"]);
var ProjectName = form["ProjectName"];
var ClientName = form["ClientName"];
var remark = form["remark"];
var planEndTime = Convert.ToDateTime(form["planEndTime"]);
var rows = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == Order_Number);
foreach (var item in rows)
{
if (item.Order_ID != orderId)
{
context.Response.Write("该订单已存在");
return;
}
}
var row1 = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_ID == orderId);
priorityOld = Convert.ToInt32(row1.FirstOrDefault().Priority);
if (priorityNew != priorityOld && priorityNew != 0)
{
var person = entities.JDJS_WMS_Staff_Info.Where(r => r.id == loginUserID).FirstOrDefault();
if (person != null)
{
if (!person.limit.Split(',').Contains("优先级修改"))
{
row1.FirstOrDefault().Priority = priorityNew;
}
}
if (row1.Count() > 0)
{
if (row1.FirstOrDefault().Order_Leader == loginName || row1.FirstOrDefault().CtratPersonID == loginUserID)
{
//context.Response.Write(String.Format("该订单负责人为{0}，当前登录用户没有修改订单权限！", loginName));
if (intention == "5")
{
row1.FirstOrDefault().Remark = remark;
row1.FirstOrDefault().IntentionPlanEndTime = planEndTime;
row1.FirstOrDefault().Order_Number = Order_Number;
row1.FirstOrDefault().Order_Leader = Order_Leader;
row1.FirstOrDefault().Product_Name = Product_Name;
row1.FirstOrDefault().Product_Material = Product_Material;
row1.FirstOrDefault().Product_Output = Product_Output;
row1.FirstOrDefault().ProjectName = ProjectName;
var guide = entities.JDJS_WMS_Order_Guide_Schedu_Table.Where(r => r.OrderID == orderId).FirstOrDefault();
if (guide != null)
{
guide.ClientName = ClientName;
}
entities.SaveChanges();
context.Response.Write("ok");
}
else if (intention == "6")
{
row1.FirstOrDefault().Remark = remark;
row1.FirstOrDefault().IntentionPlanEndTime = planEndTime;
row1.FirstOrDefault().Order_Number = Order_Number;
row1.FirstOrDefault().Order_Leader = Order_Leader;
row1.FirstOrDefault().Product_Output = Product_Output;
row1.FirstOrDefault().Product_Output = Product_Output;
row1.FirstOrDefault().ProjectName = ProjectName;
var guide = entities.JDJS_WMS_Order_Guide_Schedu_Table.Where(r => r.OrderID == orderId).FirstOrDefault();
if (guide != null)
{
guide.ClientName = ClientName;
}
entities.SaveChanges();
context.Response.Write("ok");
}
else if (intention == "1")
{
row1.FirstOrDefault().Remark = remark;
row1.FirstOrDefault().IntentionPlanEndTime = planEndTime;
row1.FirstOrDefault().Product_Output = Product_Output;
entities.SaveChanges();
context.Response.Write("ok");
}
JDJS_WMS_Order_Alter_History_Table jd = new JDJS_WMS_Order_Alter_History_Table()
{
AlterDecs = "修改优先级",
CreatPersonID = loginUserID,
CreatTime = DateTime.Now,
OrderID = orderId
};
entities.JDJS_WMS_Order_Alter_History_Table.Add(jd);
}
}
}
else
{
if (row1.Count() > 0)
{
if (row1.FirstOrDefault().Order_Leader != loginName && row1.FirstOrDefault().CtratPersonID != loginUserID)
{
context.Response.Write(String.Format("该订单负责人为{0}，当前登录用户没有修改订单权限！", row1.FirstOrDefault().Order_Leader));
return;
}
}
if (intention == "5")
{
var row = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_ID == orderId);
row.FirstOrDefault().Remark = remark;
row.FirstOrDefault().IntentionPlanEndTime = planEndTime;
row.FirstOrDefault().Order_Number = Order_Number;
row.FirstOrDefault().Order_Leader = Order_Leader;
row.FirstOrDefault().Product_Name = Product_Name;
row.FirstOrDefault().Product_Material = Product_Material;
row.FirstOrDefault().Product_Output = Product_Output;
row.FirstOrDefault().Product_Output = Product_Output;
row.FirstOrDefault().ProjectName = ProjectName;
var guide = entities.JDJS_WMS_Order_Guide_Schedu_Table.Where(r => r.OrderID == orderId).FirstOrDefault();
if (guide != null)
{
guide.ClientName = ClientName;
}
entities.SaveChanges();
context.Response.Write("ok");
}
else if (intention == "6")
{
var row = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_ID == orderId);
row.FirstOrDefault().Remark = remark;
row.FirstOrDefault().IntentionPlanEndTime = planEndTime;
row.FirstOrDefault().Order_Number = Order_Number;
row.FirstOrDefault().Order_Leader = Order_Leader;
row.FirstOrDefault().Product_Output = Product_Output;
row.FirstOrDefault().Product_Output = Product_Output;
row.FirstOrDefault().ProjectName = ProjectName;
var guide = entities.JDJS_WMS_Order_Guide_Schedu_Table.Where(r => r.OrderID == orderId).FirstOrDefault();
if (guide != null)
{
guide.ClientName = ClientName;
}
entities.SaveChanges();
context.Response.Write("ok");
}
else if (intention == "1")
{
var row = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_ID == orderId);
row.FirstOrDefault().Remark = remark;
row.FirstOrDefault().IntentionPlanEndTime = planEndTime;
row.FirstOrDefault().Product_Output = Product_Output;
entities.SaveChanges();
context.Response.Write("ok");
}
JDJS_WMS_Order_Alter_History_Table jd = new JDJS_WMS_Order_Alter_History_Table()
{
AlterDecs = "修改订单数量",
CreatPersonID = loginUserID,
CreatTime = DateTime.Now,
OrderID = orderId
};
entities.JDJS_WMS_Order_Alter_History_Table.Add(jd);
}
db.Commit();
}
catch (Exception ex)
{
db.Rollback();
context.Response.Write(ex.Message);
}
}
}
}
