コード例 #1
0
        public ResTaskBase AddTask([FromBody] TASKBASE task)
        {
            ResTaskBase retValue = new ResTaskBase();

            using (var db = DbContext.GetInstance("T_TASK"))
            {
                try
                {
                    //规范日期格式
                    db.SerializerDateFormat = "yyyy-mm-dd";
                    //设置时间
                    task.createTime   = DateTime.Now;
                    task.lastEditTime = DateTime.Now;
                    //设置最近编辑人信息
                    task.lastEditUserCode = task.createUserCode;
                    task.lastEditUserName = task.createUserName;

                    var res = db.Insert(task);
                    retValue.SuccessDefalut("添加任务成功", 1);
                    LogWirter.Record(LogType.Personal, OpType.Add, task.taskTitle + "]", "创建任务 [", Convert.ToInt32(res), task.createUserCode, task.createUserName);
                }
                catch (Exception ex)
                {
                    retValue.FailDefalut(ex);
                }
            }
            return(retValue);
        }
コード例 #2
0
        public ResTaskBase UpdateTask([FromBody] ReqTaskBase task)
        {
            ResTaskBase retValue = new ResTaskBase();

            using (var db = DbContext.GetInstance("T_TASK"))
            {
                try
                {
                    bool isIDExist = db.Queryable <TASKBASE>()
                                     .Any(s => s.ID == task.ID);
                    if (isIDExist)
                    {
                        // 设置禁止更新列
                        db.AddDisableUpdateColumns("create_time");

                        //规范日期格式
                        db.SerializerDateFormat = "yyyy-mm-dd";

                        //设置时间
                        task.lastEditTime = DateTime.Now;

                        //设置最近编辑人
                        task.lastEditUserCode = task.createUserCode;
                        task.lastEditUserName = task.createUserName;

                        var taskModel = new TASKBASE();

                        //只更新需要更新的部分
                        db.Update <TASKBASE>(
                            new
                        {
                            taskTitle        = task.taskTitle,
                            endTime          = task.endTime,
                            taskDescription  = task.taskDescription,
                            isDone           = task.isDone,
                            lastEditUserName = task.lastEditUserName,
                            lastEditUserCode = task.lastEditUserCode
                        },
                            it => it.ID == task.ID
                            );

                        retValue.SuccessDefalut("编辑任务成功", 1);
                        LogWirter.Record(LogType.Personal, OpType.Update, task.taskTitle + "]", "编辑任务 [", task.ID, task.createUserCode, task.createUserName);
                    }
                    else
                    {
                        retValue.FailDefalut("不存在该任务ID");
                    }
                }
                catch (Exception ex)
                {
                    retValue.FailDefalut(ex);
                }
            }
            return(retValue);
        }