/// <summary> /// 更新一条数据 /// </summary> public bool Update(BioDetailAssessSetModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("UPDATE tbl_BioDetailAssessSet SET "); strSql.Append("Type=@Type,"); strSql.Append("CodeName=@CodeName,"); strSql.Append("Code=@Code,"); strSql.Append("Unit=@Unit,"); strSql.Append("IsShowNum=@IsShowNum,"); strSql.Append("IncludeEqual=@IncludeEqual,"); strSql.Append("Sex=@Sex,"); strSql.Append("MaxVal=@MaxVal,"); strSql.Append("MinVal=@MinVal,"); strSql.Append("Content=@Content,"); strSql.Append("Content2=@Content2,"); strSql.Append("Content3=@Content3,"); strSql.Append("LastUpDateBy=@LastUpDateBy,"); strSql.Append("LastUpdateDate=@LastUpdateDate,"); strSql.Append("Seq=@Seq,"); strSql.Append("IfUsing=@IfUsing"); strSql.Append(" WHERE ID=@ID"); MySqlParameter[] parameters = { new MySqlParameter("@Type", MySqlDbType.VarChar, 2), new MySqlParameter("@CodeName", MySqlDbType.VarChar, 50), new MySqlParameter("@Code", MySqlDbType.VarChar, 10), new MySqlParameter("@Unit", MySqlDbType.VarChar, 10), new MySqlParameter("@IsShowNum", MySqlDbType.VarChar, 1), new MySqlParameter("@IncludeEqual", MySqlDbType.VarChar, 1), new MySqlParameter("@Sex", MySqlDbType.VarChar, 1), new MySqlParameter("@MaxVal", MySqlDbType.VarChar, 30), new MySqlParameter("@MinVal", MySqlDbType.VarChar, 30), new MySqlParameter("@Content", MySqlDbType.VarChar, 50), new MySqlParameter("@Content2", MySqlDbType.VarChar, 50), new MySqlParameter("@Content3", MySqlDbType.VarChar, 50), new MySqlParameter("@LastUpDateBy", MySqlDbType.VarChar, 100), new MySqlParameter("@LastUpdateDate", MySqlDbType.DateTime), new MySqlParameter("@Seq", MySqlDbType.Int32, 11), new MySqlParameter("@IfUsing", MySqlDbType.Int32, 11), new MySqlParameter("@ID", MySqlDbType.Int32, 11) }; parameters[0].Value = model.Type; parameters[1].Value = model.CodeName; parameters[2].Value = model.Code; parameters[3].Value = model.Unit; parameters[4].Value = model.IsShowNum; parameters[5].Value = model.IncludeEqual; parameters[6].Value = model.Sex; parameters[7].Value = model.MaxVal; parameters[8].Value = model.MinVal; parameters[9].Value = model.Content; parameters[10].Value = model.Content2; parameters[11].Value = model.Content3; parameters[12].Value = model.LastUpDateBy; parameters[13].Value = model.LastUpdateDate; parameters[14].Value = model.Seq; parameters[15].Value = model.IfUsing; parameters[16].Value = model.ID; int rows = MySQLHelper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(BioDetailAssessSetModel model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(BioDetailAssessSetModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("INSERT INTO tbl_BioDetailAssessSet("); strSql.Append("Type,CodeName,Code,Unit,IsShowNum,IncludeEqual,Sex,MaxVal,MinVal,Content,Content2,Content3,CreatedBy,CreatedDate,LastUpDateBy,LastUpdateDate,Seq,IfUsing)"); strSql.Append(" VALUES ("); strSql.Append("@Type,@CodeName,@Code,@Unit,@IsShowNum,@IncludeEqual,@Sex,@MaxVal,@MinVal,@Content,@Content2,@Content3,@CreatedBy,@CreatedDate,@LastUpDateBy,@LastUpdateDate,@Seq,@IfUsing)"); MySqlParameter[] parameters = { new MySqlParameter("@Type", MySqlDbType.VarChar, 2), new MySqlParameter("@CodeName", MySqlDbType.VarChar, 50), new MySqlParameter("@Code", MySqlDbType.VarChar, 10), new MySqlParameter("@Unit", MySqlDbType.VarChar, 10), new MySqlParameter("@IsShowNum", MySqlDbType.VarChar, 1), new MySqlParameter("@IncludeEqual", MySqlDbType.VarChar, 1), new MySqlParameter("@Sex", MySqlDbType.VarChar, 1), new MySqlParameter("@MaxVal", MySqlDbType.VarChar, 30), new MySqlParameter("@MinVal", MySqlDbType.VarChar, 30), new MySqlParameter("@Content", MySqlDbType.VarChar, 50), new MySqlParameter("@Content2", MySqlDbType.VarChar, 50), new MySqlParameter("@Content3", 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), new MySqlParameter("@Seq", MySqlDbType.Int32, 11), new MySqlParameter("@IfUsing", MySqlDbType.Int32, 10) }; parameters[0].Value = model.Type; parameters[1].Value = model.CodeName; parameters[2].Value = model.Code; parameters[3].Value = model.Unit; parameters[4].Value = model.IsShowNum; parameters[5].Value = model.IncludeEqual; parameters[6].Value = model.Sex; parameters[7].Value = model.MaxVal; parameters[8].Value = model.MinVal; parameters[9].Value = model.Content; parameters[10].Value = model.Content2; parameters[11].Value = model.Content3; parameters[12].Value = model.CreatedBy; parameters[13].Value = model.CreatedDate; parameters[14].Value = model.LastUpDateBy; parameters[15].Value = model.LastUpdateDate; parameters[16].Value = model.Seq; parameters[17].Value = model.IfUsing; 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(BioDetailAssessSetModel model) { return(dal.Add(model)); }