function act_delName()
{
$whereStr = "";
$billArr = array_filter(explode(",", trim($_POST['bill'])));
$whereStr = " where id in (" . implode(',', $billArr) . ")";
$listArr = NameSystemModel::delName($whereStr);
if ($listArr['reNum'] == '200') {
self::$errCode = $listArr['reNum'];
self::$errMsg = $listArr['reStr'];
return true;
} else {
self::$errCode = NameSystemModel::$errCode;
self::$errMsg = NameSystemModel::$errMsg;
return false;
}
}
public static function nameSystemVerify($addNewName)
{
self::initDB();
$reInfo = array();
$sql = "select * from " . self::$table1 . " where is_delete != 1 and name = '{$addNewName}'";
$query = self::$dbConn->query($sql);
if ($query) {
$ret = self::$dbConn->fetch_array_all($query);
if (empty($ret)) {
$reInfo['reNum'] = "200";
$reInfo['reStr'] = "此帐号名称可以使用!";
} else {
$sql2 = "select * from " . self::$table2 . " where is_delete != 1 and id = {$ret[0]['systemTypeId']}";
$query2 = self::$dbConn->query($sql2);
$ret2 = self::$dbConn->fetch_array_all($query2);
$reInfo['reNum'] = "400";
$reInfo['reStr'] = "此名称已被其他人使用在[{$ret2[0]['systemName']}]系统!";
}
return $reInfo;
} else {
self::$errCode = "4444";
self::$errMsg = "mysql:" . $sql . " error";
return false;
}
}
