/// <summary>
/// 修改
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Modify(Models.ys_StaffTasks model)
{
SqlParameter[] Param = new SqlParameter[] {
new SqlParameter("@Id", model.Id),
new SqlParameter("@ParentId", model.ParentId),
new SqlParameter("@TaskName", model.TaskName),
new SqlParameter("@Description", model.Description),
new SqlParameter("@StaffId", model.StaffId),
new SqlParameter("@StaffName", model.StaffName),
new SqlParameter("@StartDate", model.StartDate),
new SqlParameter("@DueDate", model.DueDate),
new SqlParameter("@Priority", model.Priority),
new SqlParameter("@Progress", model.Progress),
new SqlParameter("@CreateTime", model.CreateTime),
new SqlParameter("@IsRemoved", model.IsRemoved)
};
// Models.SqlHelper.AddNewOperatorLog("修改用户信息", "ACL_User", "修改");
return(Models.SqlHelper.ExecuteNoQuery(@"UPDATE [RightingSys].[dbo].[ys_StaffTasks]
SET [ParentId] = @ParentId
,[TaskName] = @TaskName
,[Description] = @Description
,[StaffId] = @StaffId
,[StaffName] = @StaffName
,[StartDate] = @StartDate
,[DueDate] = @DueDate
,[Priority] = @Priority
,[progress] = @progress
,[CreateTime] = @CreateTime
,[IsRemoved] = @IsRemoved
WHERE [Id] = @Id", Param) > 0 ? true : false);
}
/// <summary>
/// 完成的任务加入删除线
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void OnNodeCellStyle(object sender, GetCustomNodeCellStyleEventArgs e)
{
Models.ys_StaffTasks task = treeList1.GetRow(e.Node.Id) as Models.ys_StaffTasks;
if (task == null || !task.IsCompleted)
{
return;
}
e.Appearance.FontStyleDelta = (FontStyle.Italic | FontStyle.Strikeout);
}
/// <summary>
/// 右键显示描述信息
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void OnMouseDown(object sender, MouseEventArgs e)
{
if (e.Button != MouseButtons.Left)
{
return;
}
var hitInfo = treeList1.CalcHitInfo(e.Location);
if (hitInfo.InRowCell && hitInfo.Column.FieldName == "IsDescription")
{
Models.ys_StaffTasks task = treeList1.GetRow(hitInfo.Node.Id) as Models.ys_StaffTasks;
if (task == null || string.IsNullOrEmpty(task.Description))
{
return;
}
ToolTipController.DefaultController.ShowHint(task.Description, ToolTipLocation.RightCenter);
}
}
/// <summary>
/// 新增
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddNew(Models.ys_StaffTasks model)
{
SqlParameter[] Param = new SqlParameter[] {
new SqlParameter("@Id", model.Id),
new SqlParameter("@ParentId", model.ParentId),
new SqlParameter("@TaskName", model.TaskName),
new SqlParameter("@Description", model.Description),
new SqlParameter("@StaffId", model.StaffId),
new SqlParameter("@StaffName", model.StaffName),
new SqlParameter("@StartDate", model.StartDate),
new SqlParameter("@DueDate", model.DueDate),
new SqlParameter("@Priority", model.Priority),
new SqlParameter("@Progress", model.Progress),
new SqlParameter("@CreateTime", model.CreateTime),
new SqlParameter("@IsRemoved", model.IsRemoved)
};
return(Models.SqlHelper.ExecuteNoQuery(@"INSERT INTO [RightingSys].[dbo].[ys_StaffTasks]
([Id]
,[ParentId]
,[TaskName]
,[Description]
,[StaffId]
,[StaffName]
,[StartDate]
,[DueDate]
,[Priority]
,[Progress]
,[CreateTime]
,[IsRemoved])
VALUES
(@Id
,@ParentId
,@TaskName
,@Description
,@StaffId
,@StaffName
,@StartDate
,@DueDate
,@Priority
,@Progress
,@CreateTime
,@IsRemoved)", Param) > 0 ? true : false);
}
/// <summary>
/// 修改
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Modify(Models.ys_StaffTasks model)
{
return(sev.Modify(model));
}
/// <summary>
/// 新增
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddNew(Models.ys_StaffTasks model)
{
return(sev.AddNew(model));
}
