function act_onSampleCoefficient($cName, $sampleTypeId) { //启动一个系数,在一个事务中 try { TransactionBaseModel::begin(); $set = "SET is_open=0 "; $where = "WHERE cName<>'{$cName}' and sampleTypeId='{$sampleTypeId}' "; //先将该sampleTypeID下cName<>$cName的is_open设为0 $affectRow1 = SampleCoefficientModel::updateSampleCoefficient($set, $where); $set = "SET is_open=1 "; $where = "WHERE cName='{$cName}' and sampleTypeId='{$sampleTypeId}' "; //将该sampleTypeID下$cName设为1 $affectRow2 = SampleCoefficientModel::updateSampleCoefficient($set, $where); if (!$affectRow2) { //如果is_open=1没有更新的话,则表示已经启动或找不到该记录 throw new Exception('update error'); } TransactionBaseModel::commit(); TransactionBaseModel::autoCommit(); return 1; } catch (Exception $e) { TransactionBaseModel::rollback(); self::$errCode = "1101"; self::$errMsg = $e; return 0; } }
function act_getCnameInfo() { $id = $_POST['id']; $list = SampleCoefficientModel::getSampleCoefficientList("distinct(cName)", "where sampleTypeId = '{$id}'"); if ($list) { return $list; } else { self::$errCode = SampleCoefficientModel::$errCode; self::$errMsg = SampleCoefficientModel::$errMsg; return false; } }