/// <summary>
/// 查找最后一条已出单记录
/// </summary>
/// <param name="buid"></param>
/// <returns></returns>
public bx_consumer_review FindNewClosedOrder(long buid, int status = 1)
{
bx_consumer_review model = new bx_consumer_review();
try
{
model = DataContextFactory.GetDataContext().bx_consumer_review.Where(x => x.b_uid == buid && x.result_status == status).OrderByDescending(o => o.id).FirstOrDefault();
}
catch (Exception ex)
{
logError.Info("发生异常:" + ex.Source + "\n" + ex.StackTrace + "\n" + ex.Message + "\n" + ex.InnerException);
}
return(model);
}
public bx_consumer_review Find(int id)
{
bx_consumer_review model = new bx_consumer_review();
try
{
model = DataContextFactory.GetDataContext().bx_consumer_review.Where(i => i.id == id).FirstOrDefault();
}
catch (Exception ex)
{
logError.Info("发生异常:" + ex.Source + "\n" + ex.StackTrace + "\n" + ex.Message + "\n" + ex.InnerException);
}
return(model);
}
public int UpdateDetail(bx_consumer_review bxWorkOrderDetail)
{
int count = 0;
try
{
DataContextFactory.GetDataContext().bx_consumer_review.AddOrUpdate(bxWorkOrderDetail);
count = DataContextFactory.GetDataContext().SaveChanges();
}
catch (Exception ex)
{
logError.Info("发生异常:" + ex.Source + "\n" + ex.StackTrace + "\n" + ex.Message + "\n" + ex.InnerException);
}
return(count);
}
public int AddDetail(bx_consumer_review bxWorkOrderDetail)
{
int workOrderDetailId = 0;
try
{
var t = DataContextFactory.GetDataContext().bx_consumer_review.Add(bxWorkOrderDetail);
DataContextFactory.GetDataContext().SaveChanges();
workOrderDetailId = t.id;
}
catch (Exception ex)
{
logError.Info("发生异常:" + ex.Source + "\n" + ex.StackTrace + "\n" + ex.Message + "\n" + ex.InnerException);
workOrderDetailId = 0;
}
return(workOrderDetailId);
}
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);
}
public BaseViewModel AddReVisited(AddReVisitedRequest request)
{
var viewModel = new BaseViewModel();
try
{
DateTime dateTime = DateTime.Now;
var bxUserInfo = new bx_userinfo();
if (request.Buid.HasValue && request.Buid.Value != 0)
{//根据buid获取userinfo对象
bxUserInfo = _userInfoRepository.FindByBuid(request.Buid.Value);
}
if (bxUserInfo == null)
{
viewModel.BusinessStatus = -10002;
viewModel.StatusMessage = "获取信息失败";
return(viewModel);
}
int workOrderId = 0;
bx_userinfo_renewal_info workorder = _userinfoRenewalInfoRepository.FindByBuid(request.Buid.Value);
if (workorder == null)
{
workorder = new bx_userinfo_renewal_info();
workorder.sa_id = request.ChildAgent;
workorder.sa_name = request.ChildName;
workorder.client_name = request.CustomerName;
workorder.client_mobile = request.Phone;
workorder.b_uid = request.Buid.Value;
workorder.client_intention = 3;//默认添加，其他情况
workorder.create_time = dateTime;
workorder.xubao_id = request.ChildAgent;
workorder.xubao_name = request.ChildName;
workOrderId = _userinfoRenewalInfoRepository.Add(workorder);
}
else
{
workOrderId = workorder.id;
if (!string.IsNullOrWhiteSpace(request.CustomerName) || !string.IsNullOrWhiteSpace(request.Phone))
{
workorder.client_name = request.CustomerName;
workorder.client_mobile = request.Phone;
if (_userinfoRenewalInfoRepository.Update(workorder) == 0)
{
//将失败信息插入到error里
}
}
}
if (workOrderId > 0)
{
var workOrderDetail = new bx_consumer_review
{
b_uid = (int)bxUserInfo.Id,
content = request.Remark,
operatorId = request.ChildAgent,
operatorName = request.ChildName,
read_status = 0, //0未读，1已读
status = request.Status, //跟进类型,0回访,1投诉,2跟进..
result_status = 4, //受理结果，默认 其他。目前暂不使用
create_time = dateTime
};
if (!string.IsNullOrWhiteSpace(request.NextReviewDate))
{
workOrderDetail.next_review_date = DateTime.Parse(request.NextReviewDate);
}
int workOrderDetailId = _consumerReviewRepository.AddDetail(workOrderDetail);
if (workOrderDetailId > 0)
{
viewModel.BusinessStatus = 1;
}
else
{
viewModel.BusinessStatus = -10002;
viewModel.StatusMessage = "添加信息失败";
}
}
}
catch (Exception ex)
{
viewModel.BusinessStatus = -10003;
viewModel.StatusMessage = "服务器发生异常";
logError.Info("添加受理记录异常，受理记录信息：" + request.ToJson() + "\n 异常信息:" + ex.StackTrace + " \n " + ex.Message);
}
return(viewModel);
}
/// <summary>
/// 业务：续保顾问用。创建WorkOrderDetail对象和更新WorkOrder对象
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public AddOrUpdateWorkOrderDetailResponse AddOrUpdateWorkOrderDetail(AddOrUpdateWorkOrderDetailRequest request, IEnumerable <KeyValuePair <string, string> > pairs)
{
var response = new AddOrUpdateWorkOrderDetailResponse();
//bhToken校验
if (!AppTokenValidateReqest(request.BhToken, request.ChildAgent))
{
response.ErrCode = -300;
response.ErrMsg = "登录信息已过期，请重新登录";
return(response);
}
//传参校验
IBxAgent agentModel = GetAgentModelFactory(request.Agent);
//参数校验
if (!agentModel.AgentCanUse())
{
response.Status = HttpStatusCode.BadRequest;
return(response);
}
if (!AppValidateReqest(pairs, request.SecCode))
{
response.Status = HttpStatusCode.Forbidden;
return(response);
}
if (request.Status == 0)
{
response.ErrCode = -1;
response.ErrMsg = "受理状态不能为空";
return(response);
}
try
{
DateTime dateTime = DateTime.Now;
bx_userinfo_renewal_info workOrder;
bx_userinfo bxUserInfo;
if (request.Buid.HasValue && request.Buid.Value != 0)
{
//如果传buid过来，重新赋值request
bxUserInfo = _userInfoRepository.FindByBuid(request.Buid.Value);
if (bxUserInfo != null)
{
request.LicenseNo = bxUserInfo.LicenseNo;
request.OwnerAgent = int.Parse(bxUserInfo.Agent);
}
}
else
{
//根据OpenId、车牌号、代理人Id找userinfo对象
bxUserInfo = _userInfoRepository.FindByAgentLicense(request.LicenseNo, request.OwnerAgent.ToString());
}
if (bxUserInfo == null)
{
response.ErrCode = 0;
response.ErrMsg = "查不到此续保信息";
return(response);
}
int workOrderId = request.WorkOrderId;
if (workOrderId == 0)
{
workOrder = new bx_userinfo_renewal_info();
workOrder.sa_id = request.SaAgent;
workOrder.sa_name = request.SaAgentName;
workOrder.client_name = request.CustomerName;
workOrder.client_mobile = request.Phone;
workOrder.b_uid = (int)bxUserInfo.Id;
workOrder.client_intention = 3;//默认添加，其他情况
//workOrder.remark = request.Remark;
workOrder.create_time = dateTime;
workOrder.xubao_id = request.ChildAgent;
workOrder.xubao_name = request.ChildName;
workOrderId = _userinfoRenewalInfoRepository.Add(workOrder);
}
if (workOrderId > 0)
{
var workOrderDetail = new bx_consumer_review
{
b_uid = (int)bxUserInfo.Id,
content = request.Remark,
operatorId = request.ChildAgent,
operatorName = request.ChildName
};
if (!string.IsNullOrWhiteSpace(request.NextReviewDate))
{
workOrderDetail.next_review_date = DateTime.Parse(request.NextReviewDate);
}
workOrderDetail.read_status = 0;
workOrderDetail.status = 0;//跟进类型,0回访,1投诉,2跟进..
workOrderDetail.result_status = request.Status;
workOrderDetail.intentioncompany = request.IntentionCompany;
workOrderDetail.create_time = dateTime;
int workOrderDetailId = _consumerReviewRepository.AddDetail(workOrderDetail);
if (workOrderDetailId > 0)
{
if (workOrderId != 0)
{
if (request.Status == 1)
{
//5，添加出单通知
var msgRequest = new AddMessageRequest
{
Body = request.LicenseNo,
MsgType = 7,
ToAgentId = request.Agent,
MsgLevel = 1,
SendTime = DateTime.Now.ToString(),
ChildAgent = request.ChildAgent,
LicenseNo = request.LicenseNo,
Buid = bxUserInfo.Id,
Source = request.IntentionCompany
};
_messageService.AddMessage(msgRequest);
}
//修改意向里的主记录
workOrder = new bx_userinfo_renewal_info();
workOrder = _userinfoRenewalInfoRepository.FindById(workOrderId);
if (workOrder != null)
{
workOrder.intentioncompany = request.IntentionCompany;
workOrder.result_status = request.Status;
workOrder.xubao_id = request.ChildAgent;
workOrder.xubao_name = request.ChildName;
_userinfoRenewalInfoRepository.Update(workOrder);
//if (_userinfoRenewalInfoRepository.Update(workOrder) > 0)
//{
response.ErrCode = 1;
response.WorkOrderDetailId = workOrderDetailId;
//}
//else
//{
// response.ErrCode = 0;
//}
}
}
else
{
response.ErrCode = 0;
//response.ErrCode = 1;
//response.WorkOrderDetailId = workOrderDetailId;
}
}
else
{
response.ErrCode = 0;
}
}
}
catch (Exception ex)
{
response.ErrCode = 0;
logError.Info("添加受理记录异常，受理记录信息：" + request.ToJson() + "\n 异常信息:" + ex.StackTrace + " \n " + ex.Message);
}
return(response);
}
