예제 #1
0
        protected void ParseInsertQuery()
        {
            DataColumnCollection cols;
            TableEntity          te;
            string sql;
            string tb = FormatFieldName(Form["tb"]);

            te = new TableEntity(tb, Database);
            DataRow dr = te.GetNewRow();

            cols = te.GetColumns();
            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.MakeInsertSql(dr, true, false);
            Sql = sql;
        }