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(); } }
public static string RelDistributor(string id, TCDMS_FCPAEntities fcpa) { if (string.IsNullOrEmpty(id)) { return(string.Empty); } string[] ids = id.Split(','); return(string.Join(",", fcpa.fcpa_DistributorInfo.Where(p => ids.Contains(p.DistributorID)).Select(p => p.DistributorName))); }
public void Execute() { using (var fcpa = new TCDMS_FCPAEntities()) { fcpa.fcpa_CredentialInfo.ToList().ForEach(item => { StatusChange(item); }); fcpa.SaveChanges(); } }
public void Execute() { using (var fcpa = new TCDMS_FCPAEntities()) { var distributorGroup = fcpa.fcpa_CredentialInfo.Where(p => !string.IsNullOrEmpty(p.Certificate)).GroupBy(p => p.fcpa_DistributorInfo.DistributorID).Select(p => new { Count = p.Count(), DistributorID = p.Key }).ToList(); fcpa.fcpa_DistributorInfo.ToList().ForEach(item => { item.ValidNum = distributorGroup.Where(p => p.DistributorID == item.DistributorID).Select(p => p.Count).FirstOrDefault(); if (item.ValidNum.HasValue && item.ShouldNum.HasValue) { item.Rate = Math.Floor((item.ValidNum * 1.0 / item.ShouldNum * 100).Value); } }); fcpa.SaveChanges(); } }
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(); } }