/// <summary> /// 修改建议指导 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Update(HealthGuidanceModel model) { string sql = @"UPDATE tbl_HealthGuidance SET GreaterThanRecom = @GreaterThanRecom ,LessThanRecom = @LessThanRecom ,MiddleThanRecom = @MiddleThanRecom ,Title = @Title ,Code=@Code ,Sex=@Sex ,Type=@Type WHERE ID = @ID"; MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("@ID", MySqlDbType.Int32), new MySqlParameter("@GreaterThanRecom", MySqlDbType.Text), new MySqlParameter("@LessThanRecom", MySqlDbType.Text), new MySqlParameter("@MiddleThanRecom", MySqlDbType.Text), new MySqlParameter("@Title", MySqlDbType.String, 50), new MySqlParameter("@Code", MySqlDbType.String, 50), new MySqlParameter("@Sex", MySqlDbType.String, 1), new MySqlParameter("@Type", MySqlDbType.Int32) }; cmdParms[0].Value = model.ID; cmdParms[1].Value = model.GreaterThanRecom; cmdParms[2].Value = model.LessThanRecom; cmdParms[3].Value = model.MiddleThanRecom; cmdParms[4].Value = model.Title; cmdParms[5].Value = model.Code; cmdParms[5].Value = model.Sex; cmdParms[6].Value = model.Type; return(MySQLHelper.ExecuteSql(sql, cmdParms)); }
/// <summary> /// 添加建议指导 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Insert(HealthGuidanceModel model) { string sql = @"INSERT INTO tbl_HealthGuidance ( GreaterThanRecom ,LessThanRecom ,MiddleThanRecom ,Title ,Code ,Sex ,Type ) VALUES ( @GreaterThanRecom ,@LessThanRecom ,@MiddleThanRecom ,@Title ,@Code ,@Sex ,@Type )"; MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("@GreaterThanRecom", MySqlDbType.Text), new MySqlParameter("@LessThanRecom", MySqlDbType.Text), new MySqlParameter("@MiddleThanRecom", MySqlDbType.Text), new MySqlParameter("@Title", MySqlDbType.String, 50), new MySqlParameter("@Code", MySqlDbType.String, 50), new MySqlParameter("@Sex", MySqlDbType.String, 1), new MySqlParameter("@Type", MySqlDbType.Int32) }; cmdParms[0].Value = model.GreaterThanRecom; cmdParms[1].Value = model.LessThanRecom; cmdParms[2].Value = model.MiddleThanRecom; cmdParms[3].Value = model.Title; cmdParms[4].Value = model.Code; cmdParms[5].Value = model.Sex; cmdParms[6].Value = model.Type; return(MySQLHelper.ExecuteSql(sql, cmdParms)); }
/// <summary> /// 修改建议指导 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Update(HealthGuidanceModel model) { return(dal.Update(model)); }
/// <summary> /// 添加建议指导 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Insert(HealthGuidanceModel model) { return(dal.Insert(model)); }