I want to implement a composite project called programming, expert help,
Idea of the project: a primary project contains multiple components, called a master program, automatically saved on the component code, the information such as name,
Five, such as the main project name: hepatitis b contains five components: 1 (HBsAg - hepatitis b virus surface antigen); 2 (HBsAb - hepatitis b virus surface antibody);
3 (HBeAg - hepatitis b e antigen); 4 (HBeAb - antibody of second liver virus e); 5 core antibody (HBcAb - hepatitis b)
In the outpatient clinic or hospital for billing, call five of hepatitis b, automatic save as amounting to cost of the project,
Paid for help!

CodePudding user response:

Build a table to record the main projects and subprojects relationship is ok

CodePudding user response:

reference 1st floor baiynije response:

create a table to record the main projects and subprojects relationship can now

Using this method can,

CodePudding user response:

To build the corresponding table I understand, the key is how to implement, to be obtained the main project, subproject,

CodePudding user response:

Realize the retrieval the main project, selecting main project, obtain all component code,

CodePudding user response:

Create two table main project table (main project code name... ) to build a word list (the sub-project of the main program code, code, name... )
Then both associated with the main project code,

CodePudding user response:

Thank you more than you, the design of the tables I know, just don't know how to realize the call, how do you write code,

CodePudding user response:

You don't know how to implement what meaning be?

CodePudding user response:

7th floor convenient leave a QQ number, I would like to ask, I qq472085850

CodePudding user response:

You get where you want to pass what action list implementation way, put your main related table structure, together to write the code in detail,

CodePudding user response:

Think through the way of the primary schedule, to call the main table project, project implementation schedule to collect fees,
Structure: the main table table structure XMH char (10) project code not null
XMMC varch (100) project name not null
Mnemonic null JSDM char (20)
Xm_two char (20) schedule code not null keys

Table structure: xm_two char (20) code not null keys
Xm_name varchar (100) project name not null
Mnemonic null JSDM char (20)
Xm_prices numeric (8, 2) project price null
Dw char (20) null

Description: the main table and table by field xm_two, realizes the table can be called project, the purpose of the charge schedule, to simplify the charging part,
Five such as hepatitis B: there are five different records in the table, for example: A 01 -- A (01 is A code, is A name, the same below), 02 - B, 03 - C, 4 - D, 05 - E, I want to call A new project, such as W, to obtain W, ABCDE five charge work can be realized, then I can maintain 5 records in the main table, item number are 100, names are for W, xm_two ABCDE respectively.

In client calls W, the realization of charge ABCDE,

CodePudding user response:

Lost, don't know what you want to ask... If you have free time on 1198674710, maybe can help you

CodePudding user response:

Enter a project, according to the project query component, then insert fee information