/// <summary>
/// 更新检查项目分类
/// </summary>
/// <param name="examClass"></param>
/// <returns></returns>
public bool UpdateExamClass(ExamClassData examClass)
{
string sql = "update 影像项目分类 set 分类名称=:分类名称, 项目分类ID=:项目分类ID, 分类信息=:分类信息 where 项目分类ID=:项目分类ID";
sql = SqlHelper.GetSqlBiz().GetSqlContext("更新检查项目分类", sql);
SqlParamInfo[] sqlPars = new SqlParamInfo[] { new SqlParamInfo("分类名称", DbType.String, examClass.分类名称),
new SqlParamInfo("项目分类ID", DbType.String, examClass.项目分类ID),
new SqlParamInfo("分类信息", DbType.String, examClass.分类信息.ToString()),
new SqlParamInfo("项目分类ID", DbType.String, examClass.项目分类ID) };
_dbHelper.ExecuteSQL(sql, sqlPars);
return(true);
}
/// <summary>
/// 新增项目分类
/// </summary>
/// <param name="examClass"></param>
/// <returns></returns>
public bool NewExamClass(ExamClassData examClass)
{
string sql = "insert into 影像项目分类(项目分类ID, 上级分类ID, 影像类别, 分类名称, 分类信息)" +
"values(:项目分类ID, :上级分类ID, :影像类别, :分类名称, :分类信息)";
sql = SqlHelper.GetSqlBiz().GetSqlContext("插入检查项目分类", sql);
SqlParamInfo[] sqlPars = new SqlParamInfo[] { new SqlParamInfo("项目分类ID", DbType.String, examClass.项目分类ID),
new SqlParamInfo("上级分类ID", DbType.String, examClass.级分类ID),
new SqlParamInfo("影像类别", DbType.String, examClass.影像类别),
new SqlParamInfo("分类名称", DbType.String, examClass.分类名称),
new SqlParamInfo("分类信息", DbType.String, examClass.分类信息.ToString()) };
_dbHelper.ExecuteSQL(sql, sqlPars);
return(true);
}
