Start with several questions from development engineers

1. Implementation of sales orders

A) The order contains the following information: Order Number, order date, customer name, product number, product name, quantity, unit price, and amount

B) One order can contain multiple item information.

C) Create a table using an SQL script and consider the existing performance and table.

D) the code is used to save the order. The required ADO object is used. Some codes can be implemented using pseudocode. The information to be saved must be complete and the data correctness should be checked.

2. write a function to implement the following functions: the input value is an integer and the output value is an integer. The output integer is required to reverse the input integer. For example, if the input value is 123, the output value is 321, the code is required to run normally and no interruption error is reported.

3. What are the differences between your understanding of indexes and the types of indexes.

4. About the lifecycle of ASP. NET pages

 

(Strive to complicate simple questions and provide non-standard answers for careful reference. If there are any mistakes, please correct them by yourself)

1. According to a), B) can be used as a domain model, and an OOM model can be created in PowderDesigner15, which is actually a class diagram without behavior.

 

The above three classes are Entity classes, and ORM is later the three Relational Tables in the database. The method of simply abstracting a class from the requirement information is probably to find a noun game, such as "order", "customer", and "commodity" in ", with these "classes", you can find their attributes and finally build a complete object class.

When creating a data table, in addition to the creation constraints, pay attention to the data type and length. In terms of performance, you can also delete triggers to avoid long-term useless data accumulation.

In terms of Code-based data validation, you can make a fuss in the Property field. For example:

Assume that orderid is automatically generated and you want to read-only in the program.

 

Private string orderid;

Public String orderid
{
Get {return orderid ;}
}

 

Enter customer name check

 

 

Code
Private string customer;

Public String customer
{
Get {return customer ;}
Set {
If (value = string. Empty)
{
Console. writeline ("customer name cannot be blank ");
}
Else
{
Customer = value;
}
}
}

= 15% completed =