/// <summary>
/// 更新部位方法
/// </summary>
/// <param name="bodypartData"></param>
/// <returns></returns>
public bool UpdateBodypartWay(BodypartInfoData bodypartData)
{
string sql = "update 影像部位信息 set 部位信息=:部位信息 where 部位ID=:部位ID";
sql = SqlHelper.GetSqlBiz().GetSqlContext("更新检查部位方法", sql);
SqlParamInfo[] sqlPars = new SqlParamInfo[] { new SqlParamInfo("部位信息", DbType.String, bodypartData.部位信息.ToString()),
new SqlParamInfo("部位ID", DbType.String, bodypartData.部位ID) };
_dbHelper.ExecuteSQL(sql, sqlPars);
return(true);
}
/// <summary>
/// 新增部位信息
/// </summary>
/// <param name="bodypartData"></param>
/// <returns></returns>
public bool NewBodypartInfo(BodypartInfoData bodypartData)
{
string sql = "insert into 影像部位信息(部位ID, 影像类别, 部位名称, 分组标记, 部位信息)" +
"values(:部位ID, :影像类别, :部位名称, :分组标记, :部位信息)";
sql = SqlHelper.GetSqlBiz().GetSqlContext("插入检查部位信息", sql);
SqlParamInfo[] sqlPars = new SqlParamInfo[] { new SqlParamInfo("部位ID", DbType.String, bodypartData.部位ID),
new SqlParamInfo("影像类别", DbType.String, bodypartData.影像类别),
new SqlParamInfo("部位名称", DbType.String, bodypartData.部位名称),
new SqlParamInfo("分组标记", DbType.String, bodypartData.分组标记),
new SqlParamInfo("部位信息", DbType.String, bodypartData.部位信息.ToString()) };
_dbHelper.ExecuteSQL(sql, sqlPars);
return(true);
}
