/// <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>
/// 拖拽 - 更改排序号
/// </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);
}
}
}
