Snailsoft.CRM.DB/CRM/DB/ActrualizeDB.cs

(开头部分) 5KB

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

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

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

        public bool Add(ActrualizeDT detail)
        {
            int affected = 0;
            string sql = string.Concat(new object[] { 
                "INSERT INTO actrualize (actionID,contactID,actrDesc,personID,actrualizeMoney,moneyType,changeRate,actrualTime,actrualMemo,delFlag) VALUES (", detail.actionID, ",", detail.contactID, ",'", StringUtils.ToSQL(detail.actrDesc), "',", detail.personID, ",", detail.actrualizeMoney, ",", detail.moneyType, ",", detail.changeRate, ",", detail.actrualTime, 
                ",'", StringUtils.ToSQL(detail.actrualMemo), "',", detail.delFlag, ")"
             });
            try
            {
                affected = base.ExecuteForInt(sql);
            }
            catch
            {
            }
            return (affected == 1);
        }

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

        public bool Disuse(int aID)
        {
            int affected = 0;
            string sql = "UPDATE actrualize SET delFlag=1 Where actionID=" + aID;
            try
            {
                affected = base.ExecuteForInt(sql);
            }
            catch
            {
            }
            return (affected == 1);
        }

        public ActrualizeDT GetActrualize(int aID)
后面还有 96 行代码,购买后查看完整代码

24 小时内免费解锁 3 个项目,之后 1 积分/个。 规则说明

AI 解读

登录后可用,每次 10 积分,解读结果公开显示在下面。

还没有人解读过这个文件。