/// <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)); } }