$grobal_func=$this->container->get('global_func');
//'global_func'函数所在的文件名
$lot_data=$global_func->getDataFromFile($parm1);
//getDataFromFile函数名

$conn = $this->em->getConnection();
$sql_user="select * from lot_user where user_name=:param1 and user_id=:param2 limit 1";
$params = array(
    'param1' => $user,
    'param2' => $uid
);
$ready = $conn->prepare($sql_user);
$ready->execute($params);
$result_user = $ready->fetchAll();

$em->getConnection()->beginTransaction();
try{
   $lotuser = new LotUser();
   $lotuser->setId(0);
   $lotuser->setUserId($user_id);
   $lotuser->setUserName($user_name);
   $lotuser->setPassword($password);
   $lotuser->setUserTele($user_tele);
   $lotuser->setEmail($email);
   $lotuser->setRegDate($reg_date);
   $lotuser->setIdNumber($id_number);
   $lotuser->setRealUsername($real_username);
$em->persist($lotuser);
$em->flush();
$em->getConnection()->commit();
}catch(Exception $e){
$e->getConnection()->rollback();
}