/// <summary> /// LocationInfodelete /// </summary> /// <param name="deleteItem"></param> /// <returns></returns> public static string LocationInfodelete(string deleteItem) { string[] ridArr = deleteItem.Split(','); using (var db = new VehicleEntities()) { foreach (var ds in ridArr) { string Rid = ds; var model = db.T_Location.FirstOrDefault(p => p.RID == Rid); db.DeleteObject(model); } int success = db.SaveChanges(); if (success > 0) { ViewModel.Result result = new Result(); result.success = true; result.message = "刪除成功"; return(JsonConvert.SerializeObject(result)); } else { return(JsonConvert.SerializeObject(new ViewModel.Result() { success = true, message = "刪除失败" })); } } }
public void DeletePhone(int custID, string phoneType, string phoneNumber) { using (var context = new VehicleEntities()) { PhoneNumber queryDelete = new PhoneNumber(); queryDelete = context.PhoneNumbers.First(p => p.customerID == custID && p.phoneType == phoneType && p.number == phoneNumber); context.DeleteObject(queryDelete); context.SaveChanges(); } }
/// <summary> /// 刪除存儲 /// </summary> /// <param name="deleteItem"></param> /// <returns></returns> public static string Plandelete(string deleteItem) { string[] ridArr = deleteItem.Split(','); using (var db = new VehicleEntities()) { foreach (var ds in ridArr) { string planID = ds; var Planitem = db.M_Plan.FirstOrDefault(p => p.planID == planID && p.valid == "1"); db.DeleteObject(Planitem); var PlanRid = Planitem.RID; var RoadListitem = db.D_RoadList.Where(p => p.PlanRID == PlanRid); foreach (var item in RoadListitem) { db.DeleteObject(item); } var PassengerListitem = db.D_PassengerList.Where(p => p.PlanRID == PlanRid); foreach (var item in PassengerListitem) { db.DeleteObject(item); } } int success = db.SaveChanges(); if (success > 0) { ViewModel.Result result = new Result(); result.success = true; result.message = "刪除成功"; return(JsonConvert.SerializeObject(result)); } else { return(JsonConvert.SerializeObject(new ViewModel.Result() { success = true, message = "刪除失败" })); } } }
/// <summary> /// 合併wf派車單 /// </summary> /// <returns></returns> public static string MergePlan(List <MergePlanModel> M_PlanModel) { string rst = "success"; var Now = DateTime.Now; int success = 0; List <M_Plan> PlanList = new List <M_Plan>(); List <D_PassengerList> PassengerList = new List <D_PassengerList>(); var PlanID = GetPlanNo(); var LastUpdDate = ""; var CreateDate = ""; var NewRid = Guid.NewGuid().ToString(); using (var db = new VehicleEntities()) { foreach (var item in M_PlanModel) { var changePlanModel = db.M_Plan.Where(t => t.planID == item.PlanID).FirstOrDefault(); LastUpdDate = changePlanModel.LastUpdDate.ToString(); CreateDate = changePlanModel.CreateDate.ToString(); } foreach (var item in M_PlanModel) { var changePlanModel = db.M_Plan.Where(t => t.planID == item.PlanID).FirstOrDefault(); M_Plan Planitem = new M_Plan(); Planitem.RID = Guid.NewGuid().ToString(); Planitem.batch = changePlanModel.batch; Planitem.carID = changePlanModel.carID; Planitem.LastUpdUser = changePlanModel.LastUpdUser; Planitem.CreateUser = changePlanModel.CreateUser; Planitem.driverID = changePlanModel.driverID; Planitem.driverTel = changePlanModel.driverTel; Planitem.time = changePlanModel.time; Planitem.status = changePlanModel.status; Planitem.step = changePlanModel.step; Planitem.LastUpdDate = Convert.ToDateTime(LastUpdDate); Planitem.CreateDate = Convert.ToDateTime(CreateDate); Planitem.planID = PlanID; Planitem.valid = "0"; PlanList.Add(Planitem); var PassengerModel = db.D_PassengerList.Where(t => t.planID == item.PlanID); foreach (var Passger_Item in PassengerModel) { D_PassengerList itemList = new D_PassengerList(); itemList.RID = Guid.NewGuid().ToString(); itemList.planID = PlanID; itemList.locationID = Passger_Item.locationID; itemList.confirmTime = Passger_Item.confirmTime; itemList.destinationID = Passger_Item.destinationID; itemList.passengerID = Passger_Item.passengerID; itemList.returnTime = Passger_Item.returnTime; itemList.PlanRID = NewRid; itemList.remark = Passger_Item.remark; itemList.status = Passger_Item.status; itemList.time = Passger_Item.time; PassengerList.Add(itemList); } } foreach (var item in M_PlanModel) { var PlanModel = db.M_Plan.Where(t => t.planID == item.PlanID).FirstOrDefault(); db.DeleteObject(PlanModel); var PassengerModel = db.D_PassengerList.Where(t => t.planID == item.PlanID); foreach (var PassengerItem in PassengerModel) { if (item.PlanID == PassengerItem.planID) { db.DeleteObject(PassengerItem); } } } foreach (var addPlanitem in PlanList) { db.AddToM_Plan(addPlanitem); } foreach (var adPassengerditem in PassengerList) { db.AddToD_PassengerList(adPassengerditem); } var YearText = DateTime.Now.ToString("yyyyMMdd").Substring(2, 2); int?number = null; var List = db.T_SystemApply.Where(t => t.FunctionName == "PlanNo" && t.DateTime == YearText); if (List.Count() > 0) { var num = List.Max(t => t.Number); //number = List.OrderByDescending(t => t.Create_Date).First().Number; number = num + 1; } else { number = 1; } //存儲單號記錄 T_SystemApply SystemApply = new T_SystemApply(); SystemApply.Create_Date = DateTime.Now; SystemApply.DateTime = Now.ToString("yyyy-MM-dd").Substring(2, 2); SystemApply.Number = number; SystemApply.FunctionName = "PlanNo"; SystemApply.RID = Guid.NewGuid().ToString(); db.AddToT_SystemApply(SystemApply); success = db.SaveChanges(); } var modelRID = ""; using (var db = new VehicleEntities()) { var model = db.M_Plan.Where(t => t.planID == PlanID).FirstOrDefault(); modelRID = model.RID; var demodel = db.D_PassengerList.Where(t => t.planID == PlanID); foreach (var deitem in demodel) { deitem.PlanRID = modelRID; } db.SaveChanges(); } using (var db = new VehicleEntities()) { var modelPlanvalid = db.M_Plan.Where(t => t.RID == modelRID).FirstOrDefault(); modelPlanvalid.valid = "1"; modelPlanvalid.IsSend = "0"; db.SaveChanges(); } if (success > 0) { return(rst); } else { rst = "fail"; return(rst); } }
/// <summary> /// 更新存儲 /// </summary> /// <param name="Model"></param> /// <param name="LoginUserID"></param> /// <param name="RID"></param> /// <returns></returns> public static string PlanEditSave(PlanModel PlanModel, List <PassengerModel> PassengerModel, List <stepModel> stepModel, string LoginUserID) { using (var db = new VehicleEntities()) { DateTime LastUpdDate = DateTime.Now; string LocationID = ""; string DestinationID = ""; var stepLen = stepModel.Count - 1; var RID = ""; foreach (var item in stepModel) { if (item.sequence == 0) { LocationID = item.locationID; } if (item.sequence == stepLen) { DestinationID = item.locationID; } } var PlanList = db.M_Plan.Where(t => t.planID == PlanModel.planID); if (PlanList.Count() > 1) { foreach (var item in PlanList) { var itemRID = item.RID; item.LastUpdDate = LastUpdDate; item.locationID = LocationID; item.destinationID = DestinationID; var PassengerList = db.D_PassengerList.Where(t => t.PlanRID == item.RID); if (PassengerList.Count() > 0) { item.carID = PlanModel.carID; item.driverTel = PlanModel.driverTel; item.driverID = PlanModel.driverID; item.locationID = LocationID; item.destinationID = DestinationID; item.status = Convert.ToInt32(PlanModel.status); item.time = Convert.ToDateTime(PlanModel.time); item.LastUpdUser = LoginUserID; var PlanID = item.planID; RID = item.RID; //站點表 var RoadList = db.D_RoadList.Where(t => t.planID == PlanID); foreach (var del in RoadList) { db.DeleteObject(del); } foreach (var setpitem in stepModel) { D_RoadList RoadListitem = new D_RoadList(); RoadListitem.RID = Guid.NewGuid().ToString(); RoadListitem.PlanRID = RID; RoadListitem.planID = PlanID; RoadListitem.locationID = Convert.ToInt32(setpitem.locationID); RoadListitem.sequence = setpitem.sequence; if (setpitem.atime != null) { RoadListitem.atime = Convert.ToDateTime(setpitem.atime); } if (setpitem.ltime != null) { RoadListitem.ltime = Convert.ToDateTime(setpitem.ltime); } db.AddToD_RoadList(RoadListitem); } //乘客表 var PassengerListModel = db.D_PassengerList.Where(t => t.PlanRID == RID); foreach (var del in PassengerList) { db.DeleteObject(del); } foreach (var Passengeritem in PassengerModel) { D_PassengerList PassengerListitem = new D_PassengerList(); PassengerListitem.RID = Guid.NewGuid().ToString(); PassengerListitem.PlanRID = RID; PassengerListitem.planID = PlanID; PassengerListitem.returnTime = Passengeritem.returnTime; PassengerListitem.passengerID = Passengeritem.passengerID; PassengerListitem.time = Convert.ToDateTime(Passengeritem.time); PassengerListitem.status = Passengeritem.status; PassengerListitem.remark = Passengeritem.remark; PassengerListitem.locationID = Passengeritem.locationID; PassengerListitem.destinationID = Passengeritem.destinationID; if (Passengeritem.confirmTime != null) { PassengerListitem.confirmTime = Convert.ToDateTime(Passengeritem.confirmTime); } db.AddToD_PassengerList(PassengerListitem); } } } } else { RID = db.M_Plan.Where(t => t.planID == PlanModel.planID).FirstOrDefault().RID; //主檔 var Plan = db.M_Plan.Where(t => t.RID == RID).FirstOrDefault(); Plan.carID = PlanModel.carID; Plan.driverTel = PlanModel.driverTel; Plan.driverID = PlanModel.driverID; Plan.locationID = LocationID; Plan.destinationID = DestinationID; Plan.status = Convert.ToInt32(PlanModel.status); Plan.time = Convert.ToDateTime(PlanModel.time); Plan.LastUpdDate = LastUpdDate; Plan.LastUpdUser = LoginUserID; //站點表 var RoadList = db.D_RoadList.Where(t => t.PlanRID == RID); foreach (var del in RoadList) { db.DeleteObject(del); } foreach (var item in stepModel) { D_RoadList RoadListitem = new D_RoadList(); RoadListitem.RID = Guid.NewGuid().ToString(); RoadListitem.PlanRID = RID; RoadListitem.planID = Plan.planID; RoadListitem.locationID = Convert.ToInt32(item.locationID); RoadListitem.sequence = item.sequence; if (item.atime != null) { RoadListitem.atime = Convert.ToDateTime(item.atime); } if (item.ltime != null) { RoadListitem.ltime = Convert.ToDateTime(item.ltime); } db.AddToD_RoadList(RoadListitem); } //乘客表 var PassengerList = db.D_PassengerList.Where(t => t.PlanRID == RID); foreach (var del in PassengerList) { db.DeleteObject(del); } foreach (var item in PassengerModel) { D_PassengerList PassengerListitem = new D_PassengerList(); PassengerListitem.RID = Guid.NewGuid().ToString(); PassengerListitem.PlanRID = RID; PassengerListitem.planID = Plan.planID; PassengerListitem.passengerID = item.passengerID; PassengerListitem.time = Convert.ToDateTime(item.time); PassengerListitem.status = item.status; PassengerListitem.returnTime = item.returnTime; PassengerListitem.remark = item.remark; PassengerListitem.locationID = item.locationID; PassengerListitem.destinationID = item.destinationID; if (item.confirmTime != null) { PassengerListitem.confirmTime = Convert.ToDateTime(item.confirmTime); } db.AddToD_PassengerList(PassengerListitem); } } int success = db.SaveChanges(); if (success > 0) { var IsSend = ""; //在這寫 using (var plan = new VehicleEntities()) { var SendPlan = plan.M_Plan.Where(t => t.RID == RID).FirstOrDefault(); IsSend = SendPlan.IsSend; if (IsSend != "1") { WeChatWS.WeChatWSSoapClient ws = new WeChatWS.WeChatWSSoapClient(); ws.seedsmsToDriver(RID); SendPlan.IsSend = "1"; plan.SaveChanges(); } ; } ViewModel.Result result = new Result(); result.success = true; result.message = "提交保存成功"; return(JsonConvert.SerializeObject(result)); } else { return(JsonConvert.SerializeObject(new ViewModel.Result() { success = true, message = "保存失败" })); } } }