//删除预约信息 public void DeleteCustomerAppointment(int id) { //删除预约表 List <CustomerAppointment> customerAppointment = db.CustomerAppointment.Where(p => p.CustomerAppointmentID == id).ToList(); if (customerAppointment.Count > 0) { foreach (var item in customerAppointment) { //利用所有的预约id去查有没有体检信息,有则删除体检信息 ClientMdicalIformation clientMdicalIformation = db.ClientMdicalIformation.Where(p => p.CustomerAppointmentID == item.CustomerAppointmentID).ToList().FirstOrDefault(); if (clientMdicalIformation != null) { //删除客户回访信息 List <CustomerReturnVisit> customerReturnVisit = db.CustomerReturnVisit.Where(p => p.ConclusionID == clientMdicalIformation.ConclusionID).ToList(); if (customerReturnVisit.Count > 0) { foreach (var item1 in customerReturnVisit) { CustomerReturnVisit customerReturnVisit1 = db.CustomerReturnVisit.Where(p => p.ConclusionID == item1.ConclusionID).ToList().FirstOrDefault(); db.CustomerReturnVisit.Remove(customerReturnVisit1); db.SaveChanges(); } } //删除客户关怀信息 List <CustomerCare> customerCare = db.CustomerCare.Where(p => p.ConclusionID == clientMdicalIformation.ConclusionID).ToList(); if (customerCare.Count() > 0) { foreach (var item2 in customerCare) { int customerCareid = item2.CustomerCareID; CustomerCare customerCare1 = db.CustomerCare.Where(p => p.ConclusionID == item2.ConclusionID).ToList().FirstOrDefault(); db.CustomerCare.Remove(customerCare1); db.SaveChanges(); } } //删除体检信息之后才能删除内外科 db.ClientMdicalIformation.Remove(clientMdicalIformation); db.SaveChanges(); //删除外科体检信息 int SurgicalExaminationID = clientMdicalIformation.SurgicalExaminationID; SurgicalExamination surgicalExamination = db.SurgicalExamination.Find(SurgicalExaminationID); db.SurgicalExamination.Remove(surgicalExamination); db.SaveChanges(); //删除内科体检信息 int MedicalExaminationID = clientMdicalIformation.MedicalExaminationID; MedicalExamination medicalExamination = db.MedicalExamination.Find(MedicalExaminationID); db.MedicalExamination.Remove(medicalExamination); db.SaveChanges(); //删除预约记录 CustomerAppointment customerAppointment1 = db.CustomerAppointment.Find(item.CustomerAppointmentID); db.CustomerAppointment.Remove(customerAppointment1); db.SaveChanges(); } } } }
public async Task <ActionResult> Post([FromBody] CustomerCare customerContent) { await _service.Create(customerContent); return(CreatedAtRoute( "GetCustomerCare", new { Id = customerContent.Id }, customerContent)); }
public string UpdateWithdrawalRecord(int withdrawalRecordId, int accid = 0, int status = 5) { string ip = HttpContext.Request.UserHostAddress; int operatorId = 0; string operatorName = string.Empty; if (Session["logUser"] != null) { ManageUserModel uM = (ManageUserModel)Session["logUser"]; operatorId = uM.UserID; operatorName = uM.UserName; } return(CustomerCare.UpdateWithdrawalStatus(withdrawalRecordId, status, ip, operatorId, accid, operatorName)); }
//修改关怀信息状态 public void EditCustomerCare(int id) { CustomerCare customerCare = db.CustomerCare.Find(id); if (customerCare.ProcessedOrNot == 0) { customerCare.ProcessedOrNot = 1; db.SaveChanges(); } else { customerCare.ProcessedOrNot = 0; db.SaveChanges(); } }
public bool IsCustomerCareResponsive(out bool blnApplicable) { blnApplicable = true; if (CustomerCare.Equals(_responsiveness[0]) || CustomerCare.Equals(_responsiveness[1])) { return(true); } if (CustomerCare.Equals(_responsiveness.Last())) { //Not sure if this case is applicable blnApplicable = false; return(true); } return(false); }
public async Task <ActionResult> Put(int id, [FromBody] CustomerCare customerCare) { try { CustomerCare customerCare1 = await _service.GetSingleById(id); await _service.Update(customerCare1, customerCare); return(Ok(new { StatusCode = (int)HttpStatusCode.OK, Data = customerCare })); } catch (Exception e) { return(StatusCode(500)); } }
public string GetCarePartitionPer(DateTime startTime, DateTime endTime, string usrName, int index) { TimeSpan ts = endTime - startTime; if (ts.TotalDays <= 1) { startTime = startTime.AddDays(-1); } if (ts.TotalDays > 31) { return(""); } string returnJson = ""; returnJson = CustomerCare.GetCarePartitionPer(startTime, endTime, usrName, index); return(returnJson); }
//新增关怀 public void AddCustomerCare() { List <ClientMdicalIformation> clientMdicalIformation = db.ClientMdicalIformation.ToList(); List <CustomerCare> customerCare = db.CustomerCare.ToList(); //查询所有体检记录 foreach (var item in clientMdicalIformation) { //查询所有关怀所有记录 foreach (var item2 in customerCare) { //计算item体检信息的日期>30天的体检记录true / false DateTime time = item.InspectionTime; DateTime dateTime = DateTime.Now; //巧用C#里ToString的字符格式化更简便 DateTime time2 = DateTime.Parse(time.AddMonths(1).ToShortDateString()); //现实时间比计算后的时间更晚,结果大于0才通过 if (DateTime.Compare(dateTime, time2) > 0) { //判断item2体检id是否存在item的id 不存在就可以添加 if (db.CustomerCare.Where(p => p.ConclusionID == item.ConclusionID).Count() > 0) { } else { CustomerCare customerCare1 = new CustomerCare(); customerCare1.ConclusionID = item.ConclusionID; customerCare1.DoctorID = item.DoctorID; customerCare1.ProcessedOrNot = 0; db.CustomerCare.Add(customerCare1); db.SaveChanges(); } } } } }
public string getWithdrawRecord(int pageIndex = 1, int withdrawStatus = -99, int payType = -99, string withdrawalNo = "", string accId = "", string start = "", string end = "") { return(CustomerCare.GetWithdrawalRecord(pageIndex, withdrawStatus, payType, withdrawalNo, accId, start, end)); }
/// <summary> /// 获取回访信息 /// </summary> /// <param name="startTime"></param> /// <param name="endTime"></param> /// <returns></returns> public string getVisitInfo() { return(CustomerCare.getVisitinfo()); }
/// <summary> /// 获取订单数据 /// </summary> /// <param name="startTime"></param> /// <param name="endTime"></param> /// <param name="dayCnt"></param> /// <param name="type"></param> /// <param name="person"></param> /// <returns></returns> public string getOrderInfo(DateTime startTime, DateTime endTime, int dayCnt, int type, string person) { return(CustomerCare.getOrderInfo(startTime, endTime, dayCnt, type, person)); }
/// <summary> /// 获取客服汇总数据 /// </summary> /// <param name="startTime"></param> /// <param name="endTime"></param> /// <returns></returns> public string getServiceInfo(DateTime startTime, DateTime endTime) { return(CustomerCare.getServiceInfo(startTime, endTime)); }
/// <summary> /// 返回订单续费数据Json /// </summary> /// <param name="stDate"></param> /// <param name="edDate"></param> /// <param name="type"></param> /// <returns></returns> public string GetOrderRenewal(DateTime stDate, DateTime edDate, string type) { return(CustomerCare.GetOrderRenewal(stDate, edDate, type)); }
public string GetCareRetention(DateTime stDate, DateTime edDate, string dateType, string usrName) { return(CustomerCare.GetCareRetention(stDate, edDate, dateType, usrName)); }
/// <summary> /// 获取回访信息详情 /// </summary> /// <param name="type"></param> /// <returns></returns> public string getVisitDetail(int type) { return(CustomerCare.getVisitDetail(type)); }