public override ISQLBuilder EndOfStatement(SQLStatementType statementType = SQLStatementType.DML)
{
try {
return(base.EndOfStatement(statementType));
} finally {
AddDelimiterIfApplicable();
}
}
public static string GetStatementByDBType(SQLStatementType statetype, DBType dbtype, object other)
{
string statement;
switch (statetype)
{
case SQLStatementType.EXISTSLM:
{
switch (dbtype)
{
case DBType.MSSQL:
{
statement = string.Format("select count(*) from master.dbo.sysobjects where xtype = 'U' and object_id(N'{0}') = id", Settings.Default.LMTABLE);
}
break;
}
}
break;
}
return null;
}
public async Task <object> CustomQuery(SQLStatementType type, string query)
{
return(await Task.Run(() =>
{
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
try
{
switch (type)
{
case SQLStatementType.SELECT_LIST:
try
{
DataList dataList = new DataList();
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
DataRow row = new DataRow();
for (int i = 0; i < reader.FieldCount; i++)
{
row.Set(reader.GetName(i), reader.GetValue(i));
}
dataList.Add(row);
}
}
dataList.Error = ERROR.NoError;
return (object)dataList;
}
} catch (Exception)
{
DataList error = new DataList();
error.Error = ERROR.HasError;
return error;
}
case SQLStatementType.DELETE:
try
{
cmd.ExecuteNonQuery();
con.Close();
return true;
}
catch (Exception)
{
return false;
}
default:
return true;
}
} catch (Exception)
{
return false;
}
}
}));
}
public override ISQLBuilder EndOfStatement(SQLStatementType statementType = SQLStatementType.DML)
{
this.Emit(StatementTerminator).NewLine();
base.EndOfStatement(statementType);
return(this);
}
public override ISQLBuilder EndOfStatement(SQLStatementType statementType = SQLStatementType.DML)
{
Emit(";").NewLine();
return(base.EndOfStatement(statementType));
}
public static SQLBuilderCommand EndOfStatement(SQLStatementType sqlStatementType = SQLStatementType.DML)
{
return(new EndOfStatementCommand(sqlStatementType));
}
public EndOfStatementCommand(SQLStatementType sqlStatementType)
{
StatementType = sqlStatementType;
}
public virtual ISQLBuilder EndOfStatement(SQLStatementType statementType = SQLStatementType.DML)
{
_internalBuilder.EndOfStatement(statementType);
return(this);
}
public virtual ISQLBuilder EndOfStatement(SQLStatementType statementType = SQLStatementType.DML)
{
SetCurrentStatementType(statementType);
AdvanceNextStatement();
return(this);
}
protected ISQLBuilder SetCurrentStatementType(SQLStatementType statementType)
{
CurrentStatement = Tuple.Create(statementType, CurrentStatement.Item2);
return(this);
}
