1, zhongjian three tables in database and the SQL statements into several data.
Table 1: the order table, including the following fields:
The order no. : the primary key
The goods number: foreign keys
Customer number: foreign keys
Quantity of the goods
Plan the delivery time
The actual delivery time

Table 2: the goods table
The goods number: the primary key
Goods name:
The unit price:
Inventory quantity: initialization time are set to 100

Table 3: the customer table
Customer number: the primary key
The customer name
Whether the VIP customers

2, write a winform program to implement the following function (note the key conflict) :
Three 1, delete the data in the table,
2, imported from three excel file initialization data to three tables,
3, through the program to order three data table, (use transaction control data consistency)
4, calling a stored procedure, the input parameters for the delivery time and the actual delivery time, query the failed to timely delivery of the order information (delivery time is greater than the actual delivery time plan, display field below), and export to excel file:
Order no., user id, user name, name of commodity, quantity of the goods, plan the delivery time, the actual delivery time,
Three 1, delete the data in the table,
2, imported from three excel file initialization data to three tables,
3, through the program to order three data table, (use transaction control data consistency)
4, calling a stored procedure, the input parameters for the delivery time and the actual delivery time, query the failed to timely delivery of the order information (delivery time is greater than the actual delivery time plan, display field below), and export to excel file:
Order no., user id, user name, name of commodity, quantity of the goods, plan the delivery time, the actual delivery time,

Be specific detailed process and code, thank you, 973912032

CodePudding user response:

The original poster please transfer 3000 yuan to my pay treasure account, thank you!

CodePudding user response:

The original poster please transfer 5000 yuan to my pay treasure account, thank you!

CodePudding user response:

The original poster please transfer 2800 yuan to my pay treasure account, thank you!

CodePudding user response:

The original poster please call me at the pay treasure in 2500 yuan, thank you.

CodePudding user response:

The original poster please transfer 328 yuan to my pay treasure account, thank you! I don't know what watch pioneer pre-orders, also don't know BFS open package

CodePudding user response:

Good proud to meet such a something to

CodePudding user response:

The building Lord, 2499 can't be less, the price is appropriate, what nature is good, say ahead of time, first pay 40% deposit

CodePudding user response:

The building Lord, 2498 can't be less, the price is appropriate, what nature is good, say ahead of time, first pay 40% deposit

CodePudding user response:

I 2497, faster...

CodePudding user response:

I want to be an aircraft carrier, the lz send it round quickly,

CodePudding user response:

As long as 998, code all take home

CodePudding user response:

1999, you're worth it!

CodePudding user response:

As long as 666, code don't have to worry about, don't ask me why so cheap, because there is no middlemen to earn price difference,

CodePudding user response:

As long as 9.


To call back the money,

CodePudding user response:

We don't compete on price, they are more than 2 k, I as long as 1 k, the landlord to fix it for you

CodePudding user response:

reference 15 floor nicholasvb response:

everybody don't compete on price, they are more than 2 k, I as long as 1 k, the landlord to fix it for you

The most annoying your bullshit, one dollar, so the material? So vanity??
,,,,,,,
The building Lord, contact me, I as long as GuanFan, haidilao line,,, I have been hungry for three days,,,

Contact QQ66840199...

CodePudding user response:

Just $9.9



My signature

CodePudding user response:

Nine pieces of nine, nine pieces of nine twice, nine JiuSan,,,,,,,,,,,,,,,, nine pieces of eight!

CodePudding user response:

I a look carefully, after 16 years of post, 18 years and back,,,,,,,,,,

CodePudding user response:

11 references u013314974 response:

as long as 998, code all home

Dig a grave for fun?

CodePudding user response:

Post for a long time,,, how long words posts will tip has a long history not reply

CodePudding user response:

so deep posts you can dig out, really admire ah

CodePudding user response:

[img=https://forum.csdn.net/PointForum/ui/scripts/csdn/Plugin/003/monkey/5.gif] [/img admire

CodePudding user response:

Heard about the integral review?

CodePudding user response:

Haha, god is stuck to the top

CodePudding user response:

Can really dig, long time no post

CodePudding user response:

Be a good topic, can consider to practice a try,

CodePudding user response:

The building Lord, so the lowest price 99.9 code to take home

CodePudding user response:

The original poster please transfer 5000 yuan to my pay treasure account, thank you!

CodePudding user response:

Always have so many ZhaShi stick CSDN

CodePudding user response:

The original poster please call me at the pay treasure in 500 yuan, thank you.

CodePudding user response:

Give me a BTC is become, no problem to fix it for you!

CodePudding user response:

16 years of posts, are now 20 years,, dig the grave,