public ActionResult del(Guid?strId)
{
OilMaterialOrder oi = osms.OilMaterialOrder.Where(x => x.Id == strId).FirstOrDefault();
List <OilMaterialOrderDetail> od = osms.OilMaterialOrderDetail.Where(x => x.OrderId == strId).ToList();
foreach (var item in od)
{
osms.Entry(item).State = System.Data.Entity.EntityState.Modified;
item.IsDel = true;
}
osms.Entry(oi).State = System.Data.Entity.EntityState.Modified;
oi.IsDel = true;
List <ProcessStepRecord> lpr = (osms.ProcessStepRecord.Where(x => x.RefOrderId == strId)).ToList();
foreach (var item in lpr)
{
osms.ProcessStepRecord.Remove(item);
}
int i = osms.SaveChanges();
if (i > 0)
{
return(Content("OK"));
}
else
{
return(Content("NO"));
}
}
public ActionResult Save(string str, string s)
{
List <OilMaterialOrderDetail> od = JsonConvert.DeserializeObject <List <OilMaterialOrderDetail> >(s);
OilMaterialOrder oi = JsonConvert.DeserializeObject <OilMaterialOrder>(str);
oi.No = "YLSQ" + DateTime.Now.ToString("yyyyMMddHHmmssffffff");
oi.Id = Guid.NewGuid();
oi.CreateTime = DateTime.Now.ToLocalTime();
oi.ApplyPersonId = (Session["userInfo"] as Staff).Id;
oi.IsDel = false;
osms.OilMaterialOrder.Add(oi);
foreach (var item in od)
{
item.Id = Guid.NewGuid();
item.OrderId = oi.Id;
item.CreateTime = oi.CreateTime;
item.IsDel = false;
osms.OilMaterialOrderDetail.Add(item);
}
int i = osms.SaveChanges();
if (i > 0)
{
return(Content("AddOk"));
}
else
{
return(Content("NO"));
}
}
public ActionResult start(OilMaterialOrder oi, Guid?p_id)
{
//var list = (from a in osms.ProcessStepRecord join b in osms.Staff on a.WaitForExecutionStaffId equals b.Id join c in osms.Job on b.JobId equals c.Id join d in osms.OrganizationStructure on b.OrgID equals d.Id where a.RefOrderId == strRefOrderId orderby a.StepOrder select new { Result = a.Result, WhetherToExecute = a.WhetherToExecute, uName = b.Name, JobName = c.Name, OrgName = d.Name }).ToList();
var ap = osms.Approver.Where(x => x.ProcessItemId == p_id).ToList();
Staff sta = osms.Staff.Where(x => x.Id == oi.ApplyPersonId).FirstOrDefault();
//获取机构
List <Guid?> listOrg = new List <Guid?>();
listOrg.Add(sta.OrgID);
selorg(sta.OrgID, ref listOrg);
foreach (var item in ap)
{
var s = (from a in osms.Staff
join b in osms.Job
on a.JobId equals b.Id
where (listOrg.Contains(a.OrgID)) && b.Code == item.JobCode
select new
{
WaitForExecutionStaffId = a.Id
}).FirstOrDefault();
ProcessStepRecord psr = new ProcessStepRecord();
psr.Id = Guid.NewGuid();
psr.StepOrder = item.Order;
psr.CreateTime = DateTime.Now.ToLocalTime();
psr.UpdateTime = DateTime.Now.ToLocalTime();
psr.WaitForExecutionStaffId = s.WaitForExecutionStaffId;
psr.WhetherToExecute = false;
psr.No = oi.No;
psr.RefOrderId = oi.Id;
psr.Result = false;
psr.Type = (osms.ProcessItem.Where(x => x.Id == p_id).FirstOrDefault()).Code;
psr.Discrible = "未审批";
osms.ProcessStepRecord.Add(psr);
}
int i = osms.SaveChanges();
if (i > 0)
{
return(Content("OK"));
}
else
{
return(Content("NO"));
}
}
public ResponseModel <bool> OilOrder_Add(OilOrderViewModel model)
{
var user = _db.AspNetUsers.Where(x => true);
OilMaterialOrder o = new OilMaterialOrder();
o.Id = Guid.NewGuid();
o.No = "0";
o.ApplyPersonId = new Guid(user.Where(x => x.UserName == model.ApplyPersonId).FirstOrDefault().Id);
o.ApplyDate = model.ApplyDate;
o.Remark = model.Remark;
o.IsDel = false;
o.CreateTime = DateTime.Now;
o.UpdateTime = DateTime.Now;
OilMaterialOrderDetail d = new OilMaterialOrderDetail();
d.Id = Guid.NewGuid();
d.OrderId = o.Id;
d.OilSpec = model.OilSpec;
d.Volume = model.Volume;
d.Surplus = model.Surpuls;
d.DayAvg = model.DayAvg;
d.NeedAmount = model.NeedAmount;
d.CreateTime = DateTime.Now;
d.UpdateTime = DateTime.Now;
_db.OilMaterialOrder.Add(o);
_db.OilMaterialOrderDetail.Add(d);
int num = _db.SaveChanges();
if (num >= 2)
{
return(new ResponseModel <bool> {
code = (int)code.Success, data = true, message = "添加油料订单成功"
});
}
return(new ResponseModel <bool> {
code = (int)code.AddOilOrderFail, data = false, message = "添加油料订单失败"
});
}
