设备管理系统 源代码及运行界面Word格式.docx

设备管理系统 源代码及运行界面Word格式.docx

《设备管理系统 源代码及运行界面Word格式.docx》由会员分享，可在线阅读，更多相关《设备管理系统 源代码及运行界面Word格式.docx（92页珍藏版）》请在冰点文库上搜索。

set{_parentid=value;

}get{return_parentid;

#endregionmodel

}b．Device.cs

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;

c}．DeviceClass.cs

publicclassDeviceClass

publicDeviceClass（）

#regionmodelprivateint_classid;

privatestring_classname;

}get{return_classid;

publicstringClassName

set{_classname=value;

}get{return_classname;

get{return_typeid;

}d．DeviceType.cs

publicclassDeviceType

publicDeviceType（）

#regionmodelprivateint_typeid;

privatestring_typename;

publicstringTypeName

set{_typename=value;

}get{return_typename;

}e．RepairInfo.csusingSystem;

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;

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;

}f．

TransInfo.cs

publicclassTransInfo

publicTransInfo（）

#regionmodel

privateint_transid;

privateint_departid;

privatestring_usepeople;

privateDateTime_begintransdate;

privateint_useofmonth;

privatestring_remark;

publicintTransID

set{_transid=value;

}get{return_transid;

set{_departid=value;

publicstringUsePeople

set{_usepeople=value;

}get{return_usepeople;

publicDateTimeBeginTransDate

set{_begintransdate=value;

}get{return_begintransdate;

publicintUseOfMonth

set{_useofmonth=value;

}get{return_useofmonth;

g}．UserLevel.cs

publicclassUserLevel

publicUserLevel（）

privatestring_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;

}h．Users.cs

publicclassUsers

publicUsers（）

#regionmodelprivatestring_userid;

privatestring_userpwd;

privatestring_levelid;

publicstringUserID

set{_userid=value;

}get{return_userid;

publicstringUserPwd

set{_userpwd=value;

}get{return_userpwd;

2.D}AL类

usingSystem.Collections;

usingSystem.Data;

usingSystem.Data.SqlClient;

namespaceDAL

sqlhelpsql=newsqlhelp（）;

publicDepart（）

#region成员方法

publicArrayListGetListByParentID（intpid）

ArrayListal=newArrayList（）;

strings="

select*fromDepartwhereParentID="

+pid;

DataTabledt=null;

dt=sql.Execusql（s）;

for（inti=0;

i<

dt.Rows.Count;

i++）

model.Departmodeldepart=newmodel.Depart（）;

modeldepart.DepartID=Convert.ToInt32（dt.Rows[i]["

DepartID"

]）;

modeldepart.ParentID=Convert.ToInt32（dt.Rows[i]["

ParentID"

modeldepart.DepartName=dt.Rows[i]["

DepartName"

].ToString（）;

al.Add（modeldepart）;

returnal;

publicintInsert（model.Departmod）

intn=0;

InsertintoDepart（DepartName,ParentID）values（'

"

+mod.DepartName+"

'

"

+mod.ParentID+"

）"

;

n=sql.Execsql（s）;

returnn;

publicArrayListGetList（）

select*fromDepartwhereDepartID!

=1"

publicDataTableGetDepartList（stringstrwhere）

DataTabledt=null;

select*fromView2where"

+strwhere;

if（strwhere=="

）

s="

select*fromView2"

returndt;

publicDataTableGetDepartByID（intid）

select*fromDepartwhereDepartID="

+id;

dt=sql.Execusql（s）;

returndt;

publicintUpdate（model.Departmod）

UpdateDepartSetDepartName='

+mod.DepartName+"

ParentID="

whereDepartID="

+mod.DepartID;

publicintDelete（intid）

deletefromDepartwhereDepartID="

n=sql.Execsql（s）;

returnn;

#endregion成员方法

b}．Device.cs

publicDevice（）

publicDataTableGetDeviceByID（intdeviceid）

select*fromDevicewhereDeviceID="

+deviceid;

publicintInsert（model.Devicemodeldevice）

InsertintoDevicevalues（"

+modeldevice.DeviceID+"

'

+modeldevice.DeviceTypeID+"

+modeldevice.TypeID+"

+modeldevice.ClassID+"

+modeldevice.DeviceState+"

+modeldevice.Price+"

+modeldevice.UseOfYear+"

+modeldevice.SVP+"

+modeldevice.Manufacture+"

+modeldevice.StockDate+"

publicDataTableGetList（stringstrwhere）

Select*fromView1where"

select*fromView1"

publicDataTableGetDeviceList（stringstrwhere）

Select*fromDevicewhere"

select*fromDevice"

deletefromDevicewhereDeviceID="

+id;

publicintUpdate（model.Devicemod）

UpdateDevicesetDeviceState='

+mod.DeviceState+"

TypeID="

+mod.TypeID+"

ClassID="

+mod.ClassID+"

DeviceTypeID='

+mod.DeviceTypeID+"

Price="

+mod.Price+