Mechanical manufactory produces the design that runs a system and implementation

Manufactory of machinery of 1 system setting is Guangdong province treatment of spare parts of mark of blame of limited company of group of Shao Guangang iron makes base, have cast, the workshop section such as treatment of riveting solder, average machine, roller treatment, the engineering technology between each production workshop section becomes independent each other, carry on every months made spare parts item is amounted to 300 multinomial, the manufacturing organization of the product has a project technological process of much, working procedure is long, in the characteristic with much goods, manufacturing administrator masters in the circumstance of goods in real time hard, hard according to equipment and personnel take up the circumstance undertakes to machining the task real time is adjusted, reasonable adjust those who produce the job to carry on quantity. The ERP system that Shao Gang is implementing now, MES system, as bigger as the manufacturing mode existence of mechanical manufactory difference, need those who have older rate to adapt ability applicably. The informatization that carries out to carry out executive Shao Gang better and compressed change administrative pattern, accelerate mechanical manufactory the information between link of each production, management flows, science of implementation management job is changed, standardization, efficient change, reduce manufacturing cost further, raise economic benefits, in the light of mechanical manufactory the need of manufacturing management designed this to cover a system. 2 systems analysis and overall design should develop system of a manufacturing management, need to undertake demand analysis and overall design above all, analyse use object of the system and user demand, design systematic architecture and database structure, decide use development tool and tiring-room database, program project develops plan, in actual project development process, these jobs are very important. 2.

The daily production that 1 system demand summarizes this system to basically face mechanical manufactory manages working processing, main by plan of contract management, production, each section office (workshop section) wait for module composition. Each module function is as follows: 1) contract manages module (include in-house contract, appoint outside contract, outside sell a contract) the accretion that realizes contract information, revise, delete, inquiry and nuclear reciprocity function; This module is those who produce information of plan module data to generate provide the basiccest basis. 2) production plans module (include to plan examine and verify, scheduling, workshop section to plan to consult) the accretion that realizes production to plan information, revise, delete, the function such as inquiry, support production plan information guides the person arrives relevant workshop section in order to go to the lavatory the function that synchronism of job of each workshop section has; This module is each section office (workshop section) assure to produce working designedly to undertake providinged the primest basis. 3) each section office (workshop section) the produces information daily accretion with module respective implementation, revise, delete, the function such as inquiry and statistic; The manufacturing information that this kind of module plans module to offer according to production, undertake administrative in time to producing the job daily. 2.

2 systems flow analyses systematic flow chart is systematic whole train of thought to reflect with wraparound. If the graph is shown 1 times,the flow of this system is analysed. Graph analysis of 1 system flow is analysed in systematic flow can see in the graph, every user has an opportunity 3 times to undertake identity attestation. If 3 times the work number of the input is mixed,the password cannot match with the data in the database, quit a system compulsively. 2.

What 3 systems architecture designs a basis to realize a function is different and OK differentiate the system for 8 big module: Systematic government module, user management module, contract management module, manufacturing plan module, data management module, mechanism (each section office) module of administrative module, workshop section management and statistical management module. If the graph is shown 3 times,functional module of the system pursues. In the structure establishing record of functional module sketch map, every leaf node is the functional module that the manufacturing work function that in the light of machinery the manufactory differs one undertakes differentiating. Each function module needs to be aimed at different working job to complete identical database operation, add record, modification record namely, delete the function such as record and inquiry record information; In the meantime, what operate content according to respective job management is different, some module still add fixed position of collect statistic, data logging to check, relevant data logging guides derive and deliver, database form type is revised wait for a function, of these functions generate, improved the level of management of the user greatly. 2.

4 systems develop a tool to choose this system to use Delphi 7. 0 and SQL Server 2005 undertakes developing. 2.

The basic and practical skill that place of 5 development example requires develops database management information system to need to master following basic technologies: ◆ place chooses development tool (the method of basic process designing of Delphi) . The tiring-room database with basic ◆ manages a method, found a database for example, found watch, backup and reductive database to wait. The use of statement of ◆ commonly used SQL. ◆ ADO database visits a technology. Design of structure of database of design of structure of 3 systems database is the segment with overall very important design phase, fine database structure can simplify development process, make systematic function more clear and clear, the change of database structure meets those who cause encode alter, code must have again after structure of serious design database so, make in order to avoid meaningless heavy return to work after a strike or layoff. 3.

The database that the structure that 1 main data expresses designs this system to define names for Jzgl; The circumstance of actual production work that is aimed at mechanical manufactory, the forms for reporting statistics that need uses is various, the data table measure that establishs from this is more, list the structure that the data of module of a few main functions expresses below. Different cent is the sale way that 1) contract runs module root to seize a product two kinds (the product is sold internally and the product sells) external, among them: A) in-house contract (appoint outside contract) watch (the product sells) internally, among them: In-house contracts card (oneself produce a product to be sold internally) with the unit that will save mechanical manufactory and limited company of group of subject Yu Shaogang (namely in-house department) information of signed product production contract; Appoint outside contracts card (product appoint outside production is sold internally) the product contract information that entrusts treatment production with the product that the unit that will save mechanical manufactory and limited company of group of not subject Yu Shaogang signs; The structure of two watches is same. Contracts card sells outside B) (the product sells) external, the product that signs with the unit that will save mechanical manufactory and limited company of group of not subject Yu Shaogang sells contract information. Module of scheduling of 2) scheduling module is production the nuclear centre module in planning module, other the data content that two stature module cite comes from hereat the data that module place provides, accordingly, the data that basically introduces this module place to use here expresses a structure. Because the demand degree of the product differs and the manufacturing plan that makes according to contract information undertakes classified, among them: Key of ／ of daily ／ carry forward manufacturing schedule, use respectively save daily a manufacturing plan information, carry forward manufacturing plan information and key production plans information; The structure of these 3 watches is same, they and another watch (urgent document produces schedule) different point is before 3 watches types production plans to want to pass examine and verify first (come true in module of plan examine and verify) just can pass each section office (workshop section) . 3.

A few when the relation between table of 2 main data mentions in the structural design that main data expresses main data are expressed (do not include an user to express) if asking concern pursues 2 are shown. Graph the relation between table of 2 main data the design of 4 systems forms for reporting statistics and realize this system to use FastReport to accuse a design that undertakes systematic forms for reporting statistics and implementation. The forms for reporting statistics that FastReport is tall flexibility is designed implement, the data that is used at forms for reporting statistics can be gotten from the data source of any types, include character list, BDE database, ADO data source (do not use BDE) , interbase(uses IBO) , pascal array and record, and a few not commonly used data sources. The in-house ／ in contract management module appoint outside contract child in module, used FastReport to accuse two stature accuses: FrxReport accuses accuse with FrxDBDataset. Accuse through among them FrxDBDataset accuse with designation Adotable (Adotable accuses already with in-house ／ appoint outside photograph joins) join, accuse FrxReport accuse a join with FrxDBDataset, double stroke opens FrxReport to accuse, will among them the form of forms for reporting statistics that place of basis of field of connective data table needs undertakes be designinged one by one. 5 conclusion this system from begin proceed demand to analyse technical development, design to finish all previous classics the time of 4 many months, already threw now move, look from moving effect, better land achieved expectant goal, it is certain to have to the person of the same trade draw lessons from action. CNC Milling CNC Machining