public void GetSqlStatementsTest()
{
DataTable _table = SampleTable();
_table.Rows.Add(new object[] { null, "jsph", 1, null, null, DateTime.Now, DateTime.Now });
QueryGenerator _generator = new QueryGenerator(_table);
_generator.ExcludedFields.Add("LastModified");
_generator.ForeignKey.Field = "HeaderId";
_generator.ForeignKey.Value = Database.Database.LastInsertIdCall;
string[] _queries = _generator.GetSqlStatements();
if (_queries.Length <= 0) Assert.Fail();
else
{
for (int i = 0; i < _queries.Length; i++) Console.WriteLine(_queries[i]);
}
_table.AcceptChanges(); _generator = null;
DataRow _row = _table.Rows[0];
_row["Active"] = 0;
_generator = new QueryGenerator(_table);
_generator.ExcludedFields.Add("LastModified");
_queries = null; _queries = _generator.GetSqlStatements();
if (_queries.Length <= 0) Assert.Fail();
else Console.WriteLine(_queries[0]);
_table.AcceptChanges(); _generator = null;
_row.Delete();
_generator = new QueryGenerator(_table);
_generator.ExcludedFields.Add("LastModified");
_queries = null; _queries = _generator.GetSqlStatements();
if (_queries.Length <= 0) Assert.Fail();
else Console.WriteLine(_queries[0]);
_table.Dispose(); _table = null;
}
