public void AddAbilityLevels(List <AbilityLevel> list)
{
if (list.Count == 0)
{
return;
}
var deleteIds = new List <int>();
var levelList = GetAbilityLevelList(list[0].TenantId);
foreach (var item in levelList)
{
var tmp = list.FirstOrDefault(p => p.LevelName == item.LevelName);
if (tmp != null)
{
item.OrderNum = tmp.OrderNum;
_dataAccess.UpdateEntity(item);
list.Remove(tmp);
}
else
{
deleteIds.Add(item.LevelId);
}
}
if (deleteIds.Count > 0)
{
_dataAccess.DeleteEntities <AbilityLevel>(string.Format(" LevelId in ({0})", deleteIds.GetString()));
}
if (list.Count > 0)
{
_dataAccess.AddEntities(list);
}
}
/// <summary>
/// 添加一组用户到指定角色
/// </summary>
/// <param name="userIds">用户Id</param>
/// <param name="roleId">角色Id</param>
public void AddUsersToRole(int[] userIds, int roleId)
{
var roleUsers = new List <Sys_AdminRole>(userIds.Length);
roleUsers.AddRange(userIds.Where(p => p > 0).Select(t1 => new Sys_AdminRole {
RoleId = roleId, AdminId = t1
}));
_dataAccess.AddEntities(roleUsers);
}
public int AddSurveyInfo(SurveyInfo userSurveyInfo)
{
_dataAccess.AddEntity(userSurveyInfo);
foreach (var user in userSurveyInfo.EvalUsers)
{
user.SurveyId = userSurveyInfo.SurveyId;
}
_dataAccess.AddEntities(userSurveyInfo.EvalUsers);
return(userSurveyInfo.SurveyId);
}
/// <summary>
/// 添加一组用户到指定角色
/// </summary>
/// <param name="userIds">用户Id</param>
/// <param name="roleId">角色Id</param>
public void AddUsersToRole(int[] userIds, int roleId)
{
var roleUsers = new List <DeptRoleUser>(userIds.Length);
roleUsers.AddRange(userIds.Where(p => p > 0).Select(t1 => new DeptRoleUser {
RoleId = roleId, UserId = t1
}));
DeleteRolesToUser(userIds);
_dataAccess.AddEntities(roleUsers);
}
/// <summary>
/// 保存用户的教育经历
/// </summary>
/// <param name="userEdusList"></param>
public void SaveUserEduList(List <SysUserEdu> userEdusList)
{
if (userEdusList.Count == 0)
{
}
string deleteWhere = "UserId=" + userEdusList[0].UserId;
_dataAccess.DeleteEntities <SysUserEdu>(deleteWhere);
_dataAccess.AddEntities(userEdusList);
}
public int AddResourceOpenUsers(List <KL_KnowledgeOpenUser> openUsers)
{
if (openUsers.Count > 0)
{
var sqlwhere = "ResourceId=" + openUsers[0].ResourceId;
_dataAccess.DeleteEntities <KL_KnowledgeOpenUser>(sqlwhere);
return(_dataAccess.AddEntities(openUsers));
}
return(0);
}
public int AddReport(Cde_Report report)
{
int reportId = _dataAccess.AddEntity(report);
foreach (var index in report.IndexList)
{
index.ReportId = reportId;
}
_dataAccess.AddEntities(report.IndexList);
return(reportId);
}
public int SaveSubscription(int userId, IEnumerable <KL_CategorySubscription> subscriptions)
{
foreach (KL_CategorySubscription subscription in subscriptions)
{
var sort = AllSorts.FirstOrDefault(p => p.SortId == subscription.CategoryId);
if (sort != null)
{
subscription.FirstCategory = sort.ParentId;
}
}
return(_dataAccess.AddEntities(subscriptions.ToArray()));
}
public int AddQuestion(Models.Cde.Cde_IndexQuestion question)
{
_dataAccess.AddEntity(question);
if (question.Answers.Count > 0)
{
foreach (var answer in question.Answers)
{
answer.QuestionId = question.QuestionId;
}
_dataAccess.AddEntities(question.Answers);
}
return(question.QuestionId);
}
/// <summary>
/// 分享内部资源
/// </summary>
/// <param name="tenantId"></param>
/// <param name="userId"></param>
/// <param name="objectId"></param>
/// <param name="objectType">
/// <para>0：课程</para>
/// <para>1：知识</para>
/// <para>2：计划</para>
/// <para>3：讲师</para>
/// <para>10：外部资源</para>
/// </param>
/// <param name="sourceId">来源ID</param>
/// <param name="shareObject"></param>
/// <param name="recommend"></param>
/// <returns></returns>
public static int AddStationiShare(int tenantId, int userId, int objectId, int objectType, int sourceId, List <ShareTarget> shareObject, string recommend)
{
var model = new IntShared
{
TenantId = tenantId,
ObjectId = objectId,
ObjectType = objectType,
SourceId = sourceId,
ShareTime = DateTime.Now,
UserId = userId,
IsDelete = 0,
Recommend = recommend,
ResourceName = "",
ResourceUrl = ""
};
model.ShareId = _dataAccess.AddEntity(model);
if (shareObject.Count > 0)
{
for (int i = 0; i < shareObject.Count; i++)
{
shareObject[i].ShareId = model.ShareId;
}
_dataAccess.AddEntities(shareObject);
}
return(model.ShareId);
}
/// <summary>
/// 发送站内信
/// </summary>
/// <param name="title">标题</param>
/// <param name="content">内容</param>
/// <param name="recUserId">收件人</param>
/// <param name="sendUserId">发件人</param>
/// <param name="tenantId"></param>
public void AddMessage(string title, string content, int[] recUserId, int sendUserId, int tenantId)
{
var messageContent = new SysUserMessageContent()
{
Title = title,
MessageContent = content,
CreateTime = DateTime.Now,
TenantId = tenantId
};
messageContent.MessageId = _dataAccess.AddEntity(messageContent);
var list = new List <SysUserMessage>();
for (int i = 0; i < recUserId.Length; i++)
{
if (recUserId[i] > 0)
{
list.Add(new SysUserMessage
{
MessageId = messageContent.MessageId,
SendStatus = 0,
RecStatus = 0,
SendUserId = sendUserId,
RecUserId = recUserId[i],
TenantId = tenantId
});
}
}
_dataAccess.AddEntities(list);
}
public void AddSurveyAnswers(int userSurveyId, int sendUserId, List <Cde_SurveyReplyAnswer> list)
{
var sqlwhere = "Cde_SurveyReplyAnswer.UserSurveyID=" + userSurveyId + " AND Cde_SurveyReplyAnswer.SendUserId=" + sendUserId;
_dataAccess.DeleteEntities <Cde_SurveyReplyAnswer>(sqlwhere);
_dataAccess.AddEntities(list);
}
public int SaveRatingEntryData(List <Ab_AbilityRating> list)
{
if (list.Count() > 0)
{
_dataAccess.DeleteEntities <Ab_AbilityRating>(" PromotionId=" + list[0].PromotionId + " and PostId=" +
list[0].PostId + " and UserId=" + list[0].UserId);
}
return(_dataAccess.AddEntities(list));
}
public int AddExampaper(Cde_SurveyExampaper exampaper)
{
_dataAccess.AddEntity(exampaper);
var questions = new List <Cde_SurveyQuestion>();
for (int index = 0; index < exampaper.Questions.Count; index++)
{
var question = exampaper.Questions[index];
questions.Add(new Cde_SurveyQuestion()
{
ExampaperID = exampaper.ExampaperID,
QuestionID = question.QuestionId,
ShowOrder = index
});
}
_dataAccess.AddEntities(questions);
return(exampaper.ExampaperID);
}
private int AddQuestions(IEnumerable <ResSurveyQuestion> questions)
{
var answers = new List <ResSurveyQuestionAnswer>();
foreach (var question in questions)
{
//question.ExampaperID = id;
question.UpdateTime = System.DateTime.Now;
//再保存问题表，确定问题的Id
_dataAccess.AddEntity(question);
foreach (var option in question.Options)
{
option.QuestionID = question.QuestionID;
answers.Add(option);
}
}
//最后批量保存选项
return(_dataAccess.AddEntities(answers));
}
/// <summary>
/// 添加租户权限
/// </summary>
/// <param name="userIds"></param>
/// <param name="roleIds"></param>
public void AddTenantPermission(int[] permissionIds, int tenantId)
{
DeleteTenantPermission(tenantId);
var addlist = permissionIds.Select(permissionId => new SysTenantPermission()
{
TenantId = tenantId, PermissionId = permissionId
}).ToList();
_dataAccess.AddEntities(addlist);
}
public int AddSurveySendUsers(List <Cde_SurveySendUsers> list)
{
if (list.Count == 0)
{
return(0);
}
var sqlwhere = "UserSurveyId=" + list[0].UserSurveyId;
_dataAccess.DeleteEntities <Cde_SurveySendUsers>(sqlwhere);
return(_dataAccess.AddEntities(list));
}
/// <summary>
/// 邀请他人加入小组
/// </summary>
/// <param name="groupId"></param>
/// <param name="userId"></param>
/// <returns></returns>
public bool InviteUserJoinGroup(int groupId, IEnumerable <int> userId)
{
if (userId.Count() == 0)
{
return(false);
}
var list = new List <GroupMember>();
foreach (var item in userId)
{
list.Add(new GroupMember
{
GroupId = groupId,
InviteTime = DateTime.Now,
JoinTime = null,
Status = 1,
UserId = item
});
}
return(_dataAccess.AddEntities(list) > 0);
}
/// <summary>
/// Saves the admin permissions.
/// </summary>
/// <returns>The admin permissions.</returns>
/// <param name="adminId">Admin identifier.</param>
/// <param name="permissionIds">Permission identifiers.</param>
public int SaveAdminPermissions(int adminId, int[] permissionIds)
{
var rrs = new List <Models.Oper.Sys_OperRolePermission>();
foreach (var item in permissionIds)
{
var rr = new Models.Oper.Sys_OperRolePermission();
rr.PermissionId = item;
rr.RoleId = adminId;
rrs.Add(rr);
}
return(_dataAccess.AddEntities(rrs));
}
public int AddSectionAdmins(IEnumerable <int> userIds, int sectionId)
{
var list = new List <SectionAdmin>();
foreach (var userId in userIds)
{
list.Add(new SectionAdmin()
{
IsMain = 1,
SectionId = sectionId,
UserId = userId
});
}
return(_dataAccess.AddEntities(list));
}
/// <summary>
/// 添加课程
/// </summary>
/// <param name="courses">用户Id</param>
/// <param name="deptId">角色Id</param>
public bool AddDeptCourse(Dictionary <int, decimal> courses, int deptId)
{
var deptCourses = new List <SysDeptToCourse>();
foreach (var o in courses)
{
if (o.Key > 0)
{
SysDeptToCourse model = new SysDeptToCourse();
model.CourseId = o.Key;
model.DeptId = deptId;
model.Sell = o.Value;
deptCourses.Add(model);
}
}
_dataAccess.DeleteEntities <SysDeptToCourse>(" Sys_DeptToCourse.DeptId=" + deptId);
return(_dataAccess.AddEntities(deptCourses) > 0);
}
/// <summary>
/// 添加课程
/// </summary>
/// <param name="course">课程实体</param>
/// <returns></returns>
public int AddCourse(ResCourse course)
{
course.LastUpdateTime = DateTime.Now;
int id = _dataAccess.AddEntity(course);
foreach (var exampaper in course.Exampapers)
{
exampaper.CourseId = id;
}
foreach (var file in course.BeforeLearnFiles)
{
file.CourseId = id;
}
foreach (var crowd in course.OpenCrowds)
{
crowd.CourseId = id;
}
_dataAccess.AddEntities(course.BeforeLearnFiles);
_dataAccess.AddEntities(course.Exampapers);
_dataAccess.AddEntities(course.OpenCrowds);
BusinessCache.SystemCache.Instance.ClearCourses();
IndexCourse(id);
return(id);
}
public static void AddConfigs(List <Models.SysConfig> configs)
{
if (configs == null || configs.Count == 0)
{
return;
}
var names = "";
foreach (var sysConfig in configs)
{
names += "'" + sysConfig.ConfigName + "',";
var configKey = "SystemConfig:Tenant:" + configs.First().TenantId + ":name:" + sysConfig.ConfigName;
CacheHelper.CacheService.Remove(configKey);
}
if (names.EndsWith(","))
{
names = names.TrimEnd(',');
}
var sqlwhere = "Sys_Config.ConfigName IN (" + names + ") AND Sys_Config.TenantId=" + configs.First().TenantId;
DataAccess.DeleteEntities <Models.SysConfig>(sqlwhere);
DataAccess.AddEntities(configs);
}
/// <summary>
/// 添加成员到学习班
/// </summary>
/// <param name="classId"></param>
/// <param name="userIds"></param>
public void AddStudentsToClass(int classId, params int[] userIds)
{
if (userIds == null || userIds.Length == 0)
{
return;
}
//var deleteWhere = "Len_Students.ClassId=" + classId;// +" AND Len_Students.UserId IN (" + userIds.GetString() + ")";
//_dataAccess.DeleteEntities<LenStudents>(deleteWhere);
var students = new List <LenStudents>();
foreach (var userId in userIds)
{
var student = new LenStudents
{
ClassId = classId,
UserId = userId,
IsCreater = false,
IsDeleted = false,
JoinTime = DateTime.Now
};
students.Add(student);
}
_dataAccess.AddEntities(students);
}
/// <summary>
///
/// </summary>
/// <param name="posts"></param>
public void AddPosts(List <SysPost> posts)
{
_dataAccess.AddEntities(posts);
}
public bool AddCourse(List <LenLearnPlanCourse> addCourses)
{
_dataAccess.AddEntities(addCourses);
return(true);
}
/// <summary>
/// 添加学习卡关联课程
/// </summary>
/// <param name="courses"></param>
public void LinkCardCourse(List <ResCardCourse> courses)
{
_dataAccess.AddEntities(courses);
}
/// <summary>
/// 批量保存考勤
/// </summary>
/// <param name="list"></param>
/// <returns></returns>
public int AddUserAttendS(List <Tr_TrainUserAttend> list)
{
return(_dataAccess.AddEntities(list));
}
/// <summary>
///
/// </summary>
/// <param name="templateList"></param>
/// <returns></returns>
public int AddTemplates(List <SysReasonTemplate> templateList)
{
return(_dataAccess.AddEntities(templateList));
}
/// <summary>
/// 批量新增
/// </summary>
/// <param name="list"></param>
/// <returns></returns>
public int SaveSortAndResource(List <ResCourseWareTreeResource> list)
{
return(_dataAccess.AddEntities(list));
}