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