public ActionResult CancellBount(int courseId, int userIds)
{
var result = new resultData();
var courseDate = courseInfoService.GetCourseInfoById(new EntityDto <long>()
{
Id = courseId
}); //课程数据
var userData = userAccountService.GetUserAccountById(new EntityDto <long>()
{
Id = userIds
}); //用户数据
if (courseDate != null && userData != null)
{
var boundData = courseBoundService.GetCourseBoundByUserIdOrCourseId(userData.SysNO, Convert.ToInt32(courseDate.Id));//绑定数据
if (boundData != null)
{
courseBoundService.DeleteCourseBoundPersonnel(new EntityDto <long>()
{
Id = Convert.ToInt32(boundData.Id)
});
result.msg = "";
}
else
{
result.msg = userData.DisplayName;
}
result.status = "0";
}
return(Content(Serialize(result)));
}
public ActionResult RemoveUser(int cid, int uid)
{
var sqlstr = "update px_class_user set removed=1 where class_id=@class_id and user_id=@user_id";
var i = sqlExecuter.Execute(sqlstr, new MySqlParameter("@class_id", cid), new MySqlParameter("@user_id", uid));
var edit = classesinfoService.GetClassesInfoForEdit(new NullableIdDto <long> {
Id = cid
}).ClassesInfo;
var count = classuserService.GetAll().Where(t => t.ClassId == cid).Count();
edit.MemberCount = count;
//更新班级成员数量
classesinfoService.UpdateClassesInfoAsync(edit);
//判断课程班级表有当前班级没用如果有要更新课程人员表保持一致和手机签到一样
var dto = cbtservic.GetAll().FirstOrDefault(t => t.BusinessId == cid && t.type == 2);
if (dto != null && dto.type != 4)
{
cpservic.DeleteCourseBoundPersonnel(new EntityDto <long> {
Id = dto.Id
});
}
return(Success());
}
public ActionResult Remove(int Id)
{
var boundData = cdjService.GetClassDepJobById(new EntityDto <long> {
Id = Id
}); //绑定的数据
if (boundData != null)
{
cdjService.DeleteClassDepJob(new EntityDto <long>()
{
Id = Convert.ToInt32(boundData.Id)
});
//只能移除部门和岗位不重复的人
var userids = UnRepeatUser(boundData);
foreach (var item in userids)
{
var sqlstr = "update px_class_user set removed=1 where class_id=@class_id and user_id=@user_id";
var i = sqlExecuter.Execute(sqlstr, new MySqlParameter("@class_id", boundData.ClassId), new MySqlParameter("@user_id", item));
//判断课程班级表有当前班级没用如果有要更新课程人员表保持一致和手机签到一样
var dto = cbtservic.GetAll().FirstOrDefault(t => t.BusinessId == boundData.ClassId && t.type == 2);
if (dto != null && dto.type != 4)
{
cpservic.DeleteCourseBoundPersonnel(new EntityDto <long> {
Id = dto.Id
});
}
}
//更新班级成员数量
var edit = classService.GetClassesInfoForEdit(new NullableIdDto <long> {
Id = boundData.ClassId
}).ClassesInfo;
var count = classUserService.GetAll().Where(t => t.ClassId == boundData.ClassId).Count();
edit.MemberCount = count;
classService.UpdateClassesInfoAsync(edit);
}
return(Success());
}
