orm方法在人力资源信息系统中的应用

ORM()SQLORM,ORMORM1,:1)(OA);2),(),SQLORM2,,()B/S,VisualStudio2003(.NetFrameWork111,Asp.Net),SQLServer2000,VisualStudio2003,MicrosoftSQLServ2er2000,/,Transact-SqlSQL3,Asp.Net,Java,JavaHtmlJspServlet,JavaBeanEjb,;Asp.Net,Htmlaspaspx,.vb.cs.dll,,,,,.dll.Net,.dll,1)WindowsAsp.NetHR,HR04HR,HR.aspx1EmployeeContractHistory.as2px,EmployeeDegreeHistory.aspx,1EmployeeInfo.aspx12)HRDataManager,DataManager.cs2CompanyManager.cs,Dic2Manager.cs,EmployeeManager.cs23)().NetAdo.NetHRDBCtrl,DBCtrl.cs3Data2BaseCtrl.cs,(DBCtrl),,,,.dll.Net,.dll,4.dll34.dll,HR,.dll,,,Sql,:///summary///////summary///returns/returnspublicDataTableGetMainCompanyTable(){if(enableCache&&mainTable!=null){returnmainTable;}stringsql=selectc.ID,c.Name,c.Code,d.nameastype,c.typeastypeidfromCompanySummary214Infoc,Dictionarydwherec.type=d.idandc.Paren2tIDisnull;if(this.dbCtrl.CreateConnection()){DataTabletable=this.dbCtrl.GetDataTable(sql);this.dbCtrl.CloseConnection();if(enableCache){//mainTable=table;}returntable;}returnnull;}Sql=selectc.ID,c.Name,c.Code,d.nameastype,c.typeastypeidfromCompanySummaryInfoc,Dictionarydwherec.type=d.idandc.ParentIDisnull,table;sqlTableSql,,,SqlSql(),,,4ORMORM,Object-RelationalMapping(),,,,SQL,O/RO(Ob2ject),R(Relational),,,(O/RMap2ping),,,,DAL,,DAL,DAL,,SqlCommandSqlParameter,,SqlCommandCommandText,SqlCommandO/RMap2ping,O/RMappingDALDAL,O/RMappingO/RMapping,,,O/RMappingSQL,,ORM,(HRSQL2000),,,,,-(ORM),,ORM,.NET245ORM65ORM,ORMDAL6DataModel:DataModelContract.csHR///summary///////summarypublicstringContractNum{get{returncontractNum;}set{contractNum=value;}}privatestringcontractNum;///summary///////summarypublicintContractTimeLimit{get{returncontractTimeLimit;}set{contractTimeLimit=value;}}privateintcontractTimeLimit;///summary///////summarypublicDateTimeContractTime{get{returncontractTime;}set{contractTime=value;}}privateDateTimecontractTime;Contract.cs,(EntityClass),,SQL,,SQL.ORM,ORM34//if(employee.Contract!=null){employee.Contract.EmployeeID=employee.OID;employee.Contract.CurrentUse=true;//OrmFuns.SaveSingleObject(employee.Contract,transNum);},SqlORM()()DataModel,ORMSQL5,,,ORM,ORM,,,,ORMORM,ORM44