Class StdBSSQL
Serviços de manipulação de código SQL.
Inheritance
System.Object
StdBSSQL
Implements
Inherited Members
System.Object.ToString()
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
Namespace: StdPlatBS100
Assembly: StdPlatBS100.dll
Syntax
[ComVisible(true)]
[Guid("64916CA5-00CD-4B57-8A46-A60ED4610569")]
[ClassInterface(ClassInterfaceType.None)]
public class StdBSSQL : IStdBSSQLMethods
ConverteDataSQL(DateTime)
Declaration
public string ConverteDataSQL(DateTime datData)Parameters
| Type | Name | Description |
|---|---|---|
| System.DateTime | datData |
Returns
| Type | Description |
|---|---|
| System.String |
ConverteNumeroSQL(Object)
Declaration
public string ConverteNumeroSQL(object vntValor)Parameters
| Type | Name | Description |
|---|---|---|
| System.Object | vntValor |
Returns
| Type | Description |
|---|---|
| System.String |
Finalize()
Declaration
protected void Finalize()FormatSQL(String, Object[])
Declaration
public string FormatSQL(string strSQLSt, params object[] vntParams)Parameters
| Type | Name | Description |
|---|---|---|
| System.String | strSQLSt | |
| System.Object[] | vntParams |
Returns
| Type | Description |
|---|---|
| System.String |
FormatSQLExt(String, Object[])
Declaration
public string FormatSQLExt(string strSQLSt, params object[] vntParams)Parameters
| Type | Name | Description |
|---|---|---|
| System.String | strSQLSt | |
| System.Object[] | vntParams |
Returns
| Type | Description |
|---|---|
| System.String |
ParseTop0(String)
Devolve um query Sql com a condição TOP 0.
Declaration
public string ParseTop0(string strSql)Parameters
| Type | Name | Description |
|---|---|---|
| System.String | strSql | Identificador do Query Sql. |
Returns
| Type | Description |
|---|---|
| System.String |
ParseTopN(String, Int32)
Devolve um query Sql com a condição TOP.
Declaration
public string ParseTopN(string strSql, int iTop)Parameters
| Type | Name | Description |
|---|---|---|
| System.String | strSql | |
| System.Int32 | iTop | Nº de elementos. |
Returns
| Type | Description |
|---|---|
| System.String |
ValidaData(DateTime, Boolean)
Valida a data para ser utilizada em formato Sql.
Declaration
public bool ValidaData(DateTime vntDataVar, bool blnObrigatoria = true)Parameters
| Type | Name | Description |
|---|---|---|
| System.DateTime | vntDataVar | Data a validar. |
| System.Boolean | blnObrigatoria | Obrigatória. |
Returns
| Type | Description |
|---|---|
| System.Boolean |
ValidaData(Object, Boolean)
Valida a data para ser utilizada em formato Sql.
Declaration
public bool ValidaData(object vntDataVar, bool blnObrigatoria = true)Parameters
| Type | Name | Description |
|---|---|---|
| System.Object | vntDataVar | Data a validar. |
| System.Boolean | blnObrigatoria | Obrigatória. |
Returns
| Type | Description |
|---|---|
| System.Boolean |