源代码及运行界面1.model类a.Depart.csusingSystem。usingSystem.Collections.Generic。usingSystem.Linq。usingSystem.Text。namespacemodel{publicclassDepart{publicDepart(){}#regionmodelprivateint_departid。privatestring_departname。privateint_parentid。publicintDepartID{set{_departid=value。}get{return_departid。}}publicstringDepartName{set{_departname=value。}get{return_departname。}}publicintParentID{set{_parentid=value。}get{return_parentid。}}#endregionmodel}}b.Device.csusingSystem。usingSystem.Collections.Generic。usingSystem.Linq。usingSystem.Text。namespacemodel{publicclassDevice{publicDevice(){}#regionmodelprivateint_deviceid。privatestring_devicetypeid。privateint_typeid。privateint_classid。privatestring_devicestate。privateSingle_price。privateint_useofyear。privateSingle_svp。privatestring_manufacture。privateDateTime_stocktime。publicintDeviceID{set{_deviceid=value。}get{return_deviceid。}}publicstringDeviceTypeID{set{_devicetypeid=value。}get{return_devicetypeid。}}publicintTypeID{set{_typeid=value。}get{return_typeid。}}publicintClassID{set{_classid=value。}get{return_classid。}}publicstringDeviceState{set{_devicestate=value。}get{return_devicestate。}}publicSinglePrice{set{_price=value。}get{return_price。}}publicintUseOfYear{set{_useofyear=value。}get{return_useofyear。}}publicSingleSVP{set{_svp=value。}get{return_svp。}}publicstringManufacture{set{_manufacture=value。}get{return_manufacture。}}publicDateTimeStockDate{set{_stocktime=value。}get{return_stocktime。}}#endregionmodel}}c.DeviceClass.csusingSystem。usingSystem.Collections.Generic。usingSystem.Linq。usingSystem.Text。namespacemodel{publicclassDeviceClass{publicDeviceClass(){}#regionmodelprivateint_classid。privatestring_classname。privateint_typeid。publicintClassID{set{_classid=value。}get{return_classid。}}publicstringClassName{set{_classname=value。}get{return_classname。}}publicintTypeID{set{_typeid=value。}get{return_typeid。}}#endregionmodel}}d.DeviceType.csusingSystem。usingSystem.Collections.Generic。usingSystem.Linq。usingSystem.Text。namespacemodel{publicclassDeviceType{publicDeviceType(){}#regionmodelprivateint_typeid。privatestring_typename。publicintTypeID{set{_typeid=value。}get{return_typeid。}}publicstringTypeName{set{_typename=value。}get{return_typename。}}#endregionmodel}}e.RepairInfo.csusingSystem。usingSystem.Collections.Generic。usingSystem.Linq。usingSystem.Text。namespacemodel{publicclassRepairInfo{publicRepairInfo(){}#regionmodelprivateint_repairid。privateint_deviceid。privatestring_repairpeople。privateDateTime_beginrepairdate。privateSingle_repairprice。privateint_repairoftime。privatestring_faultcause。privatestring_remark。publicintRepairID{set{_repairid=value。}get{return_repairid。}}publicintDeviceID{set{_deviceid=value。}get{return_deviceid。}}publicstringRepairPeople{set{_repairpeople=value。}get{return_repairpeople。}}publicDateTimeBeginRepairDate{set{_beginrepairdate=value。}get{return_beginrepairdate。}}publicSingleRepairPrice{set{_repairprice=value。}get{return_repairprice。}}publicintRepairOfTime{set{_repairoftime=value。}get{return_repairoftime。}}publicstringFaultCause{set{_faultcause=value。}get{return_faultcause。}}publicstringRemark{set{_remark=value。}get{return_remark。}}#endregionmodel}}f.TransInfo.csusingSystem。usingSystem.Collections.Generic。usingSystem.Linq。usingSystem.Text。namespacemodel{publicclassTransInfo{publicTransInfo(){}#regionmodelprivateint_transid。privateint_deviceid。privateint_departid。privatestring_usepeople。privateDateTime_begintransdate。privateint_useofmonth。privatestring_remark。publicintTransID{set{_transid=value。}get{return_transid。}}publicintDeviceID{set{_deviceid=value。}get{return_deviceid。}}publicintDepartID{set{_departid=value。}get{return_departid。}}publicstringUsePeople{set{_usepeople=value。}get{return_usepeople。}}publicDateTimeBeginTransDate{set{_begintransdate=value。}get{return_begintransdate。}}publicintUseOfMonth{set{_useofmonth=value。}get{return_useofmonth。}}publicstringRemark{set{_remark=value。}get{return_remark。}}#endregionmodel}}g.UserLevel.csusingSystem。usingSystem.Collections.Generic。usingSystem.Linq。usingSystem.Text。namespacemodel{publicclassUserLevel{publicUserLevel(){}#regionmodelprivatestring_levelid。privatestring_levelname。privatestring_description。publicstringLevelID{set{_levelid=value。}get{return_levelid。}}publicstringLevelName{set{_levelname=value。}get{return_levelname。}}publicstringDescription{set{_description=value。}get{return_description。}}#endregionmodel}}h.Users.csusingSystem。usingSystem.Collections.Generic。usingSystem.Linq。usingSystem.Text。namespacemodel{publicclassUsers{publicUsers(){}#regionmodelprivatestring_userid。privatestring_userpwd。privatestring_levelid。publicstringUserID{set{_userid=value。}get{return_userid。}}publicstringUserPwd{set{_userpwd=value。}get{return_userpwd。}}publicstringLevelID{set{_levelid=value。}get{return_levelid。}}#endregionmodel}}2.DAL类a.Depart.csusingSystem。usingSystem.Collections.Generic。usingSystem.Linq。usingSystem.Text。usingSystem.Collections。usingSystem.Data。usingSystem.Data.SqlClient。namespaceDAL{publicclassDepart{sql