/// <summary>
/// 修改运行监控展示信息
/// </summary>
/// <param name="comm"></param>
/// <returns></returns>
public int UpdateContentID(ViewMonitorContentModel content)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update monitorcontent set ");
strSql.Append("devhouseID=@devhouseID,");
strSql.Append("sysType=@sysType,");
strSql.Append("contentCode=@contentCode,");
strSql.Append("contentName=@contentName,");
strSql.Append("isDel=@isDel");
strSql.Append(" where tID=@tID");
MySqlParameter[] parameters =
{
new MySqlParameter("@devhouseID", MySqlDbType.Int32, 10),
new MySqlParameter("@sysType", MySqlDbType.Int32, 10),
new MySqlParameter("@contentCode", MySqlDbType.VarChar, 20),
new MySqlParameter("@contentName", MySqlDbType.VarChar, 20),
new MySqlParameter("@isDel", MySqlDbType.Bit),
new MySqlParameter("@tID", MySqlDbType.Int32, 10)
};
parameters[0].Value = content.DevhouseID;
parameters[1].Value = content.SysType;
parameters[2].Value = content.ContentCode;
parameters[3].Value = content.ContentName;
parameters[4].Value = content.IsDel;
parameters[5].Value = content.TID;
return(MySQLHelper.ExecuteNonQuery(strSql.ToString(), parameters));
}
/// <summary>
/// 添加小区
/// </summary>
/// <param name="community"></param>
/// <returns></returns>
public int AddContent(ViewMonitorContentModel content)
{
string strsql = @"INSERT INTO monitorcontent
(devhouseID,sysType,contentCode,contentName,isDel)
VALUES(" + content.DevhouseID + "," + content.SysType + ",'" + content.ContentCode +
"','" + content.ContentName + "',0);";
return(MySQLHelper.ExecuteNonQuery(string.Format(strsql), null));
}
/// <summary>
/// 修改运行监控展示信息
/// </summary>
/// <param name="comm"></param>
/// <returns></returns>
public int UpdateContent(ViewMonitorContentModel content)
{
return(mcDal.UpdateContentID(content));
}
/// <summary>
/// 添加运行监控展示信息
/// </summary>
/// <param name="community"></param>
/// <returns></returns>
public int AddContent(ViewMonitorContentModel content)
{
return(mcDal.AddContent(content));
}
