//这个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 }); }