/// <summary> /// 更新一条数据 /// </summary> public bool Update(BMIAssessSetModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("UPDATE tbl_BMIAssessSet SET "); strSql.Append("IsShowNum=@IsShowNum,"); strSql.Append("Unit=@Unit,"); strSql.Append("ExceptionCol=@ExceptionCol,"); strSql.Append("IncludeEqual=@IncludeEqual,"); strSql.Append("Thin=@Thin,"); strSql.Append("ThinContent=@ThinContent,"); strSql.Append("ThinContent2=@ThinContent2,"); strSql.Append("ThinContent3=@ThinContent3,"); strSql.Append("Overweight=@Overweight,"); strSql.Append("OverweightContent=@OverweightContent,"); strSql.Append("OverweightContent2=@OverweightContent2,"); strSql.Append("OverweightContent3=@OverweightContent3,"); strSql.Append("Obesity=@Obesity,"); strSql.Append("ObesityContent=@ObesityContent,"); strSql.Append("ObesityContent2=@ObesityContent2,"); strSql.Append("ObesityContent3=@ObesityContent3,"); strSql.Append("LastUpDateBy=@LastUpDateBy,"); strSql.Append("LastUpdateDate=@LastUpdateDate"); strSql.Append(" WHERE ID=@ID"); MySqlParameter[] parameters = { new MySqlParameter("@IsShowNum", MySqlDbType.VarChar, 1), new MySqlParameter("@Unit", MySqlDbType.VarChar, 10), new MySqlParameter("@ExceptionCol", MySqlDbType.VarChar, 20), new MySqlParameter("@IncludeEqual", MySqlDbType.VarChar, 1), new MySqlParameter("@Thin", MySqlDbType.Decimal, 10), new MySqlParameter("@ThinContent", MySqlDbType.VarChar, 50), new MySqlParameter("@ThinContent2", MySqlDbType.VarChar, 50), new MySqlParameter("@ThinContent3", MySqlDbType.VarChar, 50), new MySqlParameter("@Overweight", MySqlDbType.Decimal, 10), new MySqlParameter("@OverweightContent", MySqlDbType.VarChar, 50), new MySqlParameter("@OverweightContent2", MySqlDbType.VarChar, 50), new MySqlParameter("@OverweightContent3", MySqlDbType.VarChar, 50), new MySqlParameter("@Obesity", MySqlDbType.Decimal, 10), new MySqlParameter("@ObesityContent", MySqlDbType.VarChar, 50), new MySqlParameter("@ObesityContent2", MySqlDbType.VarChar, 50), new MySqlParameter("@ObesityContent3", MySqlDbType.VarChar, 50), new MySqlParameter("@LastUpDateBy", MySqlDbType.VarChar, 100), new MySqlParameter("@LastUpdateDate", MySqlDbType.DateTime), new MySqlParameter("@ID", MySqlDbType.Int32, 11) }; parameters[0].Value = model.IsShowNum; parameters[1].Value = model.Unit; parameters[2].Value = model.ExceptionCol; parameters[3].Value = model.IncludeEqual; parameters[4].Value = model.Thin; parameters[5].Value = model.ThinContent; parameters[6].Value = model.ThinContent2; parameters[7].Value = model.ThinContent3; parameters[8].Value = model.Overweight; parameters[9].Value = model.OverweightContent; parameters[10].Value = model.OverweightContent2; parameters[11].Value = model.OverweightContent3; parameters[12].Value = model.Obesity; parameters[13].Value = model.ObesityContent; parameters[14].Value = model.ObesityContent2; parameters[15].Value = model.ObesityContent3; parameters[16].Value = model.LastUpDateBy; parameters[17].Value = model.LastUpdateDate; parameters[18].Value = model.ID; int rows = MySQLHelper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(BMIAssessSetModel model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(BMIAssessSetModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("INSERT INTO tbl_BMIAssessSet("); strSql.Append("IsShowNum,Unit,ExceptionCol,IncludeEqual,Thin,ThinContent,ThinContent2,ThinContent3,Overweight,OverweightContent,OverweightContent2,OverweightContent3,Obesity,"); strSql.Append("ObesityContent,ObesityContent2,ObesityContent3,CreatedBy,CreatedDate,LastUpDateBy,LastUpdateDate)"); strSql.Append(" VALUES ("); strSql.Append("@IsShowNum,@Unit,@ExceptionCol,@IncludeEqual,@Thin,@ThinContent,@ThinContent2,@ThinContent3,@Overweight,@OverweightContent,@OverweightContent2,@OverweightContent3,"); strSql.Append("@Obesity,@ObesityContent,@ObesityContent2,@ObesityContent3,@CreatedBy,@CreatedDate,@LastUpDateBy,@LastUpdateDate)"); MySqlParameter[] parameters = { new MySqlParameter("@IsShowNum", MySqlDbType.VarChar, 1), new MySqlParameter("@Unit", MySqlDbType.VarChar, 10), new MySqlParameter("@ExceptionCol", MySqlDbType.VarChar, 20), new MySqlParameter("@IncludeEqual", MySqlDbType.VarChar, 1), new MySqlParameter("@Thin", MySqlDbType.Decimal, 10), new MySqlParameter("@ThinContent", MySqlDbType.VarChar, 50), new MySqlParameter("@ThinContent2", MySqlDbType.VarChar, 50), new MySqlParameter("@ThinContent3", MySqlDbType.VarChar, 50), new MySqlParameter("@Overweight", MySqlDbType.Decimal, 10), new MySqlParameter("@OverweightContent", MySqlDbType.VarChar, 50), new MySqlParameter("@OverweightContent2", MySqlDbType.VarChar, 50), new MySqlParameter("@OverweightContent3", MySqlDbType.VarChar, 50), new MySqlParameter("@Obesity", MySqlDbType.Decimal, 10), new MySqlParameter("@ObesityContent", MySqlDbType.VarChar, 50), new MySqlParameter("@ObesityContent2", MySqlDbType.VarChar, 50), new MySqlParameter("@ObesityContent3", MySqlDbType.VarChar, 50), new MySqlParameter("@CreatedBy", MySqlDbType.VarChar, 100), new MySqlParameter("@CreatedDate", MySqlDbType.DateTime), new MySqlParameter("@LastUpDateBy", MySqlDbType.VarChar, 100), new MySqlParameter("@LastUpdateDate", MySqlDbType.DateTime) }; parameters[0].Value = model.IsShowNum; parameters[1].Value = model.Unit; parameters[2].Value = model.ExceptionCol; parameters[3].Value = model.IncludeEqual; parameters[4].Value = model.Thin; parameters[5].Value = model.ThinContent; parameters[6].Value = model.ThinContent2; parameters[7].Value = model.ThinContent3; parameters[8].Value = model.Overweight; parameters[9].Value = model.OverweightContent; parameters[10].Value = model.OverweightContent2; parameters[11].Value = model.OverweightContent3; parameters[12].Value = model.Obesity; parameters[13].Value = model.ObesityContent; parameters[14].Value = model.ObesityContent2; parameters[15].Value = model.ObesityContent3; parameters[16].Value = model.CreatedBy; parameters[17].Value = model.CreatedDate; parameters[18].Value = model.LastUpDateBy; parameters[19].Value = model.LastUpdateDate; int rows = MySQLHelper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 新增一条数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Add(BMIAssessSetModel model) { return(dal.Add(model)); }