//这个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 AddCustomData(string CustomName, string CustomValue) { this.Internationalization(); TugDataEntities db = new TugDataEntities(); try { System.Linq.Expressions.Expression<Func<CustomField, bool>> exp = u => u.CustomName == CustomName && u.CustomLabel == CustomValue; CustomField tmpCustom = db.CustomField.Where(exp).FirstOrDefault(); if (tmpCustom != null) { throw new Exception(CustomValue + "已存在!"); } 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 HH:mm:ss"); custom = db.CustomField.Add(custom); db.SaveChanges(); return Json(new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE }); } catch (Exception ex) { throw ex; } }
public ActionResult AddCredit(int billingId, string billingCode, string creditContent, double creditAmount, string creditdate, string remark) { TugDataModel.Credit credit; this.Internationalization(); try { TugDataEntities db = new TugDataEntities(); { credit = new Credit(); credit.BillingID = billingId; credit.CreditCode = "C" + billingCode.Substring(1, billingCode.Length - 1 ); credit.CreditContent = creditContent; credit.CreditAmount = creditAmount; credit.UserDefinedCol10 = creditdate; credit.Remark = remark; credit.CreateDate = credit.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); credit.OwnerID = -1; credit.UserID = credit.UserID = Session.GetDataFromSession<int>("userid"); //credit.UserDefinedCol1 = ""; //credit.UserDefinedCol2 = ""; //credit.UserDefinedCol3 = ""; //credit.UserDefinedCol4 = ""; //credit.UserDefinedCol5 = 0; //credit.UserDefinedCol6 = 0; //credit.UserDefinedCol7 = 0; //credit.UserDefinedCol8 = 0; //credit.UserDefinedCol9 = ""; //credit.UserDefinedCol10 = ""; credit = db.Credit.Add(credit); db.SaveChanges(); //更新账单中的回扣金额 { TugBusinessLogic.Module.FinanceLogic.UpdateTotalRebateOfBilling(billingId); } } var ret = new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE, billing_id = credit.IDX }; return Json(ret, JsonRequestBehavior.AllowGet); } catch (Exception) { var ret = new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE }; return Json(ret, JsonRequestBehavior.AllowGet); } }
public ActionResult Delete() { this.Internationalization(); try { var f = Request.Form; int idx = Util.toint(Request.Form["data[IDX]"]); TugDataEntities db = new TugDataEntities(); CustomField custom = db.CustomField.FirstOrDefault(u => u.IDX == idx); if (custom != null) { db.CustomField.Remove(custom); 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 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 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 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 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 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 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 AddCustomer(string Code,string Name1,string Name2,string SimpleName,string ContactPerson, string Telephone, string Fax, string Email, string Address, string MailCode, string Remark) { this.Internationalization(); try { TugDataEntities db = new TugDataEntities(); System.Linq.Expressions.Expression<Func<Customer, bool>> exp = u => u.Name1 == Name1; Customer obj = db.Customer.Where(exp).FirstOrDefault(); if (obj != null) { throw new Exception("客户名称已存在!"); } { TugDataModel.Customer cstmer = new Customer(); cstmer.Code = Code; cstmer.Name1 = Name1; cstmer.Name2 = Name2; cstmer.SimpleName = SimpleName; cstmer.ContactPerson = ContactPerson; cstmer.Telephone = Telephone; cstmer.Fax = Fax; cstmer.Email = Email; cstmer.Address = Address; cstmer.MailCode = MailCode; cstmer.Remark = 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 = ""; cstmer.UserDefinedCol2 = ""; cstmer.UserDefinedCol3 = ""; cstmer.UserDefinedCol4 = ""; //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 = ""; cstmer.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 ex) { throw ex; } }
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 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 AddCustomerBillSchemeItem(int billingTemplateId, int itemId, string unitPrice, string currency, int typeId) { this.Internationalization(); try { TugDataEntities db = new TugDataEntities(); { TugDataModel.BillingItemTemplate aScheduler = new BillingItemTemplate(); aScheduler.BillingTemplateID = billingTemplateId; aScheduler.ItemID = itemId; aScheduler.UnitPrice = Convert.ToDouble(unitPrice); aScheduler.Currency = currency; aScheduler.TypeID = typeId; 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"] != "") // aScheduler.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"]); //if (Request.Form["UserDefinedCol6"] != "") // aScheduler.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"]); //if (Request.Form["UserDefinedCol7"] != "") // aScheduler.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"]); //if (Request.Form["UserDefinedCol8"] != "") // aScheduler.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"]); aScheduler.UserDefinedCol9 = ""; aScheduler.UserDefinedCol10 = ""; 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 ex) { var ret = new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE }; //Response.Write(@Resources.Common.EXCEPTION_MESSAGE); return Json(ret); } return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE }); }
public ActionResult Delete_LinkMan() { this.Internationalization(); using (TransactionScope trans = new TransactionScope()) { try { var f = Request.Form; int idx = Util.toint(Request.Form["data[IDX]"]); TugDataEntities db = new TugDataEntities(); //删除聯繫人 LinkMan cstmer = db.LinkMan.FirstOrDefault(u => u.IDX == idx); db.LinkMan.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 DeleteCustomerBillSchemeItem() { this.Internationalization(); try { var f = Request.Form; int idx = Util.toint(Request.Form["data[IDX]"]); int billingTemplateID = Util.toint(Request.Form["data[BillingTemplateID]"]); TugDataEntities db = new TugDataEntities(); //Billing obj = db.Billing.FirstOrDefault(u => u.BillingTemplateID == billingTemplateID); //if (obj != null) // throw new Exception("此計費方案项目已在賬單中使用過,不能被刪除!"); //else { BillingItemTemplate aScheduler = db.BillingItemTemplate.FirstOrDefault(u => u.IDX == idx); if (aScheduler != null) { db.BillingItemTemplate.Remove(aScheduler); 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) { throw ex; //return Json(new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE }); } }
public static int AutoAddCustomerShip(int ctmId, string Name1, string Name2, string SimpleName, string DeadWeight, string Length, string Width, string TEUS, string Class, string Remark, int UserID) { try { TugDataEntities db = new TugDataEntities(); System.Linq.Expressions.Expression<Func<CustomerShip, bool>> exp = u => u.Name1 == Name1; CustomerShip obj = db.CustomerShip.Where(exp).FirstOrDefault(); if (obj != null) { //var ret = new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE, objid = obj.IDX }; //Response.Write(@Resources.Common.SUCCESS_MESSAGE); //return Json(ret); //throw new Exception("船名称已存在!"); return obj.IDX; } { TugDataModel.CustomerShip ship = new CustomerShip(); ship.CustomerID = ctmId;// Util.toint(Request.Form["CustomerID"]); ship.ShipTypeID = -1;//Util.toint(Request.Form["ShipTypeID"]); ship.Name1 = Name1; ship.Name2 = Name2; ship.SimpleName = SimpleName; ship.DeadWeight = Util.toint(DeadWeight); ship.Length = Util.toint(Length); ship.Width = Util.toint(Width); ship.TEUS = Util.toint(TEUS); ship.Class = Class; ship.Remark = Remark; ship.OwnerID = -1; ship.CreateDate = ship.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); ; ship.UserID = UserID; ship.UserDefinedCol1 = ""; ship.UserDefinedCol2 = ""; ship.UserDefinedCol3 = ""; ship.UserDefinedCol4 = ""; //if (Request.Form["UserDefinedCol5"] != "") // ship.UserDefinedCol5 = Util.tonumeric(Request.Form["UserDefinedCol5"]); //if (Request.Form["UserDefinedCol6"] != "") // ship.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"]); //if (Request.Form["UserDefinedCol7"] != "") // ship.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"]); //if (Request.Form["UserDefinedCol8"] != "") // ship.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"]); ship.UserDefinedCol9 = ""; ship.UserDefinedCol10 = ""; ship = db.CustomerShip.Add(ship); db.SaveChanges(); //var ret = new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE, objid=ship.IDX }; //Response.Write(@Resources.Common.SUCCESS_MESSAGE); //return Json(ret); return ship.IDX; } } catch (Exception ex) { throw ex; //var ret = new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE }; //return Json(ret); } }
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 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 }); }
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_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 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 AddLinkMan(string LinkMan, string LinkPhone, string LinkEmail, string Remark) { this.Internationalization(); try { TugDataEntities db = new TugDataEntities(); System.Linq.Expressions.Expression<Func<LinkMan, bool>> exp = u => u.LinkManName == LinkMan; LinkMan obj = db.LinkMan.Where(exp).FirstOrDefault(); if (obj != null) { throw new Exception("客户名称已存在!"); } { TugDataModel.LinkMan newLinkMan = new LinkMan();// newLinkMan.LinkManName = LinkMan; newLinkMan.LinkPhone = LinkPhone; newLinkMan.LinkEmail = LinkEmail; newLinkMan.Remark = Remark; newLinkMan.CreateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); newLinkMan.UserDefinedCol1 = ""; newLinkMan.UserDefinedCol2 = ""; newLinkMan.UserDefinedCol3 = ""; newLinkMan.UserDefinedCol4 = ""; newLinkMan.UserDefinedCol9 = ""; newLinkMan.UserDefinedCol10 = ""; newLinkMan = db.LinkMan.Add(newLinkMan); 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 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 AddCustomerBillScheme(int custId, int billingTemplateTypeId, string billingTemplateCode, string billingTemplateName, int timeTypeId, double discount, string shipLength, string shipTEUS, string expiryDate, string templateCreditContent, string remark, List<string[]> dataListFromTable) { try { //重名了 if (true == CheckBillingTemplateName(custId, billingTemplateName, -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 = billingTemplateCode; cstmer.BillingTemplateName = billingTemplateName; cstmer.BillingTemplateTypeID = billingTemplateTypeId; cstmer.ShipLength = shipLength; cstmer.ShipTEUS = shipTEUS; cstmer.ExpiryDate = expiryDate; cstmer.CreateDate = cstmer.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); cstmer.CustomerID = custId; // Convert.ToInt32(customerId); cstmer.TemplateCreditContent = templateCreditContent; cstmer.TimeTypeID = timeTypeId; cstmer.Discount = discount; cstmer.Remark = remark; cstmer.OwnerID = -1; cstmer.UserID = Session.GetDataFromSession<int>("userid"); cstmer.UserDefinedCol1 = ""; cstmer.UserDefinedCol2 = ""; cstmer.UserDefinedCol3 = ""; cstmer.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 = ""; cstmer.UserDefinedCol10 = ""; cstmer = db.BillingTemplate.Add(cstmer); db.SaveChanges(); //保存收费项 for (int i = 0; i < dataListFromTable.Count - 1; i++)//最后一行空行 { if (Util.checkdbnull(dataListFromTable[i][2]) == "") continue; TugDataModel.BillingItemTemplate aScheduler = new BillingItemTemplate(); aScheduler.BillingTemplateID = cstmer.IDX; aScheduler.ItemID =Util.toint(dataListFromTable[i][0]); aScheduler.UnitPrice = Util.tonumeric(dataListFromTable[i][2]); aScheduler.Currency = dataListFromTable[i][3]; aScheduler.TypeID = 13; 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"] != "") // aScheduler.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"]); //if (Request.Form["UserDefinedCol6"] != "") // aScheduler.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"]); //if (Request.Form["UserDefinedCol7"] != "") // aScheduler.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"]); //if (Request.Form["UserDefinedCol8"] != "") // aScheduler.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"]); aScheduler.UserDefinedCol9 = ""; aScheduler.UserDefinedCol10 = ""; 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); } }
/// <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 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 AddScheduler(int orderId, int orderServiceId, int serviceNatureId, string serviceWorkDate, string serviceWorkTime, string serviceWorkPlace, string tugId, string isCaptainConfirm, string informCaptainTime, string captainConfirmTime, string ropeUsed, int ropeNum, string remark) { this.Internationalization(); try { TugDataEntities db = new TugDataEntities(); { //插入多个调度到数据库 { List<string> lstTugIds = tugId.Split(',').ToList(); if (lstTugIds != null && lstTugIds.Count > 0) { List<Scheduler> lstSchedulers = new List<Scheduler>(); foreach (string item in lstTugIds) { TugDataModel.Scheduler aScheduler = new Scheduler(); //aScheduler.OrderID = orderId; //aScheduler.ServiceNatureID = serviceNatureId; aScheduler.OrderServiceID = orderServiceId; aScheduler.TugID = Util.toint(item); aScheduler.RopeUsed = ropeUsed; aScheduler.RopeNum = ropeNum; aScheduler.Remark = remark; aScheduler.IsCaptainConfirm = isCaptainConfirm; aScheduler.InformCaptainTime = informCaptainTime; aScheduler.CaptainConfirmTime = captainConfirmTime; aScheduler.JobStateID = 32; aScheduler.OwnerID = -1; aScheduler.UserID = Session.GetDataFromSession<int>("userid"); aScheduler.CreateDate = aScheduler.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); aScheduler.UserDefinedCol1 = ""; aScheduler.UserDefinedCol2 = ""; aScheduler.UserDefinedCol3 = ""; aScheduler.UserDefinedCol4 = ""; //if (Request.Form["UserDefinedCol5"].Trim() != "") // aScheduler.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"].Trim()); //if (Request.Form["UserDefinedCol6"].Trim() != "") // aScheduler.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"].Trim()); //if (Request.Form["UserDefinedCol7"].Trim() != "") // aScheduler.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"].Trim()); //if (Request.Form["UserDefinedCol8"].Trim() != "") // aScheduler.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"].Trim()); aScheduler.UserDefinedCol9 = ""; aScheduler.UserDefinedCol10 = ""; lstSchedulers.Add(aScheduler); } db.Scheduler.AddRange(lstSchedulers); db.SaveChanges(); } } { //更新订单状态 //OrderInfor tmpOrder = db.OrderInfor.Where(u => u.IDX == orderId).FirstOrDefault(); //if (tmpOrder != null) //{ // tmpOrder.WorkStateID = 3; //已排船 // db.Entry(tmpOrder).State = System.Data.Entity.EntityState.Modified; // db.SaveChanges(); //} } //更新服务状态 { OrderService os = db.OrderService.Where(u => u.IDX == orderServiceId).FirstOrDefault(); if (os == null) { os = new OrderService(); os.CreateDate = os.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); os.OrderID = orderId; os.OwnerID = -1; os.ServiceNatureID = serviceNatureId; os.ServiceWorkDate = serviceWorkDate; os.ServiceWorkTime = serviceWorkTime; os.ServiceWorkPlace = serviceWorkPlace; os.JobStateID = 115; os.UserID = Session.GetDataFromSession<int>("userid"); os = db.OrderService.Add(os); db.SaveChanges(); } else { os.ServiceWorkDate = serviceWorkDate; os.ServiceWorkTime = serviceWorkTime; os.ServiceWorkPlace = serviceWorkPlace; os.JobStateID = 115; os.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); db.Entry(os).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } } var ret = new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE }; //Response.Write(@Resources.Common.SUCCESS_MESSAGE); return Json(ret); } } catch (Exception) { var ret = new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE }; //Response.Write(@Resources.Common.EXCEPTION_MESSAGE); return Json(ret); } }
public ActionResult 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; } }