public void ImportTeamUser(TramUserImportListModel data)
{
if (data == null)
{
throw new BusinessException("无数据");
}
string sqlStr = @" DELETE FROM dbo.Team;
DELETE A FROM dbo.RoleUser A INNER JOIN dbo.[User] B ON A.UserID = B.UserID WHERE B.UserType = 0;
DELETE FROM dbo.[User] WHERE UserType = 0;
DELETE FROM dbo.UserTeam;";
adonetWrapper.ExecuteSqlCommand(sqlStr);
string pwd = PublicFunc.GetConfigByKey_AppSettings("DefaultPWD");
DateTime now = DateTime.Now;
int studentRoleSysNo = int.Parse(PublicFunc.GetConfigByKey_AppSettings("StudentRoleSysNo"));
IEnumerable <IGrouping <string, TeamUserImportModel> > groupList = data.Lists.GroupBy(m => m.TeamName);
foreach (var group in groupList)
{
teamRepo.Insert(new Team {
TeamName = group.Key, InDate = now, InUser = data.User.UserID
});
foreach (TeamUserImportModel user in group.ToList())
{
userRepo.Insert(new User
{
UserID = user.UserID,
UserName = user.UserName,
Password = pwd,
Status = 1,
InUser = data.User.UserID,
InDate = now
});
userTeamRepo.Insert(new UserTeam
{
TeamName = user.TeamName,
UserID = user.UserID,
InDate = now,
InUser = data.User.UserID
});
roleUserRepo.Insert(new RoleUser()
{
InDate = now,
InUser = data.User.UserID,
Status = 1,
UserID = user.UserID,
RoleSysNo = studentRoleSysNo
});
}
}
}
