/// <summary>
/// 删除多条Eterm脚本记录
/// </summary>
/// <param name="list"></param>
/// <returns></returns>
public int DeleteEtermScriptList(IList <EtermScript> list)
{
using (IDbConnection connection = DapperHelper <object> .OpenConnection())
{
const string sql = @"DELETE FROM dbo.EtermScripts WHERE id = @EtermScriptID";
return(connection.Execute(sql, list));
}
}
/// <summary>
/// 根据方法名，获得单条Eterm脚本信息记录
/// </summary>
/// <param name="methodName">方法名</param>
/// <returns></returns>
public EtermScript GetEtermScript(string methodName)
{
using (IDbConnection connection = DapperHelper <object> .OpenConnection())
{
const string sql =
@"SELECT TOP 1 id AS EtermScriptID, method AS MethodName, script AS ScriptContent, remark AS Remark, updatetime AS UpdateTime
FROM dbo.EtermScripts WITH(NOLOCK)
WHERE method = @MethodName";
return(connection.Query <EtermScript>(sql, new { MethodName = methodName }).SingleOrDefault <EtermScript>());
}
}
/// <summary>
/// 新增一条Eterm脚本记录
/// </summary>
/// <param name="item">要新增的Eterm脚本实例</param>
/// <returns>返回影响行数</returns>
public int AddEtermScript(EtermScript item)
{
if (item == null)
{
return(-1);
}
using (IDbConnection connection = DapperHelper <object> .OpenConnection())
{
const string sql =
@"INSERT INTO dbo.EtermScripts(method, script, remark, updatetime) VALUES(@MethodName, @ScriptContent, @Remark, GETDATE())";
return(connection.Execute(sql, item));
}
}
/// <summary>
/// 更新一条Eterm脚本记录
/// </summary>
/// <param name="item">要更新的Eterm脚本实例</param>
/// <returns>返回影响行数</returns>
public int UpdateEtermScript(EtermScript item)
{
if (item == null || item.EtermScriptID < 1)
{
return(-1);
}
using (IDbConnection connection = DapperHelper <object> .OpenConnection())
{
const string sql =
@"UPDATE dbo.EtermScripts
SET method = @MethodName,
script = @ScriptContent,
remark = @Remark,
updatetime = GETDATE()
WHERE id = @EtermScriptID";
return(connection.Execute(sql, item));
}
}