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}";
}
}