/// <summary> /// 我的工作列表排序号改变 /// </summary> public bool WorkListSortManage(long userId, string ids, bool isTicket = true) { var swltDal = new sys_work_list_task_dal(); var oldTaskList = swltDal.GetMyWorkList(userId, isTicket); var newTaskList = swltDal.GetTaskListByTaskIds(userId, ids); var timeNow = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now); var idArr = ids.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); if (oldTaskList != null && newTaskList != null && oldTaskList.Count == newTaskList.Count && idArr.Count() == newTaskList.Count) { for (int i = 0; i < oldTaskList.Count; i++) { var thisWorkTask = newTaskList.FirstOrDefault(_ => _.task_id.ToString() == idArr[i]); if (thisWorkTask == null) { continue; } if (thisWorkTask.sort_order == oldTaskList[i].sort_order) { continue; } thisWorkTask.sort_order = oldTaskList[i].sort_order; thisWorkTask.update_time = timeNow; swltDal.Update(thisWorkTask); } } return(true); }
/// <summary> /// 移除我的工单/任务 列表 /// </summary> public bool DeleteWorkTicket(long userId, bool isTicket = true) { var swltDal = new sys_work_list_task_dal(); var mtTaskList = swltDal.GetMyWorkList(userId, isTicket); if (mtTaskList != null && mtTaskList.Count > 0) { mtTaskList.ForEach(_ => { swltDal.Delete(_); }); } return(true); }
public bool ChangeWorkTaskSort(long firstTaskId, long lastTaskId, long userId) { if (firstTaskId == lastTaskId) { return(false); } var swltDal = new sys_work_list_task_dal(); var firWorTask = swltDal.GetByResTaskId(userId, firstTaskId); var lasWorTask = swltDal.GetByResTaskId(userId, lastTaskId); if (firWorTask == null || lasWorTask == null) { return(false); } ChangeSort(firWorTask, lasWorTask, userId); return(true); }
/// <summary> /// 删除指定的工作列表中的数据 /// </summary> public bool DeleteSingWorkTicket(string ids, long userId) { if (!string.IsNullOrEmpty(ids)) { var idArr = ids.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); var swltDal = new sys_work_list_task_dal(); foreach (var thisId in idArr) { var thisWorkTask = swltDal.FindById(long.Parse(thisId)); if (thisWorkTask != null) { swltDal.Delete(thisWorkTask); } } } return(true); }
/// <summary> /// 添加到我的工作列表 /// </summary> public bool AddToWorkList(long taskId, long resId, long userId) { var swltDal = new sys_work_list_task_dal(); var singWorkTask = swltDal.GetByResTaskId(resId, taskId); var timeNow = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now); if (singWorkTask == null) { singWorkTask = new sys_work_list_task() { id = swltDal.GetNextIdCom(), resource_id = resId, task_id = taskId, create_time = timeNow, create_user_id = userId, update_time = timeNow, sort_order = swltDal.GetMaxSortOrder(userId) + 1, }; swltDal.Insert(singWorkTask); } return(true); }
/// <summary> /// 根据任务Id 和登录用户获取相关列表信息并删除 /// </summary> public bool DeleteSingWorkTicket(long taskId, long userId) { var swltDal = new sys_work_list_task_dal(); var thisWorkTask = swltDal.GetByResTaskId(userId, taskId); if (thisWorkTask != null) { swltDal.Delete(thisWorkTask); } var nextList = swltDal.GetTaskListBySort(userId, thisWorkTask.sort_order); var timeNow = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now); if (nextList != null && nextList.Count > 0) { nextList.ForEach(_ => { _.update_time = timeNow; _.sort_order = _.sort_order - 1; swltDal.Update(_); }); } return(true); }
/// <summary> /// 拖拽 - 更改排序号 /// </summary> public void ChangeSort(sys_work_list_task firWorTas, sys_work_list_task lasWorTask, long userId) { var swltDal = new sys_work_list_task_dal(); var timeNow = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now); if (firWorTas.sort_order > lasWorTask.sort_order) { var changeList = swltDal.FindListBySql($"SELECT * from sys_work_list_task where resource_id = {userId} and sort_order>={lasWorTask.sort_order} and sort_order<{firWorTas.sort_order}"); if (changeList != null && changeList.Count > 0) { changeList.ForEach(_ => { _.update_time = timeNow; _.sort_order = _.sort_order + 1; swltDal.Update(_); }); firWorTas.update_time = timeNow; firWorTas.sort_order = lasWorTask.sort_order; swltDal.Update(firWorTas); } } else { var changeList = swltDal.FindListBySql($"SELECT * from sys_work_list_task where resource_id = {userId} and sort_order>{firWorTas.sort_order} and sort_order<={lasWorTask.sort_order}"); if (changeList != null && changeList.Count > 0) { changeList.ForEach(_ => { _.update_time = timeNow; _.sort_order = _.sort_order - 1; swltDal.Update(_); }); firWorTas.update_time = timeNow; firWorTas.sort_order = lasWorTask.sort_order; swltDal.Update(firWorTas); } } }