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