Snailsoft.CRM.DB/CRM/DB/ServicetypeDB.cs

（开头部分） 2KB

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

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

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

        public bool Add(ServicetypeDT detail)
        {
            int affected = 0;
            string sql = string.Concat(new object[] { "INSERT INTO serviceType (serviceTypeID,serviceTypeName) VALUES (", detail.serviceTypeID, ",'", StringUtils.EscapeHtml(StringUtils.ToSQL(detail.serviceTypeName)), "')" });
            try
            {
                affected = base.ExecuteForInt(sql);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return (affected == 1);
        }

        public bool Delete(int serviceTypeID)
        {
            int affected = 0;
            string sql = "DELETE FROM serviceType where (serviceTypeID=" + serviceTypeID + ")";
            try
            {
                affected = base.ExecuteForInt(sql);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return (affected == 1);
        }

        public bool Edit(ServicetypeDT detail)
        {
            int affected = 0;
            string sql = string.Concat(new object[] { "UPDATE serviceType set serviceTypeID=", detail.serviceTypeID, ",serviceTypeName='", StringUtils.EscapeHtml(StringUtils.ToSQL(detail.serviceTypeName)), "' where (serviceTypeID=", detail.serviceTypeID, ")" });
            try
            {
                affected = base.ExecuteForInt(sql);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return (affected == 1);
        }

        public ServicetypeDT Get(int serviceTypeID)
后面还有 38 行代码，购买后查看完整代码

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

AI 解读

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

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