ASP. Aries Tutorial 4: Sany drop-down configuration

Background:

Today to Shenzhen stroll a day, just came back, see the homepage are Microsoft Dafa Good, seems away. NET Spring is 3 months from now ~ ~

Back to the chase, this tutorial explains the dropdown configuration.

Sany drop-down configuration: 1: How does the Query box be configured as a dropdown?

In the configuration table header: Format configuration #是否

PS: Formatting configuration In addition to formatting the contents of the table, it will also drop down for formatting.

650) this.width=650; "src=" Http://images2015.cnblogs.com/blog/17408/201611/17408-20161116153327248-1811177492.png "/>

Effect:

650) this.width=650; "src=" Http://images2015.cnblogs.com/blog/17408/201611/17408-20161116153400701-1903543578.png "/>

Where does “ #是否 ” come from?

In configuration maintenance, for fixed options, the unified configuration is here:

650) this.width=650; "Src=" http://images2015.cnblogs.com/blog/17408/201611/17408-20161116153527998-433083284.png "/>

2: Can the Query box dropdown be more selective?

Configure formatting rules: multiple properties

650) this.width=650; "Src=" http://images2015.cnblogs.com/blog/17408/201611/17408-20161116153755826-422586236.png "/>

Effect:

650) this.width=650; "src=" Http://images2015.cnblogs.com/blog/17408/201611/17408-20161116154742154-2050996532.png "/>

3: Query box dropdown can i cascade?

Configuring formatting rules refers to the up-level:

650) this.width=650; "src=" Http://images2015.cnblogs.com/blog/17408/201611/17408-20161116154114138-1642670141.png "/>

PS: The #c_pb_provice2 here is not a configuration maintenance table, but a custom SQL statement:

650) this.width=650; "Src=" http://images2015.cnblogs.com/blog/17408/201611/17408-20161116154448217-757512816.png "/>

To avoid conflicts with the system, you can build your own Sql_xxxx.sql file to put down your business's drop-down statement.

There are two types of pull-down supported by the framework:

1: Configuration Table Maintenance # Configuration Items

2: #c_ name of the custom statement

Effect:

650) this.width=650; "Src=" http://images2015.cnblogs.com/blog/17408/201611/17408-20161116154232888-605694317.png "/>

4: How do I cascade data to a configuration maintenance table?

Just this question today a user asked:

1: Write C_XXX SQL statement, you can put notes as ParentID, in the notes to fill in the ID of the superior

650) this.width=650; "src=" Http://images2015.cnblogs.com/blog/17408/201611/17408-20161117203853810-1944493451.png "/>

2: Follow the above cascade processing.

5: How do I customize the drop-down query operator? Mode 1:

By previous: ASP. Aries Tutorial 3: Developing a list page and manipulating Sany

12th, change the operator in the intercept condition.

Mode 2:

650) this.width=650; "src=" Http://images2015.cnblogs.com/blog/17408/201611/17408-20161117204356107-1211336636.png "/>

The criteria for this query are queried from the text box's default like = number:

650) this.width=650; "Src=" Http://images2015.cnblogs.com/blog/17408/201611/17408-20161117204452404-17640676.png " />

Summarize:

The drop-down box is formatted in two ways, though:

1: Configuration Maintenance Table 2: Custom statement

But the scenarios used are quite extensive:

List data formatting, drop-down query, inline editing time-varying drop-down query.

Form input configuration (Configkey and objname), you can pull out, this follow-up will be introduced to.

ASP. Aries Tutorial 4: Sany drop-down configuration