DotNet.WebApplication/Core/WorkFlow/Task/TaskManager.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

//--------------------------------------------------------------------
// All Rights Reserved , Copyright (C) 2013 , Hairihan TECH, Ltd.
//--------------------------------------------------------------------

using System;
using System.Collections.Generic;
using System.Data;

namespace DotNet.Business
{
    using DotNet.Utilities;

    /// <summary>
    /// TaskManager
    /// 工作任务
    /// 
    /// 修改纪录
    /// 
    /// 2012-05-21 版本：1.0 JiRiGaLa 创建主键。
    /// 
    /// 版本：1.0
    /// 
    /// <author>
    /// <name>JiRiGaLa</name>
    /// <date>2012-05-21</date>
    /// </author>
    /// </summary>
    public partial class TaskManager : BaseManager, IBaseManager
    {
        /// <summary>
        /// 获得延迟的任务
        /// </summary>
        /// <returns>数据表</returns>
        public DataTable GetDelayWork(int workYear, int workMonth, int workWeek)
        {
            // 先获得上一周
            this.GetUserLastWeek(ref workYear, ref workMonth, ref workWeek);
            // 然后再列获取上周未完成的任务
            string commandText = @"SELECT *
                                      FROM Task
                                     WHERE UserId = '{0}' 
                                        AND WorkStatus = '进行中'
                                        AND DeletionStateCode = 0 
                                        AND WorkYear = {1}
                                        AND WorkMonth = {2}
                                        AND WorkWeek = {3} 
                                        AND (Id NOT IN (SELECT ParentId FROM Task WHERE UserId = '{0}' AND DeletionStateCode = 0)) ";
            commandText = string.Format(commandText, this.UserInfo.Id, workYear, workMonth, workWeek);
            DataTable returnValue = this.Fill(commandText);
            returnValue.TableName = TaskWeekEntity.TableName;
            return returnValue;
        }

        /// <summary>
        /// 获取上一周（有填报工作内容的）
        /// </summary>
        /// <param name="year">年</param>
        /// <param name="month">月</param>
        /// <param name="week">周</param>
        /// <returns>主键</returns>