设备管理系统-源代码及运行界面.doc

精品文档就在这里
-------------各类专业好文档，值得你下载，教育，管理，论文，制度，方案手册，应有尽有--------------
--------------------------------------------------------------------------------------------------------------------------------------------

源代码及运行界面
1. model类
a． Depart.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace model
{
public class Depart
{
public Depart()
{ }

#region model
private int _departid;
private string _departname;
private int _parentid;

public int DepartID
{
set {_departid = value; }
get { return _departid; }
}

public string DepartName
{
set { _departname = value; }
get { return _departname; }
}

public int ParentID
{
set { _parentid = value; }
get { return _parentid; }
}
#endregion model
}
}
b． Device.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace model
{
public class Device
{
public Device()
{ }
#region model
private int _deviceid;
private string _devicetypeid;
private int _typeid;
private int _classid;
private string _devicestate;
private Single _price;
private int _useofyear;
private Single _svp;
private string _manufacture;
private DateTime _stocktime;

public int DeviceID
{
set { _deviceid = value; }
get { return _deviceid; }
}

public string DeviceTypeID
{
set { _devicetypeid = value; }
get { return _devicetypeid; }
}

public int TypeID
{
set { _typeid = value; }
get { return _typeid; }
}

public int ClassID
{
set { _classid = value;}
get { return _classid; }
}

public string DeviceState
{
set { _devicestate = value; }
get { return _devicestate; }
}

public Single Price
{
set { _price = value; }
get { return _price; }
}

public int UseOfYear
{
set { _useofyear = value; }
get { return _useofyear; }
}

public Single SVP
{
set { _svp = value; }
get { return _svp; }
}

public string Manufacture
{
set { _manufacture = value; }
get { return _manufacture; }
}

public DateTime StockDate
{
set { _stocktime = value; }
get { return _stocktime; }
}
#endregion model
}
}
c． DeviceClass.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace model
{
public class DeviceClass
{
public DeviceClass()
{ }

#region model
private int _classid;
private string _classname;
private int _typeid;

public int ClassID
{
set { _classid = value; }
get { return _classid; }
}

public string ClassName
{
set { _classname = value;}
get { return _classname; }
}

public int TypeID
{
set { _typeid = value; }
get { return _typeid; }
}

#endregion model
}
}
d． DeviceType.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace model
{
public class DeviceType
{
public DeviceType()
{ }

#region model

private int _typeid;
private string _typename;

public int TypeID
{
set { _typeid = value; }
get { return _typeid; }
}

public string TypeName
{
set { _typename = value; }
get { return _typename; }
}
#endregion model
}
}
e． RepairInfo.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace model
{
public class RepairInfo
{
public RepairInfo()
{ }

#region model
private int _repairid;
private int _deviceid;
private string _repairpeople;
private DateTime _beginrepairdate;
private Single _repairprice;
private int _repairoftime;
private string _faultcause;
private string _remark;

public int RepairID
{
set { _repairid = value; }
get { return _repairid; }
}

public int DeviceID
{
set { _deviceid = value; }
get { return _deviceid; }
}

public string RepairPeople
{
set { _repairpeople = value; }
get { return _repairpeople; }
}

public DateTime BeginRepairDate
{
set { _beginrepairdate = value; }
get { return _beginrepairdate; }
}

public Single RepairPrice
{
set { _repairprice = value; }
get { return _repairprice; }
}

public int RepairOfTime
{
set { _repairoftime = value; }
get { return _repairoftime; }
}

public string FaultCause
{
set { _faultcause = value; }
get { return _faultcause; }
}

public string Remark
{
set { _remark = value; }
get { return _remark; }
}

#endregion model
}
}
f． TransInfo.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace model
{
public class TransInfo
{
public TransInfo()
{ }

#region model

private int _transid;
private int _deviceid;
private int _departid;
private string _usepeople;
private DateTime _begintransdate;
private int _useofmonth;
private string _remark;

public int TransID
{
set { _transid = value; }
get { return _transid; }
}

public int DeviceID
{
set { _deviceid = value; }
get { return _deviceid; }
}

public int DepartID
{
set { _departid = value; }
get { return _departid; }
}

public string UsePeople
{
set { _usepeople = value; }
get { return _usepeople; }
}

public DateTime BeginTransDate
{
set { _begintransdate = value; }
get { return _begintransdate; }
}

public int UseOfMonth
{
set { _useofmonth = value; }
get { return _useofmonth; }
}

public string Remark
{
set { _remark = value; }
get { return _remark; }
}
#endregion model
}
}
g． UserLevel.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace model
{
public class UserLevel
{
public UserLevel()
{ }

#region model

private string _levelid;
private string _levelname;
private string _description;

public string LevelID
{
set { _levelid = value; }
get { return _levelid; }
}

public string LevelName
{
set { _levelname = value; }
get { return _levelname; }
}

public string Description
{
set { _description = value; }
get { return _description; }
}
#endregion model
}
}
h． Users.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace model
{
public class Users
{
public Users()
{ }

#region model

private string _userid;
private string _userpwd;
private string _levelid;

public string UserID
{
set { _userid = value; }
get { return _userid; }
}

public string UserPwd
{
set { _userpwd = value; }
get { return _userpwd; }
}

public string LevelID
{
set { _levelid = value; }
get { return _levelid; }
}

#endregion model
}
}
2. DAL类
a． Depart.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Collections;
using System.Data;
using System.Data.SqlClient;

namespace DAL
{
public class Depart
{
sqlhelp sql = new sqlhelp();
public Depart()
{ }

#region 成员方法
public ArrayList GetListByParentID(int pid)
{
ArrayList al = new ArrayList();
string s = "select * from Depart where ParentID=" + pid;
DataTable dt = null;
dt = sql.Execusql(s);
for (int i = 0; i < dt.Rows.Count; i++)
{
model.Depart modeldepart = new model.Depart();
modeldepart.DepartID = Convert.ToInt32(dt.Rows[i]["DepartID"]);
modeldepart.ParentID = Convert.ToInt32dt.Rows[i]["ParentID"]);
modeldepart.DepartName = dt.Rows[i]["DepartName"].ToString();
al.Add(modeldepart);
}
return al;

}

public int Insert(model.Depart mod)
{
int n = 0;
string s = "Insert into Depart(DepartName,ParentID) values('" + mod.DepartName + "'," + mod.ParentID + ")";
n = sql.Execsql(s);
return n;
}

public ArrayList GetList()
{
ArrayList al = new ArrayList();
string s = "select * from Depart where DepartID!=1";
DataTable dt = null;
dt = sql.Execusql(s);
for (int i = 0; i < dt.Rows.Count; i++)
{
model.Depart modeldepart = new model.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);
}
return al;
}

public DataTable GetDepartList(string strwhere)
{
DataTable dt = null;
string s = "select * from View2 where " + strwhere;
if (strwhere == "")
s = "select * from View2";
dt = sql.Execusql(s);
return dt;
}

public DataTable GetDepartByID(int id)
{
DataTable dt = null;
string s = "select * from Depart where DepartID="+id;
dt = sql.Execusql(s);
return dt;
}

public int Update(model.Depart mod)
{
int n = 0;
string s = "Update Depart Set DepartName='" + mod.DepartName + "',ParentID=" + mod.ParentID + " where DepartID=" + mod.DepartID;
n = sql.Execsql(s);
return n;
}

public int Delete(int id)
{
int n = 0;
string s = "delete from Depart where DepartID="+id;
n = sql.Execsql(s);
return n;
}
#endregion 成员方法
}
}
b． Device.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;

namespace DAL
{
public class Device
{
sqlhelp sql = new sqlhelp();
public Device()
{ }

#region 成员方法

public DataTable GetDeviceByID(int deviceid)
{
string s = "select * from Device where DeviceID=" + deviceid;
DataTable dt = null;
dt = sql.Execusql(s);
return dt;

}
public int Insert(model.Device modeldevice)
{
int n = 0;
string s = "Insert into Device values(" + modeldevice.DeviceID + ",'" + modeldevice.DeviceTypeID + "'," + modeldevice.TypeID + ","+modeldevice.ClassID+",'" + modeldevice.DeviceState + "'," + modeldevice.Price + "," + modeldevice.UseOfYear+ "," + modeldevice.SVP+ ",'" + modeldevice.Manufacture+ "','"+modeldevice.StockDate+"')";
n = sql.Execsql(s);
return n;
}

public DataTable GetList(string strwhere)
{
DataTable dt = null;
string s = "Select * from View1 where " + strwhere;
if (strwhere == "")
{
s = "select * from View1";
}

dt = sql.Execusql(s);
return dt;
}

public DataTable GetDeviceList(string strwhere)
{
DataTable dt = null;
string s = "Select * from Device where " + strwhere;
if (strwhere == "")
{
s = "select * from Device";
}

dt = sql.Execusql(s);
return dt;
}

public int Delete(int id)
{
int n = 0;
string s = "delete from Device where DeviceID=" +id;
n = sql.Execsql(s);
return n;
}

public int Update(model.Device mod)
{
int n = 0;
string s = "Update Device set DeviceState='" + mod.DeviceState + "',TypeID="+mod.TypeID+",ClassID="+mod.ClassID+", DeviceTypeID='" + mod.DeviceTypeID + "',Price=" + mod.Price + ",SVP=" + mod.SVP + "StockDate='" + mod.StockDate + "',Manufacture='" + mod.Manufacture + "',UseOfYear=" + mod.UseOfYear + " where DeviceID=" + mod.DeviceID ;
n = sql.Execsql(s);
return n;
}
#endregion 成员方法
}
}
c． DeviceClass.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;

namespace DAL
{
public class DeviceClass
{
sqlhelp sql = new sqlhelp();
public DeviceClass()
{ }

#region 成员方法
public DataTable GetClass(