/// <summary>
/// 插入t_MonitorSystemParam
/// </summary>
public virtual bool Insert(t_MonitorSystemParam monitorSystemParam)
{
string sql = "insert into t_MonitorSystemParam (MonitorRefreshTime, StartScreenID, AlarmLogTime, ServerIP, ServerPort, Door_Sysid, Door_Com, HaveDoor) values (@MonitorRefreshTime, @StartScreenID, @AlarmLogTime, @ServerIP, @ServerPort, @Door_Sysid, @Door_Com, @HaveDoor)";
SqlParameter [] parameters = new SqlParameter[]
{
new SqlParameter("@MonitorRefreshTime", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "MonitorRefreshTime", DataRowVersion.Default, monitorSystemParam.MonitorRefreshTime),
new SqlParameter("@StartScreenID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "StartScreenID", DataRowVersion.Default, monitorSystemParam.StartScreenID),
new SqlParameter("@AlarmLogTime", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "AlarmLogTime", DataRowVersion.Default, monitorSystemParam.AlarmLogTime),
new SqlParameter("@ServerIP", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "ServerIP", DataRowVersion.Default, monitorSystemParam.ServerIP),
new SqlParameter("@ServerPort", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "ServerPort", DataRowVersion.Default, monitorSystemParam.ServerPort),
new SqlParameter("@Door_Sysid", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Door_Sysid", DataRowVersion.Default, monitorSystemParam.Door_Sysid),
new SqlParameter("@Door_Com", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "Door_Com", DataRowVersion.Default, monitorSystemParam.Door_Com),
new SqlParameter("@HaveDoor", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "HaveDoor", DataRowVersion.Default, monitorSystemParam.HaveDoor)
};
return db.ExecuteNoQuery(sql, parameters) > -1;
}
public List<t_MonitorSystemParam> selectAllDate()
{
string sql = "select * from t_MonitorSystemParam";
DataTable dt = null;
try
{
dt = db.ExecuteQuery(sql);
}
catch (Exception ex)
{
throw ex;
}
List<t_MonitorSystemParam> _List = new List<t_MonitorSystemParam>();
foreach (DataRow dr in dt.Rows)
{
t_MonitorSystemParam obj = new t_MonitorSystemParam(dr);
_List.Add(obj);
}
return _List;
}
public t_MonitorSystemParam selectARowDate(string m_id)
{
string sql = string.Format("select * from t_MonitorSystemParam where Monitorrefreshtime='{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_MonitorSystemParam m_Moni=new t_MonitorSystemParam(dr);
return m_Moni;
}
/// <summary>
/// 更新t_MonitorSystemParam
/// </summary>
public virtual bool Update(t_MonitorSystemParam monitorSystemParam)
{
string sql = "update t_MonitorSystemParam set StartScreenID = @StartScreenID, AlarmLogTime = @AlarmLogTime, ServerIP = @ServerIP, ServerPort = @ServerPort, Door_Sysid = @Door_Sysid, Door_Com = @Door_Com, HaveDoor = @HaveDoor where MonitorRefreshTime = @MonitorRefreshTime";
SqlParameter [] parameters = new SqlParameter[]
{
new SqlParameter("@MonitorRefreshTime", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "MonitorRefreshTime", DataRowVersion.Default, monitorSystemParam.MonitorRefreshTime),
new SqlParameter("@StartScreenID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "StartScreenID", DataRowVersion.Default, monitorSystemParam.StartScreenID),
new SqlParameter("@AlarmLogTime", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "AlarmLogTime", DataRowVersion.Default, monitorSystemParam.AlarmLogTime),
new SqlParameter("@ServerIP", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "ServerIP", DataRowVersion.Default, monitorSystemParam.ServerIP),
new SqlParameter("@ServerPort", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "ServerPort", DataRowVersion.Default, monitorSystemParam.ServerPort),
new SqlParameter("@Door_Sysid", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Door_Sysid", DataRowVersion.Default, monitorSystemParam.Door_Sysid),
new SqlParameter("@Door_Com", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "Door_Com", DataRowVersion.Default, monitorSystemParam.Door_Com),
new SqlParameter("@HaveDoor", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "HaveDoor", DataRowVersion.Default, monitorSystemParam.HaveDoor)
};
return db.ExecuteNoQuery(sql, parameters) > -1;
}
public void Clone(t_MonitorSystemParam obj)
{
//
MonitorRefreshTime = obj.MonitorRefreshTime;
//
StartScreenID = obj.StartScreenID;
//报警框刷新时间
AlarmLogTime = obj.AlarmLogTime;
//
ServerIP = obj.ServerIP;
//
ServerPort = obj.ServerPort;
//
Door_Sysid = obj.Door_Sysid;
//
Door_Com = obj.Door_Com;
//
HaveDoor = obj.HaveDoor;
}
/// <summary>
/// 加载参数完成！
/// </summary>
/// <param name="result"></param>
private void LoadParmCompleted()
{
try
{
var result = new MonitorSystemParamDA().selectAllDate();
if (result.Count == 0)
{
ErrorMsg += "未设置系统参数！\n";
}
else
{
SystemParam = result.First();
}
LoadCommpleteNumber++;
InitComplete();
}
catch (Exception ex)
{
LoadCommpleteNumber++;
ErrorMsg += "无法加载系统参数数据！\n";
InitComplete();
return;
}
}