public bx_message FindById(int msgId) { bx_message bxMessage = new bx_message(); try { bxMessage = DataContextFactory.GetDataContext().bx_message.FirstOrDefault(i => i.Id == msgId); } catch (Exception ex) { logError.Info("发生异常:" + ex.Source + "\n" + ex.StackTrace + "\n" + ex.Message + "\n" + ex.InnerException); } return(bxMessage); }
/// <summary> /// 添加消息 /// </summary> /// <param name="request">0:系统消息,1:到期通知,2:回访通知,3:工单提醒,4:账号审核提醒,5管理日报,6:分配通知,7:出单通知</param> /// <returns></returns> public int AddMessage(AddMessageRequest request) { var bxMessage = new bx_message(); string title = string.Empty; string body = string.Empty; switch (request.MsgType) { //消息类型,0:系统消息,1:到期通知,2:回访通知,3:工单提醒,4:账号审核提醒,5管理日报,6:分配通知,7:出单通知 case 0: title = "系统消息"; body = request.Body; break; case 2: DateTime dt = !string.IsNullOrWhiteSpace(request.SendTime) ? DateTime.Parse(request.SendTime) : DateTime.Now; title = "回访通知"; body = string.Format("{0}月{1}日{2} 需回访{3}", dt.Month, dt.Day, dt.ToString("hh:mm"), request.Body); break; case 6: title = "分配通知"; body = string.Format("{0}已进店,请分配车险业务员", request.Body); break; case 7: title = "出单通知"; body = string.Format("{0}已投保({1})", request.Body, request.Source.HasValue ? request.Source.Value.ToEnumDescriptionString(typeof(EnumSource)) : ""); break; default: title = ""; body = ""; break; } bxMessage.Title = title; bxMessage.Body = body; bxMessage.Msg_Type = request.MsgType; bxMessage.Agent_Id = request.ToAgentId; bxMessage.Create_Time = DateTime.Now; bxMessage.Msg_Status = 0; bxMessage.Msg_Level = request.MsgLevel; bxMessage.Send_Time = !string.IsNullOrWhiteSpace(request.SendTime) ? DateTime.Parse(request.SendTime) : bxMessage.Create_Time; bxMessage.Create_Agent_Id = request.ChildAgent; bxMessage.Url = request.Url; bxMessage.Buid = request.Buid; bxMessage.License_No = request.LicenseNo; return(_messageRepository.Add(bxMessage)); }
public int Update(bx_message bxMessage) { int count = 0; try { DataContextFactory.GetDataContext().bx_message.AddOrUpdate(bxMessage); count = DataContextFactory.GetDataContext().SaveChanges(); } catch (Exception ex) { logError.Info("发生异常:" + ex.Source + "\n" + ex.StackTrace + "\n" + ex.Message + "\n" + ex.InnerException); } return(count); }
public int Add(bx_message bxMessage) { int workOrderId = 0; try { var t = DataContextFactory.GetDataContext().bx_message.Add(bxMessage); DataContextFactory.GetDataContext().SaveChanges(); workOrderId = t.Id; } catch (Exception ex) { logError.Info("发生异常:" + ex.Source + "\n" + ex.StackTrace + "\n" + ex.Message + "\n" + ex.InnerException); workOrderId = 0; } return(workOrderId); }
public int Add(bx_message bxMessage) { int workOrderId = 0; try { var _db = new EntityContext(); var t = _db.bx_message.Add(bxMessage); _db.SaveChanges(); workOrderId = t.Id; } catch (Exception ex) { logError.Info("发生异常:" + ex.Source + "\n" + ex.StackTrace + "\n" + ex.Message + "\n" + ex.InnerException); workOrderId = 0; } return(workOrderId); }
public ReadMessageResponse ReadMessage(ReadMessageRequest request, IEnumerable <KeyValuePair <string, string> > pairs) { var response = new ReadMessageResponse(); IBxAgent agentModel = GetAgentModelFactory(request.Agent); //参数校验 if (!agentModel.AgentCanUse()) { response.ErrCode = -10001; response.ErrMsg = "参数校验错误,请检查您的校验码"; return(response); } if (!AppValidateReqest(pairs, request.SecCode)) { response.ErrCode = -10001; response.ErrMsg = "参数校验错误,请检查您的校验码"; return(response); } int result = 0; switch (request.MsgType) { case 1: { //修改bx_notice_xb表 bx_notice_xb bxNoticeXb = _noticexbRepository.Find(request.MsgId); if (bxNoticeXb != null) { bxNoticeXb.stauts = 1; result = _noticexbRepository.Update(bxNoticeXb); } } break; case 2: { //修改bx_consumer_review表 bx_consumer_review bxConsumerReview = _consumerReviewRepository.Find(request.MsgId); if (bxConsumerReview != null) { bxConsumerReview.read_status = 1; result = _consumerReviewRepository.UpdateDetail(bxConsumerReview); } } break; default: { //修改bx_message表 bx_message bxMessage = _messageRepository.Find(request.MsgId); if (bxMessage != null) { bxMessage.Msg_Status = 1; bxMessage.Update_Time = DateTime.Now; result = _messageRepository.Update(bxMessage); } } break; } if (result > 0) { response.Status = HttpStatusCode.OK; } return(response); }