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