/// <summary>
/// 插入操作，返回主键ID
/// </summary>
/// <param name="sql"></param>
/// <param name="obj"></param>
protected void ExecuteInsert(string sql, ScmDto obj)
{
sql += ";SELECT last_insert_rowid()";
obj.id = Connection.QueryFirst <long>(sql, obj);
//var p = new DynamicParameters();
//p.Add("@id", dbType: DbType.Int32, direction: ParameterDirection.Output);
//var i = Connection.Execute(sql, p);
//SQLiteCommand d;
//return p.Get<long>("@id");
}
/// <summary>
/// 更新操作
/// </summary>
/// <param name="sql"></param>
/// <param name="obj"></param>
protected void ExecuteUpdate(string sql, ScmDto obj)
{
Connection.Execute(sql, obj);
}
protected IEnumerable <K> Query <K>(string sql, ScmDto dto)
{
return(Connection.Query <K>(sql, dto));
}
