/// <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);
}
}
