/// <summary>
 /// 插入t_MonitorServerParam
 /// </summary>
 public virtual bool Insert(MonitorServerParamOR monitorServerParam)
 {
     string sql = "insert into t_MonitorServerParam (ParamID, ParamName, ParamAddr, Param, StationID, StationName, IsCheck, IsSmsCheck) values (@ParamID, @ParamName, @ParamAddr, @Param, @StationID, @StationName, @IsCheck, @IsSmsCheck)";
     SqlParameter [] parameters = new SqlParameter[]
     {
         new SqlParameter("@ParamID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "ParamID", DataRowVersion.Default, monitorServerParam.Paramid),
         new SqlParameter("@ParamName", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "ParamName", DataRowVersion.Default, monitorServerParam.Paramname),
         new SqlParameter("@ParamAddr", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "ParamAddr", DataRowVersion.Default, monitorServerParam.Paramaddr),
         new SqlParameter("@Param", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Param", DataRowVersion.Default, monitorServerParam.Param),
         new SqlParameter("@StationID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "StationID", DataRowVersion.Default, monitorServerParam.Stationid),
         new SqlParameter("@StationName", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "StationName", DataRowVersion.Default, monitorServerParam.Stationname),
         new SqlParameter("@IsCheck", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "IsCheck", DataRowVersion.Default, monitorServerParam.Ischeck),
         new SqlParameter("@IsSmsCheck", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "IsSmsCheck", DataRowVersion.Default, monitorServerParam.Issmscheck)
     };
     return db.ExecuteNoQuery(sql, parameters) > -1;
 }
 public MonitorServerParamOR selectARowDate(string m_id)
 {
     string sql = string.Format("select * from t_MonitorServerParam where  Paramid='{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];
     MonitorServerParamOR m_Moni=new MonitorServerParamOR(dr);
      return m_Moni;
 }
 /// <summary>
 /// 更新t_MonitorServerParam
 /// </summary>
 public virtual bool Update(MonitorServerParamOR monitorServerParam)
 {
     string sql = "update t_MonitorServerParam set  ParamName = @ParamName,  ParamAddr = @ParamAddr,  Param = @Param,  StationID = @StationID,  StationName = @StationName,  IsCheck = @IsCheck,  IsSmsCheck = @IsSmsCheck where  ParamID = @ParamID";
     SqlParameter [] parameters = new SqlParameter[]
     {
         new SqlParameter("@ParamID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "ParamID", DataRowVersion.Default, monitorServerParam.Paramid),
         new SqlParameter("@ParamName", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "ParamName", DataRowVersion.Default, monitorServerParam.Paramname),
         new SqlParameter("@ParamAddr", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "ParamAddr", DataRowVersion.Default, monitorServerParam.Paramaddr),
         new SqlParameter("@Param", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Param", DataRowVersion.Default, monitorServerParam.Param),
         new SqlParameter("@StationID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "StationID", DataRowVersion.Default, monitorServerParam.Stationid),
         new SqlParameter("@StationName", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "StationName", DataRowVersion.Default, monitorServerParam.Stationname),
         new SqlParameter("@IsCheck", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "IsCheck", DataRowVersion.Default, monitorServerParam.Ischeck),
         new SqlParameter("@IsSmsCheck", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "IsSmsCheck", DataRowVersion.Default, monitorServerParam.Issmscheck)
     };
     return db.ExecuteNoQuery(sql, parameters) > -1;
 }