public ActionResult AddScheduler(int orderId, int orderServiceId, int serviceNatureId, string serviceWorkDate, string serviceWorkTime, string serviceWorkPlace, string tugId,
string isCaptainConfirm, string informCaptainTime, string captainConfirmTime, string ropeUsed, int ropeNum, string remark)
{
this.Internationalization();
try
{
TugDataEntities db = new TugDataEntities();
{
//插入多个调度到数据库
{
List<string> lstTugIds = tugId.Split(',').ToList();
if (lstTugIds != null && lstTugIds.Count > 0)
{
List<Scheduler> lstSchedulers = new List<Scheduler>();
foreach (string item in lstTugIds)
{
TugDataModel.Scheduler aScheduler = new Scheduler();
//aScheduler.OrderID = orderId;
//aScheduler.ServiceNatureID = serviceNatureId;
aScheduler.OrderServiceID = orderServiceId;
aScheduler.TugID = Util.toint(item);
aScheduler.RopeUsed = ropeUsed;
aScheduler.RopeNum = ropeNum;
aScheduler.Remark = remark;
aScheduler.IsCaptainConfirm = isCaptainConfirm;
aScheduler.InformCaptainTime = informCaptainTime;
aScheduler.CaptainConfirmTime = captainConfirmTime;
aScheduler.JobStateID = 32;
aScheduler.OwnerID = -1;
aScheduler.UserID = Session.GetDataFromSession<int>("userid");
aScheduler.CreateDate = aScheduler.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
aScheduler.UserDefinedCol1 = "";
aScheduler.UserDefinedCol2 = "";
aScheduler.UserDefinedCol3 = "";
aScheduler.UserDefinedCol4 = "";
//if (Request.Form["UserDefinedCol5"].Trim() != "")
// aScheduler.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"].Trim());
//if (Request.Form["UserDefinedCol6"].Trim() != "")
// aScheduler.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"].Trim());
//if (Request.Form["UserDefinedCol7"].Trim() != "")
// aScheduler.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"].Trim());
//if (Request.Form["UserDefinedCol8"].Trim() != "")
// aScheduler.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"].Trim());
aScheduler.UserDefinedCol9 = "";
aScheduler.UserDefinedCol10 = "";
lstSchedulers.Add(aScheduler);
}
db.Scheduler.AddRange(lstSchedulers);
db.SaveChanges();
}
}
{
//更新订单状态
//OrderInfor tmpOrder = db.OrderInfor.Where(u => u.IDX == orderId).FirstOrDefault();
//if (tmpOrder != null)
//{
// tmpOrder.WorkStateID = 3; //已排船
// db.Entry(tmpOrder).State = System.Data.Entity.EntityState.Modified;
// db.SaveChanges();
//}
}
//更新服务状态
{
OrderService os = db.OrderService.Where(u => u.IDX == orderServiceId).FirstOrDefault();
if (os == null)
{
os = new OrderService();
os.CreateDate = os.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
os.OrderID = orderId;
os.OwnerID = -1;
os.ServiceNatureID = serviceNatureId;
os.ServiceWorkDate = serviceWorkDate;
os.ServiceWorkTime = serviceWorkTime;
os.ServiceWorkPlace = serviceWorkPlace;
os.JobStateID = 115;
os.UserID = Session.GetDataFromSession<int>("userid");
os = db.OrderService.Add(os);
db.SaveChanges();
}
else
{
os.ServiceWorkDate = serviceWorkDate;
os.ServiceWorkTime = serviceWorkTime;
os.ServiceWorkPlace = serviceWorkPlace;
os.JobStateID = 115;
os.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
db.Entry(os).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
var ret = new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE };
//Response.Write(@Resources.Common.SUCCESS_MESSAGE);
return Json(ret);
}
}
catch (Exception)
{
var ret = new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE };
//Response.Write(@Resources.Common.EXCEPTION_MESSAGE);
return Json(ret);
}
}
public ActionResult AddEditScheduler()
{
this.Internationalization();
#region Add
if (Request.Form["oper"].Equals("add"))
{
try
{
TugDataEntities db = new TugDataEntities();
{
TugDataModel.Scheduler aScheduler = new Scheduler();
aScheduler.ArrivalBaseTime = Request.Form["ArrivalBaseTime"].Trim();
aScheduler.ArrivalShipSideTime = Request.Form["ArrivalShipSideTime"].Trim();
aScheduler.CaptainConfirmTime = Request.Form["CaptainConfirmTime"].Trim();
aScheduler.DepartBaseTime = Request.Form["DepartBaseTime"].Trim();
aScheduler.InformCaptainTime = Request.Form["InformCaptainTime"].Trim();
aScheduler.WorkCommencedTime = Request.Form["WorkCommencedTime"].Trim();
aScheduler.WorkCompletedTime = Request.Form["WorkCompletedTime"].Trim();
aScheduler.JobStateID = Util.toint(Request.Form["JobStateID"].Trim()); ;
//aScheduler.OrderID = Util.toint(Request.Form["OrderID"].Trim());
aScheduler.OwnerID = -1;
aScheduler.UserID = Session.GetDataFromSession<int>("userid");
aScheduler.Remark = Request.Form["Remark"].Trim(); ;
//aScheduler.RopeUsed = Request.Form["RopeUsed"].Trim();
//if (aScheduler.RopeUsed.Equals("是"))
// aScheduler.RopeNum = Util.toint(Request.Form["RopeNum"].Trim());
//else
// aScheduler.RopeNum = 0;
//aScheduler.ServiceNatureID = Util.toint(Request.Form["ServiceNatureLabel"].Trim().Split('~')[0]);
aScheduler.TugID = Util.toint(Request.Form["TugID"].Trim());
aScheduler.CreateDate = aScheduler.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
aScheduler.UserDefinedCol1 = Request.Form["UserDefinedCol1"].Trim();
aScheduler.UserDefinedCol2 = Request.Form["UserDefinedCol2"].Trim();
aScheduler.UserDefinedCol3 = Request.Form["UserDefinedCol3"].Trim();
aScheduler.UserDefinedCol4 = Request.Form["UserDefinedCol4"].Trim();
if (Request.Form["UserDefinedCol5"].Trim() != "")
aScheduler.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"].Trim());
if (Request.Form["UserDefinedCol6"].Trim() != "")
aScheduler.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"].Trim());
if (Request.Form["UserDefinedCol7"].Trim() != "")
aScheduler.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"].Trim());
if (Request.Form["UserDefinedCol8"].Trim() != "")
aScheduler.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"].Trim());
aScheduler.UserDefinedCol9 = Request.Form["UserDefinedCol9"].Trim();
aScheduler.UserDefinedCol10 = Request.Form["UserDefinedCol10"].Trim();
aScheduler = db.Scheduler.Add(aScheduler);
db.SaveChanges();
{
//更新订单状态
//OrderInfor tmpOrder = db.OrderInfor.Where(u => u.IDX == aScheduler.OrderID).FirstOrDefault();
//if(tmpOrder != null)
//{
// tmpOrder.WorkStateID = 3; //已排船
// db.Entry(tmpOrder).State = System.Data.Entity.EntityState.Modified;
// db.SaveChanges();
//}
}
{
//OrderService os = db.OrderService.Where(u => u.OrderID == aScheduler.OrderID && u.ServiceNatureID == aScheduler.ServiceNatureID).FirstOrDefault();
//if (os == null)
//{
// os = new OrderService();
// os.CreateDate = os.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
// os.OrderID = aScheduler.OrderID;
// os.OwnerID = -1;
// os.ServiceNatureID = aScheduler.ServiceNatureID;
// os.ServiceWorkDate = Request.Form["ServiceWorkDate"].Trim();
// os.ServiceWorkPlace = Request.Form["ServiceWorkPlace"].Trim();
// os.UserID = Session.GetDataFromSession<int>("userid");
// os = db.OrderService.Add(os);
// db.SaveChanges();
//}
//else
//{
// os.ServiceWorkDate = Request.Form["ServiceWorkDate"].Trim();
// os.ServiceWorkPlace = Request.Form["ServiceWorkPlace"].Trim();
// os.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
// db.Entry(os).State = System.Data.Entity.EntityState.Modified;
// db.SaveChanges();
//}
}
var ret = new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE };
//Response.Write(@Resources.Common.SUCCESS_MESSAGE);
return Json(ret);
}
}
catch (Exception)
{
var ret = new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE };
//Response.Write(@Resources.Common.EXCEPTION_MESSAGE);
return Json(ret);
}
}
#endregion Add
#region Edit
if (Request.Form["oper"].Equals("edit"))
{
try
{
TugDataEntities db = new TugDataEntities();
int idx = Util.toint(Request.Form["IDX"].Trim());
Scheduler aScheduler = db.Scheduler.Where(u => u.IDX == idx).FirstOrDefault();
if (aScheduler == null)
{
return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE });
}
else
{
//aScheduler.ArrivalBaseTime = Request.Form["ArrivalBaseTime"].Trim();
//aScheduler.ArrivalShipSideTime = Request.Form["ArrivalShipSideTime"].Trim();
//aScheduler.CaptainConfirmTime = Request.Form["CaptainConfirmTime"].Trim();
//aScheduler.DepartBaseTime = Request.Form["DepartBaseTime"].Trim();
//aScheduler.InformCaptainTime = Request.Form["InformCaptainTime"].Trim();
//aScheduler.WorkCommencedTime = Request.Form["WorkCommencedTime"].Trim();
//aScheduler.WorkCompletedTime = Request.Form["WorkCompletedTime"].Trim();
//aScheduler.JobStateID = Util.toint(Request.Form["JobStateID"].Trim()); ;
//aScheduler.OrderID = Util.toint(Request.Form["OrderID"].Trim());
aScheduler.OwnerID = -1;
aScheduler.UserID = Session.GetDataFromSession<int>("userid");
aScheduler.Remark = Request.Form["Remark"].Trim();
aScheduler.IsCaptainConfirm = Request.Form["IsCaptainConfirm"].Trim();
//aScheduler.RopeUsed = Request.Form["RopeUsed"].Trim();
//if (aScheduler.RopeUsed.Equals("是"))
// aScheduler.RopeNum = Util.toint(Request.Form["RopeNum"].Trim());
//else
// aScheduler.RopeNum = 0;
//aScheduler.ServiceNatureID = Util.toint(Request.Form["ServiceNatureLabel"].Trim().Split('~')[0]);
//aScheduler.TugID = Util.toint(Request.Form["TugID"].Trim());
aScheduler.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
//aScheduler.UserDefinedCol1 = Request.Form["UserDefinedCol1"].Trim();
//aScheduler.UserDefinedCol2 = Request.Form["UserDefinedCol2"].Trim();
//aScheduler.UserDefinedCol3 = Request.Form["UserDefinedCol3"].Trim();
//aScheduler.UserDefinedCol4 = Request.Form["UserDefinedCol4"].Trim();
//if (Request.Form["UserDefinedCol5"].Trim() != "")
// aScheduler.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"].Trim());
//if (Request.Form["UserDefinedCol6"].Trim() != "")
// aScheduler.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"].Trim());
//if (Request.Form["UserDefinedCol7"].Trim() != "")
// aScheduler.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"].Trim());
//if (Request.Form["UserDefinedCol8"].Trim() != "")
// aScheduler.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"].Trim());
//aScheduler.UserDefinedCol9 = Request.Form["UserDefinedCol9"].Trim();
//aScheduler.UserDefinedCol10 = Request.Form["UserDefinedCol10"].Trim();
db.Entry(aScheduler).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
{
//OrderService os = db.OrderService.Where(u => u.OrderID == aScheduler.OrderID && u.ServiceNatureID == aScheduler.ServiceNatureID).FirstOrDefault();
//if (os == null)
//{
// os = new OrderService();
// os.CreateDate = os.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
// os.OrderID = aScheduler.OrderID;
// os.OwnerID = -1;
// os.ServiceNatureID = aScheduler.ServiceNatureID;
// os.ServiceWorkDate = Request.Form["ServiceWorkDate"].Trim();
// os.ServiceWorkPlace = Request.Form["ServiceWorkPlace"].Trim();
// os.UserID = Session.GetDataFromSession<int>("userid");
// os = db.OrderService.Add(os);
// db.SaveChanges();
//}
//else
//{
// os.ServiceWorkDate = Request.Form["ServiceWorkDate"].Trim();
// os.ServiceWorkPlace = Request.Form["ServiceWorkPlace"].Trim();
// os.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
// db.Entry(os).State = System.Data.Entity.EntityState.Modified;
// db.SaveChanges();
//}
}
return Json(new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE });
}
}
catch (Exception exp)
{
return Json(new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE });
}
}
#endregion Edit
return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE });
}
public ActionResult AddEditService2()
{
this.Internationalization();
#region Edit
using (System.Transactions.TransactionScope trans = new System.Transactions.TransactionScope())
{
if (Request.Form["oper"].Equals("edit"))
{
try
{
TugDataEntities db = new TugDataEntities();
int idx = Util.toint(Request.Form["OrderServiceID"].Trim());
int orderid = Util.toint(Request.Form["OrderID"].Trim());
var customerName = Request.Form["CustomerName"].Trim();
var shipName = Request.Form["ShipName"].Trim();
int customerid;// = Util.toint(Request.Form["CustomerID"].Trim());
int shipid;//= Util.toint(Request.Form["ShipID"].Trim());
//判断客户名称是否存在
System.Linq.Expressions.Expression<Func<Customer, bool>> expctm = u => u.Name1 == customerName;
Customer objctm = db.Customer.Where(expctm).FirstOrDefault();
if (objctm == null)
{
//throw new Exception("客戶名稱不存在！");
return Json(new { code = Resources.Common.ERROR_CODE, message = "客戶名稱不存在！" });
}
else
customerid = objctm.IDX;
//判断客户船名称是否存在//
System.Linq.Expressions.Expression<Func<CustomerShip, bool>> expcts = u => u.Name1 == shipName;
CustomerShip objcts = db.CustomerShip.Where(expcts).FirstOrDefault();
if (objcts == null)
{
//throw new Exception("客戶船名稱不存在！");
return Json(new { code = Resources.Common.ERROR_CODE, message = "客戶船名稱不存在！" });
}
else
shipid = objcts.IDX;
OrderService aOrderService = db.OrderService.Where(u => u.IDX == idx).FirstOrDefault();
if (aOrderService == null)
{
return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE });
}
else
{
aOrderService.ServiceWorkDate = Request.Form["ServiceWorkDate"];
aOrderService.ServiceWorkTime = Request.Form["ServiceWorkTime"];
aOrderService.ServiceNatureID = TugBusinessLogic.Module.Util.toint(Request.Form["ServiceNatureID"]);
aOrderService.ServiceWorkPlace = Request.Form["ServiceWorkPlace"];
aOrderService.BigTugNum = Util.toint(Request.Form["BigTugNum"].Trim());
aOrderService.MiddleTugNum = Util.toint(Request.Form["MiddleTugNum"].Trim());
aOrderService.SmallTugNum = Util.toint(Request.Form["SmallTugNum"].Trim());
aOrderService.UserDefinedCol9 = Request.Form["TugIDs"];
aOrderService.UserDefinedCol10 = Request.Form["TugNames"];
aOrderService.OwnerID = -1;
aOrderService.UserID = Session.GetDataFromSession<int>("userid");
aOrderService.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
db.Entry(aOrderService).State = System.Data.Entity.EntityState.Modified;
if (0 < db.SaveChanges()) //修改成功
{
//更新订单
OrderInfor aOrder = db.OrderInfor.Where(u => u.IDX == orderid).FirstOrDefault();
if (aOrder != null)
{
aOrder.CustomerID = customerid;// Util.toint(Request.Form["CustomerID"].Trim());
aOrder.CustomerName = Request.Form["CustomerName"].Trim();
aOrder.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
////aOrder.IsGuest = Request.Form["IsGuest"].Trim();
aOrder.LinkMan = Request.Form["LinkMan"].Trim();
aOrder.LinkPhone = Request.Form["LinkPhone"].Trim();
aOrder.LinkEmail = Request.Form["LinkEmail"].Trim();
//aOrder.OrdDate = Request.Form["OrdDate"].Trim();
aOrder.ShipID = shipid;//Util.toint(Request.Form["ShipID"].Trim());
aOrder.ShipName = Request.Form["ShipName"].Trim();
//aOrder.Remark = Request.Form["Remark"].Trim();
//aOrder.UserDefinedCol1 = Request.Form["UserDefinedCol1"].Trim();
//aOrder.UserDefinedCol2 = Request.Form["UserDefinedCol2"].Trim();
//aOrder.UserDefinedCol3 = Request.Form["UserDefinedCol3"].Trim();
//aOrder.UserDefinedCol4 = Request.Form["UserDefinedCol4"].Trim();
//if (Request.Form["UserDefinedCol5"].Trim() != "")
// aOrder.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"].Trim());
//if (Request.Form["UserDefinedCol6"].Trim() != "")
// aOrder.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"].Trim());
//if (Request.Form["UserDefinedCol7"].Trim() != "")
// aOrder.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"].Trim());
//if (Request.Form["UserDefinedCol8"].Trim() != "")
// aOrder.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"].Trim());
//aOrder.UserDefinedCol9 = Request.Form["UserDefinedCol9"].Trim();
//aOrder.UserDefinedCol10 = Request.Form["UserDefinedCol10"].Trim();
db.Entry(aOrder).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
//1.先删除原有的调度
var oldSchedulers = db.Scheduler.Where(u => u.OrderServiceID == idx).ToList();
if (oldSchedulers != null)
{
db.Scheduler.RemoveRange(oldSchedulers);
if (0 < db.SaveChanges())
{
OrderService os = db.OrderService.FirstOrDefault(u => u.IDX == idx);
os.JobStateID = 114;
db.Entry(os).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
//2.插入新更改的调度
#region 插入多个调度到数据库
{
if (aOrderService.UserDefinedCol9.Trim() != "")
{
List<string> lstTugIds = aOrderService.UserDefinedCol9.Split(',').ToList();
if (lstTugIds != null && lstTugIds.Count > 0)
{
List<Scheduler> lstSchedulers = new List<Scheduler>();
foreach (string item in lstTugIds)
{
TugDataModel.Scheduler aScheduler = new Scheduler();
aScheduler.OrderServiceID = idx;
aScheduler.TugID = Util.toint(item);
aScheduler.RopeUsed = "";
aScheduler.RopeNum = 0;
aScheduler.Remark = "";
aScheduler.IsCaptainConfirm = "";
aScheduler.InformCaptainTime = "";
aScheduler.CaptainConfirmTime = "";
aScheduler.JobStateID = 32;
aScheduler.OwnerID = -1;
aScheduler.UserID = Session.GetDataFromSession<int>("userid");
aScheduler.CreateDate = aScheduler.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
aScheduler.UserDefinedCol1 = "";
aScheduler.UserDefinedCol2 = "";
aScheduler.UserDefinedCol3 = "";
aScheduler.UserDefinedCol4 = "";
aScheduler.UserDefinedCol9 = "";
aScheduler.UserDefinedCol10 = "";
lstSchedulers.Add(aScheduler);
}
db.Scheduler.AddRange(lstSchedulers);
if (0 < db.SaveChanges())
{
OrderService os = db.OrderService.FirstOrDefault(u => u.IDX == idx);
os.JobStateID = 115;
db.Entry(os).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
}
}
#endregion
}
trans.Complete();
return Json(new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE });
}
}
catch (Exception ex)
{
trans.Dispose();
throw ex;
//return Json(new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE });
}
}
}
#endregion Edit
return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE });
}
public ActionResult AddScheduler2(int orderServiceId, string tugIds, string tugNames)
{
this.Internationalization();
try
{
TugDataEntities db = new TugDataEntities();
{
//1.先删除原有的调度
var oldSchedulers = db.Scheduler.Where(u => u.OrderServiceID == orderServiceId).ToList();
if (oldSchedulers != null)
{
db.Scheduler.RemoveRange(oldSchedulers);
if (0 < db.SaveChanges())
{
OrderService os = db.OrderService.FirstOrDefault(u => u.IDX == orderServiceId);
os.JobStateID = 114;
os.UserDefinedCol9 = tugIds;
os.UserDefinedCol10 = tugNames;
db.Entry(os).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
//2.插入新更改的调度
#region 插入多个调度到数据库
{
if (tugIds.Trim() != "")
{
List<string> lstTugIds = tugIds.Split(',').ToList();
if (lstTugIds != null && lstTugIds.Count > 0)
{
List<Scheduler> lstSchedulers = new List<Scheduler>();
foreach (string item in lstTugIds)
{
TugDataModel.Scheduler aScheduler = new Scheduler();
aScheduler.OrderServiceID = orderServiceId;
aScheduler.TugID = Util.toint(item);
aScheduler.RopeUsed = "";
aScheduler.RopeNum = 0;
aScheduler.Remark = "";
aScheduler.IsCaptainConfirm = "";
aScheduler.InformCaptainTime = "";
aScheduler.CaptainConfirmTime = "";
aScheduler.JobStateID = 32;
aScheduler.OwnerID = -1;
aScheduler.UserID = Session.GetDataFromSession<int>("userid");
aScheduler.CreateDate = aScheduler.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
aScheduler.UserDefinedCol1 = "";
aScheduler.UserDefinedCol2 = "";
aScheduler.UserDefinedCol3 = "";
aScheduler.UserDefinedCol4 = "";
aScheduler.UserDefinedCol9 = "";
aScheduler.UserDefinedCol10 = "";
lstSchedulers.Add(aScheduler);
}
db.Scheduler.AddRange(lstSchedulers);
if (0 < db.SaveChanges())
{
OrderService os = db.OrderService.FirstOrDefault(u => u.IDX == orderServiceId);
os.JobStateID = 115;
os.UserDefinedCol9 = tugIds;
os.UserDefinedCol10 = tugNames;
db.Entry(os).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
}
}
#endregion
var ret = new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE };
//Response.Write(@Resources.Common.SUCCESS_MESSAGE);
return Json(ret);
}
}
catch (Exception)
{
var ret = new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE };
//Response.Write(@Resources.Common.EXCEPTION_MESSAGE);
return Json(ret);
}
}