protected void ParseUpdateQuery()
{
DataColumnCollection cols;
TableEntity te;
string pv, sql;
string tb = FormatFieldName(Form["tb"]);
string pk = Form["pk"];
te = new TableEntity(tb, Database);
DataRow dr = te.GetNewRow();
cols = te.GetColumns();
pv = Form["fld_" + pk];
foreach (DataColumn col in cols)
{
string v = Form["fld_" + col.ColumnName];
if (!string.IsNullOrEmpty(v))
{
string rlt;
te.MakeFieldSql(col.ColumnName, v, out rlt, false, false);
dr[col.ColumnName] = rlt;
}
}
sql = te.MakeUpdateSql(dr, te.MakeOpSql(pk, pv), true, false);
Sql = sql;
}
private string GenerateTableCode(List <TableControl> tables)
{
StringBuilder sb = new StringBuilder();
int i = 0;
foreach (TableControl t in tables)
{
i++;
TableEntity te = t.GetTableEntity();
if (te.GetSchema() == null)
{
sb.AppendLine("CREATE TABLE " + te.GetName());
}
else
{
sb.AppendLine("CREATE TABLE " + te.GetSchema() + "." + te.GetName());
}
sb.AppendLine("(");
foreach (ColumnEntity ce in te.GetColumns())
{
sb.Append("\t" + ce.GetColumnName() + "\t\t" + ce.GetColumnType() + "(" + ce.GetColumnLength() + ")");
if (i == tables.Count)
{
sb.AppendLine();
}
else
{
sb.AppendLine(",");
}
}
sb.AppendLine(");\n\n / \n\n");
}
return(sb.ToString());
}
