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