/// <summary>
/// 取得更新数据的数据库命令
/// </summary>
/// <param name="item">实体数据</param>
/// <returns></returns>
protected override DapperCommand CreateUpdateCommand(Entity.VersionModule item)
{
string sql = $"UPDATE {TableName} SET WHERE VersionId=@VersionId And ModuleId=@ModuleId";
return(new DapperCommand()
{
CommandText = sql,
Parameters = item
});
}
/// <summary>
/// 取得插入数据的数据库命令
/// </summary>
/// <param name="item">实体数据</param>
/// <returns></returns>
protected override DapperCommand CreateInsertCommand(Entity.VersionModule item)
{
string sql = $"INSERT INTO {TableName} (VersionId,ModuleId) VALUES (@VersionId,@ModuleId)";
return(new DapperCommand()
{
CommandText = sql,
Parameters = item
});
}
/// <summary>
/// 取得删除数据的数据库命令
/// </summary>
/// <param name="item">实体实例</param>
/// <returns></returns>
protected override DapperCommand CreateDeleteCommand(Entity.VersionModule item)
{
string sql = $"DELETE FROM {TableName} WHERE VersionId=@VersionId And ModuleId=@ModuleId";
DynamicParameters dynamicParameters = new DynamicParameters();
dynamicParameters.Add("VersionId", item.VersionId);
dynamicParameters.Add("ModuleId", item.ModuleId);
return(new DapperCommand()
{
CommandText = sql,
Parameters = dynamicParameters
});
}