/// <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)); } }
/// <summary> /// 获得满足条件的Eterm脚本记录集。如果 PageItem 为null,则将获得所有满足条件的Eterm脚本记录集;如果 PageItem 不为null,则将获得某页的满足条件的Eterm脚本记录集。 /// </summary> /// <param name="searchCondition">查询条件</param> /// <param name="pageItem">分页信息</param> /// <returns></returns> public IEnumerable <EtermScript> GetEtermScriptList(EtermScript searchCondition, PageItem pageItem = null) { string sql = @"SELECT id AS EtermScriptID, method AS MethodName, script AS ScriptContent, remark AS Remark, updatetime AS UpdateTime FROM dbo.EtermScripts WITH(NOLOCK) WHERE 1 = 1"; StringBuilder whereBuilder = new StringBuilder(); if (searchCondition != null) { if (!string.IsNullOrWhiteSpace(searchCondition.MethodName)) { whereBuilder.AppendLine(" AND method LIKE '" + searchCondition.MethodName + "%'"); } } if (whereBuilder.Length > 0) { sql += whereBuilder.ToString(); } sql += " ORDER BY updatetime DESC"; return(DapperHelper <EtermScript> .GetPageList(ConnectionStr.FxDb, sql, pageItem)); }
public int UpdateEtermScript(EtermScript item) { return(dal.UpdateEtermScript(item)); }
public int AddEtermScript(EtermScript item) { return(dal.AddEtermScript(item)); }
public IEnumerable <EtermScript> GetEtermScriptPageList(EtermScript searchCondition, PageItem pageItem) { return(dal.GetEtermScriptList(searchCondition, pageItem)); }