public GetSelectHouseInfoResult Post(GetSelectHouseInfoRequestModel req) { Logger.LogDebug("GetSelectHouseInfo Request:" + JsonHelper.SerializeObject(req), "GetSelectHouseInfoController", "Post"); var ret = new GetSelectHouseInfoResult() { Code = 0, ErrMsg = "" }; try { if (_projectBLL.GetModels(x => x.ID == req.ProjectID).FirstOrDefault() == null) { ret.Code = 201; ret.ErrMsg = "项目ID不存在!"; } if (_subscriberBLL.GetModels(x => x.ID == req.SubscriberID).FirstOrDefault() == null) { ret.Code = 202; ret.ErrMsg = "认购人ID不存在!"; } else { var selectResult = _selectionBLL.GetModels(x => x.ProjectID == req.ProjectID && x.SubscriberID == req.SubscriberID).FirstOrDefault(); if (selectResult != null) { var _hs = _houseBLL.GetModels(x => x.ID == selectResult.HouseID).FirstOrDefault(); var houseInfo = new HouseAndEstateEntity() { HouseEstateName = _hs.HouseEstate.Name, SerialNumber = _hs.SerialNumber, Group = _hs.HouseGroup.Name, Block = _hs.Block, Building = _hs.Building, Unit = _hs.Unit, RoomNumber = _hs.RoomNumber, Toward = _hs.Toward, RoomType = _hs.RoomType.Name, EstimateBuiltUpArea = _hs.EstimateBuiltUpArea, EstimateLivingArea = _hs.EstimateLivingArea, AreaUnitPrice = _hs.AreaUnitPrice, TotalPrice = _hs.TotalPrice }; ret.HouseInfo = houseInfo; } else { ret.Code = 203; ret.ErrMsg = "该认购人未在该项目中选房!"; } } } catch (Exception ex) { Logger.LogException("获取选房详情发生", "GetSelectHouseInfoController", "Post", ex); ret.Code = 999; ret.ErrMsg = ex.Message; } return(ret); }
public GetSubscriberSelectionHistoryResultEntity Post(GetSubscriberSelectionHistoryRequestModel req) { Logger.LogDebug("GetSubscriberSelectionHistory Request:" + JsonHelper.SerializeObject(req), "GetSubscriberSelectionHistoryController", "Post"); var ret = new GetSubscriberSelectionHistoryResultEntity() { Code = 0, ErrMsg = "" }; try { //if(_projectBLL.GetModels(x => x.ID == req.ProjectID).FirstOrDefault() == null) //{ // ret.code = 201; // ret.ErrMsg = "项目ID不存在!"; //} if (_subscriberBLL.GetModels(x => x.ID == req.SubscriberID).FirstOrDefault() == null) { ret.Code = 202; ret.ErrMsg = "认购人ID不存在!"; } else { //var _proList = _subscriberProjectMapBLL.GetModels(x => x.SubscriberID == req.SubscriberID).ToList(); //var _selectionList = _selectionBLL.GetModels(x => x.SubscriberID == req.SubscriberID).ToList(); //var _noticeList = _noticeBLL.GetModels(x => x.ShakingNumberResult.SubscriberProjectMapping.SubscriberID == req.SubscriberID).ToList(); //var _historyList = new List<SubscriberSelectionEntity>(); //foreach(var pro in _proList) //{ // var _shakingNumber = _shakingNumberBLL.GetModels(x => x.SubscriberProjectMappingID == pro.ID).FirstOrDefault(); // var _notice = _noticeList.FirstOrDefault(x => x.ShakingNumberResult.SubscriberProjectMappingID == pro.ID); // var _selection = _selectionList.FirstOrDefault(x => x.SubscriberID == pro.SubscriberID && x.ProjectID == pro.ProjectID); // var _history = new SubscriberSelectionEntity() // { // ProjectID = pro.ProjectID, // ProjectNumber = pro.Project.Number, // ProjectName = pro.Project.Name, // NoticeStatus = _notice != null ? _notice.ResultType : 0, // AuthStatus = _shakingNumber == null ? 0 : (_shakingNumber.IsAuthorized ? 1 : 0), // SelectionStatus = _selection != null ? 1 : 0, // ConfirmStatus = _selection != null ? (_selection.IsConfirm ? 1 : 0) : 0, // ShakingResultID = _shakingNumber == null ? 0 : _shakingNumber.ID // }; // _historyList.Add(_history); //} //ret.SelectionList = _historyList; ret.SelectionList = _selectionBLL.GetSubscriberSelectionRecord(req.SubscriberID); } } catch (Exception ex) { Logger.LogException("获取认购人认购历史时发生异常!", "GetSubscriberSelectionHistoryController", "Post", ex); ret.Code = 999; ret.ErrMsg = ex.Message; } return(ret); }
private Subscriber GetSubscriberBySPMId(int spmId) { Subscriber result = new Subscriber(); var smInfo = _subscriberProjectMappingBLL.GetModels(sm => sm.ID == spmId).FirstOrDefault(); if (smInfo != null) { result = _subscriberBLL.GetModels(s => s.ID == smInfo.SubscriberID).FirstOrDefault(); } else { result = null; } return(result); }
public GetSubscriberResultEntity Post(GetSubscriberRequestModel req) { Logger.LogDebug("GetAllSubscribers Request:" + JsonHelper.SerializeObject(req), "GetAllSubscribersController", "Post"); var ret = new GetSubscriberResultEntity() { Code = 0, ErrMsg = "" }; try { //if(_projectBLL.GetModels(x => x.ID == req.ProjectID).FirstOrDefault() == null) //{ // ret.code = 201; // ret.ErrMsg = "项目ID不存在!"; //} //else //{ //var _dbSubList = _subscriberBLL.GetModelsByPage(req.PageSize, req.PageIndex, true, x => x.ID, x => x.ProjectID == req.ProjectID).ToList(); var _dbSubList = _subscriberBLL.GetModelsByPage(req.PageSize, req.PageIndex, true, x => x.ID, x => 1 == 1).ToList(); var _subList = new List <SubscriberEntity>(); foreach (var _dbSub in _dbSubList) { var _sub = new SubscriberEntity() { ID = _dbSub.ID, Name = _dbSub.Name, IdentityNumber = _dbSub.IdentityNumber, Telephone = _dbSub.Telephone, Address = _dbSub.Address, ZipCode = _dbSub.ZipCode, MaritalStatus = _dbSub.MaritalStatus, ResidenceArea = _dbSub.ResidenceArea, WorkArea = _dbSub.WorkArea, }; _subList.Add(_sub); } ret.SubscriberList = _subList; ret.RecordCount = _subscriberBLL.GetModels(x => 1 == 1).Count(); //} } catch (Exception ex) { Logger.LogException("获取认购人时发生异常", "GetSubscribersController", "Post", ex); } return(ret); }
public BaseResultEntity Post(ImportSubscriberRequestEntity req) { Logger.LogDebug("ImportSubscriber Request:" + JsonHelper.SerializeObject(req), "ImportSubscriberController", "Post"); BaseResultEntity ret = new BaseResultEntity() { Code = 0, ErrMsg = "" }; try { #region 请求数据校验 var _pro = _projectBLL.GetModels(x => x.ID == req.ProjectID).FirstOrDefault(); if (_pro == null) { ret.Code = 401; ret.ErrMsg = "项目ID不存在!"; return(ret); } else if (req.ProjectGroup == null) { ret.Code = 402; ret.ErrMsg = "项目分组不能为空!"; return(ret); } foreach (var shake in req.ShakingNumberList) { if (shake.ShakingNumber == null) { ret.Code = 403; ret.ErrMsg = "摇号编号不能为空!"; return(ret); } if (shake.Subscriber == null) { ret.Code = 404; ret.ErrMsg = "摇号编号为" + shake.ShakingNumber + "的认购人信息不能为空!"; return(ret); } if (shake.ShakingNumberSequance <= 0) { ret.Code = 405; ret.ErrMsg = "摇号编号为" + shake.ShakingNumber + "摇号序号不能为空或小于1!"; return(ret); } if (shake.SelectHouseSequance <= 0) { ret.Code = 405; ret.ErrMsg = "摇号编号为" + shake.ShakingNumber + "选房序号不能为空或小于1!"; return(ret); } if (shake.Subscriber.Name == null || shake.Subscriber.IdentityNumber == null || shake.Subscriber.Telephone == null || shake.Subscriber.Address == null || shake.Subscriber.MaritalStatus == null || shake.Subscriber.ZipCode == null || shake.Subscriber.ResidenceArea == null || shake.Subscriber.WorkArea == null) { ret.Code = 406; ret.ErrMsg = "摇号编号为" + shake.ShakingNumber + "认购人信息不完整!"; return(ret); } } #endregion #region 创建项目分组 int _projectGroupID = 0; try { if (_projectGroupBLL.GetModels(x => x.ProjectID == req.ProjectID && x.ProjectGroupName == req.ProjectGroup).FirstOrDefault() == null) //项目分组不存在 { var _progrp = new ProjectGroup() { ProjectID = req.ProjectID, ProjectGroupName = req.ProjectGroup, CreateTime = DateTime.Now, LastUpdate = DateTime.Now }; _projectGroupBLL.Add(_progrp); } _projectGroupID = _projectGroupBLL.GetModels(x => x.ProjectID == req.ProjectID && x.ProjectGroupName == req.ProjectGroup).FirstOrDefault().ID; } catch (Exception ex) { Logger.LogException("创建项目分组时发生异常!", "ImportSubscriberController", "Post", ex); ret.Code = 999; ret.ErrMsg = ex.Message; return(ret); } #endregion var _subList = new List <Subscriber>(); var _existSubList = new List <Subscriber>(); var _familyList = new List <SubscriberFamilyMemberEntity>(); var _shakeList = new List <ShakingNumberResult>(); #region 创建认购人 var _dbSubList = _subscriberBLL.GetModels(x => 1 == 1).ToList(); foreach (var shake in req.ShakingNumberList) { try { var _sub = _dbSubList.FirstOrDefault(x => x.IdentityNumber == shake.Subscriber.IdentityNumber); if (_sub == null) //认购人不存在 { var _subscriber = new Subscriber() { Name = shake.Subscriber.Name, IdentityNumber = shake.Subscriber.IdentityNumber, Telephone = shake.Subscriber.Telephone, Address = shake.Subscriber.Address, ZipCode = shake.Subscriber.ZipCode, MaritalStatus = shake.Subscriber.MaritalStatus, ResidenceArea = shake.Subscriber.ResidenceArea, WorkArea = shake.Subscriber.WorkArea, FamilyMemberNumber = shake.FamilyMemberList == null ? 0 : shake.FamilyMemberList.Count(), CreateTime = DateTime.Now, LastUpdate = DateTime.Now }; _subList.Add(_subscriber); if (shake.FamilyMemberList != null && shake.FamilyMemberList.Count() > 0) { _familyList.AddRange(shake.FamilyMemberList); } } else { _existSubList.Add(_sub); } } catch (Exception ex) { Logger.LogException("创建摇号编号为" + shake.ShakingNumber + "的认购人时发生异常!", "ImportSubscriberController", "Post", ex); ret.Code = 999; ret.ErrMsg = ex.Message; return(ret); } } _subscriberBLL.AddRange(_subList); #endregion #region 创建认购人家庭成员 var _ttlSubList = _subscriberBLL.GetModels(x => 1 == 1).ToList(); var _dbFamilyList = new List <SubscriberFamilyMember>(); foreach (var family in _familyList) { try { var _sub = _ttlSubList.FirstOrDefault(x => x.IdentityNumber == family.SubscriberIdentityNumber); if (_sub != null) { var _fam = new SubscriberFamilyMember() { SubscriberID = _sub.ID, Name = family.Name, IdentityNumber = family.IdentityNumber, Relationship = family.Relationship, Area = family.Area, CreateTime = DateTime.Now, LastUpdate = DateTime.Now }; _dbFamilyList.Add(_fam); } } catch (Exception ex) { _subscriberBLL.DeleteRange(_subList); //回滚新建认购人 Logger.LogException("创建身份证为" + family.IdentityNumber + "的认购人家庭成员时发生异常!", "ImportSubscriberController", "Post", ex); ret.Code = 999; ret.ErrMsg = ex.Message; return(ret); } } _subscriberFamilyBLL.AddRange(_dbFamilyList); #endregion #region 创建认购人项目关联关系 var _subProMapList = new List <SubscriberProjectMapping>(); foreach (var sub in _subList)//添加新认购人Mapping { var _subProMap = new SubscriberProjectMapping() { SubscriberID = sub.ID, ProjectID = req.ProjectID, CreateTime = DateTime.Now, LastUpdate = DateTime.Now }; _subProMapList.Add(_subProMap); } var _existSubMap = _subscriberProjectMapBLL.GetModels(x => x.ProjectID == req.ProjectID).ToList(); foreach (var sub in _existSubList)//添加已存在认购人Mapping { if (!_existSubMap.Any(x => x.SubscriberID == sub.ID)) { var _subProMap = new SubscriberProjectMapping() { SubscriberID = sub.ID, ProjectID = req.ProjectID, CreateTime = DateTime.Now, LastUpdate = DateTime.Now }; _subProMapList.Add(_subProMap); } } _subProMapList.OrderBy(x => x.SubscriberID); _subscriberProjectMapBLL.AddRange(_subProMapList); #endregion #region 创建摇号结果 var _dbSubProMap = _subscriberProjectMapBLL.GetModels(x => x.ProjectID == req.ProjectID).ToList(); var _existShakingList = _shakingNumberBLL.GetModels(x => x.ProjectGroup.ProjectID == req.ProjectID).ToList(); var _dbshakingNumberList = new List <ShakingNumberResult>(); foreach (var shake in req.ShakingNumberList) { try { var _subProMap = _dbSubProMap.FirstOrDefault(x => x.Subscriber.IdentityNumber == shake.Subscriber.IdentityNumber); if (_subProMap != null && _projectGroupID != 0 && !_existShakingList.Any(x => x.SubscriberProjectMapping.Subscriber.IdentityNumber == shake.Subscriber.IdentityNumber)) { var _shake = new ShakingNumberResult() { ProjectGroupID = _projectGroupID, SubscriberProjectMappingID = _subProMap.ID, ShakingNumberSequance = shake.ShakingNumberSequance, SelectHouseSequance = shake.SelectHouseSequance, ShakingNumber = shake.ShakingNumber, NoticeTime = 0, IsError = false, IsContacted = false, IsCallBack = false, IsMessageSend = false, CreateTime = DateTime.Now, LastUpdate = DateTime.Now }; _dbshakingNumberList.Add(_shake); } } catch (Exception ex) { _subscriberProjectMapBLL.DeleteRange(_subProMapList); //回滚新建认购人项目关联 Logger.LogException("创建摇号编号为" + shake.ShakingNumber + "的摇号结果时发生异常!", "ImportSubscriberController", "Post", ex); ret.Code = 999; ret.ErrMsg = ex.Message; return(ret); } } _shakingNumberBLL.AddRange(_dbshakingNumberList); #endregion } catch (Exception ex) { Logger.LogException("导入认购人和摇号信息时发生异常!", "ImportSubscriberController", "Post", ex); ret.Code = 999; ret.ErrMsg = ex.Message; } return(ret); }
public GetHouseEstateDetailsResultEntity Post(GetHouseEstateDetailsRequestModel req) { var ret = new GetHouseEstateDetailsResultEntity() { Code = 0, ErrMsg = "", Houses = new List <HouseInfo>() }; try { if (req.HouseEstateId <= 0 || req.ProjectId <= 0) { ret.Code = 401; ret.ErrMsg = "入参无效。"; } else { var houses = _houseBLL.GetModels(h => h.ProjectID == req.ProjectId && h.HouseEstateID == req.HouseEstateId && h.Building == req.BuildingId).ToList(); houses.ForEach(h => { var houseInfo = new HouseInfo(); houseInfo.Building = h.Building; houseInfo.Unit = h.Unit; var subscriberInfo = _subscriberBLL.GetModels(i => i.ID == h.SubscriberID).FirstOrDefault(); string subscriberName = string.Empty; if (subscriberInfo != null) { subscriberName = subscriberInfo.Name; } var groupInfo = _houseGroupBLL.GetModels(g => g.ID == h.GroupID).FirstOrDefault(); string groupName = string.Empty; if (groupInfo != null) { groupName = groupInfo.Name; } var roomTypeInfo = _roomTypeBLL.GetModels(r => r.ID == h.RoomTypeID).FirstOrDefault(); string roomType = string.Empty; if (roomTypeInfo != null) { roomType = roomTypeInfo.Name; } houseInfo.HouseDetail = new Model.HouseEntity() { AreaUnitPrice = h.AreaUnitPrice, Block = h.Block, Building = h.Building, EstimateBuiltUpArea = h.EstimateBuiltUpArea, EstimateLivingArea = h.EstimateLivingArea, Group = groupName, HouseID = h.ID, RoomNumber = h.RoomNumber, RoomType = roomType, SerialNumber = h.SerialNumber, SubscriberID = h.SubscriberID, SubscriberName = subscriberName, TotalPrice = h.TotalPrice, Toward = h.Toward, Unit = h.Unit }; ret.Houses.Add(houseInfo); }); } } catch (Exception ex) { Logger.LogException("获取楼盘明细信息时发生异常!", "GetHouseEstateDetailsController", "Post", ex); ret.Code = 999; ret.ErrMsg = ex.Message; } return(ret); }