/// <summary> /// 插入t_Device /// </summary> public virtual bool Insert(t_Device device) { string sql = "insert into t_Device (DeviceID, DeviceName, CommunicateType, CommunicateID, SubAddr, DeviceTypeID, StationID, StationName, IP, UserId, Password, Enable, Port) values (@DeviceID, @DeviceName, @CommunicateType, @CommunicateID, @SubAddr, @DeviceTypeID, @StationID, @StationName, @IP, @UserId, @Password, @Enable, @Port)"; SqlParameter [] parameters = new SqlParameter[] { new SqlParameter("@DeviceID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "DeviceID", DataRowVersion.Default, device.DeviceID), new SqlParameter("@DeviceName", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "DeviceName", DataRowVersion.Default, device.DeviceName), new SqlParameter("@CommunicateType", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "CommunicateType", DataRowVersion.Default, device.Communicatetype), new SqlParameter("@CommunicateID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "CommunicateID", DataRowVersion.Default, device.CommunicateID), new SqlParameter("@SubAddr", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "SubAddr", DataRowVersion.Default, device.SubAddr), new SqlParameter("@DeviceTypeID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "DeviceTypeID", DataRowVersion.Default, device.DeviceTypeID), new SqlParameter("@StationID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "StationID", DataRowVersion.Default, device.StationID), new SqlParameter("@StationName", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "StationName", DataRowVersion.Default, device.StationName), new SqlParameter("@IP", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "IP", DataRowVersion.Default, device.IP), new SqlParameter("@UserId", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "UserId", DataRowVersion.Default, device.UserID), new SqlParameter("@Password", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Password", DataRowVersion.Default, device.Password), new SqlParameter("@Enable", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "Enable", DataRowVersion.Default, device.Enable), new SqlParameter("@Port", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "Port", DataRowVersion.Default, device.Port) }; return db.ExecuteNoQuery(sql, parameters) > -1; }
public List<t_Device> GetDevicesByStationId(int stationId) { string sql = "select * from t_Device where StationID = " + stationId; DataTable dt = null; try { dt = db.ExecuteQuery(sql); } catch (Exception ex) { throw ex; } List<t_Device> _List = new List<t_Device>(); foreach (DataRow dr in dt.Rows) { t_Device obj = new t_Device(dr); _List.Add(obj); } return _List; }
public ObservableCollection<t_Device> selectAllDate() { string sql = "select * from t_Device"; DataTable dt = null; try { dt = db.ExecuteQuery(sql); } catch (Exception ex) { throw ex; } ObservableCollection<t_Device> _List = new ObservableCollection<t_Device>(); foreach (DataRow dr in dt.Rows) { t_Device obj = new t_Device(dr); _List.Add(obj); } return _List; }
/// <summary> /// 更新t_Device /// </summary> public virtual bool Update(t_Device device) { string sql = "update t_Device set DeviceName = @DeviceName, CommunicateType = @CommunicateType, CommunicateID = @CommunicateID, SubAddr = @SubAddr, DeviceTypeID = @DeviceTypeID, StationID = @StationID, StationName = @StationName, IP = @IP, UserId = @UserId, Password = @Password, Enable = @Enable, Port = @Port where DeviceID = @DeviceID"; SqlParameter [] parameters = new SqlParameter[] { new SqlParameter("@DeviceID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "DeviceID", DataRowVersion.Default, device.DeviceID), new SqlParameter("@DeviceName", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "DeviceName", DataRowVersion.Default, device.DeviceName), new SqlParameter("@CommunicateType", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "CommunicateType", DataRowVersion.Default, device.Communicatetype), new SqlParameter("@CommunicateID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "CommunicateID", DataRowVersion.Default, device.CommunicateID), new SqlParameter("@SubAddr", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "SubAddr", DataRowVersion.Default, device.SubAddr), new SqlParameter("@DeviceTypeID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "DeviceTypeID", DataRowVersion.Default, device.DeviceTypeID), new SqlParameter("@StationID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "StationID", DataRowVersion.Default, device.StationID), new SqlParameter("@StationName", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "StationName", DataRowVersion.Default, device.StationName), new SqlParameter("@IP", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "IP", DataRowVersion.Default, device.IP), new SqlParameter("@UserId", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "UserId", DataRowVersion.Default, device.UserID), new SqlParameter("@Password", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Password", DataRowVersion.Default, device.Password), new SqlParameter("@Enable", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "Enable", DataRowVersion.Default, device.Enable), new SqlParameter("@Port", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "Port", DataRowVersion.Default, device.Port) }; return db.ExecuteNoQuery(sql, parameters) > -1; }
public t_Device selectARowDate(string m_id) { string sql = string.Format("select * from t_Device where Deviceid='{0}'",m_id); DataTable dt = null; try { dt = db.ExecuteQueryDataSet(sql).Tables[0]; } catch (Exception ex) { throw ex; } if (dt == null) return null; if (dt.Rows.Count == 0) return null; DataRow dr = dt.Rows[0]; t_Device m_Devi=new t_Device(dr); return m_Devi; }
public void Clone(t_Device obj) { // DeviceID = obj.DeviceID; // DeviceName = obj.DeviceName; // Communicatetype = obj.Communicatetype; // CommunicateID = obj.CommunicateID; // SubAddr = obj.SubAddr; // DeviceTypeID = obj.DeviceTypeID; // StationID = obj.StationID; // StationName = obj.StationName; // IP = obj.IP; // UserID = obj.UserID; // Password = obj.Password; // Enable = obj.Enable; // Port = obj.Port; }