/// <summary> /// 修改异常范围及指导建议 /// </summary> /// <param name="anomal"></param> /// <returns></returns> public int UpdateAnomaly(AnomalyRangeModel anomal) { string sql = @"UPDATE tbl_anomaly Set Sex='" + anomal.Sex + @"', RangeMin='" + anomal.RangeMin + @"', RangeMax='" + anomal.RangeMax + @"', GuidanceMin='" + anomal.GuidanceMin + @"', GuidanceMax='" + anomal.GuidanceMax + @"', preinstallId='" + anomal.PreinstallId + @"' WHERE id=" + anomal.id; return(MySQLHelper.ExecuteSql(sql)); }
/// <summary> /// 添加异常范围及指导建议 /// </summary> /// <returns></returns> public int AddAnomaly(AnomalyRangeModel anomal) { string sql = @"INSERT INTO tbl_anomaly (Sex,RangeMin,RangeMax,GuidanceMin,GuidanceMax,preinstallId) VALUES ('" + anomal.Sex + "','" + anomal.RangeMin + "','" + anomal.RangeMax + "','" + anomal.GuidanceMin + "','" + anomal.GuidanceMax + "','" + anomal.PreinstallId + "');SELECT @@IDENTITY "; object single = MySQLHelper.GetSingle(sql); if (single == null) { return(0); } return(Convert.ToInt32(single)); }
/// <summary> /// 修改异常范围及指导建议 /// </summary> /// <param name="anomal"></param> /// <returns></returns> public int UpdateAnomaly(AnomalyRangeModel model) { return(dal.UpdateAnomaly(model)); }
/// <summary> /// 添加异常范围及指导建议 /// </summary> /// <returns></returns> public int AddAnomaly(AnomalyRangeModel model) { return(dal.AddAnomaly(model)); }