/// <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;
}
