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