Let's talk about the business first, from start to end!

Detailed analysis of forum services
1. Publish new posts
A. Enter the editing status
I, getforums
Ii. getforums
B. Posting
I, getforums
Ii. addpost
Iii. getforumidbypostid
Iv. getforums
V, getforums
VI, getforumidbypostid

2. Quick Reply
A. getforums
B. addpost
C. getforumidbypostid

3. Open the post
A. getforumidbypostid

4. Modify
A. getforumidbypostid

Detailed analysis of album services

1. Open the Home Page
A. Not logged on
I. gallerysqldataprovider
Ii. getgalleries
Iii. getpictures
B. Logon
I, getpictures

2. Go to the album page
A. log on
I, getpictures
Ii. getpictures

3. Click the latest release on the home page.
A. getpicture
B. getpicturemetadata
C. getcomments
D. getpicturesortorder
E. getpicturedata

4. Go to personal album
A. getpictures6 times
B. getrandompostid
C. getpicture
D. getpicturedata

5. Add picture
A. createpicture
B. createpicturedata
C. updatepicturecategories
D. getgalleries
E. getpictures
F. getgalleries
G, getpicturedata

6. Create a category
A. getrandompostid
B. getpicture

7. Open a personal album
A. getpictures
B. getrandompostid

8. Add sub-categories
A. getrandompostid
B. getpicture

9. delete a photo
A. getpicture
B. deletepicturedata
C. deletepicture
D. getgalleries

Detailed analysis of blog services

If this line is left blank, it indicates that the modification has been completed. The following is an incomplete description:

All business functions are analyzed for the weblogsqldataprovider class in the sqldataprovider project weblogsqldataprovider. CS

1. Go to the home page (the home page of the entire CS): list the latest 5 blogs. The latest 2 blogs have brief summaries,
A. getweblogs: Get the latest two blogs?
B. getblogthreads: obtains the topics of the remaining three blogs.

2. Go to my blog page: list the newest n blogs (N can be set)
A. getblogthreads: Obtain the topic
B. getpostsbymonths: obtains the number of blog statistics per month.
C. getpostsbymonth: Get the blog of the current month

3. New essay: Enter the blog editing window. After editing, add a blog record and return to the blog management list.
A. addpost: "posting", adding a new blog record
B. getblogthreads: Enter the list and read the topic.

4. Edit: Enter the blog editing window and open the specified blog. After editing, update the record and return to the blog management list.
A. Open
I. getweblogpost: Open the blog to be edited
B. Posting
I. getweblogpost: Get the edited blog
Ii. updatepost: update the blog obtained in step I.
Iii. getblogthreads: Go to the list and read the topic

5. Delete: After confirmation is displayed, delete the specified blog record and return to the blog management list.
A. getweblogpost: Get the specified blog record to ensure that the database has this record and avoid the remaining shadow record in the cache.
B. deletepost: delete a specified blog record.
C. getblogthreads: Enter the list and read the topic

6. View: view a specified blog, including comments to this blog.
A. getposts: Get the specified blog and comment on the blog
B. getpostsbymonths: obtains the number of blog statistics per month.
C. getpostsbymonth: Get the blog of the current month

7. Each database involves the following calls:
A. getsqlconnection
B. connectionstring
C. settingsidparameter
D. getsettingsid

8. automatically run at intervals (within 5 minutes)
A. updaterecentcontent