KeeSoft.DBHelper.Config 增删改查字符串

2019独角兽企业重金招聘Python工程师标准>>>

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace KeeSoft.DBHelper
{
    /// <summary>
    /// 数据库的基本配置文件
    /// </summary>
    public class Config
    {
        /// <summary>
        /// 数据库插入语句
        /// 参数分别为 Table Fields Values
        /// @Table
        /// @Fields
        /// @Values
        /// </summary>
        public static readonly string INSERT = "insert into {0}({1}) values({2}) select @@identity";

        /// <summary>
        /// 数据库更新语句
        /// 参数分别为 Table UpdateValue Where
        /// @Table
        /// @UpdateValue
        /// @Where
        /// </summary>
        public static readonly string UPDATE = "update {0} set {1} where 1=1 {2}";

        /// <summary>
        /// 数据库删除语句
        /// 参数分别为 Table Where
        /// @Table
        /// @Where
        /// </summary>
        public static readonly string DELETE = "delete from {0} where 1=1 {1}";

        /// <summary>
        /// 带Where条件的查询语句
        /// 参数分别为 Fields Table Where
        /// @Fields
        /// @Table
        /// @Where
        /// </summary>
        public static readonly string SELECT = "select {0} from {1} where 1=1 {2}";
    }
}

 

转载于:https://my.oschina.net/kee1986/blog/791890