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