private SqlParamInfo[] GetDepartmentInfoPars(DepartmentInfoData departmentInfo) { return(new SqlParamInfo[] { new SqlParamInfo("科室ID", DbType.String, departmentInfo.科室ID), new SqlParamInfo("科室名称", DbType.String, departmentInfo.科室名称), new SqlParamInfo("附加数据", DbType.String, departmentInfo.附加数据.ToString()) }); }
/// <summary> /// 更新科室信息 /// </summary> /// <param name="departmentInfo"></param> public void UpdateDepartmentInfo(DepartmentInfoData departmentInfo) { string sql = "Update 影像科室信息 " + " Set 科室名称=:科室名称, 附加数据=:附加数据 where 科室ID=:科室ID"; sql = SqlHelper.GetSqlBiz().GetSqlContext("更新影像科室信息", sql); SqlParamInfo[] sqlPars = new SqlParamInfo[] { new SqlParamInfo("科室名称", DbType.String, departmentInfo.科室名称), new SqlParamInfo("附加数据", DbType.String, departmentInfo.附加数据.ToString()), new SqlParamInfo("科室ID", DbType.String, departmentInfo.科室ID) }; _dbHelper.ExecuteSQL(sql, sqlPars); }
/// <summary> /// 新增科室信息 /// </summary> /// <param name="departmentInfo"></param> /// <returns></returns> public bool NewDepartmentInfo(DepartmentInfoData departmentInfo) { string sql = "insert into " + " 影像科室信息(科室ID, 科室名称, 附加数据) " + " values " + " (:科室ID,:科室名称, :附加数据)"; sql = SqlHelper.GetSqlBiz().GetSqlContext("插入影像科室信息", sql); SqlParamInfo[] sqlPars = GetDepartmentInfoPars(departmentInfo); DataTable dtResult = _dbHelper.ExecuteSQL(sql, sqlPars); return(true); }