public string OrderAdd()
{
string returnResult = String.Empty;
var content = JObject.Parse(Request.Params[0]);
string returnString = "添加失败！";
if (content != null)
{
SysWorkOrder order = new SysWorkOrder();
order.LastUpdateUserId = Int32.Parse(content.SelectToken("userid").ToString());
order.CreateTime = DateTime.Now;
order.LastUpdateTime = DateTime.Now;
order.DeviceCode = content.SelectToken("devicecode").ToString();
order.Device = content.SelectToken("device").ToString();
order.Department = content.SelectToken("department").ToString();
order.CurrentStatus = content.SelectToken("currentstatus").ToString();
order.OrderTitle = content.SelectToken("ordertitle").ToString();
order.Description = content.SelectToken("description").ToString();
SysWorkOrderLog orderlog = new SysWorkOrderLog();
orderlog.CreateTime = DateTime.Now;
orderlog.Description = content.SelectToken("logdescription").ToString();
orderlog.OperateUserId = Int32.Parse(content.SelectToken("userid").ToString());
DbServices.InsertNewSysWorkOrder(order, orderlog);
returnString = "添加成功！";
}
returnResult = JsonConvert.SerializeObject(new { msg = returnString });
return returnResult;
}
public static void InsertNewSysWorkOrder(SysWorkOrder order, SysWorkOrderLog orderLog)
{
using (WeChatDbContext entity = new WeChatDbContext())
{
var oldorder = (from item in entity.SysWorkOrder where item.SysWorkOrderId == order.SysWorkOrderId select item).SingleOrDefault();
if (oldorder == null)
{
var tempOrder = entity.SysWorkOrder.Add(order);
entity.SaveChanges();
orderLog.SysWorkOrderId = tempOrder.SysWorkOrderId;
entity.SysWorkOrderLog.Add(orderLog);
entity.SaveChanges();
}
}
}
public string OrderEdit()
{
string returnResult = String.Empty;
var content = JObject.Parse(Request.Params[0]);
string returnString = "更新失败！";
if (content != null)
{
SysWorkOrder order = new SysWorkOrder();
int orderid = Int32.Parse(content.SelectToken("orderid").ToString());
order = DbServices.GetSysWorkOrder(orderid);
order.CurrentStatus = content.SelectToken("status").ToString();
order.LastUpdateTime = DateTime.Now;
order.LastUpdateUserId = Int32.Parse(content.SelectToken("userid").ToString());
SysWorkOrderLog swol = new SysWorkOrderLog();
swol.CreateTime = DateTime.Now;
swol.Description = content.SelectToken("logdesc").ToString();
swol.SysWorkOrderId = orderid;
swol.OperateUserId = order.LastUpdateUserId;
DbServices.UpdateSysWorkOrder(order, swol);
returnString = "更新成功！";
}
returnResult = JsonConvert.SerializeObject(new { msg = returnString });
return returnResult;
}
public static void UpdateSysWorkOrder(SysWorkOrder order, SysWorkOrderLog orderLog)
{
using (WeChatDbContext entity = new WeChatDbContext())
{
var oldorder = (from item in entity.SysWorkOrder where item.SysWorkOrderId == order.SysWorkOrderId select item).SingleOrDefault();
if (oldorder != null)
{
entity.Entry(oldorder).State = System.Data.Entity.EntityState.Modified;
oldorder.OrderTitle = order.OrderTitle;
oldorder.LastUpdateTime = DateTime.Now;
oldorder.Device = order.Device;
oldorder.DeviceCode = order.DeviceCode;
oldorder.Description = order.Description;
oldorder.Department = order.Department;
oldorder.CurrentStatus = order.CurrentStatus;
oldorder.LastUpdateUserId = order.LastUpdateUserId;
entity.SysWorkOrderLog.Add(orderLog);
entity.SaveChanges();
}
}
}