public void Execute() { using (var fcpa = new TCDMS_FCPAEntities()) { using (var master = new TCDMS_MasterDataEntities()) { const string sql = "SELECT distinct DistributorID,DistributorName,AreaName,[RegionName] FROM master_DistributorInfo INNER JOIN master_DistributorRegionInfo ON master_DistributorRegionInfo.RegionID = master_DistributorInfo.RegionID INNER JOIN master_AreaInfo ON master_AreaInfo.AreaID = master_DistributorRegionInfo.AreaID INNER JOIN [dict_RegionInfo] ON master_DistributorRegionInfo.RegionID=[dict_RegionInfo].RegionID"; var result = master.Database.SqlQuery <SyncDistributorModel>(sql); result.ToList().ForEach(item => { var distributor = fcpa.fcpa_DistributorInfo.Find(item.DistributorID.ToString()); if (distributor != null) { distributor.DistributorName = item.DistributorName; distributor.AreaName = item.AreaName; distributor.RegionName = item.RegionName; } else { fcpa.fcpa_DistributorInfo.Add(new fcpa_DistributorInfo { DistributorID = item.DistributorID.ToString(), DistributorName = item.DistributorName, AreaName = item.AreaName, RegionName = item.RegionName }); } }); } fcpa.SaveChanges(); } }
/// <summary> /// 新增日志 /// </summary> /// <param name="tcdmse">当前上下文数据集</param> /// <param name="lngdata">日志数据</param> protected void AddLog(TCDMS_MasterDataEntities tcdmse, LogData lngdata) { string strBelongFunc = null; switch (lngdata.CurrentLogType) { case LogType.ADD: strBelongFunc = "新增"; break; case LogType.DELETE: strBelongFunc = "删除"; break; case LogType.IMPORT: strBelongFunc = "导入"; break; case LogType.UNENABLE: strBelongFunc = "停用"; break; } tcdmse.common_LogInfo.Add(new common_LogInfo { BelongModel = "基础数据", BelongFunc = strBelongFunc, LogDetails = lngdata.LogDetails, LogDate = DateTime.Now, OpratorName = lngdata.OpratorName }); }
private void RemoveAllChild(TCDMS_MasterDataEntities tcdmse, dict_RegionInfo dict, HashSet <int> idset) { var child = tcdmse.dict_RegionInfo.Where(p => p.RegionPID == dict.RegionID); foreach (var p in child) { if (idset.Contains(p.RegionID)) { throw new Exception("此条信息已使用不可删除!"); } RemoveAllChild(tcdmse, p, idset); } tcdmse.dict_RegionInfo.RemoveRange(child); }
public bool SaveDymicPassword(string PhoneNumber, string strDymicPassword, int intValidDate) { bool blResult = false; using (var dmse = new TCDMS_MasterDataEntities()) { var pp = dmse.master_UserInfo.Where(p => p.PhoneNumber == PhoneNumber && (p.IsActive ?? false)).FirstOrDefault(); if (pp != null) { pp.DynamicPassword = strDymicPassword; pp.EffectiveTtime = DateTime.Now.AddSeconds(intValidDate); } blResult = dmse.SaveChanges() > 0; } return(blResult); }
public void Execute() { var distributorUsers = new List <DistributorUserInfo>(); using (var master = new TCDMS_MasterDataEntities()) { distributorUsers.AddRange(master.Database.SqlQuery <DistributorUserInfo>("select DistributorID,master_UserInfo.UserID,master_UserInfo.Email,master_UserInfo.FullName,master_UserInfo.PhoneNumber from master_DistributorUserInfo inner join master_UserInfo on master_DistributorUserInfo.UserID=master_UserInfo.UserID").ToList()); } using (var fcpa = new TCDMS_FCPAEntities()) { //未完成 var ss = fcpa.fcpa_DistributorInfo.Where(p => p.fcpa_CredentialInfo.Any(c => c.Status == 3)).ToList(); fcpa.fcpa_DistributorInfo.Where(p => p.fcpa_CredentialInfo.Any(c => c.Status == 3)).ToList().ForEach(item => { distributorUsers.Where(p => p.DistributorID.ToString() == item.DistributorID).ToList().ForEach(user => { fcpa.fcpa_AlarmInfo.Add(new fcpa_AlarmInfo { fcpa_UserInfo = fcpa.fcpa_UserInfo.Find(user.UserID), AlarmTime = DateTime.Now, ID = Guid.NewGuid() }); }); }); fcpa.SaveChanges(); //快过期 fcpa.fcpa_DistributorInfo.Where(p => p.fcpa_CredentialInfo.Any(c => c.Status == 2)).ToList().ForEach(item => { distributorUsers.Where(p => p.DistributorID.ToString() == item.DistributorID).ToList().ForEach(user => { fcpa.fcpa_AlarmInfo.Add(new fcpa_AlarmInfo { fcpa_UserInfo = fcpa.fcpa_UserInfo.Find(user.UserID), AlarmTime = DateTime.Now, ID = Guid.NewGuid() }); }); }); fcpa.SaveChanges(); } }
public void Execute() { using (var fcpa = new TCDMS_FCPAEntities()) { using (var master = new TCDMS_MasterDataEntities()) { string sql = "SELECT master_UserInfo.*, master_DistributorUserInfo.DistributorID FROM master_UserInfo INNER JOIN master_UserRoleInfo ON master_UserInfo.UserID = master_UserRoleInfo.UserID LEFT OUTER JOIN master_DistributorUserInfo ON master_UserInfo.UserID = master_DistributorUserInfo.UserID LEFT OUTER JOIN master_DepartmentInfo ON master_UserInfo.DepartID = master_DepartmentInfo.DepartID"; master.Database.SqlQuery <UserJobDTO>(sql).ToList() .GroupBy(p => p.UserID).Select(p => new { Key = p.Key, Value = p }).ToList().ForEach(res => { var userInfo = res.Value.First(); var user = fcpa.fcpa_UserInfo.Find(userInfo.UserID); if (user == null) { fcpa.fcpa_UserInfo.Add(new fcpa_UserInfo { UserID = userInfo.UserID, UserCode = userInfo.UserCode, FullName = userInfo.FullName, PhoneNumber = userInfo.PhoneNumber, DynamicPassword = userInfo.DynamicPassword, EffectiveTtime = userInfo.EffectiveTtime, StopTime = userInfo.StopTime, Email = userInfo.Email, UserType = userInfo.UserType, AuditName = userInfo.AuditName, IsActive = userInfo.IsActive, NoActiveTime = userInfo.NoActiveTime, CreateUser = userInfo.CreateUser, CreateTime = userInfo.CreateTime, ModifyUser = userInfo.ModifyUser, ModifyTime = userInfo.ModifyTime, RelDistributor = string.Join(",", res.Value.Where(p => p.DistributorID != null).Select(p => p.DistributorID.Value.ToString()).Distinct()), Domain1 = res.Value.Where(p => p.DepartID == 1).Any(), Domain2 = res.Value.Where(p => p.DepartID == 2).Any(), Role = userInfo.UserType.HasValue ? userInfo.UserType.Value : 0, }); } else { user.UserCode = userInfo.UserCode; user.FullName = userInfo.FullName; user.PhoneNumber = userInfo.PhoneNumber; user.DynamicPassword = userInfo.DynamicPassword; user.EffectiveTtime = userInfo.EffectiveTtime; user.StopTime = userInfo.StopTime; user.Email = userInfo.Email; user.UserType = userInfo.UserType; user.AuditName = userInfo.AuditName; user.IsActive = userInfo.IsActive; user.NoActiveTime = userInfo.NoActiveTime; user.CreateUser = userInfo.CreateUser; user.CreateTime = userInfo.CreateTime; user.ModifyUser = userInfo.ModifyUser; user.ModifyTime = userInfo.ModifyTime; user.RelDistributor = string.Join(",", res.Value.Where(p => p.DistributorID != null).Select(p => p.DistributorID.Value.ToString()).Distinct()); user.Domain1 = res.Value.Where(p => p.DepartID == 1).Any(); user.Domain2 = res.Value.Where(p => p.DepartID == 2).Any(); user.Role = userInfo.UserType.HasValue ? userInfo.UserType.Value : 0; } }); } fcpa.SaveChanges(); } }
public static TCDMS_MasterDataEntities GetObj() { if (_OBJ == null) { _OBJ = new TCDMS_MasterDataEntities(); Mapper.Initialize(cfg => { cfg.ShouldMapProperty = p => p.GetMethod.IsPublic || p.GetMethod.IsAssembly; var mru = cfg.CreateMap <master_RoleAuthority, CurrentUserRoleAuthority>(); mru.ForMember(p => p.StructureID, opt => opt.MapFrom(s => s.StructureID)); mru.ForMember(p => p.RoleButtonAuthority, opt => opt.MapFrom(s => s.RoleButtonAuthority)); var muc = cfg.CreateMap <master_UserCustomerAuthority, CurrentUserCustomerAuthority>(); muc.ForMember(p => p.StructureID, opt => opt.MapFrom(s => s.StructureID)); muc.ForMember(p => p.UserButtonAuthority, opt => opt.MapFrom(s => s.UserButtonAuthority)); var muu = cfg.CreateMap <master_UserInfo, UserLoginDTO>(); muu.ForMember(p => p.CurrentUserCustomerAuthorityList, opt => opt.MapFrom(s => s.master_UserCustomerAuthority.ToList())); muu.ForMember(p => p.CurrentRoleIDList, opt => opt.MapFrom(s => s.master_RoleInfo.Select(m => m.RoleID).ToList())); muu.ForMember(p => p.DistributorIDlist, opt => opt.MapFrom(s => s.master_DistributorInfo.Select(sw => sw.DistributorID).ToList())); muu.ForMember(p => p.DistributorNamelist, opt => opt.MapFrom(s => s.master_DistributorInfo.Select(sw => sw.DistributorName).ToList())); muu.ForMember(p => p.Distributorstr, opt => opt.MapFrom(s => string.Join(",", s.master_DistributorInfo.Select(m => m.DistributorName).ToList()))); cfg.CreateMap <master_AreaInfo, AreaResultDTO>(); cfg.CreateMap <AreaOperateDTO, master_AreaInfo>(); var qyxz = cfg.CreateMap <master_AreaRegionInfo, AreaResultDTO>(); qyxz.ForMember(p => p.AreaName, opt => opt.MapFrom(s => s.dict_RegionInfo.RegionName)); qyxz.ForMember(p => p.AreaID, opt => opt.MapFrom(s => s.AreaRegionID)); var apptodto = cfg.CreateMap <master_CustomerApplyInfo, CustomerAuditResultDTO>(); apptodto.ForMember(p => p.DistributorName, opt => opt.MapFrom(s => s.master_DistributorInfo.DistributorName)); cfg.CreateMap <MessageOperateDTO, master_MessageStat>(); var msetodto = cfg.CreateMap <master_MessageStat, MessageResultDTO>(); msetodto.ForMember(p => p.DepartName, opt => opt.MapFrom(s => s.master_UserInfo.master_DepartmentInfo.DepartName)); msetodto.ForMember(p => p.FullName, opt => opt.MapFrom(s => s.master_UserInfo.FullName)); msetodto.ForMember(p => p.PhoneNumber, opt => opt.MapFrom(s => s.master_UserInfo.PhoneNumber)); msetodto.ForMember(p => p.UserType, opt => opt.MapFrom(s => s.master_UserInfo.UserType)); msetodto.ForMember(p => p.UserDistributorstr, opt => opt.MapFrom(s => string.Join(",", s.master_UserInfo.master_DistributorInfo.Select(m => m.DistributorName).ToList()))); cfg.CreateMap <UsersStatOperateDTO, master_UsersStat>(); var ustatodto = cfg.CreateMap <master_UsersStat, UsersStatResultDTO>(); ustatodto.ForMember(p => p.DepartName, opt => opt.MapFrom(s => s.master_UserInfo.master_DepartmentInfo.DepartName)); ustatodto.ForMember(p => p.FullName, opt => opt.MapFrom(s => s.master_UserInfo.FullName)); ustatodto.ForMember(p => p.PhoneNumber, opt => opt.MapFrom(s => s.master_UserInfo.PhoneNumber)); ustatodto.ForMember(p => p.UserType, opt => opt.MapFrom(s => s.master_UserInfo.UserType)); ustatodto.ForMember(p => p.UserDistributorstr, opt => opt.MapFrom(s => string.Join(",", s.master_UserInfo.master_DistributorInfo.Select(m => m.DistributorName).ToList()))); var distoannau = cfg.CreateMap <master_DistributorInfo, DistributorAnnounceAuthorityResultDTO>(); distoannau.ForMember(p => p.DistributorServiceTypeName, opt => opt.MapFrom(s => s.master_DistributorServiceType.DistributorServiceTypeName)); distoannau.ForMember(p => p.DistributorTypeName, opt => opt.MapFrom(s => s.master_DistributorType.DistributorTypeName)); distoannau.ForMember(p => p.RegionName, opt => opt.MapFrom(s => s.dict_RegionInfo.RegionName)); distoannau.ForMember(p => p.ProductLineList, opt => opt.MapFrom(s => s.master_DistributorADInfo.Select(m => m.master_ProductLine).ToList())); cfg.CreateMap <DepartmentOperateDTO, master_DepartmentInfo>(); cfg.CreateMap <master_DepartmentInfo, DepartmentResultDTO>(); var ra = cfg.CreateMap <master_RoleInfo, RoleResultDTO>(); ra.ForMember(p => p.RoleAuthority, opt => opt.MapFrom(s => s.master_RoleAuthority)); cfg.CreateMap <RoleOperateDTO, master_RoleInfo>(); var raaut = cfg.CreateMap <master_RoleAuthority, RoleAuthorityDTO>(); raaut.ForMember(p => p.StructureName, opt => opt.MapFrom(s => s.dict_Structure.StructureName)); cfg.CreateMap <RateOperateDTO, master_RateInfo>(); cfg.CreateMap <master_RateInfo, RateResultDTO>(); cfg.CreateMap <AccountDateOperateDTO, master_AccountDateInfo>(); cfg.CreateMap <master_AccountDateInfo, AccountDateResultDTO>(); cfg.CreateMap <master_PaymentInfo, PaymentResultDTO>(); cfg.CreateMap <PaymentOperateDTO, master_PaymentInfo>(); cfg.CreateMap <RegionOperateDTO, dict_RegionInfo>(); cfg.CreateMap <dict_RegionInfo, RegionResultDTO>(); cfg.CreateMap <dict_Structure, StructureDTO>(); cfg.CreateMap <dict_ButtonInfo, ButtonDTO>(); cfg.CreateMap <common_LogInfo, LogDTO>(); cfg.CreateMap <UserOperate, master_UserInfo>(); var userinfo = cfg.CreateMap <master_UserInfo, UserResultDTO>(); userinfo.ForMember(p => p.DepartName, opt => opt.MapFrom(s => s.master_DepartmentInfo.DepartName)); userinfo.ForMember(p => p.UserAuthority, opt => opt.MapFrom(s => s.master_UserCustomerAuthority)); userinfo.ForMember(p => p.UserRolelist, opt => opt.MapFrom(s => s.master_RoleInfo.Select(rs => rs.RoleID))); userinfo.ForMember(p => p.UserRoleNamelist, opt => opt.MapFrom(s => s.master_RoleInfo.Select(rs => rs.RoleName))); userinfo.ForMember(p => p.UserDistributorid, opt => opt.MapFrom(s => s.master_DistributorInfo.Select(ds => ds.DistributorID))); userinfo.ForMember(p => p.UserDistributorNamelist, opt => opt.MapFrom(s => s.master_DistributorInfo.Select(ds => ds.DistributorName))); var user = cfg.CreateMap <master_UserCustomerAuthority, StructureDTO>(); user.ForMember(p => p.BelongButton, opt => opt.MapFrom(s => s.UserButtonAuthority)); user.ForMember(p => p.StructureName, opt => opt.MapFrom(s => s.dict_Structure.StructureName)); cfg.CreateMap <master_TransportInfo, TransportResultDTO>(); cfg.CreateMap <TransportOperateDTO, master_TransportInfo>(); cfg.CreateMap <master_ProductType, ProductTypeResultDTO>(); cfg.CreateMap <ProductTypeOperateDTO, master_ProductType>(); cfg.CreateMap <master_InstrumentType, InstrumentTypeResultDTO>(); cfg.CreateMap <InstrumentTypeOperateDTO, master_InstrumentType>(); var ctore = cfg.CreateMap <master_CustomerInfo, CustomerResultDTO>(); ctore.ForMember(p => p.Auditor, opt => opt.MapFrom(s => _OBJ.master_CustomerApplyInfo.AsNoTracking().Where(p => p.CustomerApplyID == s.CustomerID).Select(m => m.Auditor).FirstOrDefault())); ctore.ForMember(p => p.DistributorName, opt => opt.MapFrom(s => s.master_DistributorInfo.DistributorName)); cfg.CreateMap <CustomerOperateDTO, master_CustomerInfo>(); cfg.CreateMap <DistributorOperateDTO, master_DistributorInfo>(); var dist = cfg.CreateMap <master_DistributorInfo, DistributorResultDTO>(); dist.ForMember(p => p.DistributorServiceTypeName, opt => opt.MapFrom(s => s.master_DistributorServiceType.DistributorServiceTypeName)); dist.ForMember(p => p.DistributorTypeName, opt => opt.MapFrom(s => s.master_DistributorType.DistributorTypeName)); dist.ForMember(p => p.RegionName, opt => opt.MapFrom(s => s.dict_RegionInfo.RegionName)); cfg.CreateMap <master_DistributorType, DistributorTypeResultDTO>(); cfg.CreateMap <DistributorTypeOperateDTO, master_DistributorType>(); cfg.CreateMap <AttachFileOperateDTO, common_AttachFileInfo>(); cfg.CreateMap <common_AttachFileInfo, AttachFileResultDTO>(); cfg.CreateMap <master_DistributorServiceType, DistributorServiceTypeResultDTO>(); cfg.CreateMap <DistributorServiceTypeOperateDTO, master_DistributorServiceType>(); cfg.CreateMap <FeedbackOperateDTO, master_FeedbackStat>(); var feedtore = cfg.CreateMap <master_FeedbackStat, FeedbackResultDTO>(); feedtore.ForMember(p => p.DepartName, opt => opt.MapFrom(s => s.master_UserInfo.master_DepartmentInfo.DepartName)); feedtore.ForMember(p => p.FullName, opt => opt.MapFrom(s => s.master_UserInfo.FullName)); feedtore.ForMember(p => p.PhoneNumber, opt => opt.MapFrom(s => s.master_UserInfo.PhoneNumber)); feedtore.ForMember(p => p.Email, opt => opt.MapFrom(s => s.master_UserInfo.Email)); feedtore.ForMember(p => p.UserType, opt => opt.MapFrom(s => s.master_UserInfo.UserType)); feedtore.ForMember(p => p.UserDistributorstr, opt => opt.MapFrom(s => string.Join(",", s.master_UserInfo.master_DistributorInfo.Select(m => m.DistributorName).ToList()))); feedtore.ForMember(p => p.AttachFile, opt => opt.MapFrom(s => _OBJ.common_AttachFileInfo.Where(p => p.BelongModule == 1 && p.BelongModulePrimaryKey == (s.FeedbackStatID + "")).FirstOrDefault())); //产品线 var proline = cfg.CreateMap <master_ProductLine, ProductLineResultDTO>(); proline.ForMember(p => p.DepartName, opt => opt.MapFrom(s => s.master_DepartmentInfo.DepartName)); cfg.CreateMap <ProductLineOperateDTO, master_ProductLine>(); //产品小类 var prosmatype = cfg.CreateMap <master_ProductSmallType, ProductSmallTypeResultDTO>(); prosmatype.ForMember(p => p.ProductLineName, opt => opt.MapFrom(s => s.master_ProductLine.ProductLineName)); cfg.CreateMap <ProductSmallTypeOperateDTO, master_ProductSmallType>(); //产品型号 var ss = cfg.CreateMap <master_ProductModel, ProductModelResultDTO>(); ss.ForMember(p => p.ProductLineName, opt => opt.MapFrom(s => s.master_ProductLine.ProductLineName)); cfg.CreateMap <ProductModelOperateDTO, master_ProductModel>(); //产品清单 var promain = cfg.CreateMap <master_ProductInfo, ProductInfoResultDTO>(); promain.ForMember(p => p.ProductLineName, opt => opt.MapFrom(s => s.master_ProductLine.ProductLineName)); promain.ForMember(p => p.ProductTypeName, opt => opt.MapFrom(s => s.master_ProductType.ProductTypeName)); promain.ForMember(p => p.ProductSmallTypeName, opt => opt.MapFrom(s => s.master_ProductSmallType.ProductSmallTypeName)); cfg.CreateMap <ProductInfoOperateDTO, master_ProductInfo>(); //产品价格 var proprice = cfg.CreateMap <master_ProductPriceInfo, ProductPriceInfoResultDTO>(); proprice.ForMember(p => p.Product, opt => opt.MapFrom(s => s.master_ProductInfo)); cfg.CreateMap <ProductPriceInfoOperateDTO, master_ProductPriceInfo>(); //OKC var okc = cfg.CreateMap <master_OKCInfo, OKCPriceInfoResultDTO>(); //okc.ForMember(p => p.OKCProductList, opt => opt.MapFrom(s => s.master_ProductOKCPriceInfo)); //okc.ForMember(p => p.OKCDistributorList, opt => opt.MapFrom(s => s.master_DistributorOKCInfo)); //OKC产品特价 var okcpro = cfg.CreateMap <master_ProductOKCPriceInfo, OKCProductResult>(); okcpro.ForMember(p => p.ArtNo, opt => opt.MapFrom(s => s.master_ProductInfo.ArtNo)); okcpro.ForMember(p => p.ProductName, opt => opt.MapFrom(s => s.master_ProductInfo.ProductName)); okcpro.ForMember(p => p.ProductLineName, opt => opt.MapFrom(s => s.master_ProductInfo.master_ProductLine.ProductLineName)); //OKC经销商及最终客户 var okcdepcut = cfg.CreateMap <master_DistributorOKCInfo, OKCDistributorResult>(); okcdepcut.ForMember(p => p.DistributorName, opt => opt.MapFrom(s => s.master_DistributorInfo.DistributorName)); okcdepcut.ForMember(p => p.CustomerName, opt => opt.MapFrom(s => s.master_CustomerInfo.CustomerName)); cfg.CreateMap <OKCPriceInfoOperateDTO, master_OKCInfo>(); cfg.CreateMap <OKCProductOperate, master_ProductOKCPriceInfo>(); cfg.CreateMap <OKCDistributorOperate, master_DistributorOKCInfo>(); //经销商价格授权 var disokc = cfg.CreateMap <master_DistributorOKCInfo, DistributorOKCProduct>(); disokc.ForMember(p => p.OKCNO, opt => opt.MapFrom(s => s.master_OKCInfo.OKCNO)); disokc.ForMember(p => p.OKCStart, opt => opt.MapFrom(s => s.master_OKCInfo.OKCStart)); disokc.ForMember(p => p.OKCEnd, opt => opt.MapFrom(s => s.master_OKCInfo.OKCEnd)); //经销商授权 var disaut = cfg.CreateMap <master_DistributorInfo, DistributorAuthorityResultDTO>(); //disaut.ForMember(p => p.Paylist, opt => opt.MapFrom(s => s.master_DistributorPayInfo)); //disaut.ForMember(p => p.ProductLineRegion, opt => opt.MapFrom(s => s.master_DistributorProductLineInfo)); //disaut.ForMember(p => p.Transportlist, opt => opt.MapFrom(s => s.master_DistributorTransport)); var dispay = cfg.CreateMap <master_DistributorPayInfo, DistributorPaymentResultDTO>(); dispay.ForMember(p => p.PayName, opt => opt.MapFrom(s => s.master_PaymentInfo.PayName)); var distra = cfg.CreateMap <master_DistributorTransport, DistributorTransportResultDTO>(); distra.ForMember(p => p.TransportName, opt => opt.MapFrom(s => s.master_TransportInfo.TransportName)); var disproline = cfg.CreateMap <master_DistributorProductLineInfo, DistributorProductLineResultDTO>(); disproline.ForMember(p => p.ProductLineName, opt => opt.MapFrom(s => s.master_ProductLine.ProductLineName)); disproline.ForMember(p => p.DepartName, opt => opt.MapFrom(s => s.master_ProductLine.master_DepartmentInfo.DepartName)); //disproline.ForMember(p => p.Region, opt => opt.MapFrom(s => s.master_DistributorRegionInfo)); var disprolineregion = cfg.CreateMap <master_DistributorRegionInfo, DistributorRegionResultDTO>(); disprolineregion.ForMember(p => p.RegionName, opt => opt.MapFrom(s => _OBJ.dict_RegionInfo.AsNoTracking().Where(p => p.RegionID == s.RegionID).Select(m => m.RegionName).FirstOrDefault())); disprolineregion.ForMember(p => p.SmallAreaName, opt => opt.MapFrom(s => _OBJ.master_AreaInfo.AsNoTracking().Where(p => p.AreaID == s.DistrictID).Select(m => m.AreaName).FirstOrDefault())); disprolineregion.ForMember(p => p.LargeAreaName, opt => opt.MapFrom(s => _OBJ.master_AreaInfo.AsNoTracking().Where(p => p.AreaID == s.AreaID).Select(m => m.AreaName).FirstOrDefault())); disprolineregion.ForMember(p => p.DepartName, opt => opt.MapFrom(s => _OBJ.master_DepartmentInfo.AsNoTracking().Where(p => p.DepartID == s.DepartID).Select(m => m.DepartName).FirstOrDefault())); //日志 var log = cfg.CreateMap <common_LogInfo, LogDTO>(); //提醒 var Warning = cfg.CreateMap <common_WarningInfo, WarningDTO>(); cfg.CreateMap <WarningDTO, common_WarningInfo>(); }); } return(_OBJ); }