//这个Tuple类型数组的amountlist中依次存储 int SchedulerID, int TugID, float Amount, float Hours
//一个账单调用一次
public void AmountSumAdd_Update(int CustomerID, int CustomerShipID, int BillingID, DateTime BillingDate, Tuple<int, int, float, float>[] amountlist)
{
try
{
TugDataEntities db = new TugDataEntities();
//先删除
System.Linq.Expressions.Expression<Func<AmountSum, bool>> exp = u => u.BillingID == BillingID;
var entitys = db.AmountSum.Where(exp);
entitys.ToList().ForEach(entity => db.Entry(entity).State = System.Data.Entity.EntityState.Deleted); //不加这句也可以
db.AmountSum.RemoveRange(entitys);
db.SaveChanges();
//新增
foreach(var obj in amountlist)
{
TugDataModel.AmountSum newobj = new AmountSum();
newobj.CustomerID = CustomerID;
newobj.CustomerShipID = CustomerShipID;
newobj.BillingID = BillingID;
newobj.BillingDateTime = BillingDate;
newobj.SchedulerID = obj.Item1;//SchedulerID;
newobj.TugID = obj.Item2;;
newobj.Amount = obj.Item3; ;
newobj.Hours = obj.Item4; ;
newobj.OwnerID = -1;
newobj.CreateDate = newobj.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); ;//.ToString("yyyy-MM-dd");
newobj.UserID = Session.GetDataFromSession<int>("userid");
newobj.UserDefinedCol1 = "";
newobj.UserDefinedCol2 = "";
newobj.UserDefinedCol3 = "";
newobj.UserDefinedCol4 = "";
//if (Request.Form["UserDefinedCol5"].Trim() != "")
// newobj.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"].Trim());
//if (Request.Form["UserDefinedCol6"].Trim() != "")
// newobj.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"].Trim());
//if (Request.Form["UserDefinedCol7"].Trim() != "")
// newobj.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"].Trim());
//if (Request.Form["UserDefinedCol8"].Trim() != "")
// newobj.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"].Trim());
newobj.UserDefinedCol9 = "";
newobj.UserDefinedCol10 = "";
newobj = db.AmountSum.Add(newobj);
}
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 ex)
{
throw ex;
}
}
public ActionResult AddEditRowUser(int rolId)
{
//this.Internationalization();
#region Add
if (Request.Form["oper"].Equals("add"))
{
try
{
TugDataEntities db = new TugDataEntities();
{
TugDataModel.UsersRole userRole = new UsersRole();
userRole.UserID = Util.toint(Request.Form["UserID"]);
userRole.RoleID = rolId;
userRole.IsAdmin = Request.Form["IsAdmin"];
userRole.System = "Role";
userRole.CreateDate = userRole.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); ;
userRole.OwnerID = -1;
userRole.AddUserID = Session.GetDataFromSession<int>("userid");
userRole.UserDefinedCol1 = Request.Form["UserDefinedCol1"];
userRole.UserDefinedCol2 = Request.Form["UserDefinedCol2"];
userRole.UserDefinedCol3 = Request.Form["UserDefinedCol3"];
userRole.UserDefinedCol4 = Request.Form["UserDefinedCol4"];
if (Request.Form["UserDefinedCol5"] != "")
userRole.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"]);
if (Request.Form["UserDefinedCol6"] != "")
userRole.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"]);
if (Request.Form["UserDefinedCol7"] != "")
userRole.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"]);
if (Request.Form["UserDefinedCol8"] != "")
userRole.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"]);
userRole.UserDefinedCol9 = Request.Form["UserDefinedCol9"];
userRole.UserDefinedCol10 = Request.Form["UserDefinedCol10"];
userRole = db.UsersRole.Add(userRole);
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"]);
UsersRole userRole = db.UsersRole.Where(u => u.IDX == idx).FirstOrDefault();
if (userRole == null)
{
return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE });
}
else
{
userRole.UserID = Util.toint(Request.Form["UserID"]);
userRole.RoleID = Util.toint(Request.Form["RoleID"]);
userRole.IsAdmin = Request.Form["IsAdmin"];
userRole.System = "Role";
userRole.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); ;
userRole.OwnerID = -1;
userRole.AddUserID = Session.GetDataFromSession<int>("userid");
userRole.UserDefinedCol1 = Request.Form["UserDefinedCol1"];
userRole.UserDefinedCol2 = Request.Form["UserDefinedCol2"];
userRole.UserDefinedCol3 = Request.Form["UserDefinedCol3"];
userRole.UserDefinedCol4 = Request.Form["UserDefinedCol4"];
if (Request.Form["UserDefinedCol5"] != "")
userRole.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"]);
if (Request.Form["UserDefinedCol6"] != "")
userRole.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"]);
if (Request.Form["UserDefinedCol7"] != "")
userRole.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"]);
if (Request.Form["UserDefinedCol8"] != "")
userRole.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"]);
userRole.UserDefinedCol9 = Request.Form["UserDefinedCol9"];
userRole.UserDefinedCol10 = Request.Form["UserDefinedCol10"];
db.Entry(userRole).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 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 AddEdit()
{
this.Internationalization();
#region Add
if (Request.Form["oper"].Equals("add"))
{
try
{
TugDataEntities db = new TugDataEntities();
{
TugDataModel.OrderInfor aOrder = new OrderInfor();
aOrder.Code = TugBusinessLogic.Utils.AutoGenerateOrderSequenceNo();
aOrder.CreateDate = aOrder.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
aOrder.CustomerID = Util.toint(Request.Form["CustomerID"]);
aOrder.CustomerName = Request.Form["CustomerName"].Trim();
aOrder.OrdDate = Request.Form["OrdDate"].Trim();
//aOrder.WorkDate = Request.Form["WorkDate"].Trim();
//aOrder.WorkTime = Request.Form["WorkTime"].Trim();
//aOrder.EstimatedCompletionTime = Request.Form["EstimatedCompletionTime"].Trim();
aOrder.IsGuest = "否"; // Request.Form["IsGuest"].Trim();
aOrder.LinkMan = Request.Form["LinkMan"].Trim();
aOrder.LinkPhone = Request.Form["LinkPhone"].Trim();
aOrder.LinkEmail = Request.Form["LinkEmail"].Trim();
//if (Request.Form["BigTugNum"].Trim() != "")
// aOrder.BigTugNum = Util.toint(Request.Form["BigTugNum"].Trim());
//if (Request.Form["MiddleTugNum"].Trim() != "")
// aOrder.MiddleTugNum = Util.toint(Request.Form["MiddleTugNum"].Trim());
//if (Request.Form["SmallTugNum"].Trim() != "")
// aOrder.SmallTugNum = Util.toint(Request.Form["SmallTugNum"].Trim());
aOrder.OwnerID = -1;
aOrder.Remark = Request.Form["Remark"].Trim();
aOrder.ShipID = Util.toint(Request.Form["ShipID"].Trim());
aOrder.ShipName = Request.Form["ShipName"].Trim();
aOrder.UserID = Session.GetDataFromSession<int>("userid");
//aOrder.WorkPlace = Request.Form["WorkPlace"].Trim();
//Dictionary<string, string> dic = TugBusinessLogic.Utils.ResolveServices(Request.Form["ServiceNatureNames"].Trim());
//aOrder.ServiceNatureIDS = dic["ids"];
//aOrder.ServiceNatureNames = dic["labels"];
//aOrder.WorkStateID = Util.toint(Request.Form["WorkStateID"].Trim());
aOrder.WorkStateID = 2; //CustomField表里面的OrderInfor.WorkStateID的IDX
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();
aOrder = db.OrderInfor.Add(aOrder);
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());
OrderInfor aOrder = db.OrderInfor.Where(u => u.IDX == idx).FirstOrDefault();
if (aOrder == null)
{
return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE });
}
else
{
aOrder.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.WorkDate = Request.Form["WorkDate"].Trim();
//aOrder.WorkTime = Request.Form["WorkTime"].Trim();
//aOrder.EstimatedCompletionTime = Request.Form["EstimatedCompletionTime"].Trim();
aOrder.ShipID = Util.toint(Request.Form["ShipID"].Trim());
aOrder.ShipName = Request.Form["ShipName"].Trim();
//if (Request.Form["BigTugNum"].Trim() != "")
// aOrder.BigTugNum = Util.toint(Request.Form["BigTugNum"].Trim());
//if (Request.Form["MiddleTugNum"].Trim() != "")
// aOrder.MiddleTugNum = Util.toint(Request.Form["MiddleTugNum"].Trim());
//if (Request.Form["SmallTugNum"].Trim() != "")
// aOrder.SmallTugNum = Util.toint(Request.Form["SmallTugNum"].Trim());
//aOrder.WorkPlace = Request.Form["WorkPlace"].Trim();
//Dictionary<string, string> dic = TugBusinessLogic.Utils.ResolveServices(Request.Form["ServiceNatureNames"].Trim());
//aOrder.ServiceNatureIDS = dic["ids"];
//aOrder.ServiceNatureNames = dic["labels"];
//aOrder.WorkStateID = Util.toint(Request.Form["WorkStateID"].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();
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 DeleteOrder_Service()
{
this.Internationalization();
using (TransactionScope trans = new TransactionScope())
{
try
{
var f = Request.Form;
int orderid = Util.toint(Request.Form["data[OrderID]"]);
int orderserviceid = Util.toint(Request.Form["data[OrderServiceID]"]);
TugDataEntities db = new TugDataEntities();
//System.Linq.Expressions.Expression<Func<V_OrderService_Scheduler, bool>> exps = u => u.UserDefinedCol1 == ordermark;
//List<V_OrderService_Scheduler> schedulerInfor = db.V_OrderService_Scheduler.Where(exps).Select(u => u).ToList<V_OrderService_Scheduler>();
//if (schedulerInfor.Count != 0)
//{
// return Json(new { code = Resources.Common.SUCCESS_CODE, message = "該訂單已排船，無法刪除！"});
//}
System.Linq.Expressions.Expression<Func<V_OrderService, bool>> exps = u => u.OrderID == orderid & (u.ServiceJobStateLabel == "已完工" || u.ServiceJobStateValue == "2");
List<V_OrderService> objs = db.V_OrderService.Where(exps).Select(u => u).ToList<V_OrderService>();
if (objs.Count != 0)
{
return Json(new { code = Resources.Common.SUCCESS_CODE, message = "該訂單的服务项已完工，無法刪除，如需刪除請先聯繫財務進行駁回操作!！" });//已完工
}
//获取服务项
System.Linq.Expressions.Expression<Func<OrderService, bool>> exp = u => u.OrderID == orderid;
List<OrderService> entityos = db.OrderService.Where(exp).ToList();
//先刪除該訂單下的排船信息
for (int i = 0; i < entityos.Count(); i++)
{
int ordsrvid = Util.toint(entityos[i].IDX);
System.Linq.Expressions.Expression<Func<Scheduler, bool>> exp0 = u => u.OrderServiceID == ordsrvid;
var entitysch = db.Scheduler.Where(exp0);
entitysch.ToList().ForEach(entity => db.Entry(entity).State = System.Data.Entity.EntityState.Deleted); //不加这句也可以
db.Scheduler.RemoveRange(entitysch);
db.SaveChanges();
}
//先删除订单下的所有服务项
entityos.ForEach(entity => db.Entry(entity).State = System.Data.Entity.EntityState.Deleted); //不加这句也可以
db.OrderService.RemoveRange(entityos);
db.SaveChanges();
//删除订单
System.Linq.Expressions.Expression<Func<OrderInfor, bool>> exp2 = u => u.IDX == orderid;
var entityord = db.OrderInfor.Where(exp2);
entityord.ToList().ForEach(entity => db.Entry(entity).State = System.Data.Entity.EntityState.Deleted); //不加这句也可以
db.OrderInfor.RemoveRange(entityord);
db.SaveChanges();
trans.Complete();
return Json(new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE });
}
catch (Exception)
{
trans.Dispose();
return Json(new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE });
}
}
}
public ActionResult Add_EditOrder(string oper,string ordermark,int customerId, string customerName, string ordDate,
int shipId, string shipName, string linkMan, string linkPhone, string linkEmail, string remark,List<string[]> dataListFromTable)
{
//customerName中&符
customerName = customerName.Replace("~*~", "&");
TugDataModel.OrderInfor aOrder=null;
this.Internationalization();
using (System.Transactions.TransactionScope trans = new System.Transactions.TransactionScope())
{
try
{
TugDataEntities db = new TugDataEntities();
{
//判断客户名称是否存在
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("客戶名稱不存在！");
}
//判断客户船名称是否存在
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("客戶船名稱不存在！");
}
//获取服务项
System.Linq.Expressions.Expression<Func<OrderService, bool>> exp = u => u.UserDefinedCol1 == ordermark;
List<OrderService> entityos = db.OrderService.Where(exp).ToList();
//先刪除該訂單下的排船信息
for (int i = 0; i < entityos.Count(); i++)
{
int ordsrvid = Util.toint(entityos[i].IDX);
System.Linq.Expressions.Expression<Func<Scheduler, bool>> exp0 = u => u.OrderServiceID == ordsrvid;
var entitysch = db.Scheduler.Where(exp0);
entitysch.ToList().ForEach(entity => db.Entry(entity).State = System.Data.Entity.EntityState.Deleted); //不加这句也可以
db.Scheduler.RemoveRange(entitysch);
db.SaveChanges();
}
//先删除订单下的所有服务项
entityos.ForEach(entity => db.Entry(entity).State = System.Data.Entity.EntityState.Deleted); //不加这句也可以
db.OrderService.RemoveRange(entityos);
db.SaveChanges();
//删除订单
System.Linq.Expressions.Expression<Func<OrderInfor, bool>> exp2 = u => u.UserDefinedCol1 == ordermark;
var entityord = db.OrderInfor.Where(exp2);
entityord.ToList().ForEach(entity => db.Entry(entity).State = System.Data.Entity.EntityState.Deleted); //不加这句也可以
db.OrderInfor.RemoveRange(entityord);
db.SaveChanges();
//保存
//获取服务项
List<CustomField> listServ;
listServ = TugBusinessLogic.Utils.GetServices();
string mcode = TugBusinessLogic.Utils.AutoGenerateOrderSequenceNo();
for (int i = 0; i < dataListFromTable.Count - 1; i++)//最后一行空行
{
//保存订单
aOrder = new OrderInfor();
aOrder.Code = mcode;//TugBusinessLogic.Utils.AutoGenerateOrderSequenceNo();
aOrder.CreateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
aOrder.HasInvoice = "否"; //没有账单
aOrder.HasInFlow = "否"; //没有在流程中
aOrder.IsGuest = "否";
//if (oper == "add")
//{
// aOrder = new OrderInfor();
// aOrder.Code = TugBusinessLogic.Utils.AutoGenerateOrderSequenceNo();
// aOrder.CreateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
// aOrder.HasInvoice = "否"; //没有账单
// aOrder.HasInFlow = "否"; //没有在流程中
// aOrder.IsGuest = "否";
//}
//else if (oper == "edit")
//{
// aOrder = db.OrderInfor.Where(u => u.IDX == orderId).FirstOrDefault();
//}
aOrder.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
//aOrder.CustomerID = customerId;
aOrder.CustomerID = CustomerLogic.AutoAddCustomer("", customerName, "", "", linkMan, linkPhone, "", linkEmail, "", "", "", Session.GetDataFromSession<int>("userid"));
aOrder.CustomerName = customerName;
aOrder.OrdDate = ordDate;
aOrder.LinkMan = linkMan;
aOrder.LinkPhone = linkPhone;
aOrder.LinkEmail = linkEmail;
aOrder.OwnerID = -1;
aOrder.Remark = remark;
//aOrder.ShipID = shipId;
aOrder.ShipID = CustomerLogic.AutoAddCustomerShip((int)aOrder.CustomerID, shipName, "", "", "", "", "", "", "", "", Session.GetDataFromSession<int>("userid"));
aOrder.ShipName = shipName;
aOrder.UserID = Session.GetDataFromSession<int>("userid");
aOrder.WorkStateID = 2; //CustomField表里面的OrderInfor.WorkStateID的IDX 订单修改后订单改为未排船
aOrder.UserDefinedCol1 = mcode;
aOrder.UserDefinedCol2 = i.ToString();
aOrder.UserDefinedCol3 = dataListFromTable[i][0];
aOrder.UserDefinedCol4 = "";
//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 = "";
aOrder.UserDefinedCol10 = "";
aOrder = db.OrderInfor.Add(aOrder);
//if (oper == "add")
//{
// aOrder = db.OrderInfor.Add(aOrder);
//}
//else if (oper == "edit")
//{
// db.Entry(aOrder).State = System.Data.Entity.EntityState.Modified;
//}
db.SaveChanges();
//保存服务项
TugDataModel.OrderService obj = new OrderService();
obj.OrderID = aOrder.IDX;
string serName = dataListFromTable[i][0];
CustomField sv = listServ.Where(u => u.CustomLabel == serName).FirstOrDefault();
obj.ServiceNatureID = sv.IDX;
obj.ServiceWorkDate = TugBusinessLogic.Utils.CNDateTimeToDateTime(dataListFromTable[i][1]).ToString("yyyy-MM-dd");
obj.ServiceWorkTime = dataListFromTable[i][2];
//obj.EstimatedCompletionTime=
obj.ServiceWorkPlace = dataListFromTable[i][6];
obj.BigTugNum = Util.toint(dataListFromTable[i][3]);
obj.MiddleTugNum = Util.toint(dataListFromTable[i][4]);
obj.SmallTugNum = Util.toint(dataListFromTable[i][5]);
//obj.Remark = "";
obj.JobStateID = 114;
obj.HasBilling = "否";
obj.HasBillingInFlow = "否";
obj.OwnerID = -1;
obj.CreateDate = aOrder.CreateDate;
obj.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); ;
obj.UserID = Session.GetDataFromSession<int>("userid");
obj.UserDefinedCol1 = mcode;
//obj.UserDefinedCol2 = "";
//obj.UserDefinedCol3 = "";
//obj.UserDefinedCol4 = "";
//if (Request.Form["UserDefinedCol5"] != "")
// obj.UserDefinedCol5 = Util.toint(Request.Form["UserDefinedCol5"]);
//obj.UserDefinedCol6 =;
//obj.UserDefinedCol7 =;
//obj.UserDefinedCol8 =;
//obj.UserDefinedCol9 = "";
//obj.UserDefinedCol10 = "";
obj = db.OrderService.Add(obj);
db.SaveChanges();
}
trans.Complete();
var ret = new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE };
//Response.Write(@Resources.Common.SUCCESS_MESSAGE);
return Json(ret);
}
}
catch (Exception ex)
{
trans.Dispose();
throw ex;
//var ret = new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE };
////Response.Write(@Resources.Common.EXCEPTION_MESSAGE);
//return Json(ret);
}
}
}
public ActionResult AddEdit()
{
this.Internationalization();
//int idx = Util.toint(Request.Form["IDX"]);
//Fuelprice price = db.Fuelprice.Where(u => u.IDX == idx).FirstOrDefault();
#region Add
if (Request.Form["oper"].Equals("add"))
{
string CustomName = Request.Form["CustomName"].Trim();
string CustomValue = Request.Form["CustomLabel"].Trim();
try
{
TugDataEntities db = new TugDataEntities();
{
TugDataModel.CustomField custom = new CustomField();
custom.CustomName = CustomName;
custom.CustomValue = "";
custom.CustomLabel = CustomValue;
custom.Description = "";
custom.UserID = Session.GetDataFromSession<int>("userid");
custom.CreateDate = custom.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd");
custom = db.CustomField.Add(custom);
db.SaveChanges();
var ret = new { code = Resources.Common.SUCCESS_CODE, message = 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"]);
CustomField customedit = db.CustomField.Where(u => u.IDX == idx).FirstOrDefault();
string oldLocation = customedit.CustomLabel;
string newLocation = Request.Form["CustomLabel"].Trim();
string CustomName = customedit.CustomName;
string CustomValue = Request.Form["CustomLabel"].Trim();
CustomField custom = db.CustomField.Where(u => u.CustomName == CustomName && u.CustomLabel==CustomValue).FirstOrDefault();
if (custom != null)
{
throw new Exception(CustomValue + "已存在！");
}
else
{
customedit.CustomLabel = CustomValue;
customedit.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd");
customedit.UserID = Session.GetDataFromSession<int>("userid");
db.Entry(customedit).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
var list = db.OrderService.Where(u => u.ServiceWorkPlace.Trim().ToLower() == oldLocation.Trim().ToLower()).Select(u => u).ToList();
if (list != null)
{
foreach (var item in list)
{
item.ServiceWorkPlace = newLocation.Trim();
db.Entry(item).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
return Json(new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE });
}
}
catch (Exception ex)
{
throw ex;
}
}
#endregion Edit
return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE });
}
public ActionResult ApproveReject(List<int> rejectdata, string RejectReason)
{
int curUserId;
int BillingType = 0;
TugDataEntities db = new TugDataEntities();
curUserId = Session.GetDataFromSession<int>("userid");
foreach (int id in rejectdata)
{
//更改Billing状态
System.Linq.Expressions.Expression<Func<Billing, bool>> exp = u => u.IDX == id;
Billing billInfor = db.Billing.Where(exp).FirstOrDefault();
string billtype = billInfor.InvoiceType.ToString();
if (billtype == "特殊账单") BillingType = 1;
billInfor.Phase = 0;
billInfor.Status = "被駁回";
db.Entry(billInfor).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
//修改訂單表
FinanceLogic.SetOrderServiceFlowingStatus(BillingType, id, "否");
//写入Approve表
Approve addApprove = new Approve();
addApprove.BillingID = id;
addApprove.FlowMark = billInfor.TimesNo;
addApprove.Phase = billInfor.Phase;
addApprove.Task = Task(id, Convert.ToInt32(billInfor.Phase), Convert.ToInt32(billInfor.TimesNo));
addApprove.Accept = 0;
addApprove.PersonID = curUserId;
addApprove.UserID = curUserId;
addApprove.CreateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
addApprove.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
addApprove = db.Approve.Add(addApprove);
db.SaveChanges();
}
return Json(new { message = "操作完成！" });
}
public ActionResult ApprovePass(List<int> passdata)
{
//var ids = Request.Form["data"];
int curUserId = 0;
TugDataEntities db = new TugDataEntities();
curUserId = Session.GetDataFromSession<int>("userid");
foreach (int id in passdata)
{
System.Linq.Expressions.Expression<Func<Billing, bool>> exp = u => u.IDX == id;
Billing billInfor = db.Billing.Where(exp).FirstOrDefault();
//写入Approve表
Approve addApprove = new Approve();
addApprove.BillingID = id;
addApprove.FlowMark = billInfor.TimesNo;
addApprove.Phase = billInfor.Phase;
addApprove.Task = Task(id, Convert.ToInt32(billInfor.Phase), Convert.ToInt32(billInfor.TimesNo));
addApprove.Accept = 1;
addApprove.PersonID = curUserId;
addApprove.UserID = curUserId;
addApprove.CreateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
addApprove.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
addApprove = db.Approve.Add(addApprove);
db.SaveChanges();
//判断是不是流程最后一步
System.Linq.Expressions.Expression<Func<Flow, bool>> expFlow = u => u.BillingID == id && u.MarkID == billInfor.TimesNo;
List<Flow> flowData = db.Flow.Where(expFlow).Select(u => u).ToList<Flow>();
if (billInfor.Phase + 1 == flowData.Count) //流程最后一步
{
string billingCode = TugBusinessLogic.Utils.AutoGenerateBillCode();
//更改Billing状态
billInfor.Phase = -1;
billInfor.Status = "完成";
if (Util.checkdbnull(billInfor.BillingCode)=="") billInfor.BillingCode = billingCode; //生成账单编号
billInfor.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
db.Entry(billInfor).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
//若账单有回扣单生成回扣单编号
System.Linq.Expressions.Expression<Func<Credit, bool>> expCredit = u => u.BillingID == id;
List<Credit> tmpCredit = db.Credit.Where(expCredit).Select(u => u).ToList<Credit>();
//Credit tmpCredit = db.Credit.Where(expCredit).FirstOrDefault();
if (tmpCredit.Count != 0)
{
foreach (var item in tmpCredit)
{
if (Util.checkdbnull(item.CreditCode) == "")
{
item.CreditCode = "C" + billInfor.BillingCode.Substring(1, billingCode.Length - 1);
db.Entry(item).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
}
}
else
{
//更改Billing状态
billInfor.Phase = billInfor.Phase + 1;
billInfor.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
billInfor.Status = Task(id, Convert.ToInt32(billInfor.Phase), Convert.ToInt32(billInfor.TimesNo));
db.Entry(billInfor).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
return Json(new { message = "审核完成！" });
}
public ActionResult UpdateUserInfor(string UserName)
{
TugDataEntities db = new TugDataEntities();
System.Linq.Expressions.Expression<Func<UserInfor, bool>> exp = u => u.UserName == UserName;
try
{
UserInfor user = db.UserInfor.Where(exp).FirstOrDefault();
if (user != null) //更新用户信息
{
user.Name1 = Request.Form["Name1"].ToString();
user.Name2 = Request.Form["Name2"].ToString();
user.Email = Request.Form["Email"].ToString();
user.Tel = Request.Form["Tel"].ToString();
user.Sex = Request.Form["Sex"].ToString();
db.Entry(user).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return Json(new { message = "个人信息已更新！" });
}
else //失败
{
return Json(new { message = "未找到当前用户信息！" });
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return Json(new { message = ex.Message });
//throw;
}
}
public ActionResult SetHomePage(string controller, string action)
{
//string v = ControllerContext.RouteData.Values["action"].ToString();
int curUserId = 0;
TugDataEntities db = new TugDataEntities();
curUserId = Session.GetDataFromSession<int>("userid");
UserInfor objs = db.UserInfor.Where(u => u.IDX == curUserId).FirstOrDefault();
//objs.UserDefinedCol1 = Session.GetDataFromSession<string>("HomePage");
objs.UserDefinedCol2 = "/" + controller + "/" + action;
db.Entry(objs).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return Json(new { message = "恁已設置當前頁為首頁！" });
}
public ActionResult SavePwd()
{
string pwd = Request.Form["Pwd"].ToString();
string newpwd = Request.Form["newPwd"].ToString();
TugDataEntities db = new TugDataEntities();
UserInfor newUser = new UserInfor();
System.Linq.Expressions.Expression<Func<UserInfor, bool>> exp = u => u.UserName == User.Identity.Name && u.Pwd == pwd;
UserInfor user = db.UserInfor.Where(exp).FirstOrDefault();
if (user != null) //原密码验证通过
{
user.Pwd = newpwd;
db.Entry(user).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return Json(new { message = "新密码已生效，请重新登录！" });
}
else //原密码错误
{
//Response.StatusCode = (int)HttpStatusCode.BadRequest;
Response.StatusCode = 404;
return Json(new { message = "原密码不正确，请重新输入！" });
}
}
public ActionResult AddEdit(string EffectiveDate, double Price)
{
this.Internationalization();
#region Add
if (Request.Form["oper"].Equals("add"))
{
try
{
TugDataEntities db = new TugDataEntities();
{
TugDataModel.Fuelprice price = new Fuelprice();
price.EffectiveDate = EffectiveDate;
price.Price = Price;
price.Unit = "";
price.Type ="";
price.CreateDate = price.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); ;
price.AddUserID = Session.GetDataFromSession<int>("userid");
price = db.Fuelprice.Add(price);
db.SaveChanges();
var ret = new { code = Resources.Common.SUCCESS_CODE, message = 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"]);
Fuelprice price = db.Fuelprice.Where(u => u.IDX == idx).FirstOrDefault();
if (price == null)
{
return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE });
}
else
{
price.EffectiveDate = EffectiveDate;
price.Price = Price;
price.Unit = "";
price.Type = "";
price.CreateDate = price.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); ;
price.AddUserID = Session.GetDataFromSession<int>("userid");
db.Entry(price).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 AddEdit()
{
this.Internationalization();
#region Add
if (Request.Form["oper"].Equals("add"))
{
try
{
TugDataEntities db = new TugDataEntities();
{
TugDataModel.TugInfor tug = new TugInfor();
tug.Code = Request.Form["Code"];
tug.Name1 = Request.Form["Name1"];
tug.Name2 = Request.Form["Name2"];
tug.SimpleName = Request.Form["SimpleName"];
tug.Power = Request.Form["Power"];
tug.Class = Request.Form["Class"];
tug.Speed = Request.Form["Speed"];
tug.Length = Request.Form["Length"];
tug.Width = Request.Form["Width"];
tug.Remark = Request.Form["Remark"];
tug.OwnerID = -1;
tug.CreateDate = tug.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");;
tug.UserID = Session.GetDataFromSession<int>("userid");
tug.UserDefinedCol1 = Request.Form["UserDefinedCol1"];
tug.UserDefinedCol2 = Request.Form["UserDefinedCol2"];
tug.UserDefinedCol3 = Request.Form["UserDefinedCol3"];
tug.UserDefinedCol4 = Request.Form["UserDefinedCol4"];
if (Request.Form["UserDefinedCol5"] != "")
tug.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"]);
if (Request.Form["UserDefinedCol6"] != "")
tug.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"]);
if (Request.Form["UserDefinedCol7"] != "")
tug.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"]);
if (Request.Form["UserDefinedCol8"] != "")
tug.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"]);
tug.UserDefinedCol9 = Request.Form["UserDefinedCol9"];
tug.UserDefinedCol10 = Request.Form["UserDefinedCol10"];
tug = db.TugInfor.Add(tug);
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();
string name1 = Request.Form["Name1"];
int idx = Util.toint(Request.Form["IDX"]);
System.Linq.Expressions.Expression<Func<TugInfor, bool>> exp = u => u.Name1 == name1 && u.IDX != idx;
TugInfor tmpName = db.TugInfor.Where(exp).FirstOrDefault();
if (tmpName != null)
{
return Json(new { code = Resources.Common.ERROR_CODE, message = "拖轮名称1已存在！" });//Resources.Common.ERROR_MESSAGE
}
TugInfor tug = db.TugInfor.Where(u => u.IDX == idx).FirstOrDefault();
if (tug == null)
{
return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE });
}
else
{
string oldTugName1 = tug.Name1;
string newTugName1 = Request.Form["Name1"].Trim();
int tugIdx = idx;
tug.Code = Request.Form["Code"];
tug.Name1 = Request.Form["Name1"];
tug.Name2 = Request.Form["Name2"];
tug.SimpleName = Request.Form["SimpleName"];
tug.Power = Request.Form["Power"];
tug.Class = Request.Form["Class"];
tug.Speed = Request.Form["Speed"];
tug.Length = Request.Form["Length"];
tug.Width = Request.Form["Width"];
tug.Remark = Request.Form["Remark"];
tug.OwnerID = -1;
tug.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");;
tug.UserID = Session.GetDataFromSession<int>("userid");
tug.UserDefinedCol1 = Request.Form["UserDefinedCol1"];
tug.UserDefinedCol2 = Request.Form["UserDefinedCol2"];
tug.UserDefinedCol3 = Request.Form["UserDefinedCol3"];
tug.UserDefinedCol4 = Request.Form["UserDefinedCol4"];
if (Request.Form["UserDefinedCol5"] != "")
tug.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"]);
if (Request.Form["UserDefinedCol6"] != "")
tug.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"]);
if (Request.Form["UserDefinedCol7"] != "")
tug.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"]);
if (Request.Form["UserDefinedCol8"] != "")
tug.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"]);
tug.UserDefinedCol9 = Request.Form["UserDefinedCol9"];
tug.UserDefinedCol10 = Request.Form["UserDefinedCol10"];
db.Entry(tug).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
TugBusinessLogic.Utils.UpDateTugName1(tugIdx, oldTugName1, newTugName1);
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 Delete()
{
this.Internationalization();
using (TransactionScope trans = new TransactionScope())
{
try
{
var f = Request.Form;
int idx = Util.toint(Request.Form["data[IDX]"]);
TugDataEntities db = new TugDataEntities();
//先判断此客户是否已被使用过
OrderInfor obj = db.OrderInfor.FirstOrDefault(u => u.CustomerID == idx);
if (obj != null) throw new Exception("此客戶已在訂單中使用過，不能被刪除！");
//先删除客户船
System.Linq.Expressions.Expression<Func<CustomerShip, bool>> exp0 = u => u.CustomerID == idx;
var entitys = db.CustomerShip.Where(exp0);
entitys.ToList().ForEach(entity => db.Entry(entity).State = System.Data.Entity.EntityState.Deleted); //不加这句也可以
db.CustomerShip.RemoveRange(entitys);
db.SaveChanges();
//删除客户
Customer cstmer = db.Customer.FirstOrDefault(u => u.IDX == idx);
db.Customer.Remove(cstmer);
db.SaveChanges();
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 });
}
}
}
public ActionResult DeleteCustomerBillScheme()
{
this.Internationalization();
try
{
var f = Request.Form;
int idx = Util.toint(Request.Form["data[BillingTemplateIDX]"]);
TugDataEntities db = new TugDataEntities();
//先判断此计费方案有没有被使用过
Billing obj = db.Billing.FirstOrDefault(u => u.BillingTemplateID == idx);
if (obj != null)
{
//throw new Exception("此計費方案已在賬單中使用過，不能被刪除！");
BillingTemplate cstmer = db.BillingTemplate.FirstOrDefault(u => u.IDX == idx);
cstmer.UserDefinedCol6 = -1;
db.Entry(cstmer).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return Json(new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE });
}
else
{
BillingTemplate cstmer = db.BillingTemplate.FirstOrDefault(u => u.IDX == idx);
if (cstmer != null)
{
List<BillingItemTemplate> items = db.BillingItemTemplate.Where(u => u.BillingTemplateID == cstmer.IDX).ToList();
if (items != null)
db.BillingItemTemplate.RemoveRange(items);
db.BillingTemplate.Remove(cstmer);
db.SaveChanges();
return Json(new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE });
}
else
{
return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE });
}
}
}
catch (Exception ex)
{
//return Json(new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE });
throw ex;
}
}
public ActionResult RepealPass()
{
//int idx = Util.toint(Request.Form["data[IDX]"].Trim());
var f = Request.Form;
int BillingType = 0;
int idx = Convert.ToInt32(Request.Form["data[IDX]"]);
TugDataEntities db = new TugDataEntities();
System.Linq.Expressions.Expression<Func<Billing, bool>> exp = u => u.IDX == idx;
Billing billInfor = db.Billing.Where(exp).FirstOrDefault();
int Phase = Convert.ToInt32(billInfor.Phase);
int timeNo = Convert.ToInt32(billInfor.TimesNo);
int tmpUserID = Convert.ToInt32(Request.Form["data[UserID]"]);
int curUserId = Session.GetDataFromSession<int>("userid");
string billtype = billInfor.InvoiceType.ToString();
if (billtype == "特殊账单") BillingType = 1;
System.Linq.Expressions.Expression<Func<Flow, bool>> expF = u => u.BillingID == idx && u.MarkID == timeNo && u.FlowUserID == curUserId;
Flow flowData = db.Flow.Where(expF).FirstOrDefault();
if (tmpUserID == curUserId)
{
return Json(new { message = "该记录是您的提交任务，您无法撤销通过！" });
}
else if (Phase > flowData.Phase + 1) //流程已进入下一审核环节，不能撤销
{
var ret = new { code = Resources.Common.ERROR_CODE, message = "已进入下一审核环节，不能撤销！" };
return Json(ret);
}
else
{
//更新Billing表状态
billInfor.Phase = 0;
billInfor.Status = "已撤销通过";
db.Entry(billInfor).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
//修改訂單表
FinanceLogic.SetOrderServiceFlowingStatus(BillingType, idx, "否");
//写入Approve表
System.Linq.Expressions.Expression<Func<Approve, bool>> expA = u => u.BillingID == idx && u.FlowMark == timeNo && u.PersonID == curUserId;
Approve approveInfor = db.Approve.Where(expA).FirstOrDefault(); //获取当前用户的审核信息
Approve addApprove = new Approve();
addApprove.BillingID = idx;
addApprove.FlowMark = billInfor.TimesNo;
addApprove.Phase = approveInfor.Phase;
addApprove.Task = approveInfor.Task;
addApprove.Accept = 4;
addApprove.PersonID = curUserId;
addApprove.UserID = curUserId;
addApprove.CreateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
addApprove.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
addApprove = db.Approve.Add(addApprove);
db.SaveChanges();
return Json(new { 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);
}
}
public ActionResult RepealSubmit(Billing data)
{
int id = data.IDX;
int BillingType = 0;
int idx = Util.toint(Request.Form["data[IDX]"].Trim());
TugDataEntities db = new TugDataEntities();
System.Linq.Expressions.Expression<Func<Billing, bool>> exp = u => u.IDX == idx;
Billing billInfor = db.Billing.Where(exp).FirstOrDefault();
int Phase = Convert.ToInt32(billInfor.Phase);
int timeNo = Convert.ToInt32(billInfor.TimesNo);
int curUserId = Session.GetDataFromSession<int>("userid");
if (Phase > 1 || Phase == -1) //流程已进入审核环节或已完成全部审核，不能撤销
{
var ret = new { code = Resources.Common.ERROR_CODE, message = "流程已进入审核环节，不能撤销！" };
return Json(ret);
}
else
{
//更新Billing状态
billInfor.Phase = 0;
billInfor.Status = "已撤销提交";
db.Entry(billInfor).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
string billtype = billInfor.InvoiceType.ToString();
if (billtype == "特殊账单") BillingType = 1;
//修改訂單表
FinanceLogic.SetOrderServiceFlowingStatus(BillingType, idx, "否");
//写入Approve表
Approve addApprove = new Approve();
addApprove.BillingID = idx;
addApprove.FlowMark = billInfor.TimesNo;
addApprove.Phase = 0;
addApprove.Task = "创建";
addApprove.Accept = 3;
addApprove.PersonID = curUserId;
addApprove.UserID = curUserId;
addApprove.CreateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
addApprove.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
addApprove = db.Approve.Add(addApprove);
db.SaveChanges();
return Json(new { message = "撤销成功！" });
}
}
public ActionResult ChangeServiceStatusToComplete(int orderId, int orderServiceId)
{
TugDataEntities db = new TugDataEntities();
OrderService os = db.OrderService.FirstOrDefault(u => u.IDX == orderServiceId);
if (os != null)
{
int neededTotalShipNumbers = TugBusinessLogic.Module.Util.toint(os.BigTugNum) + TugBusinessLogic.Module.Util.toint(os.MiddleTugNum) + TugBusinessLogic.Module.Util.toint(os.SmallTugNum);
int realTotalShipNumbers = db.Scheduler.Where(u => u.OrderServiceID == os.IDX).ToList().Count;
if (realTotalShipNumbers != neededTotalShipNumbers)
{
var retJson = new { code = Resources.Common.FAIL_CODE, message = "已經排的拖輪和所需的拖輪數量不等，無法完成，請檢查實際排船數量！" };
//Response.Write(@Resources.Common.SUCCESS_MESSAGE);
return Json(retJson);
}
os.JobStateID = 116;
db.Entry(os).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
var list = db.V_OrderService.Where(u => u.OrderID == orderId).ToList();
if (list != null)
{
bool flag = true;
foreach (var item in list) //查看该订单下有没有未完成的服务，如果有，flag = false; 如果没有flag = true
{
if(item.ServiceJobStateID != 116 || item.ServiceJobStateValue != "2" ||item.ServiceJobStateLabel != "已完工")
{
flag = false;
break;
}
}
if (flag == true) //flag是true说明该订单下的所有服务都已经是完成状态，将订单状态改为已排船，否则是未排船
{
//更新订单状态为已排船
OrderInfor oi = db.OrderInfor.FirstOrDefault(u => u.IDX == orderId);
if(oi != null)
{
oi.WorkStateID = 3; //所有服务都完成订单状态变成“已排船”
db.Entry(oi).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);
}
else
{
var ret = new { code = Resources.Common.FAIL_CODE, message = Resources.Common.FAIL_MESSAGE };
//Response.Write(@Resources.Common.SUCCESS_MESSAGE);
return Json(ret);
}
}
public ActionResult AddEdit()
{
this.Internationalization();
#region Add
if (Request.Form["oper"].Equals("add"))
{
try
{
TugDataEntities db = new TugDataEntities();
{
TugDataModel.Customer cstmer = new Customer();
cstmer.Code = Request.Form["Code"];
cstmer.Name1 = Request.Form["Name1"];
cstmer.Name2 = Request.Form["Name2"];
cstmer.SimpleName = Request.Form["SimpleName"];
cstmer.TypeID = Util.toint(Request.Form["TypeID"]);
cstmer.ContactPerson = Request.Form["ContactPerson"];
cstmer.Telephone = Request.Form["Telephone"];
cstmer.Fax = Request.Form["Fax"];
cstmer.Email = Request.Form["Email"];
cstmer.Address = Request.Form["Address"];
cstmer.MailCode = Request.Form["MailCode"];
cstmer.Remark = Request.Form["Remark"];
cstmer.OwnerID = -1;
cstmer.CreateDate = cstmer.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");;//.ToString("yyyy-MM-dd");
cstmer.UserID = Session.GetDataFromSession<int>("userid");
cstmer.UserDefinedCol1 = Request.Form["UserDefinedCol1"];
cstmer.UserDefinedCol2 = Request.Form["UserDefinedCol2"];
cstmer.UserDefinedCol3 = Request.Form["UserDefinedCol3"];
cstmer.UserDefinedCol4 = Request.Form["UserDefinedCol4"];
if (Request.Form["UserDefinedCol5"] != "")
cstmer.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"]);
if (Request.Form["UserDefinedCol6"] != "")
cstmer.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"]);
if (Request.Form["UserDefinedCol7"] != "")
cstmer.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"]);
if (Request.Form["UserDefinedCol8"] != "")
cstmer.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"]);
cstmer.UserDefinedCol9 = Request.Form["UserDefinedCol9"];
cstmer.UserDefinedCol10 = Request.Form["UserDefinedCol10"];
cstmer = db.Customer.Add(cstmer);
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
{
int idx = Util.toint(Request.Form["IDX"]);
string name1 = Request.Form["Name1"];
TugDataEntities db = new TugDataEntities();
System.Linq.Expressions.Expression<Func<Customer, bool>> exp = u => u.Name1 == name1 && u.IDX!=idx;
Customer obj = db.Customer.Where(exp).FirstOrDefault();
if (obj != null)
{
return Json(new { code = Resources.Common.ERROR_CODE, message = "客户名称已存在！" });//Resources.Common.ERROR_MESSAGE
}
Customer cstmer = db.Customer.Where(u => u.IDX == idx).FirstOrDefault();
if (cstmer == null)
{
return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE });
}
else
{
cstmer.Code = Request.Form["Code"];
cstmer.Name1 = Request.Form["Name1"];
cstmer.Name2 = Request.Form["Name2"];
cstmer.SimpleName = Request.Form["SimpleName"];
cstmer.TypeID =Util.toint(Request.Form["TypeID"]);
cstmer.ContactPerson = Request.Form["ContactPerson"];
cstmer.Telephone = Request.Form["Telephone"];
cstmer.Fax = Request.Form["Fax"];
cstmer.Email = Request.Form["Email"];
cstmer.Address = Request.Form["Address"];
cstmer.MailCode = Request.Form["MailCode"];
cstmer.Remark = Request.Form["Remark"];
cstmer.OwnerID = -1;
cstmer.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");;
cstmer.UserID = Session.GetDataFromSession<int>("userid");
cstmer.UserDefinedCol1 = Request.Form["UserDefinedCol1"];
cstmer.UserDefinedCol2 = Request.Form["UserDefinedCol2"];
cstmer.UserDefinedCol3 = Request.Form["UserDefinedCol3"];
cstmer.UserDefinedCol4 = Request.Form["UserDefinedCol4"];
if (Request.Form["UserDefinedCol5"] != "")
cstmer.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"]);
if (Request.Form["UserDefinedCol6"] != "")
cstmer.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"]);
if (Request.Form["UserDefinedCol7"] != "")
cstmer.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"]);
if (Request.Form["UserDefinedCol8"] != "")
cstmer.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"]);
cstmer.UserDefinedCol9 = Request.Form["UserDefinedCol9"];
cstmer.UserDefinedCol10 = Request.Form["UserDefinedCol10"];
db.Entry(cstmer).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
var orderList = db.OrderInfor.Where(u => u.CustomerID == idx).ToList();
if (orderList != null)
{
foreach (var item in orderList)
{
item.CustomerName = cstmer.Name1;
db.Entry(item).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
return Json(new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE });
}
}
catch (Exception ex)
{
throw ex;
}
}
#endregion Edit
return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE });
}
public ActionResult DeleteScheduler()
{
this.Internationalization();
try
{
var f = Request.Form;
int idx = Util.toint(Request.Form["data[IDX]"].Trim());
int orderId = Util.toint(Request.Form["data[OrderID]"].Trim());
int orderServiceId = Util.toint(Request.Form["data[OrderServiceID]"].Trim());
TugDataEntities db = new TugDataEntities();
Scheduler aScheduler = db.Scheduler.FirstOrDefault(u => u.IDX == idx);
if (aScheduler != null)
{
//int orderId = (int)aScheduler.OrderID;
db.Scheduler.Remove(aScheduler);
db.SaveChanges();
//删除一个调度之后，要看是否还剩下调度
{
var list = db.V_OrderScheduler.Where(u => u.OrderID == orderId && u.OrderServiceID == orderServiceId).ToList();
if (list == null || list.Count == 0)
{
//更新服务状态
OrderService tmpOrder = db.OrderService.Where(u => u.IDX == orderServiceId).FirstOrDefault();
if (tmpOrder != null)
{
tmpOrder.JobStateID = 114; //未排船
db.Entry(tmpOrder).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
//else
//{
// //更新订单状态
// OrderInfor tmpOrder = db.OrderInfor.Where(u => u.IDX == orderId).FirstOrDefault();
// if (tmpOrder != null)
// {
// if (true == TugBusinessLogic.Module.OrderLogic.OrderJobInformationInputIsComplete(orderId))
// {
// tmpOrder.WorkStateID = 5; //已完工
// db.Entry(tmpOrder).State = System.Data.Entity.EntityState.Modified;
// db.SaveChanges();
// }
// }
//}
}
return Json(new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE });
}
else
{
return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE });
}
}
catch (Exception)
{
return Json(new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE });
}
}
public ActionResult AddEditCustomerBillScheme(int custId)
{
//this.Internationalization();
#region Add
if (Request.Form["oper"].Equals("add"))
{
try
{
//重名了
if (true == CheckBillingTemplateName(custId, Request.Form["BillingTemplateName"].Trim(), -1))
{
return Json(new { code = Resources.Common.FAIL_CODE, message = Resources.Common.FAIL_MESSAGE });
}
else
{
TugDataEntities db = new TugDataEntities();
{
TugDataModel.BillingTemplate cstmer = new BillingTemplate();
cstmer.BillingTemplateCode = Request.Form["BillingTemplateCode"].Trim();
cstmer.BillingTemplateName = Request.Form["BillingTemplateName"].Trim();
cstmer.BillingTemplateTypeID = Util.toint(Request.Form["BillingTemplateTypeID"].Trim());
cstmer.CreateDate = cstmer.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
cstmer.CustomerID = custId; // Convert.ToInt32(customerId);
cstmer.TemplateCreditContent = Request.Form["TemplateCreditContent"].Trim();
cstmer.TimeTypeID = Util.toint(Request.Form["TimeTypeID"].Trim());
cstmer.Discount = Convert.ToDouble(Request.Form["Discount"].Trim());
cstmer.Remark = Request.Form["Remark"].Trim();
cstmer.OwnerID = -1;
cstmer.UserID = Session.GetDataFromSession<int>("userid");
cstmer.UserDefinedCol1 = Request.Form["UserDefinedCol1"].Trim();
cstmer.UserDefinedCol2 = Request.Form["UserDefinedCol2"].Trim();
cstmer.UserDefinedCol3 = Request.Form["UserDefinedCol3"].Trim();
cstmer.UserDefinedCol4 = Request.Form["UserDefinedCol4"].Trim();
if (Request.Form["UserDefinedCol5"].Trim() != "")
cstmer.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"].Trim());
if (Request.Form["UserDefinedCol6"].Trim() != "")
cstmer.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"].Trim());
if (Request.Form["UserDefinedCol7"].Trim() != "")
cstmer.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"].Trim());
if (Request.Form["UserDefinedCol8"].Trim() != "")
cstmer.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"].Trim());
cstmer.UserDefinedCol9 = Request.Form["UserDefinedCol9"].Trim();
cstmer.UserDefinedCol10 = Request.Form["UserDefinedCol10"].Trim();
cstmer = db.BillingTemplate.Add(cstmer);
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["BillingTemplateIDX"]);
BillingTemplate cstmer = db.BillingTemplate.Where(u => u.IDX == idx).FirstOrDefault();
if (cstmer == null)
{
return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE });
}
//重名了
if (true == CheckBillingTemplateName(Util.toint(Request.Form["CustomerID"].Trim()), Request.Form["BillingTemplateName"].Trim(), idx))
{
return Json(new { code = Resources.Common.FAIL_CODE, message = Resources.Common.FAIL_MESSAGE });
}
else
{
cstmer.BillingTemplateCode = Request.Form["BillingTemplateCode"].Trim();
cstmer.BillingTemplateName = Request.Form["BillingTemplateName"].Trim();
cstmer.BillingTemplateTypeID = Util.toint(Request.Form["BillingTemplateTypeID"].Trim());
cstmer.CustomerID = Util.toint(Request.Form["CustomerID"].Trim());
cstmer.TemplateCreditContent = Request.Form["TemplateCreditContent"].Trim();
cstmer.TimeTypeID = Util.toint(Request.Form["TimeTypeID"].Trim());
cstmer.Discount = Convert.ToDouble(Request.Form["Discount"].Trim());
cstmer.ShipLength = (Request.Form["ShipLength"]);
cstmer.ShipTEUS = (Request.Form["ShipTEUS"]);
cstmer.ExpiryDate = Request.Form["ExpiryDate"].Trim();
cstmer.Remark = Request.Form["Remark"].Trim();
cstmer.OwnerID = -1;
cstmer.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
cstmer.UserID = Session.GetDataFromSession<int>("userid");
cstmer.UserDefinedCol1 = Request.Form["UserDefinedCol1"].Trim();
cstmer.UserDefinedCol2 = Request.Form["UserDefinedCol2"].Trim();
cstmer.UserDefinedCol3 = Request.Form["UserDefinedCol3"].Trim();
cstmer.UserDefinedCol4 = Request.Form["UserDefinedCol4"].Trim();
if (Request.Form["UserDefinedCol5"].Trim() != "")
cstmer.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"].Trim());
if (Request.Form["UserDefinedCol6"].Trim() != "")
cstmer.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"].Trim());
if (Request.Form["UserDefinedCol7"].Trim() != "")
cstmer.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"].Trim());
if (Request.Form["UserDefinedCol8"].Trim() != "")
cstmer.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"].Trim());
cstmer.UserDefinedCol9 = Request.Form["UserDefinedCol9"].Trim();
cstmer.UserDefinedCol10 = Request.Form["UserDefinedCol10"].Trim();
db.Entry(cstmer).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return Json(new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE });
}
}
catch (Exception)
{
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 RejectOrderServiceToScheduler(string orderIds)
{
List<string> list = orderIds.Split(',').ToList();
List<int> rejectedOrderIds = new List<int>();
if (list != null)
{
foreach (string item in list)
{
int rowId = Convert.ToInt32(item.Split(':')[0]);
int orderId = Convert.ToInt32(item.Split(':')[1]);
int ret = TugBusinessLogic.Module.OrderLogic.HasBilling(orderId);
if (ret != -1)
{
return Json(new
{
code = Resources.Common.SUCCESS_CODE,
message = Resources.Common.SUCCESS_MESSAGE,
has_invoice = ret,
rowId = rowId
}, JsonRequestBehavior.AllowGet);
}
else
{
rejectedOrderIds.Add(orderId);
}
}
}
//int ret = TugBusinessLogic.Module.OrderLogic.HasBilling(orderId);
//沒有帳單，可以駁回
//if (ret == -1)
{
using (System.Transactions.TransactionScope trans = new System.Transactions.TransactionScope())
{
try
{
TugDataEntities db = new TugDataEntities();
foreach (var orderId in rejectedOrderIds)
{
var lstOrderService = db.OrderService.Where(u => u.OrderID == orderId).ToList();
if (lstOrderService != null)
{
foreach (var item in lstOrderService)
{
var lstScheduler = db.Scheduler.Where(u => u.OrderServiceID == item.IDX).ToList();
if (lstScheduler != null)
{
foreach (var item2 in lstScheduler)
{
item2.DepartBaseTime = "";
item2.ArrivalBaseTime = "";
item2.RopeUsed = "否";
item2.Remark = "";
db.Entry(item2).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
item.JobStateID = 124;
db.Entry(item).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
//订单状态该为未排船
{
OrderInfor oi = db.OrderInfor.FirstOrDefault(u => u.IDX == orderId);
if (oi != null)
{
oi.WorkStateID = 2; //所有服务都未完成，因此订单状态变成“未排船”
oi.UserDefinedCol4 = "0"; //0是所有时间未录入完成
db.Entry(oi).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
var ord_services = db.OrderService.Where(u => u.OrderID == orderId).ToList();
if (ord_services != null)
{
foreach (var item in ord_services)
{
item.UserDefinedCol4 = "0"; //0是所有时间未录入完成
db.Entry(item).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
}
}
}
}
trans.Complete();
}
catch(Exception ex)
{
trans.Dispose();
return Json(new
{
code = Resources.Common.EXCEPTION_CODE,
message = Resources.Common.EXCEPTION_MESSAGE,
}, JsonRequestBehavior.AllowGet);
}
}
}
return Json(new
{
code = Resources.Common.SUCCESS_CODE,
message = Resources.Common.SUCCESS_MESSAGE,
has_invoice = -1
}, JsonRequestBehavior.AllowGet);
}
public ActionResult AddEditCustomerBillSchemeItem()
{
this.Internationalization();
#region Add
if (Request.Form["oper"].Equals("add"))
{
try
{
TugDataEntities db = new TugDataEntities();
{
TugDataModel.BillingItemTemplate aScheduler = new BillingItemTemplate();
aScheduler.BillingTemplateID = Util.toint(Request.Form["BillingTemplateID"].Trim());
aScheduler.ItemID = Util.toint(Request.Form["ItemID"].Trim());
aScheduler.UnitPrice = Convert.ToDouble(Request.Form["UnitPrice"].Trim());
aScheduler.Currency = Request.Form["Currency".Trim()];
aScheduler.TypeID = Util.toint(Request.Form["TypeID"].Trim());
aScheduler.OwnerID = -1;
aScheduler.UserID = Session.GetDataFromSession<int>("userid");
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.BillingItemTemplate.Add(aScheduler);
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"]);
BillingItemTemplate aScheduler = db.BillingItemTemplate.Where(u => u.IDX == idx).FirstOrDefault();
if (aScheduler == null)
{
return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE });
}
else
{
aScheduler.BillingTemplateID = Util.toint(Request.Form["BillingTemplateID"].Trim());
aScheduler.ItemID = Util.toint(Request.Form["ItemID"].Trim());
aScheduler.UnitPrice = Convert.ToDouble(Request.Form["UnitPrice"].Trim());
aScheduler.Currency = Request.Form["Currency"].Trim();
aScheduler.TypeID = Util.toint(Request.Form["TypeID"].Trim());
aScheduler.OwnerID = -1;
aScheduler.UserID = Session.GetDataFromSession<int>("userid");
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();
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 });
}
/// <summary>
/// 服务修改
/// </summary>
/// <returns></returns>
public ActionResult AddEditService()
{
this.Internationalization();
#region Edit
if (Request.Form["oper"].Equals("edit"))
{
try
{
TugDataEntities db = new TugDataEntities();
int idx = Util.toint(Request.Form["OrderServiceID"].Trim());
OrderService aScheduler = db.OrderService.Where(u => u.IDX == idx).FirstOrDefault();
if (aScheduler == null)
{
return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE });
}
else
{
//aScheduler.ServiceNatureID = TugBusinessLogic.Module.Util.toint(Request.Form["ServiceNatureID"]);
aScheduler.ServiceWorkDate = Request.Form["ServiceWorkDate"];
aScheduler.ServiceWorkPlace = Request.Form["ServiceWorkPlace"];
aScheduler.ServiceWorkTime = Request.Form["ServiceWorkTime"];
aScheduler.BigTugNum = Util.toint(Request.Form["BigTugNum"].Trim());
aScheduler.MiddleTugNum = Util.toint(Request.Form["MiddleTugNum"].Trim());
aScheduler.SmallTugNum = Util.toint(Request.Form["SmallTugNum"].Trim());
aScheduler.OwnerID = -1;
aScheduler.UserID = Session.GetDataFromSession<int>("userid");
aScheduler.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
db.Entry(aScheduler).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 AddEdit_LinkMan()
{
this.Internationalization();
#region Add
if (Request.Form["oper"].Equals("add"))
{
try
{
TugDataEntities db = new TugDataEntities();
{
TugDataModel.LinkMan linkMan = new LinkMan();
linkMan.LinkManName = Request.Form["LinkManName"];
linkMan.LinkPhone = Request.Form["LinkPhone"];
linkMan.LinkEmail = Request.Form["LinkEmail"];
linkMan.Remark = Request.Form["Remark"];
linkMan.CreateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
linkMan.UserDefinedCol1 = Request.Form["UserDefinedCol1"];
linkMan.UserDefinedCol2 = Request.Form["UserDefinedCol2"];
linkMan.UserDefinedCol3 = Request.Form["UserDefinedCol3"];
linkMan.UserDefinedCol4 = Request.Form["UserDefinedCol4"];
if (Request.Form["UserDefinedCol5"] != "")
linkMan.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"]);
if (Request.Form["UserDefinedCol6"] != "")
linkMan.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"]);
if (Request.Form["UserDefinedCol7"] != "")
linkMan.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"]);
if (Request.Form["UserDefinedCol8"] != "")
linkMan.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"]);
linkMan.UserDefinedCol9 = Request.Form["UserDefinedCol9"];
linkMan.UserDefinedCol10 = Request.Form["UserDefinedCol10"];
linkMan = db.LinkMan.Add(linkMan);
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
{
int idx = Util.toint(Request.Form["IDX"]);
string name = Request.Form["LinkMan"];
TugDataEntities db = new TugDataEntities();
System.Linq.Expressions.Expression<Func<LinkMan, bool>> exp = u => u.LinkManName == name && u.IDX != idx;
LinkMan obj = db.LinkMan.Where(exp).FirstOrDefault();
if (obj != null)
{
return Json(new { code = Resources.Common.ERROR_CODE, message = "客户名称已存在！" });//Resources.Common.ERROR_MESSAGE
}
LinkMan linkMan = db.LinkMan.Where(u => u.IDX == idx).FirstOrDefault();
if (linkMan == null)
{
return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE });
}
else
{
linkMan.LinkManName = Request.Form["LinkManName"];
linkMan.LinkPhone = Request.Form["LinkPhone"];
linkMan.LinkEmail = Request.Form["LinkEmail"];
linkMan.Remark = Request.Form["Remark"];
linkMan.UserDefinedCol1 = Request.Form["UserDefinedCol1"];
linkMan.UserDefinedCol2 = Request.Form["UserDefinedCol2"];
linkMan.UserDefinedCol3 = Request.Form["UserDefinedCol3"];
linkMan.UserDefinedCol4 = Request.Form["UserDefinedCol4"];
if (Request.Form["UserDefinedCol5"] != "")
linkMan.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"]);
if (Request.Form["UserDefinedCol6"] != "")
linkMan.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"]);
if (Request.Form["UserDefinedCol7"] != "")
linkMan.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"]);
if (Request.Form["UserDefinedCol8"] != "")
linkMan.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"]);
linkMan.UserDefinedCol9 = Request.Form["UserDefinedCol9"];
linkMan.UserDefinedCol10 = Request.Form["UserDefinedCol10"];
db.Entry(linkMan).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
var linkmanList = db.OrderInfor.Where(u => u.CustomerID == idx).ToList();
if (linkmanList != null)
{
foreach (var item in linkmanList)
{
item.CustomerName = linkMan.LinkManName;
db.Entry(item).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
return Json(new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE });
}
}
catch (Exception ex)
{
throw ex;
}
}
#endregion Edit
return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE });
}
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);
}
}
//BillingType:0普通账单，1特殊账单,2其他賬單
public ActionResult SubmitFlow(int BillingType,string billids,List<string[]> dataListFromTable)
{
//billid 从Invoice页面传入
//int[] arrbillid =new int[2]{1,2};
string[] arrbillid = billids.Split(',');
try
{
TugDataEntities db = new TugDataEntities();
foreach (string sidx in arrbillid)
{
int idx = Util.toint(sidx);
Billing billobj = db.Billing.Where(u => u.IDX == idx).FirstOrDefault();
if (billobj == null)
{
continue ;
//return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE });
}
int newTimesNo =Util.toint(billobj.TimesNo) + 1; //第几次流程
//将流程信息写入Flow表
#region
string mark = Util.GetSequence("F");
for(int i=0;i<dataListFromTable.Count-1;i++)//最后一行空行
{
TugDataModel.Flow obj = new Flow();
obj.BillingID = idx;
obj.MarkID = newTimesNo;
obj.Phase = i;
obj.Task =dataListFromTable[i][0] ;
string Name11=dataListFromTable[i][1];
UserInfor us1 = db.UserInfor.Where(u => u.Name1 == Name11).FirstOrDefault();
obj.FlowUserID = us1.IDX;
obj.StDate = dataListFromTable[i][2];
obj.EndDate =dataListFromTable[i][3] ;
obj.System = "Tug";
obj.OwnerID = -1;
obj.CreateDate = obj.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");;
obj.UserID = Session.GetDataFromSession<int>("userid");
//obj.State =0;
obj.Sign =mark;
//obj.UserDefinedCol1 = "";
//obj.UserDefinedCol2 = "";
//obj.UserDefinedCol3 = "";
//obj.UserDefinedCol4 = "";
//if (Request.Form["UserDefinedCol5"] != "")
// obj.UserDefinedCol5 = Util.toint(Request.Form["UserDefinedCol5"]);
//obj.UserDefinedCol6 =;
//obj.UserDefinedCol7 =;
//obj.UserDefinedCol8 =;
//obj.UserDefinedCol9 = "";
//obj.UserDefinedCol10 = "";
obj = db.Flow.Add(obj);
db.SaveChanges();
}
#endregion
//将提交审核写入Approve
#region
TugDataModel.Approve objapp = new Approve();
objapp.BillingID = idx;
objapp.FlowMark = newTimesNo;
objapp.Phase = 0;
objapp.Task = dataListFromTable[0][0];
objapp.Accept=2;
objapp.Remark="";
string Name12 = dataListFromTable[0][1];
UserInfor us2 = db.UserInfor.Where(u => u.Name1 == Name12).FirstOrDefault();
objapp.PersonID = us2.IDX;
objapp.System="Tug";
objapp.OwnerID=-1;
objapp.CreateDate = objapp.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");;
objapp.UserID = Session.GetDataFromSession<int>("userid");
objapp = db.Approve.Add(objapp);
db.SaveChanges();
#endregion
//更新Billing表的流程信息
#region
billobj.TimesNo = newTimesNo;
billobj.Status = dataListFromTable[1][0];
billobj.Phase = 1;
db.Entry(billobj).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
#endregion
//更新orderinfor、orderservice表中的HasInFlow
//OrderLogic.UpdateHasInFlow(idx, "是");
if (BillingType!=2) FinanceLogic.SetOrderServiceFlowingStatus(BillingType, idx, "是");
}
}
catch (Exception exp)
{
return Json(new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE });
}
return Json(new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE });
}