public override string GetSql(bool useCache)
{
DataAccessCommon.TrimHead(_condition);
StringBuilder sql = new StringBuilder(500);
sql.Append("Delete from ");
sql.Append(_tables.ToString());
if (_condition.Length > 0)
{
sql.Append(" where ");
sql.Append(_condition.ToString());
}
return(sql.ToString());
}
public override string GetSql(bool useCache)
{
string ret = null;
DataAccessCommon.TrimHead(_condition);
if (_pageContente != null && _pageContente.PageSize > 0)
{
ret = _dbInfo.CurrentDbAdapter.CreatePageSql(_paramList, _oper, this, _pageContente, useCache);
}
else
{
ret = GetSelect();
}
return(ret);
}
public override string GetSql(bool useCache)
{
DataAccessCommon.TrimHead(_condition);
StringBuilder sbRet = new StringBuilder(2000);
sbRet.Append("update ");
sbRet.Append(_tables.ToString());
sbRet.Append(" set ");
sbRet.Append(_updateSetValue.ToString());
if (_condition.Length > 0)
{
sbRet.Append(" where ");
sbRet.Append(_condition.ToString());
}
return(sbRet.ToString());
}