/// <summary> /// 插入t_Channel /// </summary> public virtual bool Insert(t_Channel channel) { string sql = "insert into t_Channel (DeviceID, ChannelNo, ChannelName, Value0_Name, Value1_Name, CurrentValue, ChannelParam) values (@DeviceID, @ChannelNo, @ChannelName, @Value0_Name, @Value1_Name, @CurrentValue, @ChannelParam)"; SqlParameter [] parameters = new SqlParameter[] { new SqlParameter("@DeviceID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "DeviceID", DataRowVersion.Default, channel.DeviceID), new SqlParameter("@ChannelNo", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "ChannelNo", DataRowVersion.Default, channel.ChannelNo), new SqlParameter("@ChannelName", SqlDbType.NVarChar, 512, ParameterDirection.Input, false, 0, 0, "ChannelName", DataRowVersion.Default, channel.ChannelName), new SqlParameter("@Value0_Name", SqlDbType.NVarChar, 256, ParameterDirection.Input, false, 0, 0, "Value0_Name", DataRowVersion.Default, channel.Value0Name), new SqlParameter("@Value1_Name", SqlDbType.NVarChar, 256, ParameterDirection.Input, false, 0, 0, "Value1_Name", DataRowVersion.Default, channel.Value1Name), new SqlParameter("@CurrentValue", SqlDbType.Float, 8, ParameterDirection.Input, false, 0, 0, "CurrentValue", DataRowVersion.Default, channel.CurrentValue), new SqlParameter("@ChannelParam", SqlDbType.NVarChar, 256, ParameterDirection.Input, false, 0, 0, "ChannelParam", DataRowVersion.Default, channel.ChannelParam) }; return db.ExecuteNoQuery(sql, parameters) > -1; }
public ObservableCollection<t_Channel> selectAllDate() { string sql = "select * from t_Channel"; DataTable dt = null; try { dt = db.ExecuteQuery(sql); } catch (Exception ex) { throw ex; } ObservableCollection<t_Channel> _List = new ObservableCollection<t_Channel>(); foreach (DataRow dr in dt.Rows) { t_Channel obj = new t_Channel(dr); _List.Add(obj); } return _List; }
public void Clone(t_Channel obj) { // DeviceID = obj.DeviceID; // ChannelNo = obj.ChannelNo; // ChannelName = obj.ChannelName; // Value0Name = obj.Value0Name; // Value1Name = obj.Value1Name; // CurrentValue = obj.CurrentValue; // ChannelParam = obj.ChannelParam; }
public t_Channel selectARowDate(string m_id) { string sql = string.Format("select * from t_Channel 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_Channel m_Chan=new t_Channel(dr); return m_Chan; }
/// <summary> /// 更新t_Channel /// </summary> public virtual bool Update(t_Channel channel) { string sql = "update t_Channel set ChannelNo = @ChannelNo, ChannelName = @ChannelName, Value0_Name = @Value0_Name, Value1_Name = @Value1_Name, CurrentValue = @CurrentValue, ChannelParam = @ChannelParam where DeviceID = @DeviceID"; SqlParameter [] parameters = new SqlParameter[] { new SqlParameter("@DeviceID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "DeviceID", DataRowVersion.Default, channel.DeviceID), new SqlParameter("@ChannelNo", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "ChannelNo", DataRowVersion.Default, channel.ChannelNo), new SqlParameter("@ChannelName", SqlDbType.NVarChar, 512, ParameterDirection.Input, false, 0, 0, "ChannelName", DataRowVersion.Default, channel.ChannelName), new SqlParameter("@Value0_Name", SqlDbType.NVarChar, 256, ParameterDirection.Input, false, 0, 0, "Value0_Name", DataRowVersion.Default, channel.Value0Name), new SqlParameter("@Value1_Name", SqlDbType.NVarChar, 256, ParameterDirection.Input, false, 0, 0, "Value1_Name", DataRowVersion.Default, channel.Value1Name), new SqlParameter("@CurrentValue", SqlDbType.Float, 8, ParameterDirection.Input, false, 0, 0, "CurrentValue", DataRowVersion.Default, channel.CurrentValue), new SqlParameter("@ChannelParam", SqlDbType.NVarChar, 256, ParameterDirection.Input, false, 0, 0, "ChannelParam", DataRowVersion.Default, channel.ChannelParam) }; return db.ExecuteNoQuery(sql, parameters) > -1; }
public List<t_Channel> selectBy(int deviceID) { string sql = "select * from t_Channel where DeviceID=" + deviceID; DataTable dt = null; try { dt = db.ExecuteQuery(sql); } catch (Exception ex) { throw ex; } List<t_Channel> _List = new List<t_Channel>(); foreach (DataRow dr in dt.Rows) { t_Channel obj = new t_Channel(dr); _List.Add(obj); } return _List; }