Snailsoft.CRM.DB/CRM/DB/TaskDB.cs

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

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

namespace Snailsoft.CRM.DB
{
    using System;
    using Snailsoft.Common.Database;
    using Snailsoft.CRM.DB.Data;
    using Snailsoft.Utils;

    public class TaskDB : BaseDB
    {
        public TaskDB(DBOperate oper) : base(oper)
        {
        }

        public bool Add(TaskDT detail)
        {
            int affected = 0;
            string sql = string.Concat(new object[] { 
                "INSERT INTO task (taskID,personID,taskName,taskDesc,startTime,endTime,taskType,arrangeID,finish,audit,finishDesc) VALUES (", detail.taskID, ",", detail.personID, ",'", StringUtils.EscapeHtml(StringUtils.ToSQL(detail.taskName)), "','", StringUtils.EscapeHtml(StringUtils.ToSQL(detail.taskDesc)), "',", detail.startTime, ",", detail.endTime, ",", detail.taskType, ",", detail.arrangeID, 
                ",", detail.finish, ",", detail.audit, ",'", StringUtils.EscapeHtml(StringUtils.ToSQL(detail.finishDesc)), "')"
             });
            try
            {
                affected = base.ExecuteForInt(sql);
            }
            catch
            {
            }
            return (affected == 1);
        }

        public bool Delete(int taskID)
        {
            int affected = 0;
            string sql = "DELETE FROM task WHERE taskID=" + taskID;
            try
            {
                affected = base.ExecuteForInt(sql);
            }
            catch
            {
            }
            return (affected == 1);
        }

        public bool Edit(TaskDT detail)
        {
            int affected = 0;
            string sql = string.Concat(new object[] { 
                "UPDATE task set personID=", detail.personID, ",taskName='", StringUtils.EscapeHtml(StringUtils.ToSQL(detail.taskName)), "',taskDesc='", StringUtils.EscapeHtml(StringUtils.ToSQL(detail.taskDesc)), "',startTime=", detail.startTime, ",endTime=", detail.endTime, ",taskType=", detail.taskType, ",arrangeID=", detail.arrangeID, ",finish=", detail.finish, 
                ",audit=", detail.audit, ",finishDesc='", StringUtils.EscapeHtml(StringUtils.ToSQL(detail.finishDesc)), "' WHERE taskID=", detail.taskID
             });
            try
            {
                affected = base.ExecuteForInt(sql);
            }
            catch
            {
            }
            return (affected == 1);
        }