/// <summary> /// 更新一条数据 /// </summary> public bool Update(MedDRASearch.Model.meddra model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update meddra set "); strSql.Append("soc_name=@soc_name,"); strSql.Append("soc_code=@soc_code,"); strSql.Append("hlgt_name=@hlgt_name,"); strSql.Append("hlgt_code=@hlgt_code,"); strSql.Append("hlt_name=@hlt_name,"); strSql.Append("hlt_code=@hlt_code,"); strSql.Append("pt_name=@pt_name,"); strSql.Append("pt_code=@pt_code,"); strSql.Append("llt_name=@llt_name,"); strSql.Append("llt_code=@llt_code"); strSql.Append(" where "); MySqlParameter[] parameters = { new MySqlParameter("@soc_name", MySqlDbType.VarChar, 255), new MySqlParameter("@soc_code", MySqlDbType.VarChar, 255), new MySqlParameter("@hlgt_name", MySqlDbType.VarChar, 255), new MySqlParameter("@hlgt_code", MySqlDbType.VarChar, 255), new MySqlParameter("@hlt_name", MySqlDbType.VarChar, 255), new MySqlParameter("@hlt_code", MySqlDbType.VarChar, 255), new MySqlParameter("@pt_name", MySqlDbType.VarChar, 255), new MySqlParameter("@pt_code", MySqlDbType.VarChar, 255), new MySqlParameter("@llt_name", MySqlDbType.VarChar, 255), new MySqlParameter("@llt_code", MySqlDbType.VarChar, 255) }; parameters[0].Value = model.soc_name; parameters[1].Value = model.soc_code; parameters[2].Value = model.hlgt_name; parameters[3].Value = model.hlgt_code; parameters[4].Value = model.hlt_name; parameters[5].Value = model.hlt_code; parameters[6].Value = model.pt_name; parameters[7].Value = model.pt_code; parameters[8].Value = model.llt_name; parameters[9].Value = model.llt_code; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public MedDRASearch.Model.meddra DataRowToModel(DataRow row) { MedDRASearch.Model.meddra model = new MedDRASearch.Model.meddra(); if (row != null) { if (row["soc_name"] != null) { model.soc_name = row["soc_name"].ToString(); } if (row["soc_code"] != null) { model.soc_code = row["soc_code"].ToString(); } if (row["hlgt_name"] != null) { model.hlgt_name = row["hlgt_name"].ToString(); } if (row["hlgt_code"] != null) { model.hlgt_code = row["hlgt_code"].ToString(); } if (row["hlt_name"] != null) { model.hlt_name = row["hlt_name"].ToString(); } if (row["hlt_code"] != null) { model.hlt_code = row["hlt_code"].ToString(); } if (row["pt_name"] != null) { model.pt_name = row["pt_name"].ToString(); } if (row["pt_code"] != null) { model.pt_code = row["pt_code"].ToString(); } if (row["llt_name"] != null) { model.llt_name = row["llt_name"].ToString(); } if (row["llt_code"] != null) { model.llt_code = row["llt_code"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(MedDRASearch.Model.meddra model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into meddra("); strSql.Append("soc_name,soc_code,hlgt_name,hlgt_code,hlt_name,hlt_code,pt_name,pt_code,llt_name,llt_code)"); strSql.Append(" values ("); strSql.Append("@soc_name,@soc_code,@hlgt_name,@hlgt_code,@hlt_name,@hlt_code,@pt_name,@pt_code,@llt_name,@llt_code)"); MySqlParameter[] parameters = { new MySqlParameter("@soc_name", MySqlDbType.VarChar, 255), new MySqlParameter("@soc_code", MySqlDbType.VarChar, 255), new MySqlParameter("@hlgt_name", MySqlDbType.VarChar, 255), new MySqlParameter("@hlgt_code", MySqlDbType.VarChar, 255), new MySqlParameter("@hlt_name", MySqlDbType.VarChar, 255), new MySqlParameter("@hlt_code", MySqlDbType.VarChar, 255), new MySqlParameter("@pt_name", MySqlDbType.VarChar, 255), new MySqlParameter("@pt_code", MySqlDbType.VarChar, 255), new MySqlParameter("@llt_name", MySqlDbType.VarChar, 255), new MySqlParameter("@llt_code", MySqlDbType.VarChar, 255) }; parameters[0].Value = model.soc_name; parameters[1].Value = model.soc_code; parameters[2].Value = model.hlgt_name; parameters[3].Value = model.hlgt_code; parameters[4].Value = model.hlt_name; parameters[5].Value = model.hlt_code; parameters[6].Value = model.pt_name; parameters[7].Value = model.pt_code; parameters[8].Value = model.llt_name; parameters[9].Value = model.llt_code; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public MedDRASearch.Model.meddra GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select soc_name,soc_code,hlgt_name,hlgt_code,hlt_name,hlt_code,pt_name,pt_code,llt_name,llt_code from meddra "); strSql.Append(" where "); MySqlParameter[] parameters = { }; MedDRASearch.Model.meddra model = new MedDRASearch.Model.meddra(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }