【正文】 provisions excessive, no autonomy requirements。 follow the correct direction, grasp the limited goals, adhere to the party39。 rule around the party discipline, disciplinary ruler requirements, listed as negative list, focusing on vertical gauge, draw the party organizations and Party members do not touch the bottom line . Here, the main from four square face two party rules of interpretation: the first part introduces two party Revised regulations the necessity and the revision process。3 總結(jié)計算機作為數(shù)據(jù)高效處理工具，已經(jīng)逐漸成為重要的現(xiàn)代化人事管理工具，在人事管理工作中正發(fā)揮著重要的作用。備份與恢復操作是系統(tǒng)管理員維護數(shù)據(jù)庫安全性和完整性的重要操作。職員基本信息管理子模塊的功能是對職員的基本信息進行查詢、添加、刪除及修改操作。用戶可以在該模塊對自己的密碼進行修改。通過該窗口用戶可以完成諸如系統(tǒng)管理、基礎數(shù)據(jù)管理、部門管理、職員信息管理等系統(tǒng)功能。該模塊主要完成獲取用戶輸入的登錄信息，包括登錄系統(tǒng)的用戶名和密碼。通過該函數(shù)完成程序的初始化及顯示“用戶登錄”對話框。(8)truncate語句快速刪除表中記錄的方法，刪除的記錄不可恢復，不對日志文件進行操作:truncate table 獎懲記錄。(4)將“人事管理系統(tǒng)”數(shù)據(jù)庫的”員工信息”表中籍貫為“河南”并且所在部門編號為10001的數(shù)據(jù)插入到“新員工信息”表中：insert into 新員工信息(員工編號,員工姓名,所在部門編號)select 員工編號,員工姓名,所在部門編號from 員工信息where 所在部門編號 = ‘10001’and 籍貫 = ’河南’。例如，數(shù)據(jù)刷新顯示函數(shù)、檢查記錄是否存在的函數(shù)等。例如，用戶名、用戶類型及職員編號等。為工程添加一個mdi窗體，該窗體為人事管理系統(tǒng)的主窗體。本系統(tǒng)數(shù)據(jù)庫名稱為“dbemp”。a) 設計和創(chuàng)建數(shù)據(jù)庫根據(jù)系統(tǒng)功能分析和數(shù)據(jù)庫需求分析，接下來可以為本系統(tǒng)創(chuàng)建數(shù)據(jù)庫。 系統(tǒng)結(jié)構(gòu)設計本系統(tǒng)采用的是兩層結(jié)構(gòu)，即客戶端/服務器模式。這種方式辦公效率低下，不能有效地提供員工信息，對部門進行管理，而且存在著安全隱患，不能保證數(shù)據(jù)的安全性。以下是企業(yè)人事管理的流程：每位員工由人事管理部錄入基本資料，生成人事檔案；由人力資源部管理部門信息；匯集員工獎懲信息和考勤信息；每月生成員工考核信息，并根據(jù)考核信息生成工資表。有些企業(yè)還停留在用紙張檔案管理的方式，這種方式效率低下，而且容易出錯，極不適應現(xiàn)代企業(yè)發(fā)展和管理的要求。 基于SQL Server數(shù)據(jù)庫的人事管理系統(tǒng)的研究與開發(fā)【 摘 要 】 隨著信息技術(shù)的飛速發(fā)展，信息化系統(tǒng)在企業(yè)管理中應用的普及，利用計算機實現(xiàn)人事管理勢在必行?！?關(guān)鍵詞 】 sql server數(shù)據(jù)庫；人事管理系統(tǒng)【 abstract 】 with the rapid development of information technology, information system in the business management the application popularization, uses the puter realization of personnel management be imperative. enterprises using personnel management system, the pany managers and management can more scientific reasonable and fair for business and personnel management. in this paper, based on the sql server database of personnel management system research and development.【 keywords 】 sql server database；personnel management system0 引言隨著社會經(jīng)濟的不斷發(fā)展，對于一些中小型的企業(yè)來說，人力資源成為企業(yè)發(fā)展的重要因素。1 人事管理系統(tǒng)開發(fā)概述對于應用程序的開發(fā)，需要開發(fā)人員對案例本身有一個較為完整和細致的認識，包括案例的背景、所要達到的功能及需求分析等。 系統(tǒng)需求分析目前，對于一般中小型企業(yè)在人事管理上還是采用手工管理的方式。如圖1所示。2 人事管理系統(tǒng)設計與開發(fā)以下對人事管理系統(tǒng)進行設計與開發(fā)。會彈出“數(shù)據(jù)庫屬性”對話框，在選項卡中選擇“常規(guī)”選項，然后在“名稱”文本框中輸入要創(chuàng)建的數(shù)據(jù)庫名稱。b) 創(chuàng)建工程和公共函數(shù)模塊打開visual basic ，保存為“人事管理系統(tǒng)”。公共變量定義了人事管理系統(tǒng)中常用的一些變量。同時也提高了應用程序的可維護性。(3)新建一個“新員工信息”表用于存儲臨時的新員工信息，這些信息來自于“員工信息”表：insert into 新員工信息(員工編號,員工姓名,所在部門編號)select 員工編號,員工姓名,所在部門編號 from 員工信息。(7)刪除單行數(shù)據(jù):delete from 新員工信息 where 員工編號＝100503刪除多行數(shù)據(jù):delete from 新員工信息 where 所在部門編號 =1005刪除所有行數(shù)據(jù):delete from 新員工信息刪除固定行數(shù)據(jù):delete top(20) percent 員工信息。為了完成一些程序的初始化工作，將程序入口設置為main函數(shù)。e) 創(chuàng)建系統(tǒng)登錄模塊完成人事管理系統(tǒng)工程創(chuàng)建及公共模塊創(chuàng)建后，首先需要完成的系統(tǒng)模塊是用戶登錄模塊。f) 創(chuàng)建主窗體模塊主窗體是人事管理系統(tǒng)與用戶交互操作的主要窗口。修改密碼子模塊用于修改當前登錄用戶的密碼，該模塊對所有用戶開放。例如，對企業(yè)部門進行添加、刪除、修改等操作。i) 創(chuàng)建數(shù)據(jù)庫管理模塊數(shù)據(jù)庫管理模塊的功能是對數(shù)據(jù)庫進行備份與恢復操作。所以必須發(fā)布人事管理系統(tǒng)的應用程序，也就是平時見到的安裝程序。參考文獻[1] 周啟海,、mysql、,2004 第8期.[2] 張計龍,張成洪,張凱,宓鋪,郭超,2004 第8期.[3] , 504,534535.[4] 胡浪,.[5] ,.[6] 田鵬,張月琪,:自然科學版,.[7] , 2009第3期.（英文版 ） Two regulations promulgated for implementation is in the party in power for a long time and the rule of law conditions, the implementation of prehensive strictly strategic plan, implementation in accordance with the rules and discipline to manage the party, strengthen innerparty supervision of major initiatives. The two regulations supporting each other, the code adhere to a positive advocate, focusing on morality is of Party members and Party leading cadres can see, enough to get a high standard。 the fourth part on how to grasp the implementation of the two regulations of the party. code and Regulations revised the necessity and revised history of the CPC Central Committee the amendment to the Chinese Communist Party members and leading cadres honest politics several guidelines and Chinese Communist Party discipline and Punishment Regulations column 1 by 2015 to strengthen party laws and regulations focus. Two party regulations revision work lasted a Years, pooling the wisdom of the whole party, ideological consensus, draw historical experience, respect for the wisdom of our predecessors, which reflects the unity of inheritance and innovation。s eighteen years prehensive strictly practice. (a) revised two regulations of the party need of the ICAC guidelines in in 1997 Leaders as members of the Communist Party of China clean politics certain criteria (Trial) based on revised, the promulgation and implementation of January 2010, to strengthen the construction of the contingent of leading cadres play an important role. But with the party to manage the party strictly administering the deepening, has not been able to fully meet the actual needs. Content is too plicated, eight prohibition, 52 are not allowed to hard to remember, and also difficult to put into practice。 two is the political discipline regulations is not prominent, not specific, for violation of the party constitution, damage the authority of Party Constitution of misconduct lack necessary and serious responsibility to pursue。s eighteen years strict political discipline and political rules, organization and discipline and to implement the central eight provisions of the spirit against the four winds and other requirements into Disciplinary provisions. Not one pace reachs the designated position, focusing on in line with reality, pragmatic and effective. After the revision of major changes, major changes in the code and rule modified and needs to grasp several key problems (a) code code adhere to according to regulations governing the party and party with morals in bination, for at the present stage, the leadership of the party members and cadres and Party members in existing main problems of selfdiscipline, put forward principles, requirements and specifications, showing Communists noble moral pursuit, reflected at all t