예제 #1
0
        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;
        }