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);
}
